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
58
59
60

/*+ exists */
SELECT COUNT(*) as count FROM
(
    SELECT vpc_id,
    json_group_object(tag_key, tag_value) as tags
    FROM aws.ec2.vpc_tags
    WHERE region = '{{ region }}'
    AND cidr_block = '{{ cidr_block }}'
    GROUP BY vpc_id
    HAVING json_extract(tags, '$.Provisioner') = 'stackql'
    AND json_extract(tags, '$.StackName') = '{{ stack_name }}'
    AND json_extract(tags, '$.StackEnv') = '{{ stack_env }}'
) t 

/*+ create */
INSERT INTO aws.ec2.vpcs (
 CidrBlock,
 Tags,
 EnableDnsSupport,
 EnableDnsHostnames, 
 ClientToken,
 region
)
SELECT 
 '{{ cidr_block }}',
 '{{ tags }}',
 true,
 true,
 '{{ idempotency_token }}',
 '{{ region }}'

/*+ statecheck, retries=3, retry_delay=5 */
SELECT COUNT(*) as count FROM
(
    SELECT vpc_id,
    json_group_object(tag_key, tag_value) as tags
    FROM aws.ec2.vpc_tags
    WHERE region = '{{ region }}'
    AND cidr_block = '{{ cidr_block }}'
    GROUP BY vpc_id
    HAVING json_extract(tags, '$.Provisioner') = 'stackql'
    AND json_extract(tags, '$.StackName') = '{{ stack_name }}'
    AND json_extract(tags, '$.StackEnv') = '{{ stack_env }}'
) t 

/*+ exports, retries=3, retry_delay=5 */
SELECT vpc_id,
json_group_object(tag_key, tag_value) as tags
FROM aws.ec2.vpc_tags
WHERE region = '{{ region }}'
AND cidr_block = '{{ cidr_block }}'
GROUP BY vpc_id
HAVING json_extract(tags, '$.Provisioner') = 'stackql'
AND json_extract(tags, '$.StackName') = '{{ stack_name }}'
AND json_extract(tags, '$.StackEnv') = '{{ stack_env }}'

/*+ delete */
DELETE FROM aws.ec2.vpcs
WHERE Identifier = '{{ vpc_id}}'
AND region = '{{ region }}';