Add possibility of database connections being done via SSH and SSL for each database (MySQL, PostgreSQL, SQLServer and MariaDB)
Description
Currently, the only way to connect to databases are using direct connections with user, password, host, port, database name and/or schema. The idea of this task would be to test and apply some functions that use SSH and SSL to connect to databases to make it possible for the databases that only use those types of connections to connect successfully.
Tests
One way of testing this would be:
Spin up a docker container with a test database that uses SSH and/or SSL to connect to it.
Create a simple code that connects to that database using the SSH and/or SSL
When the code is working, add it as a connection option on the python class that deals with connecting to the database
Add parameter options on the pythonrest generate command that will accept the SSH and SSL additional parameters
Add environment variables to choose whether the connection with the database is done directly, or via SSH or via SSL.
Goal
Add possibility of database connections being done via SSH and SSL for each database (MySQL, PostgreSQL, SQLServer and MariaDB)
Description
Currently, the only way to connect to databases are using direct connections with user, password, host, port, database name and/or schema. The idea of this task would be to test and apply some functions that use SSH and SSL to connect to databases to make it possible for the databases that only use those types of connections to connect successfully.
Tests
One way of testing this would be:
Classes to be changed
EnvironmentVariables.py pythonrest.py MySqlConnection.py MsSqlConnection.py PgSqlConnection.py MariaDbSqlConnection.py MySqlConnectionResolver.py MsSqlConnectionResolver.py PgSqlConnectionResolver.py MariaDbSqlConnectionResolver.py