search

frictionlessdata / tableschema-sql-py

Generate SQL tables, load and extract data, based on JSON Table Schema descriptors.
MIT License
60 stars 19 forks source link

Updated to specs-v1 and improved databases support #68

Closed roll closed 7 years ago

roll commented 7 years ago

It fixes main initial implementation flaw with not supported types. Now if a database doesn't support type it uses a string fallback. As a result now we support all specs-v1 types (added to tests) and more databases (sqlite and mysql tested).

Also it includes some minor improvements and simplifies tests (schema/data in the same file instead of reading it from the disc for convenience).

Tests provide good overview how it works with types now - https://github.com/frictionlessdata/tableschema-sql-py/blob/more-databases/tests/test_storage.py

roll commented 7 years ago

@akariv Please take a look.

roll commented 7 years ago

@akariv Thanks!