feat: add setup for SQL

1 files changed, 23 insertions, 0 deletions

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 *;