iasql_platform

Components

Tables

    iasql_audit_log

    iasql_tables

Enums

    audit_log_change_type

Code examples

iasql_audit_log functionality

--- installs the aws_account module
SELECT * FROM iasql_install('aws_account');
--- inserts aws credentials
INSERT INTO aws_credentials (access_key_id, secret_access_key)
VALUES ('<AWS_ACCESS_KEY_ID>', '<AWS_SECRET_ACCESS_KEY>');
--- should work with no arguments retrieving all logs
SELECT * FROM iasql_get_sql_since();
--- should work with a valid text timestamp
SELECT * FROM iasql_get_sql_since('2023-01-01T12:00:00');
--- should work with a dynamic date
SELECT * FROM iasql_get_sql_since(now() + interval '2 seconds');
--- manual inserts on iasql audit logs
INSERT INTO iasql_audit_log (ts, table_name, "user", change_type, change)
VALUES (NOW(), 'iasql_audit_log', SESSION_USER, 'INSERT',  ('')::json);
--- checks update sql
SELECT * FROM iasql_get_sql_since();
--- checks delete sql
SELECT * FROM iasql_get_sql_since();
--- installs the aws_elb module
SELECT * FROM iasql_install('aws_elb');
--- begin a transaction
SELECT * FROM iasql_begin();
--- adds a new load balancer
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;
--- checks sql sub-query tables load_balancer and security_group for load_balancer_security_group join table
SELECT * FROM iasql_get_sql_since();
--- checks timestamp update
SELECT *
FROM iasql_audit_log
WHERE change_type = 'INSERT' AND table_name IN ('load_balancer_security_groups', 'load_balancer');

List tables functionality

--- compare iasql_tables with iasql_modules_installed
SELECT *
FROM iasql_modules_installed()
WHERE module_name NOT LIKE 'iasql_%'
AND module_name != 'aws_sdk'
AND concat_ws('@', module_name, module_version) NOT IN (SELECT module
FROM iasql_tables);