Metadata-Version: 2.1
Name: py2edw
Version: 0.0.76
Summary: A high level Python wrapper for remotely connecting to SQL databases and querying using pandas dataframes.
Home-page: https://github.com/renzobecerra/py2edw
Author: Renzo Becerra
Author-email: rbecerra@nameless.ai
License: MIT
Platform: UNKNOWN
Classifier: License :: OSI Approved :: MIT License
Classifier: Programming Language :: Python :: 3
Classifier: Programming Language :: Python :: 3.7
Description-Content-Type: text/markdown
Requires-Dist: psycopg2-binary
Requires-Dist: sshtunnel
Requires-Dist: pandas

# 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

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

#### 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>}`

#### Example code:
`py2edw = postgresql.py2edw(db_params, ssh_params=False)`

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

`py2edw.help()`


