From 4aee68096c11ce1e3762fb8cffbde2a14dfa3cd0 Mon Sep 17 00:00:00 2001 From: Karan Jayachandra Date: Mon, 14 Jul 2025 19:51:45 +0200 Subject: Added the login for changes --- migrations/env.py | 31 ++++---- migrations/versions/c08245a9c93f_.py | 147 ++++++++++++++++++++++------------- migrations/versions/d158cf8f4950_.py | 26 ++++--- 3 files changed, 118 insertions(+), 86 deletions(-) (limited to 'migrations') diff --git a/migrations/env.py b/migrations/env.py index 4c97092..d004741 100644 --- a/migrations/env.py +++ b/migrations/env.py @@ -12,32 +12,31 @@ config = context.config # Interpret the config file for Python logging. # This line sets up loggers basically. fileConfig(config.config_file_name) -logger = logging.getLogger('alembic.env') +logger = logging.getLogger("alembic.env") def get_engine(): try: # this works with Flask-SQLAlchemy<3 and Alchemical - return current_app.extensions['migrate'].db.get_engine() + return current_app.extensions["migrate"].db.get_engine() except (TypeError, AttributeError): # this works with Flask-SQLAlchemy>=3 - return current_app.extensions['migrate'].db.engine + return current_app.extensions["migrate"].db.engine def get_engine_url(): try: - return get_engine().url.render_as_string(hide_password=False).replace( - '%', '%%') + return get_engine().url.render_as_string(hide_password=False).replace("%", "%%") except AttributeError: - return str(get_engine().url).replace('%', '%%') + return str(get_engine().url).replace("%", "%%") # add your model's MetaData object here # for 'autogenerate' support # from myapp import mymodel # target_metadata = mymodel.Base.metadata -config.set_main_option('sqlalchemy.url', get_engine_url()) -target_db = current_app.extensions['migrate'].db +config.set_main_option("sqlalchemy.url", get_engine_url()) +target_db = current_app.extensions["migrate"].db # other values from the config, defined by the needs of env.py, # can be acquired: @@ -46,7 +45,7 @@ target_db = current_app.extensions['migrate'].db def get_metadata(): - if hasattr(target_db, 'metadatas'): + if hasattr(target_db, "metadatas"): return target_db.metadatas[None] return target_db.metadata @@ -64,9 +63,7 @@ def run_migrations_offline(): """ url = config.get_main_option("sqlalchemy.url") - context.configure( - url=url, target_metadata=get_metadata(), literal_binds=True - ) + context.configure(url=url, target_metadata=get_metadata(), literal_binds=True) with context.begin_transaction(): context.run_migrations() @@ -84,13 +81,13 @@ def run_migrations_online(): # when there are no changes to the schema # reference: http://alembic.zzzcomputing.com/en/latest/cookbook.html def process_revision_directives(context, revision, directives): - if getattr(config.cmd_opts, 'autogenerate', False): + if getattr(config.cmd_opts, "autogenerate", False): script = directives[0] if script.upgrade_ops.is_empty(): directives[:] = [] - logger.info('No changes in schema detected.') + logger.info("No changes in schema detected.") - conf_args = current_app.extensions['migrate'].configure_args + conf_args = current_app.extensions["migrate"].configure_args if conf_args.get("process_revision_directives") is None: conf_args["process_revision_directives"] = process_revision_directives @@ -98,9 +95,7 @@ def run_migrations_online(): with connectable.connect() as connection: context.configure( - connection=connection, - target_metadata=get_metadata(), - **conf_args + connection=connection, target_metadata=get_metadata(), **conf_args ) with context.begin_transaction(): 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 ### -- cgit v1.3.1