aboutsummaryrefslogtreecommitdiff
path: root/migrations
diff options
context:
space:
mode:
authorKaran Jayachandra <karan.jayachandra@nxp.com>2025-11-09 09:56:59 +0100
committerKaran Jayachandra <karan.jayachandra@nxp.com>2025-11-09 09:56:59 +0100
commit34d77cd777bd44d7bfe0e3ab3379f9be256ca88b (patch)
tree04fba9f8bb99ac8fa15a1048b0ee06cbfed7f25d /migrations
parent90390365bd93a4ee086c2931bb70ffa571a726b9 (diff)
Moved to javascript codebase
Diffstat (limited to 'migrations')
-rw-r--r--migrations/README1
-rw-r--r--migrations/alembic.ini50
-rw-r--r--migrations/env.py108
-rw-r--r--migrations/script.py.mako24
-rw-r--r--migrations/versions/c08245a9c93f_.py122
-rw-r--r--migrations/versions/d158cf8f4950_.py41
6 files changed, 0 insertions, 346 deletions
diff --git a/migrations/README b/migrations/README
deleted file mode 100644
index 0e04844..0000000
--- a/migrations/README
+++ /dev/null
@@ -1 +0,0 @@
-Single-database configuration for Flask.
diff --git a/migrations/alembic.ini b/migrations/alembic.ini
deleted file mode 100644
index ec9d45c..0000000
--- a/migrations/alembic.ini
+++ /dev/null
@@ -1,50 +0,0 @@
-# A generic, single database configuration.
-
-[alembic]
-# template used to generate migration files
-# file_template = %%(rev)s_%%(slug)s
-
-# set to 'true' to run the environment during
-# the 'revision' command, regardless of autogenerate
-# revision_environment = false
-
-
-# Logging configuration
-[loggers]
-keys = root,sqlalchemy,alembic,flask_migrate
-
-[handlers]
-keys = console
-
-[formatters]
-keys = generic
-
-[logger_root]
-level = WARN
-handlers = console
-qualname =
-
-[logger_sqlalchemy]
-level = WARN
-handlers =
-qualname = sqlalchemy.engine
-
-[logger_alembic]
-level = INFO
-handlers =
-qualname = alembic
-
-[logger_flask_migrate]
-level = INFO
-handlers =
-qualname = flask_migrate
-
-[handler_console]
-class = StreamHandler
-args = (sys.stderr,)
-level = NOTSET
-formatter = generic
-
-[formatter_generic]
-format = %(levelname)-5.5s [%(name)s] %(message)s
-datefmt = %H:%M:%S
diff --git a/migrations/env.py b/migrations/env.py
deleted file mode 100644
index d004741..0000000
--- a/migrations/env.py
+++ /dev/null
@@ -1,108 +0,0 @@
-import logging
-from logging.config import fileConfig
-
-from flask import current_app
-
-from alembic import context
-
-# this is the Alembic Config object, which provides
-# access to the values within the .ini file in use.
-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")
-
-
-def get_engine():
- try:
- # this works with Flask-SQLAlchemy<3 and Alchemical
- return current_app.extensions["migrate"].db.get_engine()
- except (TypeError, AttributeError):
- # this works with Flask-SQLAlchemy>=3
- return current_app.extensions["migrate"].db.engine
-
-
-def get_engine_url():
- try:
- return get_engine().url.render_as_string(hide_password=False).replace("%", "%%")
- except AttributeError:
- 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
-
-# other values from the config, defined by the needs of env.py,
-# can be acquired:
-# my_important_option = config.get_main_option("my_important_option")
-# ... etc.
-
-
-def get_metadata():
- if hasattr(target_db, "metadatas"):
- return target_db.metadatas[None]
- return target_db.metadata
-
-
-def run_migrations_offline():
- """Run migrations in 'offline' mode.
-
- This configures the context with just a URL
- and not an Engine, though an Engine is acceptable
- here as well. By skipping the Engine creation
- we don't even need a DBAPI to be available.
-
- Calls to context.execute() here emit the given string to the
- script output.
-
- """
- url = config.get_main_option("sqlalchemy.url")
- context.configure(url=url, target_metadata=get_metadata(), literal_binds=True)
-
- with context.begin_transaction():
- context.run_migrations()
-
-
-def run_migrations_online():
- """Run migrations in 'online' mode.
-
- In this scenario we need to create an Engine
- and associate a connection with the context.
-
- """
-
- # this callback is used to prevent an auto-migration from being generated
- # 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):
- script = directives[0]
- if script.upgrade_ops.is_empty():
- directives[:] = []
- logger.info("No changes in schema detected.")
-
- 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
-
- connectable = get_engine()
-
- with connectable.connect() as connection:
- context.configure(
- connection=connection, target_metadata=get_metadata(), **conf_args
- )
-
- with context.begin_transaction():
- context.run_migrations()
-
-
-if context.is_offline_mode():
- run_migrations_offline()
-else:
- run_migrations_online()
diff --git a/migrations/script.py.mako b/migrations/script.py.mako
deleted file mode 100644
index 2c01563..0000000
--- a/migrations/script.py.mako
+++ /dev/null
@@ -1,24 +0,0 @@
-"""${message}
-
-Revision ID: ${up_revision}
-Revises: ${down_revision | comma,n}
-Create Date: ${create_date}
-
-"""
-from alembic import op
-import sqlalchemy as sa
-${imports if imports else ""}
-
-# revision identifiers, used by Alembic.
-revision = ${repr(up_revision)}
-down_revision = ${repr(down_revision)}
-branch_labels = ${repr(branch_labels)}
-depends_on = ${repr(depends_on)}
-
-
-def upgrade():
- ${upgrades if upgrades else "pass"}
-
-
-def downgrade():
- ${downgrades if downgrades else "pass"}
diff --git a/migrations/versions/c08245a9c93f_.py b/migrations/versions/c08245a9c93f_.py
deleted file mode 100644
index 48b115b..0000000
--- a/migrations/versions/c08245a9c93f_.py
+++ /dev/null
@@ -1,122 +0,0 @@
-"""empty message
-
-Revision ID: c08245a9c93f
-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"
-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(
- "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)
-
- 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
- )
-
- # ### 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"))
-
- 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")
- # ### end Alembic commands ###
diff --git a/migrations/versions/d158cf8f4950_.py b/migrations/versions/d158cf8f4950_.py
deleted file mode 100644
index ba0ef5b..0000000
--- a/migrations/versions/d158cf8f4950_.py
+++ /dev/null
@@ -1,41 +0,0 @@
-"""empty message
-
-Revision ID: d158cf8f4950
-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"
-down_revision = None
-branch_labels = None
-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"),
- )
- 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"))
-
- op.drop_table("user")
- # ### end Alembic commands ###