-
Notifications
You must be signed in to change notification settings - Fork 77
Expand file tree
/
Copy pathtestLargeColumnList.java
More file actions
27 lines (20 loc) · 1.04 KB
/
Copy pathtestLargeColumnList.java
File metadata and controls
27 lines (20 loc) · 1.04 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
package common;
import gudusoft.gsqlparser.EDbVendor;
import gudusoft.gsqlparser.TBaseType;
import gudusoft.gsqlparser.TGSqlParser;
import gudusoft.gsqlparser.nodes.TResultColumn;
import gudusoft.gsqlparser.stmt.TSelectSqlStatement;
import junit.framework.TestCase;
public class testLargeColumnList extends TestCase {
public static void test1(){
TGSqlParser sqlParser = new TGSqlParser(EDbVendor.dbvredshift);
sqlParser.sqlfilename = gspCommon.BASE_SQL_DIR_PRIVATE_JAVA+"redshift/syngenta/large-column-list.sql";
sqlParser.parse();
TSelectSqlStatement select = (TSelectSqlStatement)sqlParser.sqlstatements.get(0);
StringBuilder b = new StringBuilder();
for(TResultColumn rc : select.getResultColumnList()){
b.append(rc.getDisplayName()+"\t->\t"+rc.getExpr().getObjectOperand().getSourceColumn().getDisplayName()+TBaseType.windowsLinebreak);
}
assertTrue(TBaseType.compareStringBuilderToFile(b,gspCommon.BASE_SQL_DIR_PRIVATE_JAVA+"redshift/syngenta/large-column-list.txt"));
}
}