Fixed everything on the server-side

2 files changed, 17 insertions, 1 deletions

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 = ?;