From 66983fb02847dc9b1c53916da0dc7ad5a09f6644 Mon Sep 17 00:00:00 2001 From: Kyren223 Date: Wed, 12 Feb 2025 13:08:49 +0200 Subject: Added blocking/unblocking of users using b/u (user settings are now s instead of "u") --- query/trusted_and_blocked_users.sql | 4 ++++ 1 file changed, 4 insertions(+) (limited to 'query') 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 = ?; -- cgit v1.3.1