DenozordecandCursor
50bdb8232b
Preview BIRD-фрагменты в config_revision_preview; meta_json только счётчик префиксов. Co-authored-by: Cursor <cursoragent@cursor.com>
10 lines
320 B
SQL
10 lines
320 B
SQL
UPDATE config_revision
|
|
SET meta_json = json_set(
|
|
meta_json,
|
|
'$.preview_fragments',
|
|
json(COALESCE((SELECT fragments FROM config_revision_preview p WHERE p.revision_id = config_revision.id), '{}'))
|
|
)
|
|
WHERE id IN (SELECT revision_id FROM config_revision_preview);
|
|
|
|
DROP TABLE IF EXISTS config_revision_preview;
|