mirror of
https://github.com/lightninglabs/lightning-terminal.git
synced 2026-08-14 12:43:32 +02:00
75f6137d80
Rename the session_id to group_id in kvstores table in the SQL store, to better represent how the field is actually used. Note that this is a breaking change, and would normally require a new migration. But as the SQL store is not used in production, and only enabled under the dev build flag, we can rename it without a new migration, as there's no users of the SQL store in production.
111 lines
2.7 KiB
SQL
111 lines
2.7 KiB
SQL
-- name: GetOrInsertRuleID :one
|
|
INSERT INTO rules (name)
|
|
VALUES ($1)
|
|
ON CONFLICT(name) DO UPDATE SET name = excluded.name
|
|
RETURNING id;
|
|
|
|
-- name: GetRuleID :one
|
|
SELECT id
|
|
FROM rules
|
|
WHERE name = sqlc.arg('name');
|
|
|
|
-- name: GetOrInsertFeatureID :one
|
|
INSERT INTO features (name)
|
|
VALUES ($1)
|
|
ON CONFLICT(name) DO UPDATE SET name = excluded.name
|
|
RETURNING id;
|
|
|
|
-- name: GetFeatureID :one
|
|
SELECT id
|
|
FROM features
|
|
WHERE name = sqlc.arg('name');
|
|
|
|
-- name: InsertKVStoreRecord :exec
|
|
INSERT INTO kvstores (perm, rule_id, group_id, feature_id, entry_key, value)
|
|
VALUES ($1, $2, $3, $4, $5, $6);
|
|
|
|
-- name: DeleteAllTempKVStores :exec
|
|
DELETE FROM kvstores
|
|
WHERE perm = false;
|
|
|
|
-- name: ListAllKVStoresRecords :many
|
|
SELECT *
|
|
FROM kvstores;
|
|
|
|
-- name: GetGlobalKVStoreRecord :one
|
|
SELECT value
|
|
FROM kvstores
|
|
WHERE entry_key = sqlc.arg('key')
|
|
AND rule_id = sqlc.arg('rule_id')
|
|
AND perm = sqlc.arg('perm')
|
|
AND group_id IS NULL
|
|
AND feature_id IS NULL;
|
|
|
|
-- name: GetGroupKVStoreRecord :one
|
|
SELECT value
|
|
FROM kvstores
|
|
WHERE entry_key = sqlc.arg('key')
|
|
AND rule_id = sqlc.arg('rule_id')
|
|
AND perm = sqlc.arg('perm')
|
|
AND group_id = sqlc.arg('group_id')
|
|
AND feature_id IS NULL;
|
|
|
|
-- name: GetFeatureKVStoreRecord :one
|
|
SELECT value
|
|
FROM kvstores
|
|
WHERE entry_key = sqlc.arg('key')
|
|
AND rule_id = sqlc.arg('rule_id')
|
|
AND perm = sqlc.arg('perm')
|
|
AND group_id = sqlc.arg('group_id')
|
|
AND feature_id = sqlc.arg('feature_id');
|
|
|
|
-- name: DeleteGlobalKVStoreRecord :exec
|
|
DELETE FROM kvstores
|
|
WHERE entry_key = sqlc.arg('key')
|
|
AND rule_id = sqlc.arg('rule_id')
|
|
AND perm = sqlc.arg('perm')
|
|
AND group_id IS NULL
|
|
AND feature_id IS NULL;
|
|
|
|
-- name: DeleteGroupKVStoreRecord :exec
|
|
DELETE FROM kvstores
|
|
WHERE entry_key = sqlc.arg('key')
|
|
AND rule_id = sqlc.arg('rule_id')
|
|
AND perm = sqlc.arg('perm')
|
|
AND group_id = sqlc.arg('group_id')
|
|
AND feature_id IS NULL;
|
|
|
|
-- name: DeleteFeatureKVStoreRecord :exec
|
|
DELETE FROM kvstores
|
|
WHERE entry_key = sqlc.arg('key')
|
|
AND rule_id = sqlc.arg('rule_id')
|
|
AND perm = sqlc.arg('perm')
|
|
AND group_id = sqlc.arg('group_id')
|
|
AND feature_id = sqlc.arg('feature_id');
|
|
|
|
-- name: UpdateGlobalKVStoreRecord :exec
|
|
UPDATE kvstores
|
|
SET value = $1
|
|
WHERE entry_key = sqlc.arg('key')
|
|
AND rule_id = sqlc.arg('rule_id')
|
|
AND perm = sqlc.arg('perm')
|
|
AND group_id IS NULL
|
|
AND feature_id IS NULL;
|
|
|
|
-- name: UpdateGroupKVStoreRecord :exec
|
|
UPDATE kvstores
|
|
SET value = $1
|
|
WHERE entry_key = sqlc.arg('key')
|
|
AND rule_id = sqlc.arg('rule_id')
|
|
AND perm = sqlc.arg('perm')
|
|
AND group_id = sqlc.arg('group_id')
|
|
AND feature_id IS NULL;
|
|
|
|
-- name: UpdateFeatureKVStoreRecord :exec
|
|
UPDATE kvstores
|
|
SET value = $1
|
|
WHERE entry_key = sqlc.arg('key')
|
|
AND rule_id = sqlc.arg('rule_id')
|
|
AND perm = sqlc.arg('perm')
|
|
AND group_id = sqlc.arg('group_id')
|
|
AND feature_id = sqlc.arg('feature_id');
|