Helper funcs and tools for working with SQL in mysql, postgresql, and more
Project description
About
This is meant to be a simple way to explore a postgresql/mysql/sqlite database and get data out (super light wrapper to SQLAlchemy).
Connect with DB url in the following formats:
postgresql://someuser:somepassword@somehost[:someport]/somedatabase
mysql://someuser:somepassword@somehost[:someport]/somedatabase
sqlite:///somedb.db
Note: This package uses pymysql driver for connecting to mysql. Urls that start with mysql:// will automatically be changed to use mysql+pymysql://.
Install
Ensure the pg_config executable is on the system
$ sudo apt-get install -y libpq-dev or $ brew install postgresql
Then install sql-helper
$ pip3 install sql-helper
Usage
In [1]: from sql_helper import SQL In [2]: sql = SQL('postgresql://someuser:somepassword@somehost/somedatabase') In [3]: table_names = sql.get_tables() In [4]: results = sql.execute('SELECT ...')
Extra
Install sqlalchemy-redshift wherever you installed sql-helper
$ venv/bin/pip3 install sqlalchemy-redshift
Connect with DB url in the following format:
redshift+psycopg2://someuser:somepassword@somehost/somedatabase
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distributions
Built Distribution
Hashes for sql_helper-0.0.18-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 9579b82ba0d97854c25451911b28cb121a7f2a6c0e17cbb07601e089940c0384 |
|
MD5 | ecd40a36cb4ef933714fcc9f1c57a74e |
|
BLAKE2b-256 | 80fc512ce11bf510ac77bdfc5642d151dcbb89b820dabc5934f6884b576b6f40 |