forked from mtusi2026/mtusi2026lab3
37 lines
1.3 KiB
Go
37 lines
1.3 KiB
Go
package postgres
|
|
|
|
import (
|
|
"context"
|
|
"time"
|
|
|
|
"github.com/google/uuid"
|
|
"github.com/jackc/pgx/v5"
|
|
)
|
|
|
|
// SaveSession persists an absolute expiry and a token digest in PostgreSQL.
|
|
func (s *Store) SaveSession(ctx context.Context, hash string, userID uuid.UUID, expiry time.Time) error {
|
|
ctx, cancel := context.WithTimeout(ctx, s.timeout)
|
|
defer cancel()
|
|
_, err := s.pool.Exec(ctx, `INSERT INTO sessions(token_hash,user_id,expires_at) VALUES(@hash,@user,@expiry)`, pgx.StrictNamedArgs{
|
|
"hash": hash, "user": userID, "expiry": expiry,
|
|
})
|
|
return normalize(err)
|
|
}
|
|
|
|
// SessionUser rejects absent, revoked and expired sessions using database time.
|
|
func (s *Store) SessionUser(ctx context.Context, hash string) (uuid.UUID, error) {
|
|
ctx, cancel := context.WithTimeout(ctx, s.timeout)
|
|
defer cancel()
|
|
var id uuid.UUID
|
|
err := s.pool.QueryRow(ctx, `SELECT user_id FROM sessions WHERE token_hash=@hash AND expires_at>clock_timestamp()`, pgx.StrictNamedArgs{"hash": hash}).Scan(&id)
|
|
return id, normalize(err)
|
|
}
|
|
|
|
// RevokeSession deletes the authoritative session before logout succeeds.
|
|
func (s *Store) RevokeSession(ctx context.Context, hash string) error {
|
|
ctx, cancel := context.WithTimeout(ctx, s.timeout)
|
|
defer cancel()
|
|
_, err := s.pool.Exec(ctx, `DELETE FROM sessions WHERE token_hash=@hash`, pgx.StrictNamedArgs{"hash": hash})
|
|
return normalize(err)
|
|
}
|