...
# | Issue | Answer/Resolution | Notes/Images |
---|---|---|---|
1 | After adding files there are 2,300 checkstyle violation | After conversation with Toine Siebelinkwe are to ignore violations and proceed to see if it is a viable option | |
2 | Was using latest codebase from GitHub but should be aligned with Andrew Fenner | I am in contact with Andrew Fennerto ensure that we are both testing with the same release version - We have decided to go with v4.4.2 (https://github.com/liquibase/liquibase/releases) |
Approaches
...
- Explore option to automatically copy an build using a Nordix Repo and C/I job. Some technical and legal issues to be examined. Will the delivered artifact(s) be available to non-Nordix users ie. what repo will be used?
- Create CPS sub-repo with copy of sources from https://github.com/liquibase/liquibase (legal option, but not easy to share with others) Later even a new shared stand-alone repo? (two-step approach) (Appears to be the quickest and most efficient way to add liquibase to code base)
- Consider DB-Migrator tool already used and part of ONAP: https://docs.onap.org/projects/onap-policy-parent/en/guilin/drools/pdpdEngine.html#data-migration
- Consider FlyWay https://dzone.com/articles/flyway-vs-liquibase
...
Andrew Fenneris investigating this.
liquibase-core has been manually added to Nordix Artifactory (automation pending): https://artifactory.nordix.org/ui/repos/tree/General/liquibase%2Forg%2Fliquibase%2Fliquibase-core%2F4.4.2-nordix%2Fliquibase-core-4.4.2-nordix.jar
- Add new dependencies to cps-ri & cps-depenencies poms
- Build CPS
- Ensure seed data is present in Postgres
Code Block | ||||
---|---|---|---|---|
| ||||
2021-07-29 15:00:01.833 INFO 9836 --- [ main] liquibase.database : Set default schema name to public
2021-07-29T15:00:01.833+01:00|main|| liquibase.database - Set default schema name to public
2021-07-29 15:00:02.153 INFO 9836 --- [ main] liquibase.lockservice : Successfully acquired change log lock
2021-07-29T15:00:02.153+01:00|main|| liquibase.lockservice - Successfully acquired change log lock
2021-07-29 15:00:03.220 INFO 9836 --- [ main] liquibase.changelog : Creating database history table with name: public.databasechangelog
2021-07-29T15:00:03.220+01:00|main|| liquibase.changelog - Creating database history table with name: public.databasechangelog
2021-07-29 15:00:03.262 INFO 9836 --- [ main] liquibase.changelog : Reading from public.databasechangelog
2021-07-29T15:00:03.262+01:00|main|| liquibase.changelog - Reading from public.databasechangelog
2021-07-29 15:00:04.028 INFO 9836 --- [ main] liquibase.changelog : Table anchor created
2021-07-29T15:00:04.028+01:00|main|| liquibase.changelog - Table anchor created
2021-07-29 15:00:04.032 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-1::cps ran successfully in 22ms
2021-07-29T15:00:04.032+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-1::cps ran successfully in 22ms
2021-07-29 15:00:04.069 INFO 9836 --- [ main] liquibase.changelog : Table relation created
2021-07-29T15:00:04.069+01:00|main|| liquibase.changelog - Table relation created
2021-07-29 15:00:04.073 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-2::cps ran successfully in 16ms
2021-07-29T15:00:04.073+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-2::cps ran successfully in 16ms
2021-07-29 15:00:04.095 INFO 9836 --- [ main] liquibase.changelog : Table relation_type created
2021-07-29T15:00:04.095+01:00|main|| liquibase.changelog - Table relation_type created
2021-07-29 15:00:04.098 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-3::cps ran successfully in 16ms
2021-07-29T15:00:04.098+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-3::cps ran successfully in 16ms
2021-07-29 15:00:04.124 INFO 9836 --- [ main] liquibase.changelog : Table fragment created
2021-07-29T15:00:04.124+01:00|main|| liquibase.changelog - Table fragment created
2021-07-29 15:00:04.130 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-4::cps ran successfully in 18ms
2021-07-29T15:00:04.130+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-4::cps ran successfully in 18ms
2021-07-29 15:00:04.152 INFO 9836 --- [ main] liquibase.changelog : Table schema_set created
2021-07-29T15:00:04.152+01:00|main|| liquibase.changelog - Table schema_set created
2021-07-29 15:00:04.156 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-5::cps ran successfully in 17ms
2021-07-29T15:00:04.156+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-5::cps ran successfully in 17ms
2021-07-29 15:00:04.178 INFO 9836 --- [ main] liquibase.changelog : Table yang_resource created
2021-07-29T15:00:04.178+01:00|main|| liquibase.changelog - Table yang_resource created
2021-07-29 15:00:04.181 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-6::cps ran successfully in 15ms
2021-07-29T15:00:04.181+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-6::cps ran successfully in 15ms
2021-07-29 15:00:04.214 INFO 9836 --- [ main] liquibase.changelog : Table dataspace created
2021-07-29T15:00:04.214+01:00|main|| liquibase.changelog - Table dataspace created
2021-07-29 15:00:04.217 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-7::cps ran successfully in 18ms
2021-07-29T15:00:04.217+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-7::cps ran successfully in 18ms
2021-07-29 15:00:04.242 INFO 9836 --- [ main] liquibase.changelog : Table schema_node created
2021-07-29T15:00:04.242+01:00|main|| liquibase.changelog - Table schema_node created
2021-07-29 15:00:04.248 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-8::cps ran successfully in 21ms
2021-07-29T15:00:04.248+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-8::cps ran successfully in 21ms
2021-07-29 15:00:04.279 INFO 9836 --- [ main] liquibase.changelog : Table schema_set_yang_resources created
2021-07-29T15:00:04.279+01:00|main|| liquibase.changelog - Table schema_set_yang_resources created
2021-07-29 15:00:04.282 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-9::cps ran successfully in 22ms
2021-07-29T15:00:04.282+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-9::cps ran successfully in 22ms
2021-07-29 15:00:04.299 INFO 9836 --- [ main] liquibase.changelog : Index FKI_ANCHOR_SCHEMA_SET_ID_FK created
2021-07-29T15:00:04.299+01:00|main|| liquibase.changelog - Index FKI_ANCHOR_SCHEMA_SET_ID_FK created
2021-07-29 15:00:04.302 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-10::cps ran successfully in 11ms
2021-07-29T15:00:04.302+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-10::cps ran successfully in 11ms
2021-07-29 15:00:04.322 INFO 9836 --- [ main] liquibase.changelog : Unique constraint added to anchor(dataspace_id, name)
2021-07-29T15:00:04.322+01:00|main|| liquibase.changelog - Unique constraint added to anchor(dataspace_id, name)
2021-07-29 15:00:04.325 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-11::cps ran successfully in 14ms
2021-07-29T15:00:04.325+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-11::cps ran successfully in 14ms
2021-07-29 15:00:04.348 INFO 9836 --- [ main] liquibase.changelog : Foreign key constraint added to fragment (anchor_id)
2021-07-29T15:00:04.348+01:00|main|| liquibase.changelog - Foreign key constraint added to fragment (anchor_id)
2021-07-29 15:00:04.351 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-12::cps ran successfully in 15ms
2021-07-29T15:00:04.351+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-12::cps ran successfully in 15ms
2021-07-29 15:00:04.371 INFO 9836 --- [ main] liquibase.changelog : Index FKI_RELATIONS_FROM_ID_FK created
2021-07-29T15:00:04.371+01:00|main|| liquibase.changelog - Index FKI_RELATIONS_FROM_ID_FK created
2021-07-29 15:00:04.375 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-13::cps ran successfully in 13ms
2021-07-29T15:00:04.375+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-13::cps ran successfully in 13ms
2021-07-29 15:00:04.392 INFO 9836 --- [ main] liquibase.changelog : Index FKI_RELATIONS_TO_ID_FK created
2021-07-29T15:00:04.392+01:00|main|| liquibase.changelog - Index FKI_RELATIONS_TO_ID_FK created
2021-07-29 15:00:04.397 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-14::cps ran successfully in 10ms
2021-07-29T15:00:04.397+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-14::cps ran successfully in 10ms
2021-07-29 15:00:04.414 INFO 9836 --- [ main] liquibase.changelog : Index FKI_RELATION_TYPE_ID_FK created
2021-07-29T15:00:04.414+01:00|main|| liquibase.changelog - Index FKI_RELATION_TYPE_ID_FK created
2021-07-29 15:00:04.419 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-15::cps ran successfully in 11ms
2021-07-29T15:00:04.419+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-15::cps ran successfully in 11ms
2021-07-29 15:00:04.439 INFO 9836 --- [ main] liquibase.changelog : Primary key added to relation (to_fragment_id, from_fragment_id, relation_type_id)
2021-07-29T15:00:04.439+01:00|main|| liquibase.changelog - Primary key added to relation (to_fragment_id, from_fragment_id, relation_type_id)
2021-07-29 15:00:04.449 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-16::cps ran successfully in 21ms
2021-07-29T15:00:04.449+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-16::cps ran successfully in 21ms
2021-07-29 15:00:04.504 INFO 9836 --- [ main] liquibase.changelog : Index FKI_FRAGMENT_ANCHOR_ID_FK created
2021-07-29T15:00:04.504+01:00|main|| liquibase.changelog - Index FKI_FRAGMENT_ANCHOR_ID_FK created
2021-07-29 15:00:04.524 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-17::cps ran successfully in 34ms
2021-07-29T15:00:04.524+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-17::cps ran successfully in 34ms
2021-07-29 15:00:04.543 INFO 9836 --- [ main] liquibase.changelog : Index FKI_FRAGMENT_DATASPACE_ID_FK created
2021-07-29T15:00:04.543+01:00|main|| liquibase.changelog - Index FKI_FRAGMENT_DATASPACE_ID_FK created
2021-07-29 15:00:04.548 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-18::cps ran successfully in 13ms
2021-07-29T15:00:04.548+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-18::cps ran successfully in 13ms
2021-07-29 15:00:04.564 INFO 9836 --- [ main] liquibase.changelog : Index FKI_FRAGMENT_PARENT_ID_FK created
2021-07-29T15:00:04.564+01:00|main|| liquibase.changelog - Index FKI_FRAGMENT_PARENT_ID_FK created
2021-07-29 15:00:04.567 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-19::cps ran successfully in 11ms
2021-07-29T15:00:04.567+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-19::cps ran successfully in 11ms
2021-07-29 15:00:04.615 INFO 9836 --- [ main] liquibase.changelog : Index FKI_SCHEMA_NODE_ID_TO_ID created
2021-07-29T15:00:04.615+01:00|main|| liquibase.changelog - Index FKI_SCHEMA_NODE_ID_TO_ID created
2021-07-29 15:00:04.621 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-20::cps ran successfully in 27ms
2021-07-29T15:00:04.621+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-20::cps ran successfully in 27ms
2021-07-29 15:00:04.651 INFO 9836 --- [ main] liquibase.changelog : Index UQ_FRAGMENT_XPATH created
2021-07-29T15:00:04.651+01:00|main|| liquibase.changelog - Index UQ_FRAGMENT_XPATH created
2021-07-29 15:00:04.658 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-21::cps ran successfully in 26ms
2021-07-29T15:00:04.658+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-21::cps ran successfully in 26ms
2021-07-29 15:00:04.690 INFO 9836 --- [ main] liquibase.changelog : Unique constraint added to fragment(dataspace_id, anchor_id, xpath)
2021-07-29T15:00:04.690+01:00|main|| liquibase.changelog - Unique constraint added to fragment(dataspace_id, anchor_id, xpath)
2021-07-29 15:00:04.697 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-22::cps ran successfully in 17ms
2021-07-29T15:00:04.697+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-22::cps ran successfully in 17ms
2021-07-29 15:00:04.733 INFO 9836 --- [ main] liquibase.changelog : Foreign key constraint added to relation (from_fragment_id)
2021-07-29T15:00:04.733+01:00|main|| liquibase.changelog - Foreign key constraint added to relation (from_fragment_id)
2021-07-29 15:00:04.746 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-23::cps ran successfully in 39ms
2021-07-29T15:00:04.746+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-23::cps ran successfully in 39ms
2021-07-29 15:00:04.797 INFO 9836 --- [ main] liquibase.changelog : Foreign key constraint added to relation (to_fragment_id)
2021-07-29T15:00:04.797+01:00|main|| liquibase.changelog - Foreign key constraint added to relation (to_fragment_id)
2021-07-29 15:00:04.803 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-24::cps ran successfully in 36ms
2021-07-29T15:00:04.803+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-24::cps ran successfully in 36ms
2021-07-29 15:00:04.827 INFO 9836 --- [ main] liquibase.changelog : Unique constraint added to schema_set(name, dataspace_id)
2021-07-29T15:00:04.827+01:00|main|| liquibase.changelog - Unique constraint added to schema_set(name, dataspace_id)
2021-07-29 15:00:04.830 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-25::cps ran successfully in 11ms
2021-07-29T15:00:04.830+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-25::cps ran successfully in 11ms
2021-07-29 15:00:04.847 INFO 9836 --- [ main] liquibase.changelog : Foreign key constraint added to schema_set_yang_resources (schema_set_id)
2021-07-29T15:00:04.847+01:00|main|| liquibase.changelog - Foreign key constraint added to schema_set_yang_resources (schema_set_id)
2021-07-29 15:00:04.850 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-26::cps ran successfully in 11ms
2021-07-29T15:00:04.850+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-26::cps ran successfully in 11ms
2021-07-29 15:00:04.871 INFO 9836 --- [ main] liquibase.changelog : Unique constraint added to yang_resource(checksum)
2021-07-29T15:00:04.871+01:00|main|| liquibase.changelog - Unique constraint added to yang_resource(checksum)
2021-07-29 15:00:04.874 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-27::cps ran successfully in 12ms
2021-07-29T15:00:04.874+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-27::cps ran successfully in 12ms
2021-07-29 15:00:04.944 INFO 9836 --- [ main] liquibase.changelog : Unique constraint added to dataspace(name)
2021-07-29T15:00:04.944+01:00|main|| liquibase.changelog - Unique constraint added to dataspace(name)
2021-07-29 15:00:04.949 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-28::cps ran successfully in 18ms
2021-07-29T15:00:04.949+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-28::cps ran successfully in 18ms
2021-07-29 15:00:04.974 INFO 9836 --- [ main] liquibase.changelog : Foreign key constraint added to fragment (dataspace_id)
2021-07-29T15:00:04.974+01:00|main|| liquibase.changelog - Foreign key constraint added to fragment (dataspace_id)
2021-07-29 15:00:04.979 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-29::cps ran successfully in 18ms
2021-07-29T15:00:04.979+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-29::cps ran successfully in 18ms
2021-07-29 15:00:04.998 INFO 9836 --- [ main] liquibase.changelog : Foreign key constraint added to schema_set (dataspace_id)
2021-07-29T15:00:04.998+01:00|main|| liquibase.changelog - Foreign key constraint added to schema_set (dataspace_id)
2021-07-29 15:00:05.003 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-30::cps ran successfully in 15ms
2021-07-29T15:00:05.003+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-30::cps ran successfully in 15ms
2021-07-29 15:00:05.028 INFO 9836 --- [ main] liquibase.changelog : Index PERF_SCHEMA_NODE_SCHEMA_NODE_ID created
2021-07-29T15:00:05.028+01:00|main|| liquibase.changelog - Index PERF_SCHEMA_NODE_SCHEMA_NODE_ID created
2021-07-29 15:00:05.031 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-31::cps ran successfully in 13ms
2021-07-29T15:00:05.031+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-31::cps ran successfully in 13ms
2021-07-29 15:00:05.054 INFO 9836 --- [ main] liquibase.changelog : Foreign key constraint added to schema_set_yang_resources (yang_resource_id)
2021-07-29T15:00:05.054+01:00|main|| liquibase.changelog - Foreign key constraint added to schema_set_yang_resources (yang_resource_id)
2021-07-29 15:00:05.057 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-32::cps ran successfully in 15ms
2021-07-29T15:00:05.057+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-32::cps ran successfully in 15ms
2021-07-29 15:00:05.074 INFO 9836 --- [ main] liquibase.changelog : Foreign key constraint added to anchor (dataspace_id)
2021-07-29T15:00:05.074+01:00|main|| liquibase.changelog - Foreign key constraint added to anchor (dataspace_id)
2021-07-29 15:00:05.078 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-33::cps ran successfully in 13ms
2021-07-29T15:00:05.078+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-33::cps ran successfully in 13ms
2021-07-29 15:00:05.106 INFO 9836 --- [ main] liquibase.changelog : Foreign key constraint added to anchor (schema_set_id)
2021-07-29T15:00:05.106+01:00|main|| liquibase.changelog - Foreign key constraint added to anchor (schema_set_id)
2021-07-29 15:00:05.109 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-34::cps ran successfully in 19ms
2021-07-29T15:00:05.109+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-34::cps ran successfully in 19ms
2021-07-29 15:00:05.129 INFO 9836 --- [ main] liquibase.changelog : Foreign key constraint added to relation (relation_type_id)
2021-07-29T15:00:05.129+01:00|main|| liquibase.changelog - Foreign key constraint added to relation (relation_type_id)
2021-07-29 15:00:05.140 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-35::cps ran successfully in 20ms
2021-07-29T15:00:05.140+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-35::cps ran successfully in 20ms
2021-07-29 15:00:05.166 INFO 9836 --- [ main] liquibase.changelog : Foreign key constraint added to fragment (parent_id)
2021-07-29T15:00:05.166+01:00|main|| liquibase.changelog - Foreign key constraint added to fragment (parent_id)
2021-07-29 15:00:05.170 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-36::cps ran successfully in 13ms
2021-07-29T15:00:05.170+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-36::cps ran successfully in 13ms
2021-07-29 15:00:05.186 INFO 9836 --- [ main] liquibase.changelog : Foreign key constraint added to fragment (schema_node_id)
2021-07-29T15:00:05.186+01:00|main|| liquibase.changelog - Foreign key constraint added to fragment (schema_node_id)
2021-07-29 15:00:05.191 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-37::cps ran successfully in 15ms
2021-07-29T15:00:05.191+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/01-createCPSTables.yaml::1-37::cps ran successfully in 15ms
2021-07-29 15:00:05.321 INFO 9836 --- [ main] liquibase.changelog : Data loaded from 'changelog/db/changes/data/dataspace.csv' into table 'dataspace'
2021-07-29T15:00:05.321+01:00|main|| liquibase.changelog - Data loaded from 'changelog/db/changes/data/dataspace.csv' into table 'dataspace'
2021-07-29 15:00:05.324 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/02-loadData-dataspace.yaml::2::cps ran successfully in 122ms
2021-07-29T15:00:05.324+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/02-loadData-dataspace.yaml::2::cps ran successfully in 122ms
2021-07-29 15:00:05.372 INFO 9836 --- [ main] liquibase.changelog : Data loaded from 'changelog/db/changes/data/schema_set.csv' into table 'schema_set'
2021-07-29T15:00:05.372+01:00|main|| liquibase.changelog - Data loaded from 'changelog/db/changes/data/schema_set.csv' into table 'schema_set'
2021-07-29 15:00:05.375 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/03-loadData-schema-set.yaml::3.1::cps ran successfully in 40ms
2021-07-29T15:00:05.375+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/03-loadData-schema-set.yaml::3.1::cps ran successfully in 40ms
2021-07-29 15:00:05.526 INFO 9836 --- [ main] liquibase.changelog : Data loaded from 'changelog/db/changes/data/yang_resource.csv' into table 'yang_resource'
2021-07-29T15:00:05.526+01:00|main|| liquibase.changelog - Data loaded from 'changelog/db/changes/data/yang_resource.csv' into table 'yang_resource'
2021-07-29 15:00:05.529 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/03-loadData-schema-set.yaml::3.2::cps ran successfully in 147ms
2021-07-29T15:00:05.529+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/03-loadData-schema-set.yaml::3.2::cps ran successfully in 147ms
2021-07-29 15:00:05.598 INFO 9836 --- [ main] liquibase.changelog : Data loaded from 'changelog/db/changes/data/schema_set_yang_resources.csv' into table 'schema_set_yang_resources'
2021-07-29T15:00:05.598+01:00|main|| liquibase.changelog - Data loaded from 'changelog/db/changes/data/schema_set_yang_resources.csv' into table 'schema_set_yang_resources'
2021-07-29 15:00:05.601 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/03-loadData-schema-set.yaml::3.3::cps ran successfully in 63ms
2021-07-29T15:00:05.601+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/03-loadData-schema-set.yaml::3.3::cps ran successfully in 63ms
2021-07-29 15:00:05.641 INFO 9836 --- [ main] liquibase.changelog : Data loaded from 'changelog/db/changes/data/anchor.csv' into table 'anchor'
2021-07-29T15:00:05.641+01:00|main|| liquibase.changelog - Data loaded from 'changelog/db/changes/data/anchor.csv' into table 'anchor'
2021-07-29 15:00:05.644 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/04-loadData-anchor.yaml::4::cps ran successfully in 32ms
2021-07-29T15:00:05.644+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/04-loadData-anchor.yaml::4::cps ran successfully in 32ms
2021-07-29 15:00:06.282 INFO 9836 --- [ main] liquibase.changelog : Data loaded from 'changelog/db/changes/data/fragment.csv' into table 'fragment'
2021-07-29T15:00:06.282+01:00|main|| liquibase.changelog - Data loaded from 'changelog/db/changes/data/fragment.csv' into table 'fragment'
2021-07-29 15:00:06.285 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/05-loadData-fragment.yaml::5::cps ran successfully in 635ms
2021-07-29T15:00:06.285+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/05-loadData-fragment.yaml::5::cps ran successfully in 635ms
2021-07-29 15:00:06.318 INFO 9836 --- [ main] liquibase.changelog : Custom SQL executed
2021-07-29T15:00:06.318+01:00|main|| liquibase.changelog - Custom SQL executed
2021-07-29 15:00:06.321 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/05-loadData-fragment.yaml::5.1::cps ran successfully in 29ms
2021-07-29T15:00:06.321+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/05-loadData-fragment.yaml::5.1::cps ran successfully in 29ms
2021-07-29 15:00:06.333 INFO 9836 --- [ main] liquibase.changelog : Index UQ_FRAGMENT_XPATH dropped from table fragment
2021-07-29T15:00:06.333+01:00|main|| liquibase.changelog - Index UQ_FRAGMENT_XPATH dropped from table fragment
2021-07-29 15:00:06.336 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/06-delete-not-required-fragment-index.yaml::6::cps ran successfully in 9ms
2021-07-29T15:00:06.336+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/06-delete-not-required-fragment-index.yaml::6::cps ran successfully in 9ms
2021-07-29 15:00:06.350 INFO 9836 --- [ main] liquibase.changelog : Data updated in yang_resource
2021-07-29T15:00:06.350+01:00|main|| liquibase.changelog - Data updated in yang_resource
2021-07-29 15:00:06.353 INFO 9836 --- [ main] liquibase.changelog : Data updated in yang_resource
2021-07-29T15:00:06.353+01:00|main|| liquibase.changelog - Data updated in yang_resource
2021-07-29 15:00:06.356 INFO 9836 --- [ main] liquibase.changelog : Data updated in yang_resource
2021-07-29T15:00:06.356+01:00|main|| liquibase.changelog - Data updated in yang_resource
2021-07-29 15:00:06.359 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/07-update-yang-resource-checksums.yaml::7::cps ran successfully in 16ms
2021-07-29T15:00:06.359+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/07-update-yang-resource-checksums.yaml::7::cps ran successfully in 16ms
2021-07-29 15:00:06.425 INFO 9836 --- [ main] liquibase.changelog : SQL in file changelog/db/changes/08-update-yang-resources-cps-ran-model-forward.sql executed
2021-07-29T15:00:06.425+01:00|main|| liquibase.changelog - SQL in file changelog/db/changes/08-update-yang-resources-cps-ran-model-forward.sql executed
2021-07-29 15:00:06.449 INFO 9836 --- [ main] liquibase.changelog : SQL in file changelog/db/changes/08-update-yang-resources-ietf-yang-types-forward.sql executed
2021-07-29T15:00:06.449+01:00|main|| liquibase.changelog - SQL in file changelog/db/changes/08-update-yang-resources-ietf-yang-types-forward.sql executed
2021-07-29 15:00:06.469 INFO 9836 --- [ main] liquibase.changelog : SQL in file changelog/db/changes/08-update-yang-resources-ietf-inet-types-forward.sql executed
2021-07-29T15:00:06.469+01:00|main|| liquibase.changelog - SQL in file changelog/db/changes/08-update-yang-resources-ietf-inet-types-forward.sql executed
2021-07-29 15:00:06.471 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/08-update-yang-resources.yaml::8::cps ran successfully in 104ms
2021-07-29T15:00:06.471+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/08-update-yang-resources.yaml::8::cps ran successfully in 104ms
2021-07-29 15:00:06.505 INFO 9836 --- [ main] liquibase.changelog : Data loaded from 'changelog/db/changes/data/dmi/dataspace.csv' into table 'dataspace'
2021-07-29T15:00:06.505+01:00|main|| liquibase.changelog - Data loaded from 'changelog/db/changes/data/dmi/dataspace.csv' into table 'dataspace'
2021-07-29 15:00:06.507 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/09-loadData-dmi-registry-schema-set.yaml::9::cps ran successfully in 30ms
2021-07-29T15:00:06.507+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/09-loadData-dmi-registry-schema-set.yaml::9::cps ran successfully in 30ms
2021-07-29 15:00:06.547 INFO 9836 --- [ main] liquibase.changelog : Data loaded from 'changelog/db/changes/data/dmi/schema_set.csv' into table 'schema_set'
2021-07-29T15:00:06.547+01:00|main|| liquibase.changelog - Data loaded from 'changelog/db/changes/data/dmi/schema_set.csv' into table 'schema_set'
2021-07-29 15:00:06.552 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/09-loadData-dmi-registry-schema-set.yaml::9.1::cps ran successfully in 37ms
2021-07-29T15:00:06.552+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/09-loadData-dmi-registry-schema-set.yaml::9.1::cps ran successfully in 37ms
2021-07-29 15:00:06.583 INFO 9836 --- [ main] liquibase.changelog : Data loaded from 'changelog/db/changes/data/dmi/yang_resource.csv' into table 'yang_resource'
2021-07-29T15:00:06.583+01:00|main|| liquibase.changelog - Data loaded from 'changelog/db/changes/data/dmi/yang_resource.csv' into table 'yang_resource'
2021-07-29 15:00:06.587 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/09-loadData-dmi-registry-schema-set.yaml::9.2::cps ran successfully in 22ms
2021-07-29T15:00:06.587+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/09-loadData-dmi-registry-schema-set.yaml::9.2::cps ran successfully in 22ms
2021-07-29 15:00:06.621 INFO 9836 --- [ main] liquibase.changelog : Data loaded from 'changelog/db/changes/data/dmi/schema_set_yang_resources.csv' into table 'schema_set_yang_resources'
2021-07-29T15:00:06.621+01:00|main|| liquibase.changelog - Data loaded from 'changelog/db/changes/data/dmi/schema_set_yang_resources.csv' into table 'schema_set_yang_resources'
2021-07-29 15:00:06.624 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/09-loadData-dmi-registry-schema-set.yaml::9.3::cps ran successfully in 30ms
2021-07-29T15:00:06.624+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/09-loadData-dmi-registry-schema-set.yaml::9.3::cps ran successfully in 30ms
2021-07-29 15:00:06.674 INFO 9836 --- [ main] liquibase.changelog : Data loaded from 'changelog/db/changes/data/dmi/anchor.csv' into table 'anchor'
2021-07-29T15:00:06.674+01:00|main|| liquibase.changelog - Data loaded from 'changelog/db/changes/data/dmi/anchor.csv' into table 'anchor'
2021-07-29 15:00:06.677 INFO 9836 --- [ main] liquibase.changelog : ChangeSet changelog/db/changes/09-loadData-dmi-registry-schema-set.yaml::9.4::cps ran successfully in 42ms
2021-07-29T15:00:06.677+01:00|main|| liquibase.changelog - ChangeSet changelog/db/changes/09-loadData-dmi-registry-schema-set.yaml::9.4::cps ran successfully in 42ms
2021-07-29 15:00:06.694 INFO 9836 --- [ main] liquibase.lockservice : Successfully released change log lock
2021-07-29T15:00:06.694+01:00|main|| liquibase.lockservice - Successfully released change log lock
|
Point #2
- Clone liquibase code from GitHub: https://github.com/liquibase/liquibase
- Create new module in CPS (e.g. cps-liquibase)
- Add necessary code to new module
- Build liquibase with CPS & ensure DB steps are carried out
...
user-4e793 will investigate this.
Conclusions
...
Point #1 has been tested and is working as expected.