Enterprise agent platform for building, deploying, and operating AI teammates.
"""Admission schema can be added to an existing task database without rewriting it."""
from pathlib import Path
import sqlalchemy as sa
from alembic.migration import MigrationContext
from alembic.operations import Operations
from tests.shared.postgres_disposable import load_migration_module
from tests.web.services.task_database_shared import engine as engine_fixture
from tests.web.services.task_database_shared import task_id as task_id_fixture
from xagent.web.models.task_admission import TaskAdmissionBucket, TaskAdmissionTicket
engine = engine_fixture
task_id = task_id_fixture
def test_upgrade_preserves_tasks_and_matches_metadata_then_downgrades(engine, task_id):
migration = load_migration_module(
Path(__file__).parents[2]
/ "src/xagent/migrations/versions/20260923_task_admission.py",
"task_admission_migration",
)
from xagent.web.models.task_admission_pacing import TaskAdmissionPacing
TaskAdmissionPacing.__table__.drop(engine)
TaskAdmissionTicket.__table__.drop(engine)
TaskAdmissionBucket.__table__.drop(engine)
with engine.begin() as connection:
with Operations.context(MigrationContext.configure(connection)):
migration.upgrade()
migration.upgrade()
for model in (TaskAdmissionBucket, TaskAdmissionTicket):
actual = sa.inspect(connection).get_columns(model.__tablename__)
expected = model.__table__.columns
assert {c["name"]: c["nullable"] for c in actual} == {
c.name: c.nullable for c in expected
}
inspector = sa.inspect(connection)
foreign_keys = inspector.get_foreign_keys("task_admission_tickets")
assert {
(
tuple(fk["constrained_columns"]),
fk["referred_table"],
tuple(fk["referred_columns"]),
fk["options"].get("ondelete"),
)
for fk in foreign_keys
} == {
(("command_id",), "task_execution_commands", ("id",), "CASCADE"),
(("task_id",), "tasks", ("id",), "CASCADE"),
(("bucket_key",), "task_admission_buckets", ("key",), None),
}
indexes = {
index["name"]: (tuple(index["column_names"]), bool(index["unique"]))
for index in inspector.get_indexes("task_admission_tickets")
}
assert indexes["ix_task_admission_bucket_command"] == (
("bucket_key", "command_id"),
False,
)
assert indexes["ix_task_admission_tickets_task_id"] == (("task_id",), False)
assert (
connection.scalar(
sa.text("SELECT id FROM tasks WHERE id = :id"), {"id": task_id}
)
== task_id
)
with Operations.context(MigrationContext.configure(connection)):
migration.downgrade()
assert "task_admission_tickets" not in sa.inspect(connection).get_table_names()
assert (
connection.scalar(
sa.text("SELECT id FROM tasks WHERE id = :id"), {"id": task_id}
)
== task_id
)