-
Notifications
You must be signed in to change notification settings - Fork 77
Expand file tree
/
Copy pathtestDropObject.java
More file actions
83 lines (53 loc) · 2.64 KB
/
Copy pathtestDropObject.java
File metadata and controls
83 lines (53 loc) · 2.64 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
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
package informix;
/*
* Date: 13-1-24
*/
import gudusoft.gsqlparser.EDbVendor;
import gudusoft.gsqlparser.TGSqlParser;
import gudusoft.gsqlparser.stmt.*;
import gudusoft.gsqlparser.stmt.informix.TInformixDropRowTypeStmt;
import junit.framework.TestCase;
public class testDropObject extends TestCase {
public void testRowType(){
TGSqlParser sqlparser = new TGSqlParser(EDbVendor.dbvinformix);
sqlparser.sqltext = "DROP ROW TYPE employee_t RESTRICT";
assertTrue(sqlparser.parse() == 0);
TInformixDropRowTypeStmt stmt = (TInformixDropRowTypeStmt)sqlparser.sqlstatements.get(0);
assertTrue(stmt.getRowTypeName().toString().equalsIgnoreCase("employee_t"));
}
public void testSequence(){
TGSqlParser sqlparser = new TGSqlParser(EDbVendor.dbvinformix);
sqlparser.sqltext = "DROP SEQUENCE Invoice_Numbers;";
assertTrue(sqlparser.parse() == 0);
TDropSequenceStmt stmt = (TDropSequenceStmt)sqlparser.sqlstatements.get(0);
assertTrue(stmt.getSequenceName().toString().equalsIgnoreCase("Invoice_Numbers"));
}
public void testSynonym(){
TGSqlParser sqlparser = new TGSqlParser(EDbVendor.dbvinformix);
sqlparser.sqltext = "DROP SYNONYM cathyg.nj_cust;";
assertTrue(sqlparser.parse() == 0);
TDropSynonymStmt stmt = (TDropSynonymStmt)sqlparser.sqlstatements.get(0);
assertTrue(stmt.getSynonymName().toString().equalsIgnoreCase("cathyg.nj_cust"));
}
public void testIndex(){
TGSqlParser sqlparser = new TGSqlParser(EDbVendor.dbvinformix);
sqlparser.sqltext = "DROP INDEX stores_demo:joed.o_num_ix;";
assertTrue(sqlparser.parse() == 0);
TDropIndexSqlStatement stmt = (TDropIndexSqlStatement)sqlparser.sqlstatements.get(0);
assertTrue(stmt.getIndexName().toString().equalsIgnoreCase("stores_demo:joed.o_num_ix"));
}
public void testTable(){
TGSqlParser sqlparser = new TGSqlParser(EDbVendor.dbvinformix);
sqlparser.sqltext = "DROP TABLE stores_demo@accntg:joed.state;";
assertTrue(sqlparser.parse() == 0);
TDropTableSqlStatement stmt = (TDropTableSqlStatement)sqlparser.sqlstatements.get(0);
assertTrue(stmt.getTableName().toString().equalsIgnoreCase("stores_demo@accntg:joed.state"));
}
public void testView(){
TGSqlParser sqlparser = new TGSqlParser(EDbVendor.dbvinformix);
sqlparser.sqltext = "DROP VIEW cust1";
assertTrue(sqlparser.parse() == 0);
TDropViewSqlStatement stmt = (TDropViewSqlStatement)sqlparser.sqlstatements.get(0);
assertTrue(stmt.getViewName().toString().equalsIgnoreCase("cust1"));
}
}