Added the login for changes

3 files changed, 118 insertions, 86 deletions

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 ###