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');
--- 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, attributes, availability_zones)
VALUES ('<lbName>', '<lbScheme>', null, '<lbType>', '<lbIPAddressType>', ';
--- 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);