From b09a8fba647ff030b24d9ad12215ba330c13080c Mon Sep 17 00:00:00 2001 From: Kyren223 Date: Thu, 9 Jan 2025 19:14:05 +0200 Subject: Fixed everything on the server-side --- query/members.sql | 2 +- query/users.sql | 16 ++++++++++++++++ 2 files changed, 17 insertions(+), 1 deletion(-) (limited to 'query') diff --git a/query/members.sql b/query/members.sql index 04e04cd..0b6cb21 100644 --- a/query/members.sql +++ b/query/members.sql @@ -1,4 +1,4 @@ --- name: GetMembers :many +-- name: GetNetworkMembers :many SELECT sqlc.embed(users), sqlc.embed(members) diff --git a/query/users.sql b/query/users.sql index 8247dda..0d58b2d 100644 --- a/query/users.sql +++ b/query/users.sql @@ -18,3 +18,19 @@ RETURNING *; UPDATE users SET is_deleted = true WHERE id = ? AND is_deleted = false; + +-- name: SetUserData :one +INSERT INTO user_data ( + user_id, data +) VALUES ( + @user_id, @data +) +ON CONFLICT DO +UPDATE SET + user_id = EXCLUDED.user_id, data = EXCLUDED.data +WHERE user_id = EXCLUDED.user_id +RETURNING *; + +-- name: GetUserData :one +SELECT data FROM user_data +WHERE user_id = ?; -- cgit v1.3.1