[
http://jira.codehaus.org/browse/MSQL-58?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=226092#action_226092
]
Robert Scholte commented on MSQL-58:
------------------------------------
Always good to see people trying to improve plugins and providing complete
patches. But in this case the requested improvement is out of scope. The
sql-m-p has one simple goal: provide an easy mechanism so that users can
execute their own sql on some database. Your proposal contains sql-statements
for a few databases. So what about the other databases? There's no way to make
i solid like this.
{quote}Not really happy with the mixed maven/sql ...{quote}
This seems to be your real problem. Did you try using the fileset-property,
combined with maven profiles? Filtering? There should be a better way to solve
this.
> add support for sql:clean goal
> ------------------------------
>
> Key: MSQL-58
> URL: http://jira.codehaus.org/browse/MSQL-58
> Project: Maven 2.x SQL Plugin
> Issue Type: New Feature
> Reporter: Johan Romme
> Attachments: sql-clean.diff
>
>
> For a long time I've been using a pl/sql script to clean an oracle database
> schema from it's meta information when preparing for a build. This script was
> launched using the sql-maven-plugin. Newer projects used other databases
> (ingres, sqlserver and mysql), so we created scripting to clean those
> databases/schemas also.
> Not really happy with the mixed maven/sql I started working on
> sql-maven-plugin to add a 'clean' goal, where the sql details are no longer
> needed in each project.
> Attached to the issue a patch (svn diff) containing the changes for this new
> feature.
> Please note that for many configurations this clean task can be replaced with
> a simple dropdb/createdb (or something similar for the dialect), but for most
> of our configurations this was not acceptable.
> Maybe, if others like this functionality, it can be added to the
> sql-maven-plugin.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe from this list, please visit:
http://xircles.codehaus.org/manage_email
