summaryrefslogtreecommitdiff
path: root/query/trusted_and_blocked_users.sql
diff options
context:
space:
mode:
authorKyren223 <Kyren223@proton.me>2025-02-12 13:08:49 +0200
committerKyren223 <Kyren223@proton.me>2025-02-12 13:08:49 +0200
commit66983fb02847dc9b1c53916da0dc7ad5a09f6644 (patch)
tree897301226bcb87bf6a7d2b823e74abecabece680 /query/trusted_and_blocked_users.sql
parent976d3683f963b6f9282a534e1b4fec2411b738a2 (diff)
Added blocking/unblocking of users using b/u (user settings are now s
instead of "u")
Diffstat (limited to 'query/trusted_and_blocked_users.sql')
-rw-r--r--query/trusted_and_blocked_users.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/query/trusted_and_blocked_users.sql b/query/trusted_and_blocked_users.sql
index 5b80eac..71257a1 100644
--- a/query/trusted_and_blocked_users.sql
+++ b/query/trusted_and_blocked_users.sql
@@ -19,6 +19,10 @@ WHERE trusting_user_id = ? AND trusted_user_id = ?;
SELECT blocked_user_id FROM blocked_users
WHERE blocking_user_id = ?;
+-- name: GetBlockingUsers :many
+SELECT blocking_user_id FROM blocked_users
+WHERE blocked_user_id = ?;
+
-- name: IsUserBlocked :one
SELECT blocked_user_id FROM blocked_users
WHERE blocking_user_id = ? AND blocked_user_id = ?;