diff options
Diffstat (limited to 'migrations/versions')
| -rw-r--r-- | migrations/versions/c08245a9c93f_.py | 147 | ||||
| -rw-r--r-- | migrations/versions/d158cf8f4950_.py | 26 |
2 files changed, 105 insertions, 68 deletions
diff --git a/migrations/versions/c08245a9c93f_.py b/migrations/versions/c08245a9c93f_.py index 5755bcc..48b115b 100644 --- a/migrations/versions/c08245a9c93f_.py +++ b/migrations/versions/c08245a9c93f_.py @@ -5,83 +5,118 @@ Revises: d158cf8f4950 Create Date: 2025-07-12 21:27:46.932139 """ + from alembic import op import sqlalchemy as sa # revision identifiers, used by Alembic. -revision = 'c08245a9c93f' -down_revision = 'd158cf8f4950' +revision = "c08245a9c93f" +down_revision = "d158cf8f4950" branch_labels = None depends_on = None def upgrade(): # ### commands auto generated by Alembic - please adjust! ### - op.create_table('court', - sa.Column('id', sa.Integer(), nullable=False), - sa.Column('status', sa.Boolean(), nullable=False), - sa.PrimaryKeyConstraint('id') + op.create_table( + "court", + sa.Column("id", sa.Integer(), nullable=False), + sa.Column("status", sa.Boolean(), nullable=False), + sa.PrimaryKeyConstraint("id"), ) - op.create_table('player', - sa.Column('id', sa.Integer(), nullable=False), - sa.Column('first_name', sa.String(length=64), nullable=False), - sa.Column('last_name', sa.String(length=64), nullable=False), - sa.Column('team', sa.Integer(), nullable=False), - sa.Column('status', sa.Boolean(), nullable=False), - sa.Column('level', sa.Integer(), nullable=False), - sa.PrimaryKeyConstraint('id') + op.create_table( + "player", + sa.Column("id", sa.Integer(), nullable=False), + sa.Column("first_name", sa.String(length=64), nullable=False), + sa.Column("last_name", sa.String(length=64), nullable=False), + sa.Column("team", sa.Integer(), nullable=False), + sa.Column("status", sa.Boolean(), nullable=False), + sa.Column("level", sa.Integer(), nullable=False), + sa.PrimaryKeyConstraint("id"), ) - with op.batch_alter_table('player', schema=None) as batch_op: - batch_op.create_index(batch_op.f('ix_player_first_name'), ['first_name'], unique=False) - batch_op.create_index(batch_op.f('ix_player_last_name'), ['last_name'], unique=False) - batch_op.create_index(batch_op.f('ix_player_team'), ['team'], unique=False) + with op.batch_alter_table("player", schema=None) as batch_op: + batch_op.create_index( + batch_op.f("ix_player_first_name"), ["first_name"], unique=False + ) + batch_op.create_index( + batch_op.f("ix_player_last_name"), ["last_name"], unique=False + ) + batch_op.create_index(batch_op.f("ix_player_team"), ["team"], unique=False) - op.create_table('game', - sa.Column('id', sa.Integer(), nullable=False), - sa.Column('round_id', sa.Integer(), nullable=False), - sa.Column('court_id', sa.Integer(), nullable=False), - sa.Column('player_1', sa.Integer(), nullable=False), - sa.Column('player_2', sa.Integer(), nullable=False), - sa.Column('player_3', sa.Integer(), nullable=False), - sa.Column('player_4', sa.Integer(), nullable=False), - sa.Column('date', sa.DateTime(), nullable=False), - sa.ForeignKeyConstraint(['court_id'], ['court.id'], ), - sa.ForeignKeyConstraint(['player_1'], ['player.id'], ), - sa.ForeignKeyConstraint(['player_2'], ['player.id'], ), - sa.ForeignKeyConstraint(['player_3'], ['player.id'], ), - sa.ForeignKeyConstraint(['player_4'], ['player.id'], ), - sa.PrimaryKeyConstraint('id') + op.create_table( + "game", + sa.Column("id", sa.Integer(), nullable=False), + sa.Column("round_id", sa.Integer(), nullable=False), + sa.Column("court_id", sa.Integer(), nullable=False), + sa.Column("player_1", sa.Integer(), nullable=False), + sa.Column("player_2", sa.Integer(), nullable=False), + sa.Column("player_3", sa.Integer(), nullable=False), + sa.Column("player_4", sa.Integer(), nullable=False), + sa.Column("date", sa.DateTime(), nullable=False), + sa.ForeignKeyConstraint( + ["court_id"], + ["court.id"], + ), + sa.ForeignKeyConstraint( + ["player_1"], + ["player.id"], + ), + sa.ForeignKeyConstraint( + ["player_2"], + ["player.id"], + ), + sa.ForeignKeyConstraint( + ["player_3"], + ["player.id"], + ), + sa.ForeignKeyConstraint( + ["player_4"], + ["player.id"], + ), + sa.PrimaryKeyConstraint("id"), ) - with op.batch_alter_table('game', schema=None) as batch_op: - batch_op.create_index(batch_op.f('ix_game_court_id'), ['court_id'], unique=False) - batch_op.create_index(batch_op.f('ix_game_date'), ['date'], unique=False) - batch_op.create_index(batch_op.f('ix_game_player_1'), ['player_1'], unique=False) - batch_op.create_index(batch_op.f('ix_game_player_2'), ['player_2'], unique=False) - batch_op.create_index(batch_op.f('ix_game_player_3'), ['player_3'], unique=False) - batch_op.create_index(batch_op.f('ix_game_player_4'), ['player_4'], unique=False) - batch_op.create_index(batch_op.f('ix_game_round_id'), ['round_id'], unique=False) + with op.batch_alter_table("game", schema=None) as batch_op: + batch_op.create_index( + batch_op.f("ix_game_court_id"), ["court_id"], unique=False + ) + batch_op.create_index(batch_op.f("ix_game_date"), ["date"], unique=False) + batch_op.create_index( + batch_op.f("ix_game_player_1"), ["player_1"], unique=False + ) + batch_op.create_index( + batch_op.f("ix_game_player_2"), ["player_2"], unique=False + ) + batch_op.create_index( + batch_op.f("ix_game_player_3"), ["player_3"], unique=False + ) + batch_op.create_index( + batch_op.f("ix_game_player_4"), ["player_4"], unique=False + ) + batch_op.create_index( + batch_op.f("ix_game_round_id"), ["round_id"], unique=False + ) # ### end Alembic commands ### def downgrade(): # ### commands auto generated by Alembic - please adjust! ### - with op.batch_alter_table('game', schema=None) as batch_op: - batch_op.drop_index(batch_op.f('ix_game_round_id')) - batch_op.drop_index(batch_op.f('ix_game_player_4')) - batch_op.drop_index(batch_op.f('ix_game_player_3')) - batch_op.drop_index(batch_op.f('ix_game_player_2')) - batch_op.drop_index(batch_op.f('ix_game_player_1')) - batch_op.drop_index(batch_op.f('ix_game_date')) - batch_op.drop_index(batch_op.f('ix_game_court_id')) + with op.batch_alter_table("game", schema=None) as batch_op: + batch_op.drop_index(batch_op.f("ix_game_round_id")) + batch_op.drop_index(batch_op.f("ix_game_player_4")) + batch_op.drop_index(batch_op.f("ix_game_player_3")) + batch_op.drop_index(batch_op.f("ix_game_player_2")) + batch_op.drop_index(batch_op.f("ix_game_player_1")) + batch_op.drop_index(batch_op.f("ix_game_date")) + batch_op.drop_index(batch_op.f("ix_game_court_id")) - op.drop_table('game') - with op.batch_alter_table('player', schema=None) as batch_op: - batch_op.drop_index(batch_op.f('ix_player_team')) - batch_op.drop_index(batch_op.f('ix_player_last_name')) - batch_op.drop_index(batch_op.f('ix_player_first_name')) + op.drop_table("game") + with op.batch_alter_table("player", schema=None) as batch_op: + batch_op.drop_index(batch_op.f("ix_player_team")) + batch_op.drop_index(batch_op.f("ix_player_last_name")) + batch_op.drop_index(batch_op.f("ix_player_first_name")) - op.drop_table('player') - op.drop_table('court') + op.drop_table("player") + op.drop_table("court") # ### end Alembic commands ### diff --git a/migrations/versions/d158cf8f4950_.py b/migrations/versions/d158cf8f4950_.py index 392d3bf..ba0ef5b 100644 --- a/migrations/versions/d158cf8f4950_.py +++ b/migrations/versions/d158cf8f4950_.py @@ -1,16 +1,17 @@ """empty message Revision ID: d158cf8f4950 -Revises: +Revises: Create Date: 2025-07-06 15:31:24.124657 """ + from alembic import op import sqlalchemy as sa # revision identifiers, used by Alembic. -revision = 'd158cf8f4950' +revision = "d158cf8f4950" down_revision = None branch_labels = None depends_on = None @@ -18,22 +19,23 @@ depends_on = None def upgrade(): # ### commands auto generated by Alembic - please adjust! ### - op.create_table('user', - sa.Column('id', sa.Integer(), nullable=False), - sa.Column('username', sa.String(length=64), nullable=False), - sa.Column('password_hash', sa.String(length=256), nullable=True), - sa.PrimaryKeyConstraint('id') + op.create_table( + "user", + sa.Column("id", sa.Integer(), nullable=False), + sa.Column("username", sa.String(length=64), nullable=False), + sa.Column("password_hash", sa.String(length=256), nullable=True), + sa.PrimaryKeyConstraint("id"), ) - with op.batch_alter_table('user', schema=None) as batch_op: - batch_op.create_index(batch_op.f('ix_user_username'), ['username'], unique=True) + with op.batch_alter_table("user", schema=None) as batch_op: + batch_op.create_index(batch_op.f("ix_user_username"), ["username"], unique=True) # ### end Alembic commands ### def downgrade(): # ### commands auto generated by Alembic - please adjust! ### - with op.batch_alter_table('user', schema=None) as batch_op: - batch_op.drop_index(batch_op.f('ix_user_username')) + with op.batch_alter_table("user", schema=None) as batch_op: + batch_op.drop_index(batch_op.f("ix_user_username")) - op.drop_table('user') + op.drop_table("user") # ### end Alembic commands ### |