-
Notifications
You must be signed in to change notification settings - Fork 77
Expand file tree
/
Copy pathtestExecuteMacro.java
More file actions
44 lines (32 loc) · 1.97 KB
/
Copy pathtestExecuteMacro.java
File metadata and controls
44 lines (32 loc) · 1.97 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
43
44
package teradata;
import gudusoft.gsqlparser.EDbVendor;
import gudusoft.gsqlparser.EExpressionType;
import gudusoft.gsqlparser.TGSqlParser;
import gudusoft.gsqlparser.nodes.TExecParameter;
import gudusoft.gsqlparser.nodes.TExpression;
import gudusoft.gsqlparser.stmt.teradata.TTeradataExecute;
import junit.framework.TestCase;
public class testExecuteMacro extends TestCase {
public void test1(){
TGSqlParser sqlparser = new TGSqlParser(EDbVendor.dbvteradata);
sqlparser.sqltext = "EXEC add_log_info('1', CAST('2016-02-23' AS DATE FORMAT 'YYYY-MM-DD'), 'CAD_RK', 'Blad CAD_RK_P_K42', -1);";
assertTrue(sqlparser.parse() == 0);
TTeradataExecute execute = (TTeradataExecute)sqlparser.sqlstatements.get(0);
assertTrue(execute.getMacroName().toString().equalsIgnoreCase("add_log_info"));
assertTrue(execute.getParameters().size() == 5);
assertTrue(execute.getParameters().getExecParameter(0).getParameterValue().toString().equalsIgnoreCase("'1'"));
TExpression expr = execute.getParameters().getExecParameter(1).getParameterValue();
assertTrue(expr.getExpressionType() == EExpressionType.function_t);
assertTrue(expr.getFunctionCall().getFunctionName().toString().equalsIgnoreCase("CAST"));
}
public void test2(){
TGSqlParser sqlparser = new TGSqlParser(EDbVendor.dbvteradata);
sqlparser.sqltext = "EXECUTE new_hire (fl_name='Toby Smith', title='Programmer',doh=DATE -1);";
assertTrue(sqlparser.parse() == 0);
TTeradataExecute execute = (TTeradataExecute)sqlparser.sqlstatements.get(0);
assertTrue(execute.getMacroName().toString().equalsIgnoreCase("new_hire"));
TExecParameter parameter = execute.getParameters().getExecParameter(0);
assertTrue(parameter.getParameterName().toString().equalsIgnoreCase("fl_name"));
assertTrue(parameter.getParameterValue().toString().equalsIgnoreCase("'Toby Smith'"));
}
}