aws_ecs_simplified

Components

Code examples

Manage ECS simplified

--- installs the ecs simplified module and its dependencies
SELECT * FROM iasql_install('<modules>');
--- adds a new row
INSERT INTO ecs_simplified (app_name, desired_count, app_port, cpu_mem, image_tag, public_ip)
VALUES ('<appName>',<desiredCount>,<appPort>, '<cpuMem>', '<imageTag>',<publicIp>);
--- updates a row
UPDATE ecs_simplified
SET app_port =<appName>WHERE app_name = '';
--- deletes the app
delete from ecs_simplified
where app_name = '<appName>';
--- updates a row
UPDATE ecs_simplified
SET app_port =<appName>WHERE app_name = '';
--- updates a row
UPDATE ecs_simplified
SET cpu_mem = '<updateCpuMem>', image_tag = '<updateImageTag>'
WHERE app_name = '<appName>';
--- updates env vars
UPDATE ecs_simplified SET env_variables = '<envVariables>' WHERE app_name = '<appName>';
--- deletes the app
delete from ecs_simplified
where app_name = '<appName>';