Skip to main content
Donate to the Python Software Foundation or Purchase a PyCharm License to Benefit the PSF! Donate Now

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.

Filename, size & hash SHA256 hash help File type Python version Upload date
sql_helper-0.0.5-py3-none-any.whl (4.4 kB) Copy SHA256 hash SHA256 Wheel py3

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN SignalFx SignalFx Supporter DigiCert DigiCert EV certificate StatusPage StatusPage Status page