SELECT * FROM iasql_install('<modules>');
INSERT INTO bucket (name)
VALUES ('<s3NameNoPolicy>');
SELECT *
FROM bucket
WHERE name = '<s3NameNoPolicy>';
DELETE FROM bucket
WHERE name = '<s3NameNoPolicy>';
SELECT *
FROM bucket
WHERE name = '<s3NameNoPolicy>';
INSERT INTO bucket (name, policy)
VALUES ('<s3Name>', '<policyDocument>');
SELECT * FROM s3_upload_object('<s3Name>', 'iasql_message', '<bucketContent>', 'application/json');
SELECT * FROM s3_upload_object('<s3Name>', 'iasql_message_1', '<bucketContent>', 'application/json');
SELECT *
FROM bucket_object
WHERE bucket_name = '<s3Name>';
DELETE FROM bucket_object WHERE bucket_name = '<s3Name>' AND key='iasql_message';
SELECT *
FROM bucket_object
WHERE bucket_name = '<s3Name>' AND key='iasql_message';
SELECT * FROM bucket WHERE name = '<s3Name>';
DELETE FROM bucket_object WHERE bucket_name='<s3Name>';
SELECT *
FROM bucket_object
WHERE bucket_name = '<s3Name>';
INSERT INTO public_access_block (bucket_name, block_public_acls, ignore_public_acls, block_public_policy,
restrict_public_buckets)
VALUES ('<s3Name>', false, false, false, false);
SELECT *
FROM public_access_block
WHERE bucket_name = '<s3Name>'
AND block_public_acls = FALSE
AND ignore_public_acls = FALSE
AND block_public_policy = FALSE
AND restrict_public_buckets = FALSE;
UPDATE public_access_block
SET block_public_acls = true
WHERE bucket_name = '<s3Name>';
SELECT *
FROM public_access_block
WHERE bucket_name = '<s3Name>'
AND block_public_acls = TRUE
AND ignore_public_acls = FALSE
AND block_public_policy = FALSE
AND restrict_public_buckets = FALSE;
DELETE
FROM public_access_block
WHERE bucket_name = '<s3Name>';
INSERT INTO bucket_website (bucket_name, index_document)
VALUES ('<s3Name>', 'index.html');
SELECT *
FROM bucket_website
WHERE bucket_name = '<s3Name>'
AND index_document = 'index.html';
UPDATE bucket_website
SET error_document = 'error.html'
WHERE bucket_name = '<s3Name>';
SELECT *
FROM bucket_website
WHERE bucket_name = '<s3Name>'
AND index_document = 'index.html' AND error_document = 'error.html';
DELETE
FROM bucket_website
WHERE bucket_name = '<s3Name>';