2026-02-19 10:21:27 +00:00
|
|
|
-- name: SelectUserByUsername :one
|
2026-02-25 11:04:47 +00:00
|
|
|
SELECT * FROM users WHERE username = ? LIMIT 1;
|
|
|
|
|
|
|
|
|
|
-- name: SelectUserByID :one
|
|
|
|
|
SELECT * FROM users WHERE id = ? LIMIT 1;
|
2026-02-19 10:21:27 +00:00
|
|
|
|
2026-02-19 11:29:44 +00:00
|
|
|
-- name: InsertUser :one
|
2026-02-26 11:23:47 +00:00
|
|
|
INSERT INTO users (username, password, created_at) VALUES (?, ?, ?) RETURNING id;
|
2026-02-19 11:29:44 +00:00
|
|
|
|
|
|
|
|
-- name: UpdateUser :exec
|
|
|
|
|
UPDATE users SET username = ?, password = ? WHERE id = ?;
|
