Skip to main content

Helper funcs and tools for working with SQL in mysql or postgresql

Project description

About

This is meant to be a simple way to explore a postgresql/mysql database and get data out (super light wrapper to SQLAlchemy).

Connect with DB url in the following formats:

  • postgresql://someuser:somepassword@somehost/somedatabase

  • mysql://someuser:somepassword@somehost/somedatabase

    Note: This package uses pymysql driver for connecting to mysql. Urls that start with mysql:// will automatically be changed to use mysql+pymysql://.

Install

$ 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

Redshift

Ensure the pg_config executable is on the system
$ sudo apt-get install -y libpq-dev

or

$ brew install postgresql

Then 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


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for sql-helper, version 0.0.7
Filename, size File type Python version Upload date Hashes
Filename, size sql_helper-0.0.7-py3-none-any.whl (5.5 kB) File type Wheel Python version py3 Upload date Hashes View

Supported by

Pingdom Pingdom Monitoring Google Google Object Storage and Download Analytics Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page