From a6ea05146050a8b2ae5963d4ea96434dc3005f37 Mon Sep 17 00:00:00 2001
From: Kyren223 <Kyren223@proton.me>
Date: Wed, 22 Jan 2025 17:23:18 +0200
Subject: Added the ability to trust/untrust users

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

(limited to 'query')

diff --git a/query/trusted_and_blocked_users.sql b/query/trusted_and_blocked_users.sql
new file mode 100644
index 0000000..f91e616
--- /dev/null
+++ b/query/trusted_and_blocked_users.sql
@@ -0,0 +1,16 @@
+-- name: GetUserTrusteds :many
+SELECT trusted_user_id, trusted_public_key FROM trusted_users
+WHERE trusting_user_id = ?;
+
+-- name: GetTrustedPublicKey :one
+SELECT trusted_public_key FROM trusted_users
+WHERE trusting_user_id = ? AND trusted_user_id = ?;
+
+-- name: TrustUser :exec
+INSERT OR IGNORE INTO trusted_users (
+  trusting_user_id, trusted_user_id, trusted_public_key
+) VALUES (?, ?, ?);
+
+-- name: UntrustUser :exec
+DELETE FROM trusted_users
+WHERE trusting_user_id = ? AND trusted_user_id = ?;
-- 
cgit v1.3.1