Schema creation and Data pre-load to on cps-xnf-proxy start-up using liquibase
[cps.git] / cps-ri / src / main / resources / changelog / db / changes / 03-loadData-schema-set.yaml
1 databaseChangeLog:
2   - changeSet:
3       author: cps
4       label: xnf-data-preload
5       id: 3.1
6       loadUpdateData:
7         encoding: UTF-8
8         file: 'changelog/db/changes/data/schema_set.csv'
9         onlyUpdate: 'false'
10         primaryKey: 'id'
11         quotchar: '"'
12         separator: '|'
13         tableName: 'schema_set'
14
15   - changeSet:
16       author: cps
17       label: xnf-data-preload
18       id: 3.2
19       loadUpdateData:
20         encoding: UTF-8
21         file: 'changelog/db/changes/data/yang_resource.csv'
22         onlyUpdate: 'false'
23         primaryKey: 'id'
24         quotchar: '"'
25         separator: '|'
26         tableName: 'yang_resource'
27         columns:
28           - column:
29               header:  name
30               name:  name
31               type:  STRING
32           - column:
33               header:  content
34               name: content
35               type: STRING
36           - column:
37               header:  checkstyle
38               name: checkstyle
39               type: STRING
40
41   - changeSet:
42       author: cps
43       label: xnf-data-preload
44       id: 3.3
45       loadUpdateData:
46         encoding: UTF-8
47         file: 'changelog/db/changes/data/schema_set_yang_resources.csv'
48         quotchar: '"'
49         primaryKey: 'schema_set_id,yang_resource_id'
50         separator: '|'
51         tableName: 'schema_set_yang_resources'
52         usePreparedStatements:  true
53