protected void tearDown() throws Exception {
super.tearDown();
}
public void testDataSet() throws Exception {
SpagoBiDataSet dataSetConfig = new SpagoBiDataSet();
dataSetConfig.setQuery("SELECT fullname as 'Full Name' FROM CUSTOMER LIMIT 10");
SpagoBiDataSource dataSourceConfig = new SpagoBiDataSource();
dataSourceConfig.setDriver(TestCaseConstants.CONNECTION_DRIVER);
dataSourceConfig.setHibDialectClass(TestCaseConstants.CONNECTION_DIALECT);
dataSourceConfig.setHibDialectName(TestCaseConstants.CONNECTION_DIALECT);
dataSourceConfig.setMultiSchema(false);
dataSourceConfig.setUser(TestCaseConstants.CONNECTION_USER);
dataSourceConfig.setPassword(TestCaseConstants.CONNECTION_PWD);
dataSourceConfig.setUrl(TestCaseConstants.CONNECTION_URL);
dataSetConfig.setDataSource(dataSourceConfig);
IDataSet dataset = new JDBCDataSet(dataSetConfig);
dataset.loadData();
IDataStore dataStore1 = dataset.getDataStore();
JSONDataWriter dataWriter = new JSONDataWriter();