diff options
| author | James Elliott <james-d-elliott@users.noreply.github.com> | 2025-02-22 19:20:34 +1100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2025-02-22 08:20:34 +0000 |
| commit | 111344eaea4fd0c32ce58a181b94414ae639fe2b (patch) | |
| tree | 76e024658c1e2483795a8153fe18661ca035c138 /internal/storage/sql_provider_queries.go | |
| parent | 9c718b39888bbaafdbc623acd0efd2138b6b8068 (diff) | |
feat(oidc): claims parameter support (#8081)
This adds formal support for the claims parameter.
Closes #2868
Signed-off-by: James Elliott <james-d-elliott@users.noreply.github.com>
Diffstat (limited to 'internal/storage/sql_provider_queries.go')
| -rw-r--r-- | internal/storage/sql_provider_queries.go | 18 |
1 files changed, 9 insertions, 9 deletions
diff --git a/internal/storage/sql_provider_queries.go b/internal/storage/sql_provider_queries.go index f6a415f8b..8fe0787c0 100644 --- a/internal/storage/sql_provider_queries.go +++ b/internal/storage/sql_provider_queries.go @@ -315,30 +315,30 @@ const ( const ( queryFmtSelectOAuth2ConsentPreConfigurations = ` - SELECT id, client_id, subject, created_at, expires_at, revoked, scopes, audience + SELECT id, client_id, subject, created_at, expires_at, revoked, scopes, audience, requested_claims, signature_claims, granted_claims FROM %s WHERE client_id = ? AND subject = ? AND revoked = FALSE AND (expires_at IS NULL OR expires_at >= CURRENT_TIMESTAMP);` queryFmtInsertOAuth2ConsentPreConfiguration = ` - INSERT INTO %s (client_id, subject, created_at, expires_at, revoked, scopes, audience) - VALUES(?, ?, ?, ?, ?, ?, ?);` + INSERT INTO %s (client_id, subject, created_at, expires_at, revoked, scopes, audience, requested_claims, signature_claims, granted_claims) + VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?);` queryFmtInsertOAuth2ConsentPreConfigurationPostgreSQL = ` - INSERT INTO %s (client_id, subject, created_at, expires_at, revoked, scopes, audience) - VALUES($1, $2, $3, $4, $5, $6, $7) + INSERT INTO %s (client_id, subject, created_at, expires_at, revoked, scopes, audience, requested_claims, signature_claims, granted_claims) + VALUES($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) RETURNING id;` queryFmtSelectOAuth2ConsentSessionByChallengeID = ` SELECT id, challenge_id, client_id, subject, authorized, granted, requested_at, responded_at, - form_data, requested_scopes, granted_scopes, requested_audience, granted_audience, preconfiguration + form_data, requested_scopes, granted_scopes, requested_audience, granted_audience, granted_claims, preconfiguration FROM %s WHERE challenge_id = ?;` queryFmtInsertOAuth2ConsentSession = ` INSERT INTO %s (challenge_id, client_id, subject, authorized, granted, requested_at, responded_at, - form_data, requested_scopes, granted_scopes, requested_audience, granted_audience, preconfiguration) - VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);` + form_data, requested_scopes, granted_scopes, requested_audience, granted_audience, granted_claims, preconfiguration) + VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);` queryFmtUpdateOAuth2ConsentSessionSubject = ` UPDATE %s @@ -347,7 +347,7 @@ const ( queryFmtUpdateOAuth2ConsentSessionResponse = ` UPDATE %s - SET authorized = ?, responded_at = CURRENT_TIMESTAMP, granted_scopes = ?, granted_audience = ?, preconfiguration = ? + SET authorized = ?, responded_at = CURRENT_TIMESTAMP, granted_scopes = ?, granted_audience = ?, granted_claims = ?, preconfiguration = ? WHERE id = ? AND responded_at IS NULL;` queryFmtUpdateOAuth2ConsentSessionGranted = ` |