21 lines
782 B
SQL
21 lines
782 B
SQL
|
-- name: get-dashboard-charts
|
||
|
|
SELECT data FROM mat_dashboard_charts;
|
||
|
|
|
||
|
|
-- name: get-dashboard-counts
|
||
|
|
SELECT data FROM mat_dashboard_counts;
|
||
|
|
|
||
|
|
-- name: get-settings
|
||
|
|
SELECT JSON_OBJECT_AGG(key, value) AS settings FROM (SELECT * FROM settings ORDER BY key) t;
|
||
|
|
|
||
|
|
-- name: update-settings
|
||
|
|
UPDATE settings AS s SET value = c.value
|
||
|
|
-- For each key in the incoming JSON map, update the row with the key and its value.
|
||
|
|
FROM(SELECT * FROM JSONB_EACH($1)) AS c(key, value) WHERE s.key = c.key;
|
||
|
|
|
||
|
|
-- name: update-settings-by-key
|
||
|
|
UPDATE settings SET value = $2, updated_at = NOW() WHERE key = $1;
|
||
|
|
|
||
|
|
-- name: get-db-info
|
||
|
|
SELECT JSON_BUILD_OBJECT('version', (SELECT VERSION()),
|
||
|
|
'size_mb', (SELECT ROUND(pg_database_size((SELECT CURRENT_DATABASE()))/(1024^2)))) AS info;
|