petl-developers / petlx

Optional extensions for petl based on third party libraries.
MIT License
44 stars 9 forks source link

support automated database table creation upon loading #36

Closed alimanfoo closed 10 years ago

alimanfoo commented 10 years ago

This is a placeholder for adding support for creating a database table prior to loading it. I.e., a function similar to the standard petl.todb() function, but automatically generate a schema definition based on the table to be loaded, and execute the table creation, prior to loading.

It looks like sqlalchemy has good support for managing different SQL dialects, so proposed to use sqlalchemy as a dependency.

Moved from https://github.com/alimanfoo/petl/issues/225