diff options
| author | James Elliott <james-d-elliott@users.noreply.github.com> | 2022-10-19 18:17:55 +1100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2022-10-19 18:17:55 +1100 |
| commit | 24e41aed845d5f06a26444bb154e22e1b41bba8d (patch) | |
| tree | 6182ec17b43a182bfa194196c887438701b55013 /internal/storage/sql_provider_queries.go | |
| parent | 52102eea8c7379e0d34d9025ea72bebdcf639673 (diff) | |
feat(commands): add webauthn device commands (#3671)
Diffstat (limited to 'internal/storage/sql_provider_queries.go')
| -rw-r--r-- | internal/storage/sql_provider_queries.go | 26 |
1 files changed, 19 insertions, 7 deletions
diff --git a/internal/storage/sql_provider_queries.go b/internal/storage/sql_provider_queries.go index 7dc44e156..eedfca30a 100644 --- a/internal/storage/sql_provider_queries.go +++ b/internal/storage/sql_provider_queries.go @@ -122,13 +122,13 @@ const ( const ( queryFmtSelectWebauthnDevices = ` - SELECT id, created_at, last_used_at, rpid, username, description, kid, public_key, attestation_type, transport, aaguid, sign_count, clone_warning + SELECT id, created_at, last_used_at, rpid, username, description, kid, public_key, attestation_type, transport, aaguid, sign_count, clone_warning FROM %s LIMIT ? OFFSET ?;` queryFmtSelectWebauthnDevicesByUsername = ` - SELECT id, created_at, last_used_at, rpid, username, description, kid, public_key, attestation_type, transport, aaguid, sign_count, clone_warning + SELECT id, created_at, last_used_at, rpid, username, description, kid, public_key, attestation_type, transport, aaguid, sign_count, clone_warning FROM %s WHERE username = ?;` @@ -144,14 +144,14 @@ const ( queryFmtUpdateWebauthnDeviceRecordSignIn = ` UPDATE %s - SET + SET rpid = ?, last_used_at = ?, sign_count = ?, clone_warning = CASE clone_warning WHEN TRUE THEN TRUE ELSE ? END WHERE id = ?;` queryFmtUpdateWebauthnDeviceRecordSignInByUsername = ` UPDATE %s - SET + SET rpid = ?, last_used_at = ?, sign_count = ?, clone_warning = CASE clone_warning WHEN TRUE THEN TRUE ELSE ? END WHERE username = ? AND kid = ?;` @@ -165,6 +165,18 @@ const ( VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12) ON CONFLICT (username, description) DO UPDATE SET created_at = $1, last_used_at = $2, rpid = $3, kid = $6, public_key = $7, attestation_type = $8, transport = $9, aaguid = $10, sign_count = $11, clone_warning = $12;` + + queryFmtDeleteWebauthnDevice = ` + DELETE FROM %s + WHERE kid = ?;` + + queryFmtDeleteWebauthnDeviceByUsername = ` + DELETE FROM %s + WHERE username = ?;` + + queryFmtDeleteWebauthnDeviceByUsernameAndDescription = ` + DELETE FROM %s + WHERE username = ? AND description = ?;` ) const ( @@ -232,7 +244,7 @@ const ( SELECT id, challenge_id, client_id, subject, authorized, granted, requested_at, responded_at, expires_at, form_data, requested_scopes, granted_scopes, requested_audience, granted_audience FROM %s - WHERE client_id = ? AND subject = ? AND + WHERE client_id = ? AND subject = ? AND authorized = TRUE AND granted = TRUE AND expires_at IS NOT NULL AND expires_at >= CURRENT_TIMESTAMP;` queryFmtInsertOAuth2ConsentSession = ` @@ -263,8 +275,8 @@ const ( WHERE signature = ? AND revoked = FALSE;` queryFmtInsertOAuth2Session = ` - INSERT INTO %s (challenge_id, request_id, client_id, signature, subject, requested_at, - requested_scopes, granted_scopes, requested_audience, granted_audience, + INSERT INTO %s (challenge_id, request_id, client_id, signature, subject, requested_at, + requested_scopes, granted_scopes, requested_audience, granted_audience, active, revoked, form_data, session_data) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);` |