-
Notifications
You must be signed in to change notification settings - Fork 77
Expand file tree
/
Copy pathtestCall.java
More file actions
42 lines (36 loc) · 2.11 KB
/
Copy pathtestCall.java
File metadata and controls
42 lines (36 loc) · 2.11 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
33
34
35
36
37
38
39
40
41
42
package common;
import gudusoft.gsqlparser.EDbVendor;
import gudusoft.gsqlparser.ESqlStatementType;
import gudusoft.gsqlparser.TGSqlParser;
import gudusoft.gsqlparser.nodes.TTable;
import gudusoft.gsqlparser.sqlenv.ESQLDataObjectType;
import gudusoft.gsqlparser.sqlenv.TSQLEnv;
import gudusoft.gsqlparser.stmt.TCallStatement;
import gudusoft.gsqlparser.stmt.TSelectSqlStatement;
import junit.framework.TestCase;
public class testCall extends TestCase {
public void test1(){
TGSqlParser sqlparser = new TGSqlParser(EDbVendor.dbvnetezza);
sqlparser.sqltext = "CALL DB_NAME.SCHEMA_NAME.PROC_NAME();";
assertTrue(sqlparser.parse() == 0);
assertTrue(sqlparser.sqlstatements.get(0).sqlstatementtype == ESqlStatementType.sstcall);
TCallStatement callStatement = (TCallStatement)sqlparser.sqlstatements.get(0);
//System.out.println(callStatement.getRoutineName().toString());
assertTrue(callStatement.getRoutineName().getDatabaseString().equalsIgnoreCase("DB_NAME"));
assertTrue(callStatement.getRoutineName().getSchemaString().equalsIgnoreCase("SCHEMA_NAME"));
assertTrue(callStatement.getRoutineName().getObjectString().equalsIgnoreCase("PROC_NAME"));
}
public void testTeradata(){
TGSqlParser sqlparser = new TGSqlParser(EDbVendor.dbvteradata);
// there is only database or schema name in teradata, they can't appear both.
// so, this testcase seems invalid.
sqlparser.sqltext = "CALL DB_NAME.SCHEMA_NAME.PROC_NAME();";
assertTrue(sqlparser.parse() == 0);
assertTrue(sqlparser.sqlstatements.get(0).sqlstatementtype == ESqlStatementType.sstcall);
TCallStatement callStatement = (TCallStatement)sqlparser.sqlstatements.get(0);
// //System.out.println(callStatement.getRoutineName().toString());
// assertTrue(callStatement.getRoutineName().getDatabaseString().equalsIgnoreCase("DB_NAME"));
// assertTrue(callStatement.getRoutineName().getSchemaString().equalsIgnoreCase("SCHEMA_NAME"));
// assertTrue(callStatement.getRoutineName().getObjectString().equalsIgnoreCase("PROC_NAME"));
}
}