mirror of
https://github.com/1f349/gomvn.git
synced 2024-10-18 09:21:48 +01:00
35 lines
538 B
SQL
35 lines
538 B
SQL
-- name: CountUsers :one
|
|
SELECT count(*)
|
|
FROM users;
|
|
|
|
-- name: IsAdmin :one
|
|
SELECT 1
|
|
FROM users
|
|
WHERE admin = 1
|
|
AND token_hash = ?;
|
|
|
|
-- name: IsValid :one
|
|
SELECT 1
|
|
FROM users
|
|
WHERE token_hash = ?;
|
|
|
|
-- name: GetAllUsers :many
|
|
SELECT id, name
|
|
FROM users;
|
|
|
|
-- name: CreateUser :execlastid
|
|
INSERT INTO users (name, admin, token_hash)
|
|
VALUES (?, ?, ?);
|
|
|
|
-- name: RefreshUserToken :exec
|
|
UPDATE users
|
|
SET token_hash =?
|
|
WHERE id = ?
|
|
AND token_hash = ?;
|
|
|
|
-- name: CheckUserDetails :one
|
|
SELECT 1
|
|
FROM users
|
|
WHERE name = ?
|
|
AND token_hash = ?;
|