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