1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
|
"""
Fix ForeignKey constraint definitions
Revision ID: 840b460c5613
Created at: 2016-08-15 18:39:30.909867
"""
import sqlalchemy as sa
from alembic import op
revision = "840b460c5613"
down_revision = "7f6baf38c27c"
branch_labels = None
depends_on = None
def upgrade():
op.drop_constraint("post_user_id_fkey", "post", type_="foreignkey")
op.drop_constraint("snapshot_user_id_fkey", "snapshot", type_="foreignkey")
op.create_foreign_key(
None, "post", "user", ["user_id"], ["id"], ondelete="SET NULL"
)
op.create_foreign_key(
None, "snapshot", "user", ["user_id"], ["id"], ondelete="set null"
)
def downgrade():
op.drop_constraint(None, "snapshot", type_="foreignkey")
op.drop_constraint(None, "post", type_="foreignkey")
op.create_foreign_key(
"snapshot_user_id_fkey", "snapshot", "user", ["user_id"], ["id"]
)
op.create_foreign_key(
"post_user_id_fkey", "post", "user", ["user_id"], ["id"]
)
|
