Metadata-Version: 2.0
Name: tableschema-sql
Version: 0.10.2
Summary: Generate SQL tables, load and extract data, based on JSON Table Schema descriptors.
Home-page: https://github.com/frictionlessdata/tableschema-sql-py
Author: Open Knowledge Foundation
Author-email: info@okfn.org
License: MIT
Keywords: frictionless data
Platform: UNKNOWN
Classifier: Development Status :: 4 - Beta
Classifier: Environment :: Web Environment
Classifier: Intended Audience :: Developers
Classifier: License :: OSI Approved :: MIT License
Classifier: Operating System :: OS Independent
Classifier: Programming Language :: Python :: 2
Classifier: Programming Language :: Python :: 2.7
Classifier: Programming Language :: Python :: 3
Classifier: Programming Language :: Python :: 3.3
Classifier: Programming Language :: Python :: 3.4
Classifier: Programming Language :: Python :: 3.5
Classifier: Topic :: Internet :: WWW/HTTP :: Dynamic Content
Classifier: Topic :: Software Development :: Libraries :: Python Modules
Requires-Dist: pybloom-live (<3.0,>=2.2)
Requires-Dist: six (>=1.9,<2.0)
Requires-Dist: sqlalchemy (>=1.0,<2.0)
Requires-Dist: tableschema (>=1.0,<2.0)
Requires-Dist: tabulator (>=1.0.0a5,<2.0)
Provides-Extra: develop
Requires-Dist: psycopg2; extra == 'develop'
Requires-Dist: pylama; extra == 'develop'
Requires-Dist: pymysql; extra == 'develop'
Requires-Dist: python-dotenv; extra == 'develop'
Requires-Dist: tox; extra == 'develop'

tableschema-sql-py
==================

| |Travis|
| |Coveralls|
| |PyPi|
| |Gitter|

Generate and load SQL tables based on `Table
Schema <http://specs.frictionlessdata.io/table-schema/>`__ descriptors.

Features
--------

-  implements ``tableschema.Storage`` interface
-  provides additional features like indexes and updating

Getting Started
---------------

Installation
~~~~~~~~~~~~

The package use semantic versioning. It means that major versions could
include breaking changes. It's highly recommended to specify ``package``
version range in your ``setup/requirements`` file e.g.
``package>=1.0,<2.0``.

.. code:: bash

    pip install tableschema-sql

Examples
~~~~~~~~

Code examples in this readme requires Python 3.3+ interpreter. You could
see even more example in
`examples <https://github.com/frictionlessdata/tableschema-sql-py/tree/master/examples>`__
directory.

.. code:: python

    from tableschema import Table
    from sqlalchemy import create_engine

    # Load and save table to SQL
    engine = create_engine('sqlite://')
    table = Table('data.csv', schema='schema.json')
    table.save('data', storage='sql', engine=engine)

Documentation
-------------

The whole public API of this package is described here and follows
semantic versioning rules. Everyting outside of this readme are private
API and could be changed without any notification on any new version.

Storage
~~~~~~~

Package implements `Tabular
Storage <https://github.com/frictionlessdata/tableschema-py#storage>`__
interface (see full documentation on the link):

|Storage|

This driver provides an additional API:

``Storage(engine, dbschema=None, prefix='', reflect_only=None, autoincrement=False)``
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

-  ``engine (object)`` - ``sqlalchemy`` engine
-  ``dbschema (str)`` - name of database schema
-  ``prefix (str)`` - prefix for all buckets
-  ``reflect_only (callable)`` - a boolean predicate to filter the list
   of table names when reflecting
-  ``autoincrement (bool)`` - add autoincrement column at the beginning

``storage.create(..., indexes_fields=None)``
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

-  ``indexes_fields (str[])`` - list of tuples containing field names,
   or list of such lists

``storage.write(..., keyed=False, as_generator=False, update_keys=None)``
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

-  ``keyed (bool)`` - accept keyed rows
-  ``as_generator (bool)`` - returns generator to provide writing
   control to the client
-  ``update_keys (str[])`` - update instead of inserting if key values
   match existent rows

Contributing
------------

The project follows the `Open Knowledge International coding
standards <https://github.com/okfn/coding-standards>`__.

| Recommended way to get started is to create and activate a project
virtual environment.
| To install package and development dependencies into active
environment:

::

    $ make install

To run tests with linting and coverage:

.. code:: bash

    $ make test

| For linting ``pylama`` configured in ``pylama.ini`` is used. On this
stage it's already
| installed into your environment and could be used separately with more
fine-grained control
| as described in documentation -
https://pylama.readthedocs.io/en/latest/.

For example to sort results by error type:

.. code:: bash

    $ pylama --sort <path>

| For testing ``tox`` configured in ``tox.ini`` is used.
| It's already installed into your environment and could be used
separately with more fine-grained control as described in documentation
- https://testrun.org/tox/latest/.

| For example to check subset of tests against Python 2 environment with
increased verbosity.
| All positional arguments and options after ``--`` will be passed to
``py.test``:

.. code:: bash

    tox -e py27 -- -v tests/<path>

| Under the hood ``tox`` uses ``pytest`` configured in ``pytest.ini``,
``coverage``
| and ``mock`` packages. This packages are available only in tox
envionments.

Changelog
---------

Here described only breaking and the most important changes. The full
changelog and documentation for all released versions could be found in
nicely formatted `commit
history <https://github.com/frictionlessdata/tableschema-sql-py/commits/master>`__.

v0.x
~~~~

Initial driver implementation.

.. |Travis| image:: https://img.shields.io/travis/frictionlessdata/tableschema-sql-py/master.svg
   :target: https://travis-ci.org/frictionlessdata/tableschema-sql-py
.. |Coveralls| image:: http://img.shields.io/coveralls/frictionlessdata/tableschema-sql-py/master.svg
   :target: https://coveralls.io/r/frictionlessdata/tableschema-sql-py?branch=master
.. |PyPi| image:: https://img.shields.io/pypi/v/tableschema-sql.svg
   :target: https://pypi.python.org/pypi/tableschema-sql
.. |Gitter| image:: https://img.shields.io/gitter/room/frictionlessdata/chat.svg
   :target: https://gitter.im/frictionlessdata/chat
.. |Storage| image:: https://i.imgur.com/RQgrxqp.png

