-
Notifications
You must be signed in to change notification settings - Fork 77
Expand file tree
/
Copy pathtestPlsql1.java
More file actions
55 lines (50 loc) · 2.6 KB
/
Copy pathtestPlsql1.java
File metadata and controls
55 lines (50 loc) · 2.6 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
package formatsql;
/*
* Date: 13-2-8
*/
import gudusoft.gsqlparser.EDbVendor;
import gudusoft.gsqlparser.TGSqlParser;
import gudusoft.gsqlparser.pp.para.GFmtOpt;
import gudusoft.gsqlparser.pp.para.GFmtOptFactory;
import gudusoft.gsqlparser.pp.para.styleenums.TAlignOption;
import gudusoft.gsqlparser.pp.para.styleenums.TAlignStyle;
import gudusoft.gsqlparser.pp.para.styleenums.TLinefeedsCommaOption;
import gudusoft.gsqlparser.stmt.oracle.TPlsqlCreateProcedure;
import junit.framework.TestCase;
public class testPlsql1 extends TestCase {
public static void test1(){
TGSqlParser sqlParser = new TGSqlParser(EDbVendor.dbvoracle);
sqlParser
.setSqltext("CREATE OR REPLACE PROCEDURE RULE14002TESTPROC1( A1 IN NUMBER )\n"
+ "IS\n"
+ "PROCEDURE INPROC1 (A1 NUMBER); -- Declaration\n"
+ "PROCEDURE INPROC2 (A1 NUMBER) -- Definition\n"
+ "IS\n"
+ "BEGIN\n"
+ "INSERT INTO T1 VALUES(1, A1);\n"
+ "END;\n"
+ "BEGIN\n"
+ "INPROC1(TEMP1.M1);\n"
+ "END;\n"
+ "/");
int ret = sqlParser.parse();
if (ret != 0)
{
System.out.println(sqlParser.getErrormessage());
}
TPlsqlCreateProcedure stmt = (TPlsqlCreateProcedure) sqlParser.getSqlstatements().get(0);
GFmtOpt sqlFormatOption = GFmtOptFactory.newInstance();
sqlFormatOption.beStyleCreatetableLeftBEOnNewline = false;
sqlFormatOption.beStyleCreatetableRightBEOnNewline = false;
sqlFormatOption.createtableListitemInNewLine = false;
sqlFormatOption.createtableFieldlistAlignOption = TAlignOption.AloLeft;
sqlFormatOption.defaultAligntype = TAlignStyle.AsStacked;
sqlFormatOption.defaultCommaOption = TLinefeedsCommaOption.LfAfterComma;
sqlFormatOption.cteNewlineBeforeAs = true;
sqlFormatOption.linebreakBeforeParamInExec = true;
sqlFormatOption.linebreakAfterDeclare = true;
sqlFormatOption.beStyleFunctionFirstParamInNewline = true;
//System.out.println(stmt.toString());
//System.out.println(FormatterFactory.pp(sqlParser, sqlFormatOption));
}
}