qshub / utils /security.py
basel00omar's picture
THE QS HUB v2.0 - Complete React + FastAPI Platform (clean deploy)
1b4b6d2
Raw History Blame
2.64 kB
"""Auth-adjacent production helpers for Streamlit."""
from __future__ import annotations
import hashlib
import json
import secrets
from datetime import datetime, timedelta
import bcrypt
from utils.db import safe_execute, safe_query
def hash_token(token: str) -> str:
return hashlib.sha256(token.encode("utf-8")).hexdigest()
def password_hash(password: str) -> str:
return bcrypt.hashpw(password.encode("utf-8"), bcrypt.gensalt()).decode("utf-8")
def password_ok(password: str, hashed: str) -> bool:
return bcrypt.checkpw(password.encode("utf-8"), hashed.encode("utf-8"))
def issue_reset_token(email: str) -> str | None:
token = secrets.token_urlsafe(32)
expires = datetime.utcnow() + timedelta(hours=1)
success, _ = safe_execute(
"""
UPDATE qto_users
SET reset_token_hash=%s, reset_token_expires_at=%s
WHERE email=%s
""",
(hash_token(token), expires.strftime("%Y-%m-%d %H:%M:%S"), email),
)
df = safe_query("SELECT id FROM qto_users WHERE email=%s", (email,))
return token if success and not df.empty else None
def reset_password(token: str, new_password: str) -> bool:
token_h = hash_token(token)
df = safe_query(
"""
SELECT id FROM qto_users
WHERE reset_token_hash=%s AND reset_token_expires_at > UTC_TIMESTAMP()
LIMIT 1
""",
(token_h,),
)
if df.empty:
return False
user_id = int(df.iloc[0]["id"])
ok, _ = safe_execute(
"""
UPDATE qto_users
SET password_hash=%s, reset_token_hash=NULL, reset_token_expires_at=NULL
WHERE id=%s
""",
(password_hash(new_password), user_id),
)
return bool(ok)
def login_rate_limited(email: str, max_attempts: int = 8) -> bool:
df = safe_query(
"""
SELECT metadata
FROM qto_usage_logs
WHERE event_type='login_failed'
AND created_at > DATE_SUB(NOW(), INTERVAL 15 MINUTE)
""",
)
if df.empty:
return False
attempts = 0
target = (email or "").strip().lower()
for row in df.to_dict("records"):
try:
metadata = row.get("metadata") or "{}"
if isinstance(metadata, str):
metadata = json.loads(metadata)
logged_email = str(metadata.get("email", "")).strip().lower()
if logged_email == target:
attempts += 1
except Exception:
continue
return attempts >= max_attempts
def touch_login(user_id: int) -> None:
safe_execute("UPDATE qto_users SET last_login_at=NOW() WHERE id=%s", (user_id,))