-
Notifications
You must be signed in to change notification settings - Fork 77
Expand file tree
/
Copy pathtestDeclareCursor.java
More file actions
29 lines (23 loc) · 991 Bytes
/
Copy pathtestDeclareCursor.java
File metadata and controls
29 lines (23 loc) · 991 Bytes
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
package mssql;
/*
* Date: 12-3-12
*/
import gudusoft.gsqlparser.EDbVendor;
import gudusoft.gsqlparser.TGSqlParser;
import gudusoft.gsqlparser.stmt.mssql.TMssqlDeclare;
import junit.framework.TestCase;
public class testDeclareCursor extends TestCase {
public void test1(){
TGSqlParser sqlparser = new TGSqlParser(EDbVendor.dbvmssql);
sqlparser.sqltext = " declare sds_post_asset_identifier cursor for\n" +
" select distinct\n" +
" asset_id \n" +
" , asset_name_1 \n" +
" \tfrom asd_wk_asset_identifier\n" +
" where last_mod_tmstmp < @source_start_time\n" +
"\torder by asset_id, last_mod_tmstmp";
assertTrue(sqlparser.parse() == 0);
TMssqlDeclare declare = (TMssqlDeclare)sqlparser.sqlstatements.get(0);
assertTrue(declare.getCursorName().toString().equalsIgnoreCase("sds_post_asset_identifier"));
}
}