diff options
Diffstat (limited to 'query/trusted_and_blocked_users.sql')
| -rw-r--r-- | query/trusted_and_blocked_users.sql | 6 |
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 |