-
Notifications
You must be signed in to change notification settings - Fork 77
Expand file tree
/
Copy pathtestCommentOn.java
More file actions
52 lines (45 loc) · 2.91 KB
/
Copy pathtestCommentOn.java
File metadata and controls
52 lines (45 loc) · 2.91 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
package common;
import gudusoft.gsqlparser.EDbObjectType;
import gudusoft.gsqlparser.EDbVendor;
import gudusoft.gsqlparser.TGSqlParser;
import gudusoft.gsqlparser.stmt.TCommentOnSqlStmt;
import junit.framework.TestCase;
public class testCommentOn extends TestCase {
public void test0(){
TGSqlParser sqlparser = new TGSqlParser(EDbVendor.dbvvertica);
sqlparser.sqltext = "COMMENT ON COLUMN customer_dimension_vmart_node01.customer_name IS 'Last name only';";
assertTrue(sqlparser.parse() == 0);
TCommentOnSqlStmt commentOnSqlStmt = (TCommentOnSqlStmt)sqlparser.sqlstatements.get(0);
assertTrue(commentOnSqlStmt.getDbObjectType() == EDbObjectType.column);
assertTrue(commentOnSqlStmt.getObjectName().toString().equalsIgnoreCase("customer_dimension_vmart_node01.customer_name"));
assertTrue(commentOnSqlStmt.getMessage().toString().equalsIgnoreCase("'Last name only'"));
}
public void testNetezza(){
TGSqlParser sqlparser = new TGSqlParser(EDbVendor.dbvnetezza);
sqlparser.sqltext = "COMMENT ON COLUMN LOAD_INPUT_DATASET.STATUS_CD IS '[0=Loading;1=Ready;2=Failed;3=Archived;4=Purged]';';";
assertTrue(sqlparser.parse() == 0);
TCommentOnSqlStmt commentOnSqlStmt = (TCommentOnSqlStmt)sqlparser.sqlstatements.get(0);
assertTrue(commentOnSqlStmt.getDbObjectType() == EDbObjectType.column);
assertTrue(commentOnSqlStmt.getObjectName().toString().equalsIgnoreCase("LOAD_INPUT_DATASET.STATUS_CD"));
assertTrue(commentOnSqlStmt.getMessage().toString().equalsIgnoreCase("'[0=Loading;1=Ready;2=Failed;3=Archived;4=Purged]'"));
}
public void testOracle(){
TGSqlParser sqlparser = new TGSqlParser(EDbVendor.dbvoracle);
sqlparser.sqltext = "comment on column sql_policy.policy_id is 'test'";
assertTrue(sqlparser.parse() == 0);
TCommentOnSqlStmt commentOnSqlStmt = (TCommentOnSqlStmt)sqlparser.sqlstatements.get(0);
assertTrue(commentOnSqlStmt.getDbObjectType() == EDbObjectType.column);
assertTrue(commentOnSqlStmt.getObjectName().toString().equalsIgnoreCase("sql_policy.policy_id"));
assertTrue(commentOnSqlStmt.getObjectName().getTableString().equalsIgnoreCase("sql_policy"));
assertTrue(commentOnSqlStmt.getMessage().toString().equalsIgnoreCase("'test'"));
}
public void testPostgres(){
TGSqlParser sqlparser = new TGSqlParser(EDbVendor.dbvpostgresql);
sqlparser.sqltext = "COMMENT ON TABLE ACT_DIM_HLHA IS 'Type lieu HAD historise';";
assertTrue(sqlparser.parse() == 0);
TCommentOnSqlStmt commentOnSqlStmt = (TCommentOnSqlStmt)sqlparser.sqlstatements.get(0);
assertTrue(commentOnSqlStmt.getDbObjectType() == EDbObjectType.table);
assertTrue(commentOnSqlStmt.getObjectName().toString().equalsIgnoreCase("ACT_DIM_HLHA"));
assertTrue(commentOnSqlStmt.getMessage().toString().equalsIgnoreCase("'Type lieu HAD historise'"));
}
}