Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Updating SQL tables with indexes in dump_to_sql #170

Open
pwalsh opened this issue Sep 18, 2021 · 1 comment
Open

Updating SQL tables with indexes in dump_to_sql #170

pwalsh opened this issue Sep 18, 2021 · 1 comment

Comments

@pwalsh
Copy link
Contributor

pwalsh commented Sep 18, 2021

Relates to #169

With support for index fields, the question arises regarding updating existing tables. There is no migration process now, so if one added indexes and wanted to apply them to an existing table when updating data, there is no possibility via the sql dumper.

Update runs could probably use Alembic and specifically https://alembic.sqlalchemy.org/en/latest/autogenerate.html to handle this.

@pwalsh pwalsh changed the title Updating SQL tables with indexes in sump_to_sql Updating SQL tables with indexes in dump_to_sql Sep 18, 2021
@akariv
Copy link
Member

akariv commented Sep 19, 2021

Yes, using alembic would be pretty cool - perhaps as an improvement to the current tableschema-sql inner workings.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants