From a496d59fd64102b9aa8da8d86ee19d4eb8cbb547 Mon Sep 17 00:00:00 2001 From: Kyren223 Date: Mon, 10 Feb 2025 19:27:24 +0200 Subject: Implemented blocking on the server-side --- query/trusted_and_blocked_users.sql | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) (limited to 'query/trusted_and_blocked_users.sql') diff --git a/query/trusted_and_blocked_users.sql b/query/trusted_and_blocked_users.sql index a06cd55..5b80eac 100644 --- a/query/trusted_and_blocked_users.sql +++ b/query/trusted_and_blocked_users.sql @@ -19,9 +19,13 @@ WHERE trusting_user_id = ? AND trusted_user_id = ?; SELECT blocked_user_id FROM blocked_users WHERE blocking_user_id = ?; +-- name: IsUserBlocked :one +SELECT blocked_user_id FROM blocked_users +WHERE blocking_user_id = ? AND blocked_user_id = ?; + -- name: BlockUser :exec INSERT OR IGNORE INTO blocked_users ( - blocking_user_id, blocking_user_id + blocking_user_id, blocked_user_id ) VALUES (?, ?); -- name: UnblockUser :exec -- cgit v1.3.1