ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bailey, Darragh" <dbai...@hp.com>
Subject RE: How to script database upgrade using ANT script
Date Fri, 05 Nov 2010 10:47:44 GMT
 

> -----Original Message-----
> From: Java Jboss [mailto:apacheant@hotmail.co.uk] 
> Sent: 04 November 2010 22:43
> To: user@ant.apache.org
> Subject: RE: How to script database upgrade using ANT script
> 
> 
> 
> Hi Antoine, 
> 
> Thank you very much for providing me this example. 
> unfortunately I've been asked to use ANT only without using 
> unix shell scripts.  I have tried to tackle it as individual 
> modules using ANT script  running the 1st iteration of the 
> mysql scripts against newschema1.  I need to run each 
> iteration against all 4 schemas, then it would do a version 
> check and if version check wasn't met then it would start 2nd 
> iteration and so on. 
> 
> I would appreciate if you could take a look at the script and 
> assist. I need to create a recursive loop which I can't do 
> and also some error checking module as well as some how 
> linking these modules together so that they depend on each 
> other etc... At the moment I have to run each target on its own.
>  
> Please feel free to change my novice attempt at writing an ANT script.
>  
> Thank you
>  
> <!-- ***************************************
>   Restore MySQL database 
>   **************************************** -->  
> <target name="restore-db" >
>     <!-- Clean up the database by deleting and then creating it. -->
>     <antcall target="delete_db"/>
>     <antcall target="create_db"/>
> <!-- Import data from the backup file. -->
>     <exec executable="${my.sql}" input="db_dumps/db1.sql">
>       <arg value="--user=root"/>
>       <arg value="--password=<password>"/>
>       <arg value="--host=localhost" />   
>       <arg value="--port=3306" />   
>       <arg value="<newschema1>"/>

Take a look at the apply task to see if you can remove a number of mostly duplicated steps.


--
Regards,
Darragh Bailey

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org


Mime
View raw message