Download backend/tests/test_migrations.py from deeep-sec/campus-placement-engine: direct link, hf CLI and curl.
- Browser
- Download file 1.55 kB
-
https://huggingface.co/deeep-sec/campus-placement-engine/resolve/main/backend/tests/test_migrations.py
- Command line
-
hf download hf://deeep-sec/campus-placement-engine/backend/tests/test_migrations.py
-
curl -L -o test_migrations.py https://huggingface.co/deeep-sec/campus-placement-engine/resolve/main/backend/tests/test_migrations.py
1.55 kB
| """ | |
| Tests for Alembic migrations. | |
| Verifies clean upgrade to head, complete downgrade to base, and re-upgrade. | |
| """ | |
| import os | |
| from alembic import command | |
| from alembic.config import Config | |
| from sqlalchemy import inspect | |
| from backend.app.storage.database import engine | |
| INI_PATH = os.path.abspath(os.path.join(os.path.dirname(__file__), "..", "alembic.ini")) | |
| def test_migration_upgrade_and_downgrade_cycle() -> None: | |
| alembic_cfg = Config(INI_PATH) | |
| # 1. Upgrade to head | |
| command.upgrade(alembic_cfg, "head") | |
| inspector = inspect(engine) | |
| tables = inspector.get_table_names() | |
| assert "students" in tables | |
| assert "drives" in tables | |
| assert "policies" in tables | |
| assert "eligibility_runs" in tables | |
| assert "eligibility_decisions" in tables | |
| assert "slots" in tables | |
| assert "rooms" in tables | |
| assert "events" in tables | |
| # 2. Downgrade to base | |
| command.downgrade(alembic_cfg, "base") | |
| inspector = inspect(engine) | |
| tables_after_downgrade = inspector.get_table_names() | |
| # All application tables should be dropped (only alembic_version might remain) | |
| assert "students" not in tables_after_downgrade | |
| assert "drives" not in tables_after_downgrade | |
| assert "policies" not in tables_after_downgrade | |
| # 3. Re-upgrade to head | |
| command.upgrade(alembic_cfg, "head") | |
| inspector = inspect(engine) | |
| re_tables = inspector.get_table_names() | |
| assert "students" in re_tables | |
| assert "drives" in re_tables | |
| assert "events" in re_tables | |