forked from mtusi2026/mtusi2026lab4
88 lines
4.4 KiB
Python
88 lines
4.4 KiB
Python
"""docker compose exec -T api python < tests/database.py."""
|
|
import asyncio
|
|
import subprocess
|
|
import sys
|
|
from datetime import datetime, timedelta, timezone
|
|
from uuid import uuid4
|
|
|
|
from sqlalchemy import Column, MetaData, String, Table, func, insert, select, text
|
|
from sqlalchemy.exc import IntegrityError
|
|
from sqlalchemy.ext.asyncio import async_sessionmaker
|
|
|
|
from src.core.db.models import Chat, ChatMember, Message, User
|
|
from src.core.db.repo.chat import create_chat
|
|
from src.core.db.repo.message import history_query
|
|
from src.core.db.session import create_engine
|
|
|
|
|
|
async def main():
|
|
engine = create_engine()
|
|
factory = async_sessionmaker(engine, expire_on_commit=False)
|
|
try:
|
|
async def counts():
|
|
async with factory() as session:
|
|
return [await session.scalar(select(func.count()).select_from(model))
|
|
for model in (User, Chat, ChatMember, Message)]
|
|
|
|
before = await counts()
|
|
for _ in range(2):
|
|
subprocess.run([sys.executable, '-m', 'alembic', 'upgrade', 'head'], check=True)
|
|
assert before == await counts(), 'Повтор миграций изменил данные'
|
|
versions = Table('alembic_version', MetaData(), Column('version_num', String(32), primary_key=True))
|
|
async with factory() as session:
|
|
assert (await session.scalars(select(versions.c.version_num))).all() == ['006']
|
|
print('PASS: два повторных запуска миграций не изменили данные; версия 006 одна')
|
|
|
|
user_id, chat_id = uuid4(), uuid4()
|
|
now = datetime.now(timezone.utc)
|
|
try:
|
|
async with factory.begin() as session:
|
|
await create_chat(session, chat_id, 'rollback', [user_id], now)
|
|
except IntegrityError as error:
|
|
assert getattr(error.orig, 'sqlstate', None) == '23503'
|
|
else:
|
|
raise AssertionError('Ожидался отказ внешнего ключа')
|
|
async with factory() as session:
|
|
assert await session.get(Chat, chat_id) is None
|
|
assert await session.scalar(
|
|
select(func.count()).select_from(ChatMember).where(ChatMember.chat_id == chat_id)
|
|
) == 0
|
|
print('PASS: ошибка участника откатила INSERT чата и участников')
|
|
|
|
async with factory() as session:
|
|
try:
|
|
session.add(User(id=user_id, username='plan_' + uuid4().hex[:16],
|
|
display_name='EXPLAIN', password_hash='test-not-for-login', created_at=now))
|
|
await session.flush()
|
|
await create_chat(session, chat_id, 'EXPLAIN', [user_id], now)
|
|
await session.execute(insert(Message), [
|
|
dict(id=uuid4(), chat_id=chat_id, sender_id=user_id, text=f'message {n}',
|
|
created_at=now + timedelta(milliseconds=n)) for n in range(1, 10001)
|
|
])
|
|
# ANALYZE и EXPLAIN — диагностические команды PostgreSQL, не запросы репозитория.
|
|
await session.execute(text('ANALYZE messages'))
|
|
count = await session.scalar(
|
|
select(func.count()).select_from(Message).where(Message.chat_id == chat_id)
|
|
)
|
|
print('Сообщений в исследуемом чате:', count)
|
|
after = (await session.execute(
|
|
select(Message.created_at, Message.id).where(Message.chat_id == chat_id)
|
|
.order_by(Message.created_at, Message.id).offset(8999).limit(1)
|
|
)).one()
|
|
# Исследуется именно выражение SQLAlchemy, используемое в репозитории.
|
|
compiled = history_query(chat_id, 51, tuple(after)).compile(
|
|
dialect=engine.dialect, compile_kwargs={'literal_binds': True},
|
|
)
|
|
rows = await session.execute(text('EXPLAIN (ANALYZE, BUFFERS) ' + str(compiled)))
|
|
plan = '\n'.join(row[0] for row in rows)
|
|
assert 'messages_history_idx' in plan, plan
|
|
print(plan)
|
|
print('PASS: индекс истории используется для глубокой страницы из 10000 сообщений')
|
|
finally:
|
|
await session.rollback()
|
|
finally:
|
|
await engine.dispose()
|
|
|
|
|
|
asyncio.run(main())
|