mirror of
https://github.com/lightninglabs/lightning-terminal.git
synced 2026-08-13 12:33:36 +02:00
18 lines
432 B
SQL
18 lines
432 B
SQL
-- name: InsertPrivacyPair :exec
|
|
INSERT INTO privacy_pairs (group_id, real_val, pseudo_val)
|
|
VALUES ($1, $2, $3);
|
|
|
|
-- name: GetRealForPseudo :one
|
|
SELECT real_val
|
|
FROM privacy_pairs
|
|
WHERE group_id = $1 AND pseudo_val = $2;
|
|
|
|
-- name: GetPseudoForReal :one
|
|
SELECT pseudo_val
|
|
FROM privacy_pairs
|
|
WHERE group_id = $1 AND real_val = $2;
|
|
|
|
-- name: GetAllPrivacyPairs :many
|
|
SELECT real_val, pseudo_val
|
|
FROM privacy_pairs
|
|
WHERE group_id = $1;
|