-
Notifications
You must be signed in to change notification settings - Fork 77
Expand file tree
/
Copy pathtestCommentOn.java
More file actions
21 lines (16 loc) · 904 Bytes
/
Copy pathtestCommentOn.java
File metadata and controls
21 lines (16 loc) · 904 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
package test.oracle;
import gudusoft.gsqlparser.EDbVendor;
import gudusoft.gsqlparser.TGSqlParser;
import gudusoft.gsqlparser.stmt.TCommentOnSqlStmt;
import junit.framework.TestCase;
public class testCommentOn extends TestCase{
public void test1(){
TGSqlParser sqlparser = new TGSqlParser(EDbVendor.dbvoracle);
sqlparser.sqltext = "COMMENT ON TABLE \"SFMFG\".\"SFFND_OPER_TYPE_DEF\" IS 'Test'";
assertTrue(sqlparser.parse() == 0);
TCommentOnSqlStmt commentOnSqlStmt = (TCommentOnSqlStmt)sqlparser.sqlstatements.get(0);
assertTrue(commentOnSqlStmt.getObjectName().toString().equalsIgnoreCase("\"SFMFG\".\"SFFND_OPER_TYPE_DEF\""));
assertTrue(commentOnSqlStmt.getObjectName().getTableString().equalsIgnoreCase("\"SFFND_OPER_TYPE_DEF\""));
assertTrue(commentOnSqlStmt.getObjectName().getSchemaString().equalsIgnoreCase("\"SFMFG\""));
}
}