]> git.lizzy.rs Git - cheatdb.git/commitdiff
Fix migration misordering
authorrubenwardy <rw@rubenwardy.com>
Sun, 12 Jul 2020 01:45:19 +0000 (02:45 +0100)
committerrubenwardy <rw@rubenwardy.com>
Sun, 12 Jul 2020 01:45:19 +0000 (02:45 +0100)
migrations/versions/838081950f27_.py

index f30d547f0b3bf516872189f9ca021f3a1cf286df..b8e5db0736178bc8bd1693964d64740745328d00 100644 (file)
@@ -17,14 +17,14 @@ depends_on = None
 
 
 def upgrade():
-       op.create_check_constraint("mp_name_valid", "meta_package", "name ~* '^[a-z0-9_]+$'")
-
        op.execute("""
                DELETE FROM provides AS t USING meta_package AS m WHERE t.metapackage_id = m.id AND NOT (m.name ~* '^[a-z0-9_]+$');
                DELETE FROM dependency AS t USING meta_package AS m WHERE t.meta_package_id = m.id AND NOT (m.name ~* '^[a-z0-9_]+$');
                DELETE FROM meta_package WHERE NOT (name ~* '^[a-z0-9_]+$');
        """)
 
+       op.create_check_constraint("mp_name_valid", "meta_package", "name ~* '^[a-z0-9_]+$'")
+
 
 def downgrade():
        op.drop_constraint("mp_name_valid", "meta_package", type_="check")