forked from mtusi2026/mtusi2026lab6
71 lines
2.2 KiB
Python
71 lines
2.2 KiB
Python
"""Хранение и блокировка ключей в PostgreSQL."""
|
|
|
|
from datetime import timedelta
|
|
import hashlib
|
|
import json
|
|
from uuid import UUID
|
|
|
|
from sqlalchemy import BigInteger, func, literal, select, tuple_
|
|
from sqlalchemy.dialects.postgresql import insert
|
|
from sqlalchemy.ext.asyncio import AsyncSession
|
|
|
|
from app.models.idempotency_key import IdempotencyKey
|
|
|
|
Scope = tuple[UUID, str, str, str]
|
|
|
|
|
|
async def lock_key(session: AsyncSession, scope: Scope) -> None:
|
|
"""Сериализует один ключ до конца транзакции."""
|
|
raw = json.dumps([str(scope[0]), *scope[1:]]).encode()
|
|
lock_id = int.from_bytes(hashlib.sha256(raw).digest()[:8], signed=True)
|
|
await session.execute(
|
|
select(func.pg_advisory_xact_lock(literal(lock_id, type_=BigInteger)))
|
|
)
|
|
|
|
|
|
async def get_active_key(
|
|
session: AsyncSession, scope: Scope, ttl_seconds: int
|
|
) -> IdempotencyKey | None:
|
|
"""Читает результат, пока срок ключа не истёк."""
|
|
stmt = select(IdempotencyKey).where(
|
|
tuple_(
|
|
IdempotencyKey.user_id,
|
|
IdempotencyKey.method,
|
|
IdempotencyKey.path,
|
|
IdempotencyKey.key,
|
|
)
|
|
== tuple_(*scope),
|
|
IdempotencyKey.created_at
|
|
> func.clock_timestamp() - timedelta(seconds=ttl_seconds),
|
|
)
|
|
return await session.scalar(stmt)
|
|
|
|
|
|
async def save_result(
|
|
session: AsyncSession, scope: Scope, request_hash: str, message_id: UUID
|
|
) -> None:
|
|
"""Сохраняет новый результат или заменяет истёкший."""
|
|
stmt = insert(IdempotencyKey).values(
|
|
user_id=scope[0],
|
|
method=scope[1],
|
|
path=scope[2],
|
|
key=scope[3],
|
|
request_hash=request_hash,
|
|
message_id=message_id,
|
|
)
|
|
await session.execute(
|
|
stmt.on_conflict_do_update(
|
|
index_elements=[
|
|
IdempotencyKey.user_id,
|
|
IdempotencyKey.method,
|
|
IdempotencyKey.path,
|
|
IdempotencyKey.key,
|
|
],
|
|
set_={
|
|
"request_hash": request_hash,
|
|
"message_id": message_id,
|
|
"created_at": func.clock_timestamp(),
|
|
},
|
|
)
|
|
)
|