Added the ability to trust/untrust users

1 files changed, 16 insertions, 0 deletions

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