diff options
| author |   puthuparambil.aditya <aditya.puthuparambil@bell.ca> | 2021-02-23 15:51:00 +0000 |
|---|---|---|
| committer | puthuparambil.aditya <aditya.puthuparambil@bell.ca> | 2021-02-24 10:10:34 +0000 |
| commit | 495ae8e49f0131bf461ea52baa87004c39f40bd3 (patch) | |
| tree | 667898db10d46db52617e92157c13781537c3796 /cps-ri/src/main/resources/changelog/db/changes/05-loadData-fragment.yaml | |
| parent | 861ecab596c548d77cc18f1581a992159ada82ee (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.yaml | 42 |
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 000000000..1a31f424a --- /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 |