Watch
1
0
Fork
You've already forked arc
0
forked from hesabix/arc
arc/hesabixAPI/adapters/db/repositories/password_reset_repo.py

55 lines
1.7 KiB
Python
Executable file

from __future__ import annotations
from datetime import datetime, timedelta
from typing import Optional
from sqlalchemy import select, and_
from sqlalchemy.orm import Session
from adapters.db.models.password_reset import PasswordReset
class PasswordResetRepository:
def __init__(self, db: Session) -> None:
self.db = db
def create(self, *, user_id: int, token_hash: str, expires_at: datetime, commit: bool = True) -> PasswordReset:
obj = PasswordReset(user_id=user_id, token_hash=token_hash, expires_at=expires_at)
self.db.add(obj)
if commit:
self.db.commit()
else:
self.db.flush()
self.db.refresh(obj)
return obj
def get_by_hash(self, token_hash: str) -> Optional[PasswordReset]:
stmt = select(PasswordReset).where(PasswordReset.token_hash == token_hash)
return self.db.execute(stmt).scalars().first()
def mark_used(self, pr: PasswordReset) -> None:
pr.used_at = datetime.utcnow()
self.db.add(pr)
self.db.commit()
def get_by_user_and_hash(self, user_id: int, token_hash: str) -> Optional[PasswordReset]:
"""دریافت reset token برای کاربر با hash خاص"""
stmt = select(PasswordReset).where(
and_(
PasswordReset.user_id == user_id,
PasswordReset.token_hash == token_hash,
PasswordReset.used_at.is_(None)
)
).order_by(PasswordReset.created_at.desc())
return self.db.execute(stmt).scalars().first()
def count_recent_by_user(self, user_id: int, hours: int = 24) -> int:
"""شمارش reset token های ایجاد شده در N ساعت اخیر"""
cutoff = datetime.utcnow() - timedelta(hours=hours)
stmt = select(PasswordReset).where(
and_(
PasswordReset.user_id == user_id,
PasswordReset.created_at >= cutoff
)
)
return len(self.db.execute(stmt).scalars().all())