Skip to main content

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

Redshift

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.

Source Distributions

No source distribution files available for this release.See tutorial on generating distribution archives.

Built Distribution

sql_helper-0.0.18-py3-none-any.whl (12.2 kB view hashes)

Uploaded Python 3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page