gitscope
https://dev.kronoz.win/r/marzneshin.git
app/db/migrations/versions/74e234a3bd4b_add_mux_fragment_to_hosts.py · v0.5.0
Source
1 0b152b5 Mrdn 2y ago """add fragment settings and mux columns to hosts table
2 0b152b5 Mrdn 2y ago
3 0b152b5 Mrdn 2y ago Revision ID: 74e234a3bd4b
4 0b152b5 Mrdn 2y ago Revises: e8325f600a49
5 0b152b5 Mrdn 2y ago Create Date: 2024-05-22 00:26:26.865255
6 0b152b5 Mrdn 2y ago
7 0b152b5 Mrdn 2y ago """
8 0b152b5 Mrdn 2y ago
9 0b152b5 Mrdn 2y ago from alembic import op
10 0b152b5 Mrdn 2y ago import sqlalchemy as sa
11 0b152b5 Mrdn 2y ago
12 0b152b5 Mrdn 2y ago
13 0b152b5 Mrdn 2y ago # revision identifiers, used by Alembic.
14 0b152b5 Mrdn 2y ago revision = "74e234a3bd4b"
15 0b152b5 Mrdn 2y ago down_revision = "e8325f600a49"
16 0b152b5 Mrdn 2y ago branch_labels = None
17 0b152b5 Mrdn 2y ago depends_on = None
18 0b152b5 Mrdn 2y ago
19 0b152b5 Mrdn 2y ago
20 0b152b5 Mrdn 2y ago def upgrade() -> None:
21 0b152b5 Mrdn 2y ago # ### commands auto generated by Alembic - please adjust! ###
22 0b152b5 Mrdn 2y ago op.add_column(
23 0b152b5 Mrdn 2y ago "hosts",
24 f1ab16c Dawsh 2y ago sa.Column(
25 f1ab16c Dawsh 2y ago "mux", sa.Boolean(), server_default=sa.sql.true(), nullable=False
26 f1ab16c Dawsh 2y ago ),
27 0b152b5 Mrdn 2y ago )
28 0b152b5 Mrdn 2y ago op.add_column("hosts", sa.Column("fragment", sa.JSON(), nullable=True))
29 0b152b5 Mrdn 2y ago # ### end Alembic commands ###
30 0b152b5 Mrdn 2y ago
31 0b152b5 Mrdn 2y ago
32 0b152b5 Mrdn 2y ago def downgrade() -> None:
33 0b152b5 Mrdn 2y ago # ### commands auto generated by Alembic - please adjust! ###
34 0b152b5 Mrdn 2y ago op.drop_column("hosts", "fragment")
35 0b152b5 Mrdn 2y ago op.drop_column("hosts", "mux")
36 0b152b5 Mrdn 2y ago # ### end Alembic commands ###