summaryrefslogtreecommitdiffstats
path: root/cps-ri/src/main/resources/changelog/db/changes/05-loadData-fragment.yaml
diff options
context:
space:
mode:
authorputhuparambil.aditya <aditya.puthuparambil@bell.ca>2021-02-23 15:51:00 +0000
committerputhuparambil.aditya <aditya.puthuparambil@bell.ca>2021-02-24 10:10:34 +0000
commit495ae8e49f0131bf461ea52baa87004c39f40bd3 (patch)
tree667898db10d46db52617e92157c13781537c3796 /cps-ri/src/main/resources/changelog/db/changes/05-loadData-fragment.yaml
parent861ecab596c548d77cc18f1581a992159ada82ee (diff)
Schema creation and Data pre-load to on cps-xnf-proxy start-up using liquibase
1. Common change-log master used only to specify the different change sets. 2. Specific change set created for cpsTables creation and for loading data to each cps component like dataspace, schema-set, anchor and dataNode 3. The data load cabability is configurable in the sense, it will be trigered only if the label is specified in the application.yaml Issue-ID: CPS-173, CPS-242 Signed-off-by: puthuparambil.aditya <aditya.puthuparambil@bell.ca> Change-Id: I44c640ce50b7203f5799d722149397478a98bc05
Diffstat (limited to 'cps-ri/src/main/resources/changelog/db/changes/05-loadData-fragment.yaml')
-rw-r--r--cps-ri/src/main/resources/changelog/db/changes/05-loadData-fragment.yaml42
1 files changed, 42 insertions, 0 deletions
diff --git a/cps-ri/src/main/resources/changelog/db/changes/05-loadData-fragment.yaml b/cps-ri/src/main/resources/changelog/db/changes/05-loadData-fragment.yaml
new file mode 100644
index 0000000000..1a31f424a4
--- /dev/null
+++ b/cps-ri/src/main/resources/changelog/db/changes/05-loadData-fragment.yaml
@@ -0,0 +1,42 @@
+databaseChangeLog:
+ - changeSet:
+ author: cps
+ label: xnf-data-preload
+ id: 5
+ loadUpdateData:
+ encoding: UTF-8
+ file: 'changelog/db/changes/data/fragment.csv'
+ onlyUpdate: 'false'
+ primaryKey: 'id'
+ quotchar: '"'
+ separator: '|'
+ tableName: 'fragment'
+ columns:
+ - column:
+ header: id
+ name: id
+ type: NUMERIC
+ - column:
+ header: xpath
+ name: xpath
+ type: STRING
+ - column:
+ header: attributes
+ name: attributes
+ type: CLOB
+ - column:
+ header: anchor_id
+ name: anchor_id
+ type: NUMERIC
+ - column:
+ header: parent_id
+ name: parent_id
+ type: NUMERIC
+ - column:
+ header: dataspace_id
+ name: dataspace_id
+ type: NUMERIC
+ - column:
+ header: schema_node_id
+ name: schema_node_id
+ type: NUMERIC