[
https://issues.apache.org/jira/browse/AIRAVATA-3326?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Marcus Christie updated AIRAVATA-3326:
--------------------------------------
Description:
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}}).
- clean up remove generate-sql-persistence.xml and maven goal that used it
was:
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}}).
> 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
> Priority: Major
>
> 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}}).
> - clean up remove generate-sql-persistence.xml and maven goal that used it
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
