7 lines
234 B
SQL
7 lines
234 B
SQL
-- name: GetKeyByHash :one
|
|
SELECT k.id, k.owner_id, k.scopes, k.quota_tier, k.status, k.expires_at,
|
|
o.status AS owner_status
|
|
FROM api.keys k
|
|
JOIN api.owners o ON o.id = k.owner_id
|
|
WHERE k.key_hash = $1 AND k.status = 'active';
|