Debian Codegraph @

modules/sequence/functions/sequence-cv-helper.plpgsql

raw
1
2 CREATE OR REPLACE FUNCTION get_cv_id_for_feature() RETURNS BIGINT
3 AS 'SELECT cv_id FROM cv WHERE name=''sequence''' LANGUAGE 'sql';
4 CREATE OR REPLACE FUNCTION get_cv_id_for_featureprop() RETURNS BIGINT
5 AS 'SELECT cv_id FROM cv WHERE name=''feature_property''' LANGUAGE 'sql';
6 CREATE OR REPLACE FUNCTION get_cv_id_for_feature_relationsgip() RETURNS BIGINT
7 AS 'SELECT cv_id FROM cv WHERE name=''relationship''' LANGUAGE 'sql';
8
9 CREATE OR REPLACE FUNCTION get_feature_type_id(VARCHAR) RETURNS BIGINT
10 AS '
11 SELECT cvterm_id
12 FROM cv INNER JOIN cvterm USING (cv_id)
13 WHERE cvterm.name=$1 AND cv.name=''sequence''
14 ' LANGUAGE 'sql';
15
16 CREATE OR REPLACE FUNCTION get_featureprop_type_id(VARCHAR) RETURNS BIGINT
17 AS '
18 SELECT cvterm_id
19 FROM cv INNER JOIN cvterm USING (cv_id)
20 WHERE cvterm.name=$1 AND cv.name=''feature_property''
21 ' LANGUAGE 'sql';
22
23 CREATE OR REPLACE FUNCTION get_feature_relationship_type_id(VARCHAR) RETURNS BIGINT
24 AS '
25 SELECT cvterm_id
26 FROM cv INNER JOIN cvterm USING (cv_id)
27 WHERE cvterm.name=$1 AND cv.name=''relationship''
28 ' LANGUAGE 'sql';
29