semvec/pypi-packages huggingface dataset:
py2edw 0.0.92
A high level Python wrapper for remotely connecting to SQL databases and querying using pandas dataframes.
License: MIT

# py2edw
A high level Python wrapper for remotely connecting to SQL databases and querying using pandas dataframes.

- SQL commands can be executed using the SQL operator.
- All queries input and outout using pandas dataframes.
- Optional ssh tunnel connection

#### Connectors:
- postgresql
- mysql

#### Import:
`from py2edw import postgresql, mysql`

#### db  & ssh parameter format:
`db_params = {"database": <db_name>, "user": <username>, "password": <password>, "host": <host>}`

`ssh_params = {"ssh_ip": <ip_address>, "ssh_port": <port>, "ssh_username": <username>, "ssh_password": <password>, "remote_bind_ip": <local_ip>, "remote_bind_port": <local_port>}`

#### Sample code:
`py2edw = mysql.py2edw(db_params, ssh_params=False)`

`py2edw.import_DataFrame("select * from table_name")`

#### Avaliable operators:
- sql
- import
- insert
- upsert
- start connection
- close connection
- show tables

`py2edw.help()` for details