social-app/backend/tests/unit/database/test_profile_migration_contract.py

from __future__ import annotations

from pathlib import Path


def test_profiles_has_settings_column() -> None:
    """Verify profiles and auth trigger are defined in split migrations."""
    versions_dir = Path(__file__).resolve().parents[3] / "alembic" / "versions"
    migration_files = sorted(versions_dir.glob("20260226_*.py"))
    content = "\n".join(m.read_text(encoding="utf-8") for m in migration_files)

    assert 'create_table(\n        "profiles"' in content
    assert '"settings"' in content
    assert "create_profile_for_new_user" in content
    assert "on_auth_user_created" in content