From 31e3778061a20e0787c076d9353e82b2e223841e Mon Sep 17 00:00:00 2001
From: Kyren223 <ulmliad223@gmail.com>
Date: Sun, 27 Oct 2024 17:04:08 +0200
Subject: feat: add setup for SQL

---
 query/users.sql | 23 +++++++++++++++++++++++
 1 file changed, 23 insertions(+)
 create mode 100644 query/users.sql

(limited to 'query/users.sql')

diff --git a/query/users.sql b/query/users.sql
new file mode 100644
index 0000000..28ca8b9
--- /dev/null
+++ b/query/users.sql
@@ -0,0 +1,23 @@
+-- name: GetUser :one
+SELECT * FROM users
+WHERE id = ?;
+
+-- name: CreateUser :one
+INSERT INTO users (
+  id, name, public_key
+) VALUES (
+  ?, 'User' || abs(random()) % 1000000, ?
+)
+RETURNING *;
+
+-- name: SetUserName :one
+UPDATE users SET
+  name = ?
+WHERE id = ?
+RETURNING *;
+
+-- name: SetUserPublicKey :one
+UPDATE users SET
+  public_key = ?
+WHERE id = ?
+RETURNING *;
-- 
cgit v1.3.1