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

Should be able to save tables to MySQL #65

Closed roll closed 6 years ago

roll commented 6 years ago

@vshih wrote:

import sqlalchemy as sa
engine = sa.create_engine('mysql://...')
from jsontableschema import Table
t = Table(SOURCE, SCHEMA)
t.save('test_package', backend='sql', engine=engine)
# _mysql_exceptions.ProgrammingError: (1146, "Table 'mydatabase.users' doesn't exist")

related #64

roll commented 6 years ago

@vshih Sorry right now we're totally our of resources to work on MySQL issue (for now it's tested only for Postgresql). We'll be on it as soon as possible.

roll commented 6 years ago

MERGED https://github.com/frictionlessdata/tableschema-sql-py/issues/64