aboutsummaryrefslogtreecommitdiffhomepage
path: root/backend/db/queries/users.sql
blob: 99515d5bb519c4099f5d11c065892030307d8606 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
-- name: CreateUser :one
INSERT INTO users (username, password_hash)
VALUES (?, ?)
RETURNING *;

-- name: GetUserByUsername :one
SELECT id, username, password_hash, created_at
FROM users
WHERE username = ?;

-- name: GetUserByID :one
SELECT id, username, password_hash, created_at
FROM users
WHERE id = ?;