aws_api_gateway

Components

Tables

    api

Enums

    protocol

Code examples

Manage API gateway

--- installs the API gateway module
SELECT * FROM iasql_install('<modules>');
--- adds a new API gateway
INSERT INTO api (name, description, disable_execute_api_endpoint, version, tags)
VALUES ('<apiName>', 'description', false, '1.0', '{"toUpdate": "value", "toDelete": "value"}');
--- check API gateway is available
SELECT * FROM api WHERE name='<apiName>';
--- tries to update API description
UPDATE api SET description='new description', tags = '{"toUpdate": "value2", "newTag": "value"}' WHERE name='<apiName>';
--- checks that API has been been modified
SELECT * FROM api WHERE description='new description' and name='<apiName>';
--- deletes the API
DELETE FROM api
WHERE name = '<apiName>';