stackql-deploy 2.1.1

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

/*+ exists, retries=10, retry_delay=5 */
SELECT
  id as subnet_route_table_assn_id
FROM awscc.ec2.vw_subnet_route_table_associations
WHERE
  region = '{{ region }}'
  AND route_table_id = '{{ route_table_id }}'
  AND subnet_id = '{{ subnet_id }}';

/*+ create */
INSERT INTO awscc.ec2.subnet_route_table_associations (
 RouteTableId,
 SubnetId,
 region
)
SELECT
 '{{ route_table_id }}',
 '{{ subnet_id }}',
 '{{ region }}'
RETURNING *;

/*+ exports */
SELECT '{{ this.subnet_route_table_assn_id }}' as subnet_route_table_assn_id;

/*+ delete */
DELETE FROM awscc.ec2.subnet_route_table_associations
WHERE
Identifier = '{{ subnet_route_table_assn_id }}' AND
region = '{{ region }}';