/
soma_stmt_tx_tree_keeper_nodes.go
122 lines (110 loc) · 2.85 KB
/
soma_stmt_tx_tree_keeper_nodes.go
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
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
package main
/*
* Statements for NODE actions
*/
const tkStmtUpdateNodeState = `
UPDATE soma.nodes
SET object_state = $2::varchar
WHERE node_id = $1::uuid;`
const tkStmtNodeUnassignFromBucket = `
DELETE FROM soma.node_bucket_assignment
WHERE node_id = $1::uuid
AND bucket_id = $2::uuid
AND organizational_team_id = $3::uuid;`
const tkStmtNodePropertyOncallCreate = `
INSERT INTO soma.node_oncall_property (
instance_id,
source_instance_id,
node_id,
view,
oncall_duty_id,
repository_id,
inheritance_enabled,
children_only)
SELECT $1::uuid,
$2::uuid,
$3::uuid,
$4::varchar,
$5::uuid,
$6::uuid,
$7::boolean,
$8::boolean;`
const tkStmtNodePropertyOncallDelete = `
DELETE FROM soma.node_oncall_property
WHERE instance_id = $1::uuid;`
const tkStmtNodePropertyServiceCreate = `
INSERT INTO soma.node_service_properties (
instance_id,
source_instance_id,
node_id,
view,
service_property,
organizational_team_id,
repository_id,
inheritance_enabled,
children_only)
SELECT $1::uuid,
$2::uuid,
$3::uuid,
$4::varchar,
$5::varchar,
$6::uuid,
$7::uuid,
$8::boolean,
$9::boolean;`
const tkStmtNodePropertyServiceDelete = `
DELETE FROM soma.node_service_properties
WHERE instance_id = $1::uuid;`
const tkStmtNodePropertySystemCreate = `
INSERT INTO soma.node_system_properties (
instance_id,
source_instance_id,
node_id,
view,
system_property,
source_type,
repository_id,
inheritance_enabled,
children_only,
value,
inherited)
SELECT $1::uuid,
$2::uuid,
$3::uuid,
$4::varchar,
$5::varchar,
$6::varchar,
$7::uuid,
$8::boolean,
$9::boolean,
$10::text,
$11::boolean;`
const tkStmtNodePropertySystemDelete = `
DELETE FROM soma.node_system_properties
WHERE instance_id = $1::uuid;`
const tkStmtNodePropertyCustomCreate = `
INSERT INTO soma.node_custom_properties (
instance_id,
source_instance_id,
node_id,
view,
custom_property_id,
bucket_id,
repository_id,
inheritance_enabled,
children_only,
value)
SELECT $1::uuid,
$2::uuid,
$3::uuid,
$4::varchar,
$5::uuid,
$6::uuid,
$7::uuid,
$8::boolean,
$9::boolean,
$10::text;`
const tkStmtNodePropertyCustomDelete = `
DELETE FROM soma.node_custom_properties
WHERE instance_id = $1::uuid;`
// vim: ts=4 sw=4 sts=4 noet fenc=utf-8 ffs=unix