diff options
Diffstat (limited to 'cps-ri/src/main/resources/changelog/db/changes/16-insert-cm-handle-state-forward.sql')
-rw-r--r-- | cps-ri/src/main/resources/changelog/db/changes/16-insert-cm-handle-state-forward.sql | 137 |
1 files changed, 0 insertions, 137 deletions
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 deleted file mode 100644 index 01d441f46..000000000 --- a/cps-ri/src/main/resources/changelog/db/changes/16-insert-cm-handle-state-forward.sql +++ /dev/null @@ -1,137 +0,0 @@ -INSERT INTO - fragment( - xpath, - attributes, - anchor_id, - parent_id, - dataspace_id, - schema_node_id - ) -SELECT - concat(cmHandles.xpath, '/state') AS xpath, - to_jsonb( - concat( - '{"cm-handle-state": "READY", "last-update-time": "', - to_char( - now(), - 'YYYY-MM-DD"T"HH24:MI:SS.MSTZHTZM' - ), - '", "data-sync-enabled": false}' - ) :: json - ) AS attributes, - cmHandles.anchor_id, - cmHandles.id, - cmHandles.dataspace_id, - cmHandles.schema_node_id -FROM - ( - SELECT - id, - xpath, - anchor_id, - dataspace_id, - schema_node_id - FROM - fragment - WHERE - xpath ~* '^/dmi-registry/cm-handles\[@id=''[\w\-]+''\]$' - AND xpath NOT IN ( - SELECT - SUBSTRING( - xpath - FROM - '^/dmi-registry/cm-handles\[@id=''[\w\-]+''\]' - ) - FROM - fragment - WHERE - xpath ~* '^/dmi-registry/cm-handles\[@id=''[\w\-]+''\]/state$' - ) - ) AS cmHandles; -INSERT INTO - fragment( - xpath, - attributes, - anchor_id, - parent_id, - dataspace_id, - schema_node_id - ) -SELECT - concat(cmHandlesStates.xpath, '/datastores'), - to_jsonb('{}' :: json), - cmHandlesStates.anchor_id, - cmHandlesStates.id, - cmHandlesStates.dataspace_id, - cmHandlesStates.schema_node_id -FROM - ( - SELECT - id, - xpath, - anchor_id, - dataspace_id, - schema_node_id - FROM - fragment - WHERE - xpath ~* '^/dmi-registry/cm-handles\[@id=''[\w\-]+''\]/state$' - AND xpath NOT IN ( - SELECT - SUBSTRING( - xpath - FROM - '^/dmi-registry/cm-handles\[@id=''[\w\-]+''\]/state' - ) - FROM - fragment - WHERE - xpath ~* '^/dmi-registry/cm-handles\[@id=''[\w\-]+''\]/state/datastores$' - ) - ) AS cmHandlesStates; -INSERT INTO - fragment( - xpath, - attributes, - anchor_id, - parent_id, - dataspace_id, - schema_node_id - ) -SELECT - concat( - cmHandlesDatastores.xpath, - '/operational' - ), - to_jsonb( - concat('{"sync-state": "NONE_REQUESTED"}') :: json - ), - cmHandlesDatastores.anchor_id, - cmHandlesDatastores.id, - cmHandlesDatastores.dataspace_id, - cmHandlesDatastores.schema_node_id -FROM - ( - SELECT - id, - xpath, - anchor_id, - dataspace_id, - schema_node_id - FROM - fragment - WHERE - xpath ~* '^/dmi-registry/cm-handles\[@id=''[\w\-]+''\]/state/datastores$' - AND xpath NOT IN ( - SELECT - SUBSTRING( - xpath - FROM - '^/dmi-registry/cm-handles\[@id=''[\w\-]+''\]/state/datastores' - ) - FROM - fragment - WHERE - xpath ~* '^/dmi-registry/cm-handles\[@id=''[\w\-]+''\]/state/datastores/operational$' - ) - ) AS cmHandlesDatastores;
\ No newline at end of file |