mirror of
https://github.com/abhinavxd/libredesk.git
synced 2025-11-04 22:13:25 +00:00
17 lines
435 B
SQL
17 lines
435 B
SQL
-- name: get-all
|
|
SELECT JSON_OBJECT_AGG(key, value) AS settings FROM (SELECT * FROM settings ORDER BY key) t;
|
|
|
|
-- name: update
|
|
UPDATE settings AS s
|
|
SET value = c.value,
|
|
updated_at = now()
|
|
FROM (SELECT * FROM jsonb_each($1)) AS c(key, value)
|
|
WHERE s.key = c.key;
|
|
|
|
-- name: get-by-prefix
|
|
SELECT JSON_OBJECT_AGG(key, value) AS settings
|
|
FROM settings
|
|
WHERE key LIKE $1 || '%';
|
|
|
|
-- name: get
|
|
SELECT value FROM settings WHERE key = $1; |