SQLUnit XSL Transform Tool

If your SQL or stored procedures that you want to test are already available in an XML format, if you were using a ORM framework such as iBATIS SQLMaps, for instance, then you can use this tool to transform the information into a form suitable for SQLUnit to consume. The Transform Tool is a simple XSLT parser. You will need to supply the appropriate XSL file containing the required transformation.

The W3Schools page on XSLT is quite comprehensive and is useful as a reference or tutorial if you need pointers on how to get started using XSLT.

A sample run of using the TransformTool from within ant is shown below:

$ ant transform -Dtransform.input=inputfile.xml \
    -Dtransform.transform=xsltfile.xsl \
    -Dtransform.output=sqlunitfile.xml

Buildfile: build.xml
 
init:
  
precompile:
   
compile:
    [javac] Compiling 10 source files to /home/sujit/src/sqlunit/build
    [javac] Compiling 1 source file to /home/sujit/src/sqlunit/build
            
transform:
    [java] SQLUnit Transform Tool
    [java] Copyright(c) 2005, The SQLUnit Team

BUILD SUCCESSFUL
Total time: 5 seconds

The various files that drove the development of this tool can be found here:

• Input XML file

• XSL Transform file