HN-like selfhosted forums

Code git clone ssh://git.poy.ooo:6969/~rii/district ZIP
store/queries/sessions.sql / 403B #16628526
Raw
-- name: NewSession :oneINSERT INTO sessions(user_id, token_hash, expires_at)VALUES ($1, $2, $3)RETURNING *;-- name: GetSessionByTokenHash :oneSELECT s.*, u.username as session_usernameFROM sessions sJOIN users u ON u.id = s.user_idWHERE token_hash = $1    AND revoked_at IS NULL    AND expires_at > NOW();-- name: RevokeSession :execUPDATE sessionsSET revoked_at = NOW()WHERE id = $1;