Page Comparison

...
#	Assumption	Notes
1
Open Issues & Decisions

...
#	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	Image Modified
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
title	Liquibase Console Ouput
collapse	true
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
Point #3

TBD
Point #4

Former user (Deleted)is investigating will investigate this.
Conclusions

...
Point #1 has been tested and is working as expected.
Versions Compared

Old Version 6

New Version Current

Key

Open Issues & Decisions

Approaches

Point #2

Point #3

Point #4

Conclusions
