summaryrefslogtreecommitdiff
path: root/query
diff options
context:
space:
mode:
Diffstat (limited to 'query')
-rw-r--r--query/users.sql8
1 files changed, 7 insertions, 1 deletions
diff --git a/query/users.sql b/query/users.sql
index 0d58b2d..bd91cda 100644
--- a/query/users.sql
+++ b/query/users.sql
@@ -4,7 +4,7 @@ WHERE id = ? AND is_deleted = false;
-- name: GetUserByPublicKey :one
SELECT * FROM users
-WHERE public_key = ? AND is_deleted = false;
+WHERE public_key = ?;
-- name: CreateUser :one
INSERT INTO users (
@@ -31,6 +31,12 @@ UPDATE SET
WHERE user_id = EXCLUDED.user_id
RETURNING *;
+-- name: UpdateUser :one
+UPDATE users SET
+ name = ?, description = ?, is_public_dm = ?
+WHERE id = ?
+RETURNING *;
+
-- name: GetUserData :one
SELECT data FROM user_data
WHERE user_id = ?;