ssh_accounts

Components

Tables

    ssh_credentials

Functions

    ssh_exec

    ssh_ls

    ssh_mkdir

    ssh_mv

    ssh_read_file_text

    ssh_rm

    ssh_rmdir

    ssh_write_file_text

Code examples

SSH Accounts Integration Testing

--- can run a command
SELECT * FROM ssh_exec('<prefix>', 'echo Hello, World');
--- can list a directory
SELECT * FROM ssh_ls('<prefix>', '/home/ubuntu');
--- can create a directory
SELECT * FROM ssh_mkdir('<prefix>', '/home/ubuntu/<prefix>');
--- can create a file
SELECT * FROM ssh_write_file_text('<prefix>', '/home/ubuntu/<prefix>.txt', 'test file');
--- can read a file
SELECT * FROM ssh_read_file_text('<prefix>', '/home/ubuntu/<prefix>.txt');
--- can move a file
SELECT * FROM ssh_mv('<prefix>', '/home/ubuntu/<prefix>.txt', '/home/ubuntu/<prefix>/new_location');
--- can delete a file
SELECT * FROM ssh_rm('<prefix>', '/home/ubuntu/<prefix>/new_location');
--- can delete a directory
SELECT * FROM ssh_rmdir('<prefix>', '/home/ubuntu/<prefix>');
--- deletes the ssh server
DELETE FROM ssh_credentials WHERE "name" = '<prefix>';