feat: add setup for SQL

4 files changed, 69 insertions, 0 deletions

diff --git a/query/frequencies.sql b/query/frequencies.sql
new file mode 100644
index 0000000..ed68c78
--- /dev/null
+++ b/query/frequencies.sql
@@ -0,0 +1,12 @@
+-- name: GetNetworkFrequencies :many
+SELECT * FROM frequencies
+WHERE network_id = ?
+ORDER BY id;
+
+-- name: CreateFrequency :one
+INSERT INTO frequencies (
+  id, network_id, name
+) VALUES (
+  ?, ?, ?
+)
+RETURNING *;
diff --git a/query/messages.sql b/query/messages.sql
new file mode 100644
index 0000000..1e982b1
--- /dev/null
+++ b/query/messages.sql
@@ -0,0 +1,19 @@
+-- name: ListMessages :many
+SELECT * FROM messages
+ORDER BY id;
+
+-- name: CreateDirectMessage :one
+INSERT INTO messages (
+  id, content, sender_id, receiver_id
+) VALUES (
+  ?, ?, ?, ?
+)
+RETURNING *;
+
+-- name: CreateMessage :one
+INSERT INTO messages (
+  id, content, sender_id, frequency_id
+) VALUES (
+  ?, ?, ?, ?
+)
+RETURNING *;
diff --git a/query/networks.sql b/query/networks.sql
new file mode 100644
index 0000000..d709975
--- /dev/null
+++ b/query/networks.sql
@@ -0,0 +1,15 @@
+-- name: ListNetworks :many
+SELECT * FROM networks
+ORDER BY id;
+
+-- name: GetNetwork :one
+SELECT * FROM networks
+WHERE id = ?;
+
+-- name: CreateNetwork :one
+INSERT INTO networks (
+  id, name, owner_id
+) VALUES (
+  ?, ?, ?
+)
+RETURNING *;
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 *;