blob: f91e6160d584b0a4ded928a8483260e0846fd620 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
-- name: GetUserTrusteds :many
SELECT trusted_user_id, trusted_public_key FROM trusted_users
WHERE trusting_user_id = ?;
-- name: GetTrustedPublicKey :one
SELECT trusted_public_key FROM trusted_users
WHERE trusting_user_id = ? AND trusted_user_id = ?;
-- name: TrustUser :exec
INSERT OR IGNORE INTO trusted_users (
trusting_user_id, trusted_user_id, trusted_public_key
) VALUES (?, ?, ?);
-- name: UntrustUser :exec
DELETE FROM trusted_users
WHERE trusting_user_id = ? AND trusted_user_id = ?;
|
