"""Alembic environment for canonical document metadata migrations.""" from logging.config import fileConfig from alembic import context from sqlalchemy import engine_from_config, pool from ekp_core.config import get_settings from ekp_domain import Base config = context.config if config.config_file_name is not None: fileConfig(config.config_file_name) target_metadata = Base.metadata def _database_url() -> str: """Allow tests to override the URL without changing runtime settings.""" override = config.attributes.get("database_url") return override if isinstance(override, str) else get_settings().database_url def run_migrations_offline() -> None: """Render migration SQL without creating an engine or connection.""" context.configure( url=_database_url(), target_metadata=target_metadata, literal_binds=True, dialect_opts={"paramstyle": "named"}, compare_type=True, ) with context.begin_transaction(): context.run_migrations() def run_migrations_online() -> None: """Run migrations through a short-lived SQLAlchemy engine.""" connectable = engine_from_config( {"sqlalchemy.url": _database_url()}, prefix="sqlalchemy.", poolclass=pool.NullPool, ) with connectable.connect() as connection: context.configure( connection=connection, target_metadata=target_metadata, compare_type=True, ) with context.begin_transaction(): context.run_migrations() if context.is_offline_mode(): run_migrations_offline() else: run_migrations_online()