SELECT * FROM iasql_install('aws_account');
INSERT INTO aws_credentials (access_key_id, secret_access_key)
VALUES ('<AWS_ACCESS_KEY_ID>', '<AWS_SECRET_ACCESS_KEY>');
SELECT * FROM iasql_get_sql_since();
SELECT * FROM iasql_get_sql_since('2023-01-01T12:00:00');
SELECT * FROM iasql_get_sql_since(now() + interval '2 seconds');
INSERT INTO iasql_audit_log (ts, table_name, "user", change_type, change)
VALUES (NOW(), 'iasql_audit_log', SESSION_USER, 'INSERT', ('')::json);
SELECT * FROM iasql_get_sql_since();
SELECT * FROM iasql_get_sql_since();
SELECT * FROM iasql_install('aws_elb');
SELECT * FROM iasql_begin();
BEGIN;
INSERT INTO load_balancer (load_balancer_name, scheme, vpc, load_balancer_type, ip_address_type)
VALUES ('<lbName>', '<lbScheme>', null, '<lbType>', '<lbIPAddressType>');
INSERT INTO load_balancer_security_groups(load_balancer_id, security_group_id)
SELECT (SELECT id FROM load_balancer WHERE load_balancer_name = '<lbName>'),
(SELECT id FROM security_group WHERE group_name = 'default' AND region = '<region>');
COMMIT;
SELECT * FROM iasql_get_sql_since();
SELECT *
FROM iasql_audit_log
WHERE change_type = 'INSERT' AND table_name IN ('load_balancer_security_groups', 'load_balancer');