HN-like selfhosted forums

Code git clone ssh://git.poy.ooo:6969/~rii/district ZIP
store/queries/users.sql / 427B #8e0cfbc0
Raw
-- name: GetUser :oneSELECT * FROM users WHERE id = $1;-- name: GetUserByUsername :oneSELECT * FROM users WHERE lower(username) = lower(sqlc.arg(username)::text);-- name: NewUser :oneINSERT INTO users (username, email, passwd_hash)VALUES ($1, $2, $3)RETURNING *;-- name: GetUserByLogin :oneSELECT * FROM usersWHERE lower(email) = lower(sqlc.arg(login)::text)    OR lower(username) = lower(sqlc.arg(login)::text);