| 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 |
|