[
http://jira.codehaus.org/browse/MSQL-28?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=153490#action_153490
]
chandanbenjaram edited comment on MSQL-28 at 11/7/08 9:13 PM:
---------------------------------------------------------------
Sorry. I was little bit busy this week.
By the way, my simple use case is something like this:
1-create db schema and dump test data into database in mvn test resources phase.
(Schema is in a simple '.sql/.ddl' type file which was generated by hbm2ddl
engine)
2-tests suite runs on this dummy data (may change db state in case of committed
Transactions)
(test data can be either in '.sql or .xml' file)
3-after all tests run successfully, I am looking to clear db and dump post-test
content.
(data would be in '.xml' file)
I tried to use Maven-DBUnit plug-in to load content from several '.sql'
resource files in same phase, but didn't quite worked for me (not persisting
data to database after all tests are ran :-().
As a get around to this, I am currently using Maven-SQL for executing '.sql'
resource files and 'Maven-DBUnit' to load XML content.
Any suggestion or comments on this approach?
-Chandan Benjaram
was (Author: chandanbenjaram):
Sorry. I was little bit busy this week.
By the way, my simple use case is something like this:
1-create db schema and dump test data into database in mvn test resources phase.
(Schema is in a simple '.sql/.ddl' type file which was generated by hbm2ddl
engine)
2-tests suite runs on this dummy data (may change db state in case of committed
Transactions)
(test data can be either in '.sql or .xml' file)
3-after all tests run successfully, I am looking to clear db and dump post-test
content.
(data would be in '.xml' file)
I tried to use Maven-DBUnit plug-in, but it to load content from several '.sql'
resource files in same phase.
As a get around to this, I am currently using Maven-SQL for executing '.sql'
resource files and 'Maven-DBUnit' to load XML content.
Any suggestion or comments on this approach?
-Chandan Benjaram
> Maven 2.x SQL Plugin- plugin should have capabilitties to load SQL scripts
> from XML(which has SQL scripts embeded in it) files.
> -------------------------------------------------------------------------------------------------------------------------------
>
> Key: MSQL-28
> URL: http://jira.codehaus.org/browse/MSQL-28
> Project: Maven 2.x SQL Plugin
> Issue Type: New Feature
> Environment: Platform independent.
> Reporter: Chandan Benjaram
>
> Hi,
> I am looking for a feature in Maven 2.x SQL Plugin, which should trigger SQL
> scripts written in an XML files. Please do let me know, what do you think of
> this feature request. And should you need any task for me! please feel free
> to shoot and email to my registered email id.
> -Chandan Benjaram
--
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
