/**
* @param type
* @param fileName
* @return
* @throws BirtException
*/
private DataEngineContext newContext(int type, String fileName) throws BirtException {
switch (type) {
case DataEngineContext.MODE_GENERATION:
{
try {
archiveWriter = new FileArchiveWriter(fileName);
archiveWriter.initialize();
} catch (IOException e) {
throw new IllegalArgumentException(e.getMessage());
}
return DataEngineContext.newInstance(
DataEngineContext.MODE_GENERATION, null, null, archiveWriter);
}
case DataEngineContext.MODE_PRESENTATION:
{
try {
archiveReader = new FileArchiveReader(fileName);
archiveReader.open();
} catch (IOException e) {
throw new IllegalArgumentException(e.getMessage());
}
return DataEngineContext.newInstance(
DataEngineContext.MODE_PRESENTATION, null, archiveReader, null);
}
default:
throw new IllegalArgumentException("" + type);
}
}
/**
* @param name
* @param dataType
* @param se
* @throws BirtException
*/
private void basicTestNoDataSet(String[] name, int[] dataType, ScriptExpression[] se)
throws BirtException {
DataEngine dataEngine =
new DataEngineImpl(
DataEngineContext.newInstance(DataEngineContext.DIRECT_PRESENTATION, null, null, null));
QueryDefinition queryDefn = new QueryDefinition();
for (int i = 0; i < name.length; i++) queryDefn.addBinding(new Binding(name[i], se[i]));
IResultIterator ri = dataEngine.prepare(queryDefn).execute(null).getResultIterator();
if (ri.next()) {
String str = "";
for (int i = 0; i < name.length; i++) {
Object value = ri.getValue(name[i]);
str += value;
if (i < name.length - 1) str += ", ";
if (dataType[i] == DataType.INTEGER_TYPE)
assertTrue(value.getClass().equals(Integer.class));
else if (dataType[i] == DataType.DOUBLE_TYPE)
assertTrue(value.getClass().equals(Double.class));
else if (dataType[i] == DataType.DATE_TYPE) assertTrue(value.getClass().equals(Date.class));
}
testPrintln(str);
}
}
/*
* @see junit.framework.TestCase#setUp()
*/
@Before
public void mirrorCursorModelSetUp() throws Exception {
this.scope = new ImporterTopLevel();
DataEngineContext context =
DataEngineContext.newInstance(DataEngineContext.DIRECT_PRESENTATION, scope, null, null);
context.setTmpdir(this.getTempDir());
de = (DataEngineImpl) DataEngine.newDataEngine(context);
this.creator = new CubeUtility();
creator.createCube(de);
creator.createCube1(de);
cube1 = creator.getCube(CubeUtility.cubeName, de);
cube2 = creator.getCube(CubeUtility.timeCube, de);
}
/** @throws Exception */
@Test
public void testNoDataSetWithSubQuery() throws Exception {
// outer query without data set
int[] dataType = new int[] {DataType.DATE_TYPE};
String[] name = new String[] {"testColumn1"};
IResultIterator ri2 = null;
{
ScriptExpression[] se =
new ScriptExpression[] {
new ScriptExpression("new Date()", dataType[0]),
};
QueryDefinition queryDefn = new QueryDefinition();
for (int i = 0; i < name.length; i++) queryDefn.addBinding(new Binding(name[i], se[i]));
// sub query
String subQueryName = "TEST";
SubqueryDefinition subQueryDefn = new SubqueryDefinition(subQueryName, queryDefn);
for (int i = 0; i < name.length; i++)
subQueryDefn.addBinding(
new Binding(name[i], new ScriptExpression("row._outer." + name[i], dataType[i])));
queryDefn.addSubquery(subQueryDefn);
DataEngine myDataEngine =
new DataEngineImpl(
DataEngineContext.newInstance(
DataEngineContext.DIRECT_PRESENTATION, null, null, null));
IResultIterator ri = myDataEngine.prepare(queryDefn).execute(null).getResultIterator();
ri.next();
ri2 = ri.getSecondaryIterator(subQueryName, null);
}
if (ri2.next()) {
String str = "";
for (int i = 0; i < name.length; i++) {
Object value = ri2.getValue(name[i]);
str += value;
if (i < name.length - 1) str += ", ";
if (dataType[0] == DataType.DATE_TYPE) assertTrue(value.getClass().equals(Date.class));
}
testPrintln(str);
}
ri2.close();
}
/** @throws Exception */
@Test
public void testNoDataSetWithNestedQuery() throws Exception {
// outer query without data set
String[] name = new String[] {"testColumn1"};
IQueryResults queryResult = null;
{
int[] dataType = new int[] {DataType.DATE_TYPE};
ScriptExpression[] se =
new ScriptExpression[] {
new ScriptExpression("new Date()", dataType[0]),
};
DataEngine myDataEngine =
new DataEngineImpl(
DataEngineContext.newInstance(
DataEngineContext.DIRECT_PRESENTATION, null, null, null));
QueryDefinition queryDefn = new QueryDefinition();
for (int i = 0; i < name.length; i++) queryDefn.addBinding(new Binding(name[i], se[i]));
IResultIterator ri = myDataEngine.prepare(queryDefn).execute(null).getResultIterator();
queryResult = ri.getQueryResults();
}
// inner query with data set
QueryDefinition queryDefn2 = this.newReportQuery();
for (int i = 0; i < name.length; i++)
queryDefn2.addBinding(new Binding(name[i], new ScriptExpression("row._outer." + name[i])));
IResultIterator ri2 =
this.dataEngine.prepare(queryDefn2).execute(queryResult, null).getResultIterator();
if (ri2.next()) {
String str = "";
for (int i = 0; i < name.length; i++) {
Object value = ri2.getValue(name[i]);
str += value;
if (i < name.length - 1) str += ", ";
}
testPrintln(str);
}
ri2.close();
}