Debian Codegraph @

modules/sequence/functions/feature_subalignments.plpgsql

raw
1 CREATE OR REPLACE FUNCTION feature_subalignments(bigint) RETURNS SETOF featureloc AS '
2 DECLARE
3 return_data featureloc%ROWTYPE;
4 f_id ALIAS FOR $1;
5 feature_data feature%rowtype;
6 featureloc_data featureloc%rowtype;
7
8 s text;
9
10 fmin bigint;
11 slen bigint;
12 BEGIN
13 --RAISE NOTICE ''feature_id is %'', featureloc_data.feature_id;
14 SELECT INTO feature_data * FROM feature WHERE feature_id = f_id;
15
16 FOR featureloc_data IN SELECT * FROM featureloc WHERE feature_id = f_id LOOP
17
18 --RAISE NOTICE ''fmin is %'', featureloc_data.fmin;
19
20 return_data.feature_id = f_id;
21 return_data.srcfeature_id = featureloc_data.srcfeature_id;
22 return_data.is_fmin_partial = featureloc_data.is_fmin_partial;
23 return_data.is_fmax_partial = featureloc_data.is_fmax_partial;
24 return_data.strand = featureloc_data.strand;
25 return_data.phase = featureloc_data.phase;
26 return_data.residue_info = featureloc_data.residue_info;
27 return_data.locgroup = featureloc_data.locgroup;
28 return_data.rank = featureloc_data.rank;
29
30 s = feature_data.residues;
31 fmin = featureloc_data.fmin;
32 slen = char_length(s);
33
34 WHILE char_length(s) LOOP
35 --RAISE NOTICE ''residues is %'', s;
36
37 --trim off leading match
38 s = trim(leading ''|ATCGNatcgn'' from s);
39 --if leading match detected
40 IF slen > char_length(s) THEN
41 return_data.fmin = fmin;
42 return_data.fmax = featureloc_data.fmin + (slen - char_length(s));
43
44 --if the string started with a match, return it,
45 --otherwise, trim the gaps first (ie do not return this iteration)
46 RETURN NEXT return_data;
47 END IF;
48
49 --trim off leading gap
50 s = trim(leading ''-'' from s);
51
52 fmin = featureloc_data.fmin + (slen - char_length(s));
53 END LOOP;
54 END LOOP;
55
56 RETURN;
57
58 END;
59 ' LANGUAGE 'plpgsql';