Myconnections
Connects to Oracle databases or sftp servers depending on configured environmental variables.
VERY IMPORTANT: VPN must exist.
Installation
Use the package manager pip to install myconnections.
pip install git+https://github.com/jtorre94/myconnections
Usage
from myconnections import Connections
# automatically detects the connection type and returns the connection object.
conn_bwup = Connections('RBIP')
conn_serafin = Connections('SERAFIN')
Configuring environmental variables to make it work
Five environmental variables per connection must be configured: The below example is configured for an Oracle DB called BWUP.
| Variable name | Example value |
|---|---|
| BWUP_TYPE | ORACLE |
| BWUP_USER | MY_USER |
| BWUP_PASS | MY_PASSWORD |
| BWUP_HOSTNAME | XX.X.XXX.XX (digits) |
| BWUP_PORT | 1541 |
The below example is for a sftp server called SERAFIN.
| Variable name | Example value |
|---|---|
| SERAFIN_TYPE | SFTP |
| SERAFIN_USER | MY_USER |
| SERAFIN_PASS | MY_PASSWORD |
| SERAFIN_HOSTNAME | XX.X.XXX.XX (digits) |
| SERAFIN_PORT | None |
Contributing
Pull requests are welcome. For major changes, please open an issue first to discuss what you would like to change.
Please make sure to update tests as appropriate.
125 Jan 04, 2023
120 Nov 20, 2022
1.4k Jan 06, 2023
3.5k Dec 31, 2022
68 Sep 09, 2022
105 Dec 24, 2022
23 Apr 30, 2022
2 Jan 30, 2022
269 Dec 20, 2022
401 Dec 11, 2022
30 Dec 16, 2022
1 Jan 03, 2022
1.2k Dec 29, 2022
69 Nov 03, 2022
32 Dec 26, 2022
3 Feb 13, 2022
0 Jan 23, 2022
1 Oct 23, 2021
1 Dec 19, 2021
1 Dec 24, 2021