Commit29a9e26

committed

Format oauth2.sql

1 parent8368548 commit29a9e26Copy full SHA for 29a9e26

File tree

+20

-10

lines changed

+20

-10

lines changed

Lines changed: 10 additions & 5 deletions

Some generated files are not rendered by default. Learn more aboutcustomizing how changed files appear on GitHub.

Lines changed: 10 additions & 5 deletions

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`		`-SELECTCOUNT(DISTINCToauth2_provider_app_tokens.id)as token_count,`
	`114`	`+SELECT`
	`115`	`+COUNT(DISTINCToauth2_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`	`ONoauth2_provider_apps.id=oauth2_provider_app_secrets.app_id`
`121`	`122`	`INNER JOIN api_keys`
`122`	`123`	`ONapi_keys.id=oauth2_provider_app_tokens.api_key_id`
`123`		`-WHEREapi_keys.user_id= $1`
`124`		`-GROUP BYoauth2_provider_apps.id;`
	`124`	`+WHERE`
	`125`	`+api_keys.user_id= $1`
	`126`	`+GROUP BY`
	`127`	`+oauth2_provider_apps.id;`
`125`	`128`
`126`	`129`	`-- name: DeleteOAuth2ProviderAppTokensByAppAndUserID :exec`
`127`		`-DELETEFROM oauth2_provider_app_tokens`
`128`		`-USING oauth2_provider_app_secrets, api_keys`
	`130`	`+DELETEFROM`
	`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`	`ANDapi_keys.id=oauth2_provider_app_tokens.api_key_id`

Comments

(0)