From 984d1f2d90fee958d545da6924c3628f87fac840 Mon Sep 17 00:00:00 2001
From: lukegleeson <luke.gleeson@est.tech>
Date: Tue, 4 Oct 2022 16:07:37 +0100
Subject: Make CPS/NCMP upgradeable

Liquibase step to add CM Handle Advised state to existing CM Handles

Issue-ID: CPS-1312
Signed-off-by: lukegleeson <luke.gleeson@est.tech>
Change-Id: I8077e66c64946f6ce092daa96ee40cd935fe0b72
---
 .../changelog/db/changes/16-insert-cm-handle-state-forward.sql         | 3 +++
 1 file changed, 3 insertions(+)
 create mode 100644 cps-ri/src/main/resources/changelog/db/changes/16-insert-cm-handle-state-forward.sql

(limited to 'cps-ri/src/main/resources/changelog/db/changes/16-insert-cm-handle-state-forward.sql')

diff --git a/cps-ri/src/main/resources/changelog/db/changes/16-insert-cm-handle-state-forward.sql b/cps-ri/src/main/resources/changelog/db/changes/16-insert-cm-handle-state-forward.sql
new file mode 100644
index 0000000000..64b185f3b2
--- /dev/null
+++ b/cps-ri/src/main/resources/changelog/db/changes/16-insert-cm-handle-state-forward.sql
@@ -0,0 +1,3 @@
+create view cmHandles as select * from fragment where xpath ~* '^/dmi-registry/cm-handles\[@id=''[\w\-]+''\]$';
+insert into fragment(xpath, attributes, anchor_id, parent_id, dataspace_id, schema_node_id) select concat(xpath, '/state'), to_jsonb(concat('{"cm-handle-state": "ADVISED", "last-update-time": "', to_char(now(), 'YYYY-MM-DD"T"HH24:MI:SS.MSTZHTZM'), '"}')::json), anchor_id, id, dataspace_id, schema_node_id from cmHandles;
+drop view cmHandles;
\ No newline at end of file
-- 
cgit 1.2.3-korg

