PR#1868: frontend: fix alembic migration - copr/copr

copr / copr

#1868 frontend: fix alembic migration

Merged 2 years ago by praiskup. Opened 2 years ago by schlupov.

copr/ schlupov/copr fix_user_proxy_migration into main

Silvie Chlupova • 2 years ago

7f89ec8

frontend/coprs_frontend/alembic/versions/45d0515bdc3f_drop_proxy_column.py

file modified

+2 -1

		`@@ -15,7 +15,8 @@`


		`def upgrade():`
		`- op.execute("""delete from "user" where proxy = true""")`
		`+ op.execute("""delete from user_private where user_id=(select id from "user" WHERE proxy = true);""")`
		`+ op.execute("""delete from "user" where proxy = true;""")`
		`op.drop_column('user', 'proxy')`

schlupov commented 2 years ago

The user also has to be deleted from the user_private
table.
At the time I created the migration, I didn't have the last database dump with me, so I only discovered this issue today.

Relates: #1859