Metadata-Version: 2.1
Name: sql-helper
Version: 0.0.2
Summary: Helper funcs and tools for working with SQL in mysql or postgresql
Home-page: https://github.com/kenjyco/sql-helper
Author: Ken
Author-email: kenjyco@gmail.com
License: MIT
Download-URL: https://github.com/kenjyco/sql-helper/tarball/v0.0.2
Keywords: sql,mysql,postgresql,helper
Platform: UNKNOWN
Classifier: Development Status :: 3 - Alpha
Classifier: Environment :: Console
Classifier: License :: OSI Approved :: MIT License
Classifier: Programming Language :: Python
Classifier: Programming Language :: Python :: 3.5
Classifier: Topic :: Software Development :: Libraries
Classifier: Intended Audience :: Developers
Requires-Dist: SQLAlchemy (==1.3.2)
Requires-Dist: psycopg2-binary (==2.8.1)
Requires-Dist: PyMySQL (==0.9.3)
Requires-Dist: settings-helper

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 ...')


