| 1 |
|
| 2 |
CREATE OR REPLACE FUNCTION store_db (VARCHAR) |
| 3 |
RETURNS BIGINT AS |
| 4 |
'DECLARE |
| 5 |
v_name ALIAS FOR $1; |
| 6 |
|
| 7 |
v_db_id BIGINT; |
| 8 |
BEGIN |
| 9 |
SELECT INTO v_db_id db_id |
| 10 |
FROM db |
| 11 |
WHERE name=v_name; |
| 12 |
IF NOT FOUND THEN |
| 13 |
INSERT INTO db |
| 14 |
(name) |
| 15 |
VALUES |
| 16 |
(v_name); |
| 17 |
RETURN currval(''db_db_id_seq''); |
| 18 |
END IF; |
| 19 |
RETURN v_db_id; |
| 20 |
END; |
| 21 |
' LANGUAGE 'plpgsql'; |
| 22 |
|
| 23 |
CREATE OR REPLACE FUNCTION store_dbxref (VARCHAR,VARCHAR) |
| 24 |
RETURNS BIGINT AS |
| 25 |
'DECLARE |
| 26 |
v_dbname ALIAS FOR $1; |
| 27 |
v_accession ALIAS FOR $2; |
| 28 |
|
| 29 |
v_db_id BIGINT; |
| 30 |
v_dbxref_id BIGINT; |
| 31 |
BEGIN |
| 32 |
SELECT INTO v_db_id |
| 33 |
store_db(v_dbname); |
| 34 |
SELECT INTO v_dbxref_id dbxref_id |
| 35 |
FROM dbxref |
| 36 |
WHERE db_id=v_db_id AND |
| 37 |
accession=v_accession; |
| 38 |
IF NOT FOUND THEN |
| 39 |
INSERT INTO dbxref |
| 40 |
(db_id,accession) |
| 41 |
VALUES |
| 42 |
(v_db_id,v_accession); |
| 43 |
RETURN currval(''dbxref_dbxref_id_seq''); |
| 44 |
END IF; |
| 45 |
RETURN v_dbxref_id; |
| 46 |
END; |
| 47 |
' LANGUAGE 'plpgsql'; |
| 48 |
|