gitscope
/
← marzneshin / app/db/migrations/versions/3acfdeb79b78_add_admin_services.py / blame
Files Commits 446 Branches 1 Tags 43 Markers 4 README License
https://dev.kronoz.win/r/marzneshin.git
app/db/migrations/versions/3acfdeb79b78_add_admin_services.py · v0.5.3
Source
1 4708fcb Dawsh 2y ago """Add services and subscription url prefix to admins
2 4708fcb Dawsh 2y ago
3 4708fcb Dawsh 2y ago Revision ID: 3acfdeb79b78
4 4708fcb Dawsh 2y ago Revises: a83e4dd22672
5 4708fcb Dawsh 2y ago Create Date: 2024-07-08 12:50:12.570534
6 4708fcb Dawsh 2y ago
7 4708fcb Dawsh 2y ago """
8 4708fcb Dawsh 2y ago
9 4708fcb Dawsh 2y ago import sqlalchemy as sa
10 4708fcb Dawsh 2y ago from alembic import op
11 4708fcb Dawsh 2y ago
12 4708fcb Dawsh 2y ago # revision identifiers, used by Alembic.
13 4708fcb Dawsh 2y ago revision = "3acfdeb79b78"
14 4708fcb Dawsh 2y ago down_revision = "a83e4dd22672"
15 4708fcb Dawsh 2y ago branch_labels = None
16 4708fcb Dawsh 2y ago depends_on = None
17 4708fcb Dawsh 2y ago
18 4708fcb Dawsh 2y ago
19 4708fcb Dawsh 2y ago def upgrade() -> None:
20 4708fcb Dawsh 2y ago # ### commands auto generated by Alembic - please adjust! ###
21 4708fcb Dawsh 2y ago op.create_table(
22 4708fcb Dawsh 2y ago "admins_services",
23 4708fcb Dawsh 2y ago sa.Column("admin_id", sa.Integer(), nullable=False),
24 4708fcb Dawsh 2y ago sa.Column("service_id", sa.Integer(), nullable=False),
25 4708fcb Dawsh 2y ago sa.ForeignKeyConstraint(
26 4708fcb Dawsh 2y ago ["admin_id"],
27 4708fcb Dawsh 2y ago ["admins.id"],
28 4708fcb Dawsh 2y ago ),
29 4708fcb Dawsh 2y ago sa.ForeignKeyConstraint(
30 4708fcb Dawsh 2y ago ["service_id"],
31 4708fcb Dawsh 2y ago ["services.id"],
32 4708fcb Dawsh 2y ago ),
33 4708fcb Dawsh 2y ago sa.PrimaryKeyConstraint("admin_id", "service_id"),
34 4708fcb Dawsh 2y ago )
35 4708fcb Dawsh 2y ago op.add_column(
36 4708fcb Dawsh 2y ago "admins",
37 4708fcb Dawsh 2y ago sa.Column(
38 4708fcb Dawsh 2y ago "all_services_access",
39 4708fcb Dawsh 2y ago sa.Boolean(),
40 4708fcb Dawsh 2y ago server_default=sa.sql.false(),
41 4708fcb Dawsh 2y ago nullable=False,
42 4708fcb Dawsh 2y ago ),
43 4708fcb Dawsh 2y ago )
44 4708fcb Dawsh 2y ago op.add_column(
45 4708fcb Dawsh 2y ago "admins",
46 4708fcb Dawsh 2y ago sa.Column(
47 4708fcb Dawsh 2y ago "modify_users_access",
48 4708fcb Dawsh 2y ago sa.Boolean(),
49 4708fcb Dawsh 2y ago server_default=sa.sql.true(),
50 4708fcb Dawsh 2y ago nullable=False,
51 4708fcb Dawsh 2y ago ),
52 4708fcb Dawsh 2y ago )
53 4708fcb Dawsh 2y ago op.add_column(
54 4708fcb Dawsh 2y ago "admins",
55 4708fcb Dawsh 2y ago sa.Column(
56 4708fcb Dawsh 2y ago "enabled",
57 4708fcb Dawsh 2y ago sa.Boolean(),
58 4708fcb Dawsh 2y ago server_default=sa.sql.true(),
59 4708fcb Dawsh 2y ago nullable=False,
60 4708fcb Dawsh 2y ago ),
61 4708fcb Dawsh 2y ago )
62 4708fcb Dawsh 2y ago op.add_column(
63 4708fcb Dawsh 2y ago "admins",
64 4708fcb Dawsh 2y ago sa.Column(
65 4708fcb Dawsh 2y ago "subscription_url_prefix",
66 4708fcb Dawsh 2y ago sa.String(length=256),
67 4708fcb Dawsh 2y ago nullable=False,
68 4708fcb Dawsh 2y ago server_default="",
69 4708fcb Dawsh 2y ago ),
70 4708fcb Dawsh 2y ago )
71 4708fcb Dawsh 2y ago
72 4708fcb Dawsh 2y ago
73 4708fcb Dawsh 2y ago def downgrade() -> None:
74 4708fcb Dawsh 2y ago # ### commands auto generated by Alembic - please adjust! ###
75 4708fcb Dawsh 2y ago op.drop_column("admins", "subscription_url_prefix")
76 4708fcb Dawsh 2y ago op.drop_column("admins", "all_services_access")
77 4708fcb Dawsh 2y ago op.drop_column("admins", "enabled")
78 4708fcb Dawsh 2y ago op.drop_column("admins", "modify_users_access")
79 4708fcb Dawsh 2y ago op.drop_table("admins_services")
80 4708fcb Dawsh 2y ago # ### end Alembic commands ###