StackRef-HM/database/1015-UPDATE-table.sr.cloud-resource-type.sql at main · StackRef/StackRef-HM · GitHub

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
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
-- Database:    sr
-- Table:       cloud_resource_type
-- Description: Add more resource costs and change aws.ec2 to aws.ec2.instance

UPDATE
    sr."cloud_resource_type"
SET
    cloud_resource_type_name = 'aws.ec2.instance',
    ts_modified = NOW()
WHERE
    cloud_resource_type_name = 'aws.ec2'
;

INSERT INTO sr."cloud_resource_type" (
    cloud_resource_type_name, cloud_resource_type_description, stackcash_cost, cloud_account_provider_id
) VALUES
    (
        'aws.ec2.volume',
        'AWS EC2 EBS Volume',
        10.00,
        (
            SELECT
                cloud_account_provider_id
            FROM
                sr.cloud_account_provider
            WHERE
                cloud_account_provider_name = 'AWS'
        )
    ),
    (
        'aws.rds.instance',
        'AWS RDS Instance',
        200.00,
        (
            SELECT
                cloud_account_provider_id
            FROM
                sr.cloud_account_provider
            WHERE
                cloud_account_provider_name = 'AWS'
        )
    ),
    (
        'aws.elasticache.replicationgroup',
        'AWS ElastiCache Redis Replication Group',
        100.00,
        (
            SELECT
                cloud_account_provider_id
            FROM
                sr.cloud_account_provider
            WHERE
                cloud_account_provider_name = 'AWS'
        )
    ),
    (
        'aws.elasticache.cachecluster',
        'AWS ElastiCache Memcache Cluster',
        100.00,
        (
            SELECT
                cloud_account_provider_id
            FROM
                sr.cloud_account_provider
            WHERE
                cloud_account_provider_name = 'AWS'
        )
    ),
    (
        'aws.lambda.function',
        'AWS Lambda Function',
        0.00,
        (
            SELECT
                cloud_account_provider_id
            FROM
                sr.cloud_account_provider
            WHERE
                cloud_account_provider_name = 'AWS'
        )
    ),
    (
        'aws.s3.bucket',
        'AWS S3 Bucket',
        10.00,
        (
            SELECT
                cloud_account_provider_id
            FROM
                sr.cloud_account_provider
            WHERE
                cloud_account_provider_name = 'AWS'
        )
    ),
    (
        'aws.dynamodb.table',
        'AWS DynamoDB Table',
        10.00,
        (
            SELECT
                cloud_account_provider_id
            FROM
                sr.cloud_account_provider
            WHERE
                cloud_account_provider_name = 'AWS'
        )
    ),
    (
        'aws.apigateway.rest',
        'AWS REST API Gateway',
        10.00,
        (
            SELECT
                cloud_account_provider_id
            FROM
                sr.cloud_account_provider
            WHERE
                cloud_account_provider_name = 'AWS'
        )
    ),
    (
        'aws.cloudfront.distribution',
        'AWS CloudFront Distribution',
        100.00,
        (
            SELECT
                cloud_account_provider_id
            FROM
                sr.cloud_account_provider
            WHERE
                cloud_account_provider_name = 'AWS'
        )
    )
;

INSERT INTO sr."cloud_resource_type" (
    cloud_resource_type_name, cloud_resource_type_description, stackcash_cost, cloud_account_provider_id
) VALUES
    (
        'aws.apigateway.http',
        'AWS HTTP API Gateway',
        10.00,
        (
            SELECT
                cloud_account_provider_id
            FROM
                sr.cloud_account_provider
            WHERE
                cloud_account_provider_name = 'AWS'
        )
    )
;