forked from mtusi2026/mtusi2026lab2
70 lines
2.4 KiB
Python
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"
|