mirror of
https://github.com/pocket-id/pocket-id.git
synced 2026-09-02 09:11:28 +02:00
13 lines
595 B
SQL
13 lines
595 B
SQL
-- Freeze the app configuration
|
|
-- Encode every row of the standalone config table as a single JSON object (mapping key -> value) and store it in the "kv" table under the "config_migrated" key
|
|
--
|
|
-- json_object_agg aggregates all rows into a JSON object
|
|
-- The "HAVING count(*) > 0" clause ensures that nothing is written to the "kv" table when the config table is empty
|
|
INSERT INTO kv ("key", "value")
|
|
SELECT 'config_migrated', json_object_agg("key", "value")::text
|
|
FROM app_config_variables
|
|
HAVING count(*) > 0;
|
|
|
|
-- Drop the now-frozen standalone config table
|
|
DROP TABLE app_config_variables;
|