1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
|
CREATE OR REPLACE FUNCTION pgl_ddl_deploy.deploy(p_set_name text)
RETURNS boolean
LANGUAGE plpgsql
AS $function$
DECLARE
v_deployable BOOLEAN;
v_result BOOLEAN;
BEGIN
SELECT pgl_ddl_deploy.deployment_check(p_set_name) INTO v_deployable;
IF v_deployable THEN
SELECT pgl_ddl_deploy.schema_execute(p_set_name, 'deploy_sql') INTO v_result;
RETURN v_result;
ELSE
RETURN v_deployable;
END IF;
END;
$function$
;
CREATE OR REPLACE FUNCTION pgl_ddl_deploy.deploy(p_set_config_id int) RETURNS BOOLEAN AS
$BODY$
DECLARE
v_deployable BOOLEAN;
v_result BOOLEAN;
BEGIN
SELECT pgl_ddl_deploy.deployment_check(p_set_config_id) INTO v_deployable;
IF v_deployable THEN
SELECT pgl_ddl_deploy.schema_execute(p_set_config_id, 'deploy_sql') INTO v_result;
RETURN v_result;
ELSE
RETURN v_deployable;
END IF;
END;
$BODY$
LANGUAGE plpgsql;
|
