*/
public class BreakdownTest {
@Test
public void testBreakdownReport() throws Exception {
TestDatabase testDatabase = new TestDatabase();
testDatabase.setUpDatabase();
Connection connection = testDatabase.getDs().getConnection();
try {
connection.createStatement().executeUpdate("drop table month_batch;");
} catch (SQLException e) {
//ignore
}
try {
connection.createStatement().executeUpdate("drop table sold_item;");
} catch (SQLException e) {
//ignore
}
connection.createStatement().executeUpdate("create table month_batch (month varchar);");
connection.createStatement().executeUpdate("create table sold_item (month varchar, name varchar, price decimal);");
connection.createStatement().executeUpdate("insert into month_batch values('Jan');");
connection.createStatement().executeUpdate("insert into month_batch values('Feb');");
connection.createStatement().executeUpdate("insert into month_batch values('March');");
connection.createStatement().executeUpdate("insert into sold_item values('Jan', 'Apple', 100);");
connection.createStatement().executeUpdate("insert into sold_item values('Jan', 'Cucumber', 200);");
connection.createStatement().executeUpdate("insert into sold_item values('Jan', 'Tomato', 300);");
connection.createStatement().executeUpdate("insert into sold_item values('Feb', 'Apple', 200);");
connection.createStatement().executeUpdate("insert into sold_item values('Feb', 'Cucumber', 200);");
connection.createStatement().executeUpdate("insert into sold_item values('March', 'Tomato', 500);");
connection.commit();
Report report = new DefaultXmlReader().parseXml(FileUtils.readFileToString(new File("./modules/core/test/sample/financedetails/breakdown.xml")));
System.out.println();
Reporting reporting = new Reporting();
reporting.setFormatterFactory(new DefaultFormatterFactory());
reporting.setLoaderFactory(new DefaultLoaderFactory()
.setGroovyDataLoader(new GroovyDataLoader(new DefaultScriptingImpl()))
.setSqlDataLoader(new SqlDataLoader(testDatabase.getDs())));
ReportOutputDocument reportOutputDocument = reporting.runReport(new RunParams(report), new FileOutputStream("./result/sample/breakdown.xls"));
testDatabase.stop();
}