Files
2026-10-30 12:32:42 +03:00

70 lines
2.4 KiB
Python

import asyncpg
import pytest
from conftest import DATABASE, scalar
from messenger.migrate import MigrationChangedError, migrate, migrations, target
COUNTS = """
SELECT (SELECT count(*) FROM users), (SELECT count(*) FROM sessions),
(SELECT count(*) FROM chats), (SELECT count(*) FROM chat_members),
(SELECT count(*) FROM messages)
"""
async def counts() -> list[int]:
connection = await asyncpg.connect(DATABASE["url"])
try:
return list(await connection.fetchrow(COUNTS))
finally:
await connection.close()
async def test_migrations_are_ordered_and_versioned() -> None:
versions = [version for version, _ in migrations()]
assert versions == sorted(versions)
assert versions[0] == "0001_init"
applied = await scalar("SELECT array_agg(version ORDER BY version) FROM schema_migrations")
assert applied == versions
async def test_rerun_changes_nothing() -> None:
before = await counts()
assert await migrate(DATABASE["url"]) == []
assert await counts() == before
async def test_changed_migration_is_refused() -> None:
connection = await asyncpg.connect(DATABASE["url"])
try:
original = await connection.fetchval(
"SELECT checksum FROM schema_migrations WHERE version = '0001_init'"
)
await connection.execute(
"UPDATE schema_migrations SET checksum = 'tampered' WHERE version = '0001_init'"
)
with pytest.raises(MigrationChangedError):
await migrate(DATABASE["url"])
await connection.execute(
"UPDATE schema_migrations SET checksum = $1 WHERE version = '0001_init'", original
)
finally:
await connection.close()
async def test_sender_must_be_member_even_bypassing_api() -> None:
connection = await asyncpg.connect(DATABASE["url"])
try:
with pytest.raises(asyncpg.ForeignKeyViolationError):
await connection.execute(
"INSERT INTO messages (id, chat_id, sender_id, text, created_at) "
"VALUES (gen_random_uuid(), gen_random_uuid(), gen_random_uuid(), 'x', now())"
)
finally:
await connection.close()
def test_database_name_argument_replaces_only_the_database() -> None:
dsn = "postgresql://user:secret@postgres:5432/messenger"
assert target(dsn, []) == dsn
assert target(dsn, ["track"]) == "postgresql://user:secret@postgres:5432/track"