"""Запуск внутри API: rollback и 24h expiry без ожидания суток.""" import asyncio from datetime import datetime, timezone from uuid import uuid4 from sqlalchemy import delete, select, text, update from sqlalchemy.ext.asyncio import async_sessionmaker from src.core.db.models import Chat, ChatMember, Message, MessageRequest, User from src.core.db.repo.message import create_idempotent_message from src.core.db.session import create_engine async def main(): engine = create_engine() factory = async_sessionmaker(engine, expire_on_commit=False) user_id, chat_id = uuid4(), uuid4() now = datetime.now(timezone.utc) async with factory.begin() as s: s.add( User( id=user_id, username="idem_" + user_id.hex[:20], display_name="Fixture", password_hash="not-for-login", created_at=now, ) ) await s.flush() s.add(Chat(id=chat_id, title="Idempotency fixture", created_at=now)) await s.flush() s.add(ChatMember(chat_id=chat_id, user_id=user_id)) try: try: async with factory.begin() as s: await create_idempotent_message( s, uuid4(), chat_id, user_id, "rollback", now, "same" ) raise RuntimeError("simulated failure before COMMIT") except RuntimeError: pass async with factory() as s: assert not list(await s.scalars(select(Message).where(Message.chat_id == chat_id))) assert not list( await s.scalars(select(MessageRequest).where(MessageRequest.chat_id == chat_id)) ) async with factory.begin() as s: first = await create_idempotent_message( s, uuid4(), chat_id, user_id, "committed", now, "same" ) async with factory.begin() as s: replay = await create_idempotent_message( s, uuid4(), chat_id, user_id, "committed", now, "same" ) assert replay == first await s.execute( update(MessageRequest) .where(MessageRequest.chat_id == chat_id) .values(expires_at=text("clock_timestamp() - interval '1 second'")) ) async with factory.begin() as s: fresh = await create_idempotent_message( s, uuid4(), chat_id, user_id, "new after expiry", now, "same" ) assert fresh.id != first.id print( "PASS: rollback removes both message/key; committed result replays; expired key can be reused" ) finally: async with factory.begin() as s: await s.execute(delete(MessageRequest).where(MessageRequest.chat_id == chat_id)) await s.execute(delete(Message).where(Message.chat_id == chat_id)) await s.execute(delete(Chat).where(Chat.id == chat_id)) await s.execute(delete(User).where(User.id == user_id)) await engine.dispose() asyncio.run(main())