test_dispatch_priority_migration_2915.py 2.2 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859
  1. """The startup migration gives a database from before #2915 the printers.dispatch_priority column."""
  2. from __future__ import annotations
  3. import pytest
  4. from sqlalchemy import text
  5. from sqlalchemy.ext.asyncio import create_async_engine
  6. from backend.app.core.database import run_migrations
  7. @pytest.fixture(autouse=True)
  8. def force_sqlite_dialect(monkeypatch):
  9. from backend.app.core import database as database_module, db_dialect
  10. monkeypatch.setattr(db_dialect, "is_sqlite", lambda: True)
  11. monkeypatch.setattr(db_dialect, "is_postgres", lambda: False)
  12. monkeypatch.setattr(database_module, "is_sqlite", lambda: True)
  13. async def _columns(engine) -> list[str]:
  14. async with engine.connect() as conn:
  15. return [row[1] for row in (await conn.execute(text("PRAGMA table_info(printers)"))).all()]
  16. @pytest.mark.asyncio
  17. async def test_the_column_is_added_once_and_existing_printers_keep_no_priority():
  18. import importlib
  19. import pkgutil
  20. from sqlalchemy.ext.asyncio import AsyncSession
  21. import backend.app.models as models_pkg
  22. from backend.app.core.database import Base
  23. # Every table the migrations touch, not just those the package imports.
  24. for module in pkgutil.iter_modules(models_pkg.__path__):
  25. importlib.import_module(f"backend.app.models.{module.name}")
  26. from backend.app.models.printer import Printer
  27. engine = create_async_engine("sqlite+aiosqlite:///:memory:", echo=False)
  28. async with engine.begin() as conn:
  29. await conn.run_sync(Base.metadata.create_all)
  30. async with AsyncSession(engine) as db:
  31. db.add(Printer(name="P", serial_number="S", ip_address="1.2.3.4", access_code="x"))
  32. await db.commit()
  33. async with engine.begin() as conn:
  34. await conn.execute(text("ALTER TABLE printers DROP COLUMN dispatch_priority"))
  35. assert "dispatch_priority" not in await _columns(engine)
  36. for _ in range(2): # idempotent
  37. async with engine.begin() as conn:
  38. await run_migrations(conn)
  39. assert "dispatch_priority" in await _columns(engine)
  40. async with engine.connect() as conn:
  41. value = (await conn.execute(text("SELECT dispatch_priority FROM printers"))).scalar_one()
  42. await engine.dispose()
  43. assert value is None