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

update db schema to included last updated on for each table #40

Open
falkben opened this issue Mar 23, 2022 · 0 comments
Open

update db schema to included last updated on for each table #40

falkben opened this issue Mar 23, 2022 · 0 comments

Comments

@falkben
Copy link
Owner

falkben commented Mar 23, 2022

Related to #39 we want a way to track when data in the database has been updated.

for an "updated_on" column, alembic won't auto-generated data for existing rows. We need to create a migration manually to support adding columns that have a default value.

One suggestion i've seen is that inside the migration, copy the data to a separate table with a new name, then copy it back into the original named table, with the updated column.

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

1 participant