Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Jira Legacy
serverSystem Jira
columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId4733707d-2057-3a0f-ae5e-4fd8aff50176
keyPOLICY-1787


Move table creation into the upgrade/downgrade/install scripts in order to support upgrade/rollback of ONAP releases.

Liquibase may be the required solution.

Policy database DDL can be exported from MariaDB to a file using HeidiSQL.

MariaDB and Postgres(8.2+) work with Liquibase, Cassandra requires an extension.

It can also be used with Hibernate.

Testing

Liquibase changeLog Testing

Liquibase Docker Testing

Liquibase Docker Compose Testing

Notes

We can either integrate Liquibase as part of our application code (Spring boot/Hibernate is the easiest option) or as part of our CI/CD pipeline.

Need to address the table-creation JPA errors currently appearing in the logs