Files
mtusi2026lab7/backend/db/sqlc/queries/security.sql

7 lines
532 B
SQL

-- name: AllowLogin :one
UPDATE login_limits SET attempts=CASE WHEN started_at<=clock_timestamp()-interval '60 seconds' THEN 1 ELSE attempts+1 END,
started_at=CASE WHEN started_at<=clock_timestamp()-interval '60 seconds' THEN clock_timestamp() ELSE started_at END
WHERE bucket=$1 AND (started_at<=clock_timestamp()-interval '60 seconds' OR attempts<10) RETURNING bucket;
-- name: RehashPassword :one
UPDATE users SET password_hash=sqlc.arg(replacement) WHERE id=sqlc.arg(user_id) AND password_hash=sqlc.arg(previous) RETURNING id;