You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openjpa.apache.org by "Francesco Chicchiriccò (JIRA)" <ji...@apache.org> on 2017/01/03 07:33:58 UTC

[jira] [Updated] (OPENJPA-2581) openjpa-maven-plugin: drop and create schema regardless of the current database state

     [ https://issues.apache.org/jira/browse/OPENJPA-2581?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Francesco Chicchiriccò updated OPENJPA-2581:
--------------------------------------------
    Fix Version/s:     (was: 2.4.2)
                   2.4.3

> openjpa-maven-plugin: drop and create schema regardless of the current database state
> -------------------------------------------------------------------------------------
>
>                 Key: OPENJPA-2581
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-2581
>             Project: OpenJPA
>          Issue Type: Improvement
>          Components: tooling
>    Affects Versions: 2.3.0
>            Reporter: Stefan Reiterer
>            Assignee: Mark Struberg
>             Fix For: 2.4.3
>
>         Attachments: OPENJPA-2581_dropSchema_integrationtest.patch, drop_and_create_schema_regardless_of_the_current_database_state.patch
>
>
> openjpa:sql allows to create sql-scripts based on the project's jpa entities. The following sql actions are allowed:
> {noformat}
> add (see MappingTool#ACTION_ADD)
> refresh (see MappingTool#ACTION_REFRESH)
> drop (see MappingTool#ACTION_DROP)
> buildSchema (see MappingTool#ACTION_BUILD_SCHEMA)
> import (see MappingTool#ACTION_IMPORT)
> export (see MappingTool#ACTION_EXPORT)
> validate (see MappingTool#ACTION_VALIDATE)
> {noformat}
> We need an action which creates drop statements regardless if there is already an table/sequence/... with the same name in the database. The drop action currently removes columns from an existing table, if there is a table in the database with additional columns.
> We created a patch (see attachment) which adds an additional action (dropSchema). This action creates drop statements regardless of the current database state.
> Furthermore, buildSchema should create all create statements regardless of the current database state. JavaDoc of buildSchema:
> {noformat}/**
> * Re-execute all SQL used for the creation of the current database;
> * this action is usually used when creating SQL scripts.
> */{noformat}
> Currently buildSchema checks if a table already exists in the database and adds missing columns. (like the add action) The attached patch changes the current behavior of buildSchema so that it generates the schema regardless of the current database state.
> Best regards,
> Stefan



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)