Debian Codegraph @

modules/sequence/functions/sequence-loading.plpgsql

raw
1 CREATE OR REPLACE FUNCTION store_feature
2 (INT,INT,INT,INT,
3 INT,INT,VARCHAR,VARCHAR,INT,BOOLEAN)
4 RETURNS INT AS
5 'DECLARE
6 v_srcfeature_id ALIAS FOR $1;
7 v_fmin ALIAS FOR $2;
8 v_fmax ALIAS FOR $3;
9 v_strand ALIAS FOR $4;
10 v_dbxref_id ALIAS FOR $5;
11 v_organism_id ALIAS FOR $6;
12 v_name ALIAS FOR $7;
13 v_uniquename ALIAS FOR $8;
14 v_type_id ALIAS FOR $9;
15 v_is_analysis ALIAS FOR $10;
16 v_feature_id INT;
17 v_featureloc_id INT;
18 BEGIN
19 IF v_dbxref_id IS NULL THEN
20 SELECT INTO v_feature_id feature_id
21 FROM feature
22 WHERE uniquename=v_uniquename AND
23 organism_id=v_organism_id AND
24 type_id=v_type_id;
25 ELSE
26 SELECT INTO v_feature_id feature_id
27 FROM feature
28 WHERE dbxref_id=v_dbxref_id;
29 END IF;
30 IF NOT FOUND THEN
31 INSERT INTO feature
32 ( dbxref_id ,
33 organism_id ,
34 name ,
35 uniquename ,
36 type_id ,
37 is_analysis )
38 VALUES
39 ( v_dbxref_id ,
40 v_organism_id ,
41 v_name ,
42 v_uniquename ,
43 v_type_id ,
44 v_is_analysis );
45 v_feature_id = currval(''feature_feature_id_seq'');
46 ELSE
47 UPDATE feature SET
48 dbxref_id = v_dbxref_id ,
49 organism_id = v_organism_id ,
50 name = v_name ,
51 uniquename = v_uniquename ,
52 type_id = v_type_id ,
53 is_analysis = v_is_analysis
54 WHERE
55 feature_id=v_feature_id;
56 END IF;
57 PERFORM store_featureloc(v_feature_id,
58 v_srcfeature_id,
59 v_fmin,
60 v_fmax,
61 v_strand,
62 0,
63 0);
64 RETURN v_feature_id;
65 END;
66 ' LANGUAGE 'plpgsql';
67
68
69 CREATE OR REPLACE FUNCTION store_featureloc
70 (INT,INT,INT,INT,INT,INT,INT)
71 RETURNS INT AS
72 'DECLARE
73 v_feature_id ALIAS FOR $1;
74 v_srcfeature_id ALIAS FOR $2;
75 v_fmin ALIAS FOR $3;
76 v_fmax ALIAS FOR $4;
77 v_strand ALIAS FOR $5;
78 v_rank ALIAS FOR $6;
79 v_locgroup ALIAS FOR $7;
80 v_featureloc_id INT;
81 BEGIN
82 IF v_feature_id IS NULL THEN RAISE EXCEPTION ''feature_id cannot be null'';
83 END IF;
84 SELECT INTO v_featureloc_id featureloc_id
85 FROM featureloc
86 WHERE feature_id=v_feature_id AND
87 rank=v_rank AND
88 locgroup=v_locgroup;
89 IF NOT FOUND THEN
90 INSERT INTO featureloc
91 ( feature_id,
92 srcfeature_id,
93 fmin,
94 fmax,
95 strand,
96 rank,
97 locgroup)
98 VALUES
99 ( v_feature_id,
100 v_srcfeature_id,
101 v_fmin,
102 v_fmax,
103 v_strand,
104 v_rank,
105 v_locgroup);
106 v_featureloc_id = currval(''featureloc_featureloc_id_seq'');
107 ELSE
108 UPDATE featureloc SET
109 feature_id = v_feature_id,
110 srcfeature_id = v_srcfeature_id,
111 fmin = v_fmin,
112 fmax = v_fmax,
113 strand = v_strand,
114 rank = v_rank,
115 locgroup = v_locgroup
116 WHERE
117 featureloc_id=v_featureloc_id;
118 END IF;
119 RETURN v_featureloc_id;
120 END;
121 ' LANGUAGE 'plpgsql';
122
123 CREATE OR REPLACE FUNCTION store_feature_synonym
124 (INT,VARCHAR,INT,BOOLEAN,BOOLEAN,INT)
125 RETURNS INT AS
126 'DECLARE
127 v_feature_id ALIAS FOR $1;
128 v_syn ALIAS FOR $2;
129 v_type_id ALIAS FOR $3;
130 v_is_current ALIAS FOR $4;
131 v_is_internal ALIAS FOR $5;
132 v_pub_id ALIAS FOR $6;
133 v_synonym_id INT;
134 v_feature_synonym_id INT;
135 BEGIN
136 IF v_feature_id IS NULL THEN RAISE EXCEPTION ''feature_id cannot be null'';
137 END IF;
138 SELECT INTO v_synonym_id synonym_id
139 FROM synonym
140 WHERE name=v_syn AND
141 type_id=v_type_id;
142 IF NOT FOUND THEN
143 INSERT INTO synonym
144 ( name,
145 synonym_sgml,
146 type_id)
147 VALUES
148 ( v_syn,
149 v_syn,
150 v_type_id);
151 v_synonym_id = currval(''synonym_synonym_id_seq'');
152 END IF;
153 SELECT INTO v_feature_synonym_id feature_synonym_id
154 FROM feature_synonym
155 WHERE feature_id=v_feature_id AND
156 synonym_id=v_synonym_id AND
157 pub_id=v_pub_id;
158 IF NOT FOUND THEN
159 INSERT INTO feature_synonym
160 ( feature_id,
161 synonym_id,
162 pub_id,
163 is_current,
164 is_internal)
165 VALUES
166 ( v_feature_id,
167 v_synonym_id,
168 v_pub_id,
169 v_is_current,
170 v_is_internal);
171 v_feature_synonym_id = currval(''feature_synonym_feature_synonym_id_seq'');
172 ELSE
173 UPDATE feature_synonym
174 SET is_current=v_is_current, is_internal=v_is_internal
175 WHERE feature_synonym_id=v_feature_synonym_id;
176 END IF;
177 RETURN v_feature_synonym_id;
178 END;
179 ' LANGUAGE 'plpgsql';
180
181
182