Files
2026-11-06 18:54:28 +03:00

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())