Implemented blocking on the server-side

1 files changed, 5 insertions, 1 deletions

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