-
Notifications
You must be signed in to change notification settings - Fork 77
Expand file tree
/
Copy pathtestIIF.java
More file actions
33 lines (26 loc) · 1.09 KB
/
Copy pathtestIIF.java
File metadata and controls
33 lines (26 loc) · 1.09 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
package mdx;
import gudusoft.gsqlparser.EDbVendor;
import gudusoft.gsqlparser.TGSqlParser;
import gudusoft.gsqlparser.nodes.mdx.*;
import gudusoft.gsqlparser.stmt.mdx.TMdxSelect;
import junit.framework.TestCase;
public class testIIF extends TestCase {
public void test1() {
TGSqlParser sqlparser = new TGSqlParser(EDbVendor.dbvmdx);
sqlparser.sqltext = "select \n" +
"iif([Measures].[Orders Count]<>0, \n" +
" [Measures].[Unit Price BAD],\n" +
" 0) on 1\n" +
"from t";
int i = sqlparser.parse();
assertTrue( i== 0);
TMdxSelect select = (TMdxSelect)sqlparser.sqlstatements.get(0);
TMdxAxisNode axisNode = select.getAxes().getElement(0);
TMdxFunctionNode functionNode = (TMdxFunctionNode)axisNode.getExpNode();
assertTrue(functionNode.getArguments().size() == 3);
for(int j=0;j<functionNode.getArguments().size();j++){
TMdxExpNode expNode = functionNode.getArguments().getElement(j);
// System.out.println(expNode.toString());
}
}
}