stackql-deploy 2.2.0

Infrastructure-as-code framework for declarative cloud resource management using StackQL
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

/*+ exists */
SELECT COUNT(*) AS count
FROM github.issues.labels
WHERE owner = '{{ owner }}'
AND repo = '{{ repo }}'
AND name = '{{ label_name }}'

/*+ create */
INSERT INTO github.issues.labels (
  owner,
  repo,
  name,
  color,
  description
)
SELECT
  '{{ owner }}',
  '{{ repo }}',
  '{{ label_name }}',
  '{{ label_color }}',
  '{{ label_description }}'

/*+ statecheck, retries=3, retry_delay=3 */
SELECT COUNT(*) AS count FROM
(
  SELECT name, color, description
  FROM github.issues.labels
  WHERE owner = '{{ owner }}'
  AND repo = '{{ repo }}'
) t
WHERE name = '{{ label_name }}'
AND color = '{{ label_color }}'
AND description = '{{ label_description }}'

/*+ update */
UPDATE github.issues.labels
SET color = '{{ label_color }}',
    description = '{{ label_description }}'
WHERE owner = '{{ owner }}'
AND repo = '{{ repo }}'
AND name = '{{ label_name }}'

/*+ exports */
SELECT id AS run_label_id, url AS run_label_url FROM
(
  SELECT id, url, name
  FROM github.issues.labels
  WHERE owner = '{{ owner }}'
  AND repo = '{{ repo }}'
) t
WHERE name = '{{ label_name }}'

/*+ delete */
DELETE FROM github.issues.labels
WHERE owner = '{{ owner }}'
AND repo = '{{ repo }}'
AND name = '{{ label_name }}'