aws_cloudfront

Components

Tables

    distribution

Enums

    origin_protocol_policy

    viewer_protocol_policy

Code examples

Manage CloudFront

--- installs the cloudfront module
SELECT * FROM iasql_install('<modules>');
--- creates a dummy s3 resource
INSERT INTO bucket (name) VALUES ('<bucket>');
--- check distribution is available
SELECT * FROM distribution WHERE caller_reference='<s3CallerReference>';
--- adds a new distribution
INSERT INTO distribution (caller_reference, comment, enabled, is_ipv6_enabled, default_cache_behavior, origins )
VALUES ('<callerReference>', 'a comment', true, false, '<behaviorString>', '<originsString>');
--- check distribution is available
SELECT * FROM distribution WHERE caller_reference='<callerReference>';
--- tries to update distribution comment
UPDATE distribution SET comment='new comment' WHERE caller_reference='<callerReference>';
--- checks that distribution have been modified
SELECT * FROM distribution WHERE caller_reference='<callerReference>' AND comment='new comment';
--- deletes the distribution
DELETE FROM distribution
WHERE caller_reference = '<callerReference>';
--- deletes the s3 bucket
DELETE FROM bucket WHERE name = '<bucket>';