File tree 1 file changed +10
-5
lines changed
1 file changed +10
-5
lines changed Original file line number Diff line number Diff line change @@ -111,7 +111,8 @@ INSERT INTO oauth2_provider_app_tokens (
111
111
) RETURNING * ;
112
112
113
113
-- name: GetOAuth2ProviderAppsByUserID :many
114
- SELECT COUNT (DISTINCT oauth2_provider_app_tokens .id ) as token_count,
114
+ SELECT
115
+ COUNT (DISTINCT oauth2_provider_app_tokens .id ) as token_count,
115
116
sqlc .embed (oauth2_provider_apps)
116
117
FROM oauth2_provider_app_tokens
117
118
INNER JOIN oauth2_provider_app_secrets
@@ -120,12 +121,16 @@ FROM oauth2_provider_app_tokens
120
121
ON oauth2_provider_apps .id = oauth2_provider_app_secrets .app_id
121
122
INNER JOIN api_keys
122
123
ON api_keys .id = oauth2_provider_app_tokens .api_key_id
123
- WHERE api_keys .user_id = $1
124
- GROUP BY oauth2_provider_apps .id ;
124
+ WHERE
125
+ api_keys .user_id = $1
126
+ GROUP
127
+ BY oauth2_provider_apps .id ;
125
128
126
129
-- name: DeleteOAuth2ProviderAppTokensByAppAndUserID :exec
127
- DELETE FROM oauth2_provider_app_tokens
128
- USING oauth2_provider_app_secrets, api_keys
130
+ DELETE FROM
131
+ oauth2_provider_app_tokens
132
+ USING
133
+ oauth2_provider_app_secrets, api_keys
129
134
WHERE
130
135
oauth2_provider_app_secrets .id = oauth2_provider_app_tokens .app_secret_id
131
136
AND api_keys .id = oauth2_provider_app_tokens .api_key_id
You can’t perform that action at this time.
0 commit comments