Skip to main content

Generate SQL tables, load and extract data, based on JSON Table Schema descriptors.

Project description

tableschema-sql-py

Travis Coveralls PyPi Gitter

Generate and load SQL tables based on Table Schema descriptors.

Features

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

Contents

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.

pip install tableschema-sql

Examples

Code examples in this readme requires Python 3.3+ interpreter. You could see even more example in examples directory.

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

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:

$ 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:

$ 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:

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.

v1.0

  • Added FK support for SQLite databases

v0.x

  • Initial driver implementation.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

tableschema-sql-1.0.2.tar.gz (12.9 kB view details)

Uploaded Source

Built Distribution

tableschema_sql-1.0.2-py2.py3-none-any.whl (11.0 kB view details)

Uploaded Python 2 Python 3

File details

Details for the file tableschema-sql-1.0.2.tar.gz.

File metadata

  • Download URL: tableschema-sql-1.0.2.tar.gz
  • Upload date:
  • Size: 12.9 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.13.0 pkginfo/1.5.0.1 requests/2.22.0 setuptools/41.2.0 requests-toolbelt/0.9.1 tqdm/4.35.0 CPython/2.7.15

File hashes

Hashes for tableschema-sql-1.0.2.tar.gz
Algorithm Hash digest
SHA256 1f6cfa7203e259f5e8a8d7a61c0c87febb43529d63780291034b36603bc30827
MD5 442cef413515d166ea91c169e7ec53c7
BLAKE2b-256 e2d3120394f3ebd0204fbfc0f956cad6d198c16527f0dd2ed7ee414fb693366f

See more details on using hashes here.

Provenance

File details

Details for the file tableschema_sql-1.0.2-py2.py3-none-any.whl.

File metadata

  • Download URL: tableschema_sql-1.0.2-py2.py3-none-any.whl
  • Upload date:
  • Size: 11.0 kB
  • Tags: Python 2, Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.13.0 pkginfo/1.5.0.1 requests/2.22.0 setuptools/41.2.0 requests-toolbelt/0.9.1 tqdm/4.35.0 CPython/2.7.15

File hashes

Hashes for tableschema_sql-1.0.2-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 97c38dd18283f0288c92e4cf322bb24bd08d9e0e106d0ef99ce8509daa92be3b
MD5 76d0fcf0606b4d972076de723cb3c6e7
BLAKE2b-256 80c2b59dc17f9045541f12fbe0c706af4e955b5368b510b0ac5defcea885b54f

See more details on using hashes here.

Provenance

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