Metadata-Version: 2.0
Name: sqlian
Version: 0.1.0.dev0
Summary: A good SQLian like a good shepherd.
Home-page: https://github.com/uranusjr/sqlian
Author: Tzu-ping Chung
Author-email: uranusjr@gmail.com
License: ISC
Keywords: SQL
Platform: UNKNOWN
Classifier: Development Status :: 2 - Pre-Alpha
Classifier: Intended Audience :: Developers
Classifier: License :: OSI Approved :: ISC License (ISCL)
Classifier: Natural Language :: English
Classifier: Programming Language :: SQL
Classifier: Programming Language :: Python
Classifier: Programming Language :: Python :: 2
Classifier: Programming Language :: Python :: 2.7
Classifier: Programming Language :: Python :: 3
Classifier: Programming Language :: Python :: 3.4
Classifier: Programming Language :: Python :: 3.5
Classifier: Programming Language :: Python :: 3.6
Classifier: Programming Language :: Python :: Implementation :: CPython
Classifier: Programming Language :: Python :: Implementation :: PyPy
Requires-Dist: six

=======
SQLian
=======

.. image:: https://travis-ci.org/uranusjr/sqlian.svg?branch=master
    :target: https://travis-ci.org/uranusjr/sqlian
    :alt: Project Build Status

.. image:: https://readthedocs.org/projects/sqlian/badge/?version=latest
    :target: http://sqlian.readthedocs.io/en/latest/?badge=latest
    :alt: Documentation Status


A good SQLian like a good shepherd. I handle SQL strings so you don’t have to.


Sneak Peek
============

Connect to a database::

    import sqlian
    db = sqlian.connect('postgresql:://user:pa55@localhost/contactbook')


Perform a query::

    rows = db.select(
        'name', 'occupation',
        from_='person',
        where={'main_language': 'Python'},
    )


Access the data directly::

    >>> rows[0]
    <Record {"name": "Mosky", "occupation": "Pinkoi"}>


Or iterate over them::

    for r in rows:
        print('{} works at {}'.format(r.name, r.occupation))


Want more? `Read the documentation. <https://sqlian.readthedocs.io/en/latest/#table-of-contents>`__




