7 lines
232 B
SQL
7 lines
232 B
SQL
-- name: CreateUser :one
|
|
INSERT INTO users (id, created_at, updated_at, name, api_key)
|
|
VALUES ($1, $2, $3, $4, encode(sha256(random()::text::bytea), 'hex'))
|
|
RETURNING *;
|
|
|
|
-- name: GetUser :one
|
|
SELECT * FROM users WHERE api_key = $1; |