gitscope
/
← marzneshin / app/db/migrations/versions/20240724_5410d8ec78ff_alpn_to_string.py / blame
Files Commits 446 Branches 1 Tags 43 Markers 4 README License
https://dev.kronoz.win/r/marzneshin.git
app/db/migrations/versions/20240724_5410d8ec78ff_alpn_to_string.py · v0.7.0
Source
1 244c9d8 Dawsh 2y ago """make host alpn string
2 244c9d8 Dawsh 2y ago
3 244c9d8 Dawsh 2y ago Revision ID: 5410d8ec78ff
4 244c9d8 Dawsh 2y ago Revises: b0357faf51c8
5 244c9d8 Dawsh 2y ago Create Date: 2024-07-24 22:47:51.528849
6 244c9d8 Dawsh 2y ago
7 244c9d8 Dawsh 2y ago """
8 244c9d8 Dawsh 2y ago
9 244c9d8 Dawsh 2y ago import sqlalchemy as sa
10 244c9d8 Dawsh 2y ago from alembic import op
11 244c9d8 Dawsh 2y ago from sqlalchemy.dialects import postgresql, mysql
12 244c9d8 Dawsh 2y ago
13 244c9d8 Dawsh 2y ago # revision identifiers, used by Alembic.
14 244c9d8 Dawsh 2y ago revision = "5410d8ec78ff"
15 244c9d8 Dawsh 2y ago down_revision = "b0357faf51c8"
16 244c9d8 Dawsh 2y ago branch_labels = None
17 244c9d8 Dawsh 2y ago depends_on = None
18 244c9d8 Dawsh 2y ago
19 244c9d8 Dawsh 2y ago
20 244c9d8 Dawsh 2y ago def upgrade() -> None:
21 244c9d8 Dawsh 2y ago # ### commands auto generated by Alembic - please adjust! ###
22 244c9d8 Dawsh 2y ago if (dialect := op.get_bind().dialect.name) == "postgresql":
23 244c9d8 Dawsh 2y ago op.alter_column(
24 244c9d8 Dawsh 2y ago "hosts",
25 244c9d8 Dawsh 2y ago "alpn",
26 244c9d8 Dawsh 2y ago existing_type=postgresql.ENUM(
27 244c9d8 Dawsh 2y ago "none", "h2", "http/1.1", "h2,http/1.1", name="proxyhostalpn"
28 244c9d8 Dawsh 2y ago ),
29 244c9d8 Dawsh 2y ago type_=sa.String(length=32),
30 244c9d8 Dawsh 2y ago existing_nullable=False,
31 244c9d8 Dawsh 2y ago nullable=True,
32 244c9d8 Dawsh 2y ago server_default=None,
33 244c9d8 Dawsh 2y ago )
34 244c9d8 Dawsh 2y ago elif dialect == "mysql" or dialect == "mariadb":
35 244c9d8 Dawsh 2y ago op.alter_column(
36 244c9d8 Dawsh 2y ago "hosts",
37 244c9d8 Dawsh 2y ago "alpn",
38 244c9d8 Dawsh 2y ago existing_type=mysql.ENUM("none", "h2", "http/1.1", "h2,http/1.1"),
39 244c9d8 Dawsh 2y ago type_=sa.String(length=32),
40 244c9d8 Dawsh 2y ago nullable=True,
41 244c9d8 Dawsh 2y ago )
42 244c9d8 Dawsh 2y ago # ### end Alembic commands ###
43 244c9d8 Dawsh 2y ago
44 244c9d8 Dawsh 2y ago
45 244c9d8 Dawsh 2y ago def downgrade() -> None:
46 244c9d8 Dawsh 2y ago # ### commands auto generated by Alembic - please adjust! ###
47 244c9d8 Dawsh 2y ago if (dialect := op.get_bind().dialect.name) == "postgresql":
48 244c9d8 Dawsh 2y ago op.alter_column(
49 244c9d8 Dawsh 2y ago "hosts",
50 244c9d8 Dawsh 2y ago "alpn",
51 244c9d8 Dawsh 2y ago existing_type=sa.String(length=32),
52 244c9d8 Dawsh 2y ago type_=postgresql.ENUM(
53 244c9d8 Dawsh 2y ago "none", "h2", "http/1.1", "h2,http/1.1", name="proxyhostalpn"
54 244c9d8 Dawsh 2y ago ),
55 244c9d8 Dawsh 2y ago existing_nullable=True,
56 244c9d8 Dawsh 2y ago nullable=False,
57 244c9d8 Dawsh 2y ago existing_server_default=None,
58 244c9d8 Dawsh 2y ago server_default=sa.text("'none'::proxyhostalpn"),
59 244c9d8 Dawsh 2y ago )
60 244c9d8 Dawsh 2y ago elif dialect == "mysql" or dialect == "mariadb":
61 244c9d8 Dawsh 2y ago op.alter_column(
62 244c9d8 Dawsh 2y ago "hosts",
63 244c9d8 Dawsh 2y ago "alpn",
64 244c9d8 Dawsh 2y ago existing_type=sa.String(length=32),
65 244c9d8 Dawsh 2y ago type_=mysql.ENUM("none", "h2", "http/1.1", "h2,http/1.1"),
66 244c9d8 Dawsh 2y ago nullable=False,
67 244c9d8 Dawsh 2y ago existing_server_default=None,
68 244c9d8 Dawsh 2y ago server_default=sa.text("'none'"),
69 244c9d8 Dawsh 2y ago )
70 244c9d8 Dawsh 2y ago # ### end Alembic commands ###