Tuesday, 9 April 2013

Exporting MySql tables to DBUnit FlatXmlDataSet format

This fragment of code allows export a table to the DBUnit Flat XML format
Class.forName("org.gjt.mm.mysql.Driver");
Connection jdbcConnection = DriverManager.getConnection("jdbc:mysql://localhost:3306/database_name?zeroDateTimeBehavior=convertToNull","user", "password");
IDatabaseConnection connection = new DatabaseConnection(jdbcConnection);
QueryDataSet partialDataSet = new QueryDataSet(connection);
partialDataSet.addTable("table_name");
FlatXmlDataSet.write(partialDataSet,new FileOutputStream("partial.xml"));