| Serge Bazanski | a5baa87 | 2022-09-15 18:49:35 +0200 | [diff] [blame] | 1 | -- name: GetAccountByOIDC :many |
| 2 | SELECT | ||||
| 3 | accounts.* | ||||
| 4 | FROM accounts | ||||
| 5 | WHERE account_oidc_sub = $1; | ||||
| 6 | |||||
| 7 | -- name: InitializeAccountFromOIDC :one | ||||
| 8 | INSERT INTO accounts ( | ||||
| 9 | account_oidc_sub, account_display_name | ||||
| 10 | ) VALUES ( | ||||
| 11 | $1, $2 | ||||
| 12 | ) | ||||
| 13 | RETURNING *; | ||||