8 lines
234 B
SQL
8 lines
234 B
SQL
-- name: GetUser :one
|
|
SELECT * FROM users WHERE id = $1 LIMIT 1;
|
|
|
|
-- name: GetUserByIDP :one
|
|
SELECT * FROM users WHERE idp_sub = $1 LIMIT 1;
|
|
|
|
-- name: CreateUser :one
|
|
INSERT INTO users (username, idp_sub) VALUES ($1, $2) RETURNING *;
|