Debian Codegraph @

modules/companalysis/functions/companalysis-loading.plpgsql

raw
1
2 CREATE OR REPLACE FUNCTION store_analysis (VARCHAR,VARCHAR,VARCHAR)
3 RETURNS BIGINT AS
4 'DECLARE
5 v_program ALIAS FOR $1;
6 v_programversion ALIAS FOR $2;
7 v_sourcename ALIAS FOR $3;
8 pkval BIGINT;
9 BEGIN
10 SELECT INTO pkval analysis_id
11 FROM analysis
12 WHERE program=v_program AND
13 programversion=v_programversion AND
14 sourcename=v_sourcename;
15 IF NOT FOUND THEN
16 INSERT INTO analysis
17 (program,programversion,sourcename)
18 VALUES
19 (v_program,v_programversion,v_sourcename);
20 RETURN currval(''analysis_analysis_id_seq'');
21 END IF;
22 RETURN pkval;
23 END;
24 ' LANGUAGE 'plpgsql';
25
26 --CREATE OR REPLACE FUNCTION store_analysisfeature
27 --()
28 --RETURNS INT AS
29 --'DECLARE
30 -- v_srcfeature_id ALIAS FOR $1;
31