Page Comparison

...
Table of Contents
Purpose of spike

...
Because of license issues with Liquibase core we need to investigate building liquibase-core from open source Apacahe-2.0 sources ourselves.
see also this mail snippet from Steve Winslow:
"At the community discussion form post that I linked to below, https://forum.liquibase.org/t/licensing-questions-for-community-distro/5617/3, someone from the Liquibase team (I believe one of the primary authors) responded to my question there. They indicated that the built components they offer do contain both Apache-2.0 and proprietary code, and didn't appear to indicate that they could be redistributed due to the presence of the latter. Because of this, they indicated that if ONAP wants to have an open source / Apache-2.0 only version, we would need to build it from the Liquibase Apache-2.0 sources ourselves."Liquibase base code can be found on
Assumptions

...
#	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 Added
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
Point #1

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

...
Open Issues & Decisions

...
#
...
Question
...
Answer
...
Clone liquibase code from GitHub: https://github.com/liquibase/liquibase
Assumptions

...
#
...
Assumption
...
Notes
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) will investigate this.
Conclusions

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

Old Version 2

New Version Current

Key

Purpose of spike

Assumptions

Open Issues & Decisions

Approaches

Point #1

Point #2

Open Issues & Decisions

Assumptions

Point #3

Point #4

Conclusions
