ssh_docker

Components

Tables

    docker_container

Enums

    docker_container_states

Code examples

SSH Docker Integration Testing

--- waits for cloud-init to finish
SELECT * FROM ssh_exec('<prefix>', 'cloud-init status --wait');
--- checks docker is running
SELECT * FROM ssh_exec('<prefix>', 'sudo docker ps');
--- creates a new httpd container
INSERT INTO docker_container (server_name, name, image, ports, state)
VALUES ('<prefix>', 'httpd-container', 'httpd',
'{"80/tcp": [{"HostIp": "", "HostPort": "8080"}]}', 'created');
--- updates the container state to running
UPDATE docker_container
SET state = 'running'
WHERE server_name = '<prefix>'
AND name = 'httpd-container';
--- stops the container
UPDATE docker_container
SET state = 'exited'
WHERE server_name = '<prefix>'
AND name = 'httpd-container';
--- deletes the container
DELETE FROM docker_container
WHERE server_name = '<prefix>'
AND name = 'httpd-container';
--- checks the container is deleted
SELECT * FROM docker_container
WHERE server_name = '<prefix>'
AND name = 'httpd-container';