Generate and load SQL tables based on JSON Table Schema descriptors.
Version v0.3 contains breaking changes:
renamed Storage.tables to Storage.buckets
changed Storage.read to read into memory
added Storage.iter to yield row by row
Getting Started
Installation
pip install jsontableschema-sqlStorage
Package implements Tabular Storage interface.
SQLAlchemy is used as sql wrapper. We can get storage this way:
from sqlalchemy import create_engine
from jsontableschema_sql import Storage
engine = create_engine('sqlite:///:memory:', prefix='prefix')
storage = Storage(engine)Then we could interact with storage:
storage.buckets
storage.create('bucket', descriptor)
storage.delete('bucket')
storage.describe('bucket') # return descriptor
storage.iter('bucket') # yield rows
storage.read('bucket') # return rows
storage.write('bucket', rows)Mappings
schema.json -> SQL table schema data.csv -> SQL talbe data
Drivers
SQLAlchemy is used - docs.
API Reference
Snapshot
https://github.com/frictionlessdata/jsontableschema-py#snapshot
Detailed
Contributing
Please read the contribution guideline:
Thanks!
Release files for jsontableschema-sql 0.8.0
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| jsontableschema-sql-0.8.0.tar.gz | 9.2 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| jsontableschema_sql-0.8.0-py2.py3-none-any.whl | Python 2, Python 3 | none | any | Details |
Total release size: 19.8 kB
Release files / jsontableschema-sql-0.8.0.tar.gz
| Download URL | jsontableschema-sql-0.8.0.tar.gz |
|---|---|
| Size | 9.2 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
a0ace5efbb66bb875e8a9d4e9735d267d77cf58cb568d55f9853f8465f06acdb
|
|
BLAKE2b-256 checksum How to use checksums |
2f7803febef2cd1268e55469be1cfa68a06bf8f2bd69ff2e79734085155d8f70
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
Release files / jsontableschema_sql-0.8.0-py2.py3-none-any.whl
| Download URL | jsontableschema_sql-0.8.0-py2.py3-none-any.whl |
|---|---|
| Size | 10.6 kB |
| Tags | Python 2 Python 3 |
|
SHA-256 checksum How to use checksums |
fde0700cacf2174d80e4619d24f7905f2832ee59b02eb7481aaad73a9fd6811c
|
|
BLAKE2b-256 checksum How to use checksums |
4e900dc3230fcdf14e76424bbf9ad8349d5b9058bae2b0669719dbb21f2b0f1f
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
