gitscope
/
← marzneshin / app/db/migrations/versions/35774c98f945_add_node_backends.py / blame
Files Commits 446 Branches 1 Tags 43 Markers 4 README License
https://dev.kronoz.win/r/marzneshin.git
app/db/migrations/versions/35774c98f945_add_node_backends.py · v0.5.0
Source
1 f5c168d Mardin 2y ago """add node backends
2 f5c168d Mardin 2y ago
3 f5c168d Mardin 2y ago Revision ID: 35774c98f945
4 f5c168d Mardin 2y ago Revises: c4fb5f6423a8
5 f5c168d Mardin 2y ago Create Date: 2024-08-01 08:29:56.436001
6 f5c168d Mardin 2y ago
7 f5c168d Mardin 2y ago """
8 f5c168d Mardin 2y ago
9 f5c168d Mardin 2y ago import sqlalchemy as sa
10 f5c168d Mardin 2y ago from alembic import op
11 f5c168d Mardin 2y ago
12 f5c168d Mardin 2y ago # revision identifiers, used by Alembic.
13 f5c168d Mardin 2y ago revision = "35774c98f945"
14 f5c168d Mardin 2y ago down_revision = "c4fb5f6423a8"
15 f5c168d Mardin 2y ago branch_labels = None
16 f5c168d Mardin 2y ago depends_on = None
17 f5c168d Mardin 2y ago
18 f5c168d Mardin 2y ago
19 f5c168d Mardin 2y ago def upgrade() -> None:
20 f5c168d Mardin 2y ago # ### commands auto generated by Alembic - please adjust! ###
21 f5c168d Mardin 2y ago op.create_table(
22 f5c168d Mardin 2y ago "backends",
23 f5c168d Mardin 2y ago sa.Column("id", sa.Integer(), nullable=False),
24 f5c168d Mardin 2y ago sa.Column("name", sa.String(length=64), nullable=False),
25 f5c168d Mardin 2y ago sa.Column("node_id", sa.Integer(), nullable=True),
26 f5c168d Mardin 2y ago sa.Column("backend_type", sa.String(length=32), nullable=False),
27 f5c168d Mardin 2y ago sa.Column("version", sa.String(length=32), nullable=True),
28 f5c168d Mardin 2y ago sa.Column("running", sa.Boolean(), nullable=False),
29 f5c168d Mardin 2y ago sa.ForeignKeyConstraint(
30 f5c168d Mardin 2y ago ["node_id"],
31 f5c168d Mardin 2y ago ["nodes.id"],
32 f5c168d Mardin 2y ago ),
33 f5c168d Mardin 2y ago sa.PrimaryKeyConstraint("id"),
34 f5c168d Mardin 2y ago )
35 f5c168d Mardin 2y ago op.create_index(op.f("ix_backends_node_id"), "backends", ["node_id"])
36 f5c168d Mardin 2y ago # ### end Alembic commands ###
37 f5c168d Mardin 2y ago
38 f5c168d Mardin 2y ago
39 f5c168d Mardin 2y ago def downgrade() -> None:
40 f5c168d Mardin 2y ago # ### commands auto generated by Alembic - please adjust! ###
41 f5c168d Mardin 2y ago op.drop_index(op.f("ix_backends_node_id"), table_name="backends")
42 f5c168d Mardin 2y ago op.drop_table("backends")
43 f5c168d Mardin 2y ago # ### end Alembic commands ###