py2edw 0.0.76

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

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()