Marcus Christie created AIRAVATA-3326:
-----------------------------------------
Summary: Improved database migration script creation
Key: AIRAVATA-3326
URL: https://issues.apache.org/jira/browse/AIRAVATA-3326
Project: Airavata
Issue Type: New Feature
Components: Registry API
Reporter: Marcus Christie
Assignee: Marcus Christie
Improve automatic generation of database migration scripts. Work on this was
started in AIRAVATA-3126. In that issue the OpenJPA MappingTool was integrated
to run and generate a migration script whenever the schema validation fails.
Continuing on that work, I'd like to
- create a migration script generation tool (MappingTool) that can be run
directly from the command line
- integrate starting a MariaDB, perhaps via docker-compose, and run MappingTool
against that to generate the mysql scripts
- finish the documentation on how to take the generated scripts and integrate
them in the various places in the code base where they belong
- change ide-migration docker-compose database server to mariadb. MariaDB has
some good additions to mysql for creating migration scripts that can be
re-runnable (e.g., {{IF NOT EXISTS}}).
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
