// Clean Insert data
IDataSet dataSet = getDataSet("ExecuteNormal1.xls");
DatabaseOperation.CLEAN_INSERT.execute(connection, dataSet);
// Getting expected data ( ExecuteNormal2-Expected.xls )
IDataSet expected = getDataSet("ExecuteNormal2-Expected.xls");
ITable expectedTable = expected.getTable("ExpectedTable1.xls");
/**
* getting Dataset from .xls file.
*
* @param fileName Excel File Name
*
* @return Dataset for DBunit.
*/
private IDataSet getDataSet(String fileName){
IDataSet dataSet = null;
try {
dataSet = new XlsDataSet(this.getClass().getResourceAsStream(TESTDATA_PATH + fileName));
} catch (Throwable ex) {
ex.printStackTrace();
fail("getDataSet thrown exception : " + ex.getMessage());
}
return dataSet;
}
Thursday, January 17, 2008
Clean Insert with excel file
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment