[
http://jira.codehaus.org/browse/MOJO-643?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jay Dolan updated MOJO-643:
---------------------------
Attachment: sql-maven-plugin_token-replacement.diff
I ran into this same limitation. Attached is a patch which adds $token
replacement in all SQL statements this plugin will execute. You should then
pass the plugin tokens (as properties) in your pom:
<plugin>
<groupId>org.codehaus.mojo</groupId>
<artifactId>sql-maven-plugin</artifactId>
<version>1.0-optaros-1</version>
<configuration>
<username>${sql.admin.username}</username>
<password>${sql.admin.password}</password>
<url>${sql.admin.url}</url>
<driver>${sql.admin.driver}</driver>
<autocommit>true</autocommit>
<srcFiles>
<srcFile>${sql.create.script}</srcFile>
</srcFiles>
<tokens>
<sql.create.username>${sql.create.username}</sql.create.username>
<sql.create.password>${sql.create.password}</sql.create.password>
<sql.create.resource>${sql.create.resource}</sql.create.resource>
</tokens>
</configuration>
</plugin>
Anything provided in the <tokens> map will be available for expansion as
$variables in your SQL, e.g.:
create user $sql.create.username with password $sql.create.password;
create database $sql.create.resource with owner $sql.create.username;
Hope this helps,
> Filtering of sqlFiles prior to execution
> ----------------------------------------
>
> Key: MOJO-643
> URL: http://jira.codehaus.org/browse/MOJO-643
> Project: Mojo
> Issue Type: New Feature
> Components: sql
> Reporter: Martin Gilday
> Attachments: sql-maven-plugin_token-replacement.diff
>
>
> Have the ability to have files defined in <sqlFiles> be interpolated with
> Maven and System properties. This would give similar functionality to the
> Maven WAR plugin's <webResources>. This is achieved there through the
> PropertyUtils
> http://svn.apache.org/viewvc/maven/plugins/trunk/maven-war-plugin/src/main/java/org/apache/maven/plugin/war/PropertyUtils.java?view=markup
--
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
