Debian Codegraph @

modules/db/functions/db-loading.plpgsql

raw
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