Groovy Integration with Ant

Recently I come across a requirement to execute few SQL statements during the build process. Initially we thought of executing a shell/perl script to perform the job. Then we explored the power of dynamic JVM based scripting languages.. and here comes Groovy.

It jells with Ant very well and very good support for SQL operations, including executing a stored procedures. Adding groovy to your project is very simple and straight forward. Also, since groovy is much similar to java, literally there is no learning curve.

Check out the simplified and start grooving for your petty project needs....

<project name="GroovyBuild" basedir="." default="testGroovy">

<property name="jdbc.url" value="jdbc:oracle:thin:@yourdb"/>

<property name="jdbc.username" value="username"/>

<property name="jdbc.password" value="pass"/>

<path id="groovypath">

<pathelement location="C:\lib\groovy-all-1.8.0.jar"/>

<pathelement location="C:\lib\ojdbc14.jar"/>

</path>

<path id="groovypath">...</path>

<taskdef name="groovy" classname="org.codehaus.groovy.ant.Groovy" classpathref="groovypath"/>

<target name="setupDB">

<echo message="Test Groovy Started.."/>

<groovy>

import groovy.sql.Sql
def jdbcUrl = "${properties['jdbc.url']}"
def user = "${properties['jdbc.username']}"
def password = "${properties['jdbc.password']}"

def sql = Sql.newInstance("${jdbcUrl}","${user}","${password}","oracle.jdbc.driver.OracleDriver")

project.addReference("groovy.sqlinstance", sql)

</groovy>

<groovy>...</groovy>

</target>

<target name="setupDB">...</target>

<macrodef name="read">

<sequential>

<groovy>

def sql = project.getReference("groovy.sqlinstance")
println "TestName - Updatetime"
sql.eachRow("select testname,to_char(updatetime) as updatetime from groovy_test order by updatetime") {
println "${it.testname} - ${it.updatetime}"
}

</groovy>

<groovy>...</groovy>

</sequential>

<sequential>...</sequential>

</macrodef>

<macrodef name="read">...</macrodef>

<macrodef name="add">

<sequential>

<groovy>

def name = 'test3'
def sql = project.getReference("groovy.sqlinstance")
try {
sql.execute("insert into groovy_test(testname,updatetime) values(${name},sysdate)")
} catch(Exception e){}

</groovy>

<groovy>...</groovy>

</sequential>

<sequential>...</sequential>

</macrodef>

<macrodef name="add">...</macrodef>

<macrodef name="update">

<sequential>

<groovy>

def sql = project.getReference("groovy.sqlinstance")
try {
sql.execute("update groovy_test set updatetime = sysdate+1 where testname='test1'")
} catch(Exception e){}

</groovy>

<groovy>...</groovy>

</sequential>

<sequential>...</sequential>

</macrodef>

<macrodef name="update">...</macrodef>

<target name="testGroovy" depends="setupDB">

<add/>

<update/>

<read/>

<echo message="Test Groovy Completed successfully.."/>

</target>

<target name="testGroovy" depends="setupDB">...</target>

</project>

<project name="GroovyBuild" basedir="." default="testGroovy">...</project>