summaryrefslogtreecommitdiff
path: root/query/users.sql
diff options
context:
space:
mode:
authorKyren223 <Kyren223@proton.me>2025-01-09 17:28:46 +0200
committerKyren223 <Kyren223@proton.me>2025-01-09 17:28:46 +0200
commit936d3cf690ace9adfdfe0fb44193c11a0cb26d95 (patch)
tree3d0699aa5c50efb7ecac3dddd25fe959366b7562 /query/users.sql
parentd0cb135161b18f37c25501cb863fa783cd723758 (diff)
Added goose for migrations, refactored SQL schema, server and client
are broken
Diffstat (limited to 'query/users.sql')
-rw-r--r--query/users.sql28
1 files changed, 0 insertions, 28 deletions
diff --git a/query/users.sql b/query/users.sql
index d136f15..8247dda 100644
--- a/query/users.sql
+++ b/query/users.sql
@@ -6,10 +6,6 @@ WHERE id = ? AND is_deleted = false;
SELECT * FROM users
WHERE public_key = ? AND is_deleted = false;
--- name: GetDeletedUserById :one
-SELECT * FROM users
-WHERE id = ? AND is_deleted = true;
-
-- name: CreateUser :one
INSERT INTO users (
id, name, public_key
@@ -18,30 +14,6 @@ INSERT INTO users (
)
RETURNING *;
--- name: SetUserName :one
-UPDATE users SET
- name = ?
-WHERE id = ? AND is_deleted = false
-RETURNING *;
-
--- name: SetUserPublicKey :one
-UPDATE users SET
- public_key = ?
-WHERE id = ? AND is_deleted = false
-RETURNING *;
-
--- name: SetUserDescription :one
-UPDATE users SET
- description = ?
-WHERE id = ? AND is_deleted = false
-RETURNING *;
-
--- name: SetUserPublicDMs :one
-UPDATE users SET
- is_public_dm = ?
-WHERE id = ? AND is_deleted = false
-RETURNING *;
-
-- name: DeleteUser :exec
UPDATE users SET
is_deleted = true