SQLion (General SQL Parser Java Library Core 3.0.9.1 API)

Object
- gudusoft.gsqlparser.pp.stmtformatter.SQLion

```
public class SQLion
extends Object
```

Nested Class Summary

Nested Classes
Modifier and Type Class and Description

static class SQLion.TStringTokenizer

static class SQLion.TTextTokenizer

Nested Classes
Modifier and Type	Class and Description
`static class`	`SQLion.TStringTokenizer`
`static class`	`SQLion.TTextTokenizer`

Field Summary

Fields
Modifier and Type	Field and Description
`int`	`additionalIndent`
`boolean`	`alignAliasName`
`boolean`	`alignAliasNameAtPredefinedPos`
`int`	`alignAliasNamePos`
`boolean`	`alignCommaInList`
`boolean`	`alignConcateOP`
`boolean`	`alignEqualSigns`
`boolean`	`alignLineComment`
`boolean`	`alignOperator`
`boolean`	`alwaysPut1SpaceAfterComma`
`static char`	`BACKSLASH`
`static char`	`BACKSPACE`
`String`	`blockCommentStr1`
`boolean`	`breakAfterMasterKeyword`
`boolean`	`breakBeforeONkeyword`
`boolean`	`breaksAroundUnionIntersect`
`static String`	`c_char_at`
`static String`	`c_char_colon`
`static String`	`c_char_coma`
`static String`	`c_char_divide`
`static String`	`c_char_dot`
`static String`	`c_char_equal`
`static String`	`c_char_exclamation`
`static String`	`c_char_great`
`static String`	`c_char_left_paren`
`static String`	`c_char_less`
`static String`	`c_char_minus`
`static String`	`c_char_percent`
`static String`	`c_char_plus`
`static String`	`c_char_pound`
`static String`	`c_char_question_mark`
`static String`	`c_char_right_paren`
`static String`	`c_char_semicolon`
`static String`	`c_char_star`
`static String`	`c_char_vertical_bar`
`static String`	`c_predefined_sep`
`static char`	`CARRIAGE_RETURN`
`String`	`caseCustomizedKeywords`
`String`	`caseCustomizedVariableType`
`String`	`charEncloseSQL`
`int`	`colorOfBlockComment`
`int`	`colorOfCASEKeyword`
`int`	`colorOfLineComment`
`int`	`colorOfLiteral`
`int`	`colorOfMasterKeyword`
`int`	`colorOfReservedWords`
`boolean`	`colorRelatedB1`
`byte`	`colorRelatedB2`
`boolean`	`colouredSQL`
`int`	`count1`
`EDbVendor`	`dbname`
`boolean`	`deleteComments`
`String`	`doubleQuotesStr1`
`boolean`	`enableNonFormat`
`static int`	`encrypt_key`
`boolean`	`escapeCharacter`
`boolean`	`findUnnecessaryBracket`
`boolean`	`flexibleSpaceCalculation`
`static char`	`FORM_FEED`
`boolean`	`formatSQLOn1Line`
`short`	`genericIndentSize`
`int`	`hostVariableRelatedCount`
`boolean`	`inComment1`
`boolean`	`inComment2`
`boolean`	`indentANDOR`
`boolean`	`indentBlockComment`
`boolean`	`indentCaseElse`
`boolean`	`indentCaseInBracket`
`boolean`	`indentCaseThen`
`boolean`	`indentColumnValueOfInsert`
`boolean`	`indentConditionInParenthesis`
`boolean`	`indentJoinStatement`
`boolean`	`indentMasterKeyword`
`boolean`	`indentOnStatement`
`boolean`	`indentSubquery`
`boolean`	`isRemoveUnnecessaryBracket`
`boolean`	`keepEmptyLine`
`boolean`	`keepFirstLineIndent`
`boolean`	`keywordLower`
`boolean`	`keywordUpper`
`static char`	`LEFT_PARENTHESIS`
`boolean`	`leftAlignBlockComment`
`static char`	`LINE_FEED`
`boolean`	`linebreakAfterANDOR`
`boolean`	`linebreakAfterComma`
`boolean`	`linebreakAfterConcatenations`
`boolean`	`linebreakAfterEndParenthesisOfCase`
`boolean`	`linebreakAfterEndParenthesisOfCondition`
`boolean`	`linebreakAfterEndParenthesisOfInsert`
`boolean`	`linebreakAfterEndParenthesisOfSubquery`
`boolean`	`linebreakAfterLeftBracketOfACondition`
`boolean`	`linebreakAfterLeftBracketsOfSubSelect`
`boolean`	`linebreakAfterStartParenthesisOfCase`
`boolean`	`linebreakAfterStartParenthesisOfInsert`
`boolean`	`linebreakBeforeAndOr`
`boolean`	`linebreakBeforeBlockComment`
`boolean`	`linebreakBeforeCaseANDOR`
`boolean`	`linebreakBeforeCaseElse`
`boolean`	`linebreakBeforeCaseThen`
`boolean`	`linebreakBeforeCaseWhen`
`boolean`	`linebreakBeforeComma`
`boolean`	`linebreakBeforeConcatenations`
`boolean`	`linebreakBeforeEndParenthesisOfCase`
`boolean`	`linebreakBeforeEndParenthesisOfCondition`
`boolean`	`linebreakBeforeEndParenthesisOfInsert`
`boolean`	`linebreakBeforeEndParenthesisOfSubquery`
`boolean`	`linebreakBeforeLineComment`
`boolean`	`linebreakBeforeStartParenthesisOfCase`
`boolean`	`linebreakBeforeStartParenthesisOfCondition`
`boolean`	`linebreakBeforeStartParenthesisOfInsert`
`boolean`	`linebreakBeforeStartParenthesisOfSubquery`
`boolean`	`linebreakForCase`
`String`	`literalQuote`
`String`	`literalStr1`
`int`	`maxLineWidth`
`boolean`	`moveComma2colsToTheLeft`
`String`	`nonFormatEndTag`
`String`	`nonFormatStartTag`
`int`	`numberOfIdentifiersPerLine`
`boolean`	`onlyKeywordUpper`
`String`	`output_end_line`
`String`	`output_end_of_each_line`
`String`	`output_start_line`
`String`	`output_start_of_each_line`
`String`	`outputFormat`
`String`	`outVariableName`
`int`	`precedingBlanksOfBlockComment`
`int`	`precedingBlanksOfDoubleQuotes`
`int`	`precedingBlanksOfLiteral`
`boolean`	`putCommentBetweenSlashStar`
`boolean`	`putHostVariableBetweenSlashStar`
`Boolean`	`reduceAfterRelatedB1`
`boolean`	`reduceLevelRelatedB1`
`boolean`	`reduceLevelRelatedB2`
`boolean`	`reduceLevelRelatedB3`
`boolean`	`removeUnnecessayWhiteSpaces`
`boolean`	`replaceHostVariable`
`boolean`	`rightAlignMasterKeywords`
`boolean`	`showIndentionLevel`
`boolean`	`showLineNumber`
`boolean`	`showPseudoCode`
`int`	`smallSQLLen`
`static char`	`SPACE`
`String`	`spaceAroundBracketOption`
`String`	`spaceAroundCommaOption`
`String`	`spaceAroundOperatorOption`
`boolean`	`SPAlignDeclareVariable`
`boolean`	`SPIndentConditionInBracket`
`boolean`	`SPIndentParameterInBracket`
`boolean`	`SPLinebreakAfterANDORofCondition`
`boolean`	`SPLinebreakAfterEndParenthesisofCondition`
`boolean`	`SPLinebreakAfterStartParenthesisofCondition`
`boolean`	`SPLinebreakAfterStartParenthesisofParameters`
`boolean`	`SPLinebreakBeforeANDORofCondition`
`boolean`	`SPLinebreakBeforeEndParenthesisofCondition`
`boolean`	`SPLinebreakBeforeEndParenthesisofParameters`
`boolean`	`SPLinebreakBeforeStartParenthesisofCondition`
`boolean`	`SPLinebreakBeforeStartParenthesisofParameters`
`boolean`	`SQLFromProgram`
`boolean`	`sqlserverb1`
`boolean`	`sqlserverMasterKeyRelatedBoolean`
`int`	`sqlserverMasterKeyRelatedLevel`
`static String[]`	`tokenSeparatorArray`
`boolean`	`useTab`
`int`	`valuesPerLineForINLists`
`boolean`	`wholeLower`
`boolean`	`wholeUpper`

Constructor Summary

Constructors
Constructor and Description

SQLion(EDbVendor vendor, GFmtOpt option)

Constructors
Constructor and Description
`SQLion(EDbVendor vendor, GFmtOpt option)`

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`void`	`addFunctions(ArrayList<String> functionList, String[] functionArray)`
`void`	`addToFormattedSQL(String str)`
`void`	`alignToken(int pTokenPos, int pAlignType, String pDirection, String pIgnoreBracketLevel)`
`void`	`calculateSQLLen()`
`void`	`changePrecedingBlankFrom0to1()`
`void`	`checkOutputSQLBuffer()`
`void`	`combineSomeKeywordIntoOne()`
`void`	`concateSpecialChar()`
`String`	`concatTokens(int startPos, int len, String numberOfSpace)`
`static String`	`decode(String input)`
`static String`	`decrypt(String input, int key)`
`void`	`detectAlias()`
`void`	`detectColumn()`
`void`	`doAddProcessedTokenToStringBuilder()`
`void`	`doAlign()`
`void`	`doApplyDebugInstruction()`
`void`	`doCalculateNbrOfPrecedingBlanks1()`
`void`	`doCalculatePrecedingSpace1()`
`void`	`doColorSQL()`
`void`	`doFormatSpace()`
`void`	`doIndentRelated()`
`void`	`doModifyCase()`
`static String`	`encode(String s)`
`static String`	`encrypt(String s, int key)`
`static boolean`	`endsWith(String src, String pattern)`
`static boolean`	`equalsIgnoreCase(String src, String dest)`
`static boolean`	`equalsToChar(String src, char dest)`
`static boolean`	`equalsToChar(String src, String dest)`
`void`	`findMasterSQL()`
`void`	`formatLinebreak()`
`void`	`formatsqltext(String sqltext)`
`String`	`getFormattedSQL()`
`int`	`getLastNoBracketnoCommentPos(int i1)`
`static boolean`	`includeStr(String substr, String str)`
`void`	`initArrayIndexByToken()`
`void`	`initBlockRelatedArray(int i1)`
`void`	`initFormatOptions(EDbVendor vendor, GFmtOpt option)`
`void`	`initNextTokenOfThisAlignType(int i1, int j1)`
`void`	`initStatementRelatedArray()`
`void`	`initTokenArray()`
`static String`	`internalDecrypt(String s, int key)`
`static String`	`internalEncrypt(String s, int key)`
`boolean`	`isFunction(String s1, ArrayList<String> functionList)`
`boolean`	`isInsertToken(String s1)`
`boolean`	`isSelectToken(String s1)`
`boolean`	`isUpdateToken(String s1)`
`boolean`	`isValidIdentifier(String str, boolean caseInsensitive)`
`static void`	`main(String[] args)`
`boolean`	`matchByPattern(String pattern, boolean caseInsensitive, int startPos, int len, String numberOfSpace)`
`boolean`	`matchByPattern2(String pattern, boolean caseInsensitive, int startPos, int len, String numberOfSpace)`
`boolean`	`matchByPatternYieldString(String pattern, boolean caseInsensitive, int startPos, int len, String numberOfSpace)`
`boolean`	`matchByPatternYieldStringAndTokenNum(String pattern, boolean caseInsensitive, int startPos, int len, String numberOfSpace)`
`void`	`mergeDoubleQuoteIntoOneToken()`
`void`	`mergeEscapeChar()`
`void`	`mergeLiteralIntoOneToken()`
`void`	`mergeQualifiedIdentifier()`
`void`	`mergeSignOfComment()`
`void`	`mergeSquareBracketIntoOneToken()`
`static String`	`myDecrypt(String input)`
`static boolean`	`myequals(String src, String dest)`
`void`	`myStrToStrings(String S, String Sep, List<String> List, boolean AllowEmptyString)`
`static boolean`	`myTryStrToInt(String S, int[] Value)`
`int`	`next2SolidToken(int startPos)`
`String`	`nextSolidToken(int i1)`
`String`	`nextToken_nocomment_noempty_noleftbracket(int i1)`
`void`	`outputFormattedSQL()`
`int`	`posOfNextToken_nocomment_noempty_noleftbracket(int i1)`
`int`	`posOfNextToken_nonComment_nonEmpty(int i1)`
`int`	`posOfPrevToken_nonEmpty(int i1)`
`static String`	`postProcess(String s)`
`void`	`prepareForNextToken()`
`static String`	`preProcess(String s)`
`String`	`prevNonCommentToken(int i1)`
`int`	`prevToken_nonComment_noEmpty_returnPos(int i1)`
`String`	`prevToken_nonComment_noEmpty(int i1)`
`String`	`prevToken_nonComment_nonEmpty_nonLeftBracket(int i1)`
`String`	`prevToken_nonEmpty(int i1)`
`void`	`processCaseRelated2()`
`void`	`processDB2Linebreak()`
`void`	`processLinebreak()`
`void`	`processMySQLLinebreak()`
`void`	`processSQLServerLinebreak()`
`void`	`removeUnnecessaryBracket()`
`static String`	`replaceAll(String s, String search, String replace)`
`int`	`resetBlockIDToSameBracketsLevelNotStartWithMasterKey(int pBlockID)`
`void`	`resetSomeBracketArrayIfNotInASQL()`
`void`	`selectStatementClauseScope()`
`void`	`setBlockRelatedArray()`
`void`	`setCaseSegment()`
`void`	`setFalseCanGetLineBreakAfter()`
`void`	`setJoinScope()`
`void`	`setKeyword1()`
`void`	`setNonFormatZone()`
`void`	`setNonFormatZoneSQLServer()`
`void`	`setPrecedingTokenOfLeftBracket_masterkey()`
`void`	`setSPKeyword(String s1)`
`void`	`setSQLBlock()`
`void`	`setToEmptyTokenInThisRange(int startPos, int range)`
`void`	`setTrueCanGetLineBreakAfter()`
`int`	`skipToNextNonEmptyToken(int i1)`
`int`	`skipToNonEmptyToken(int i1)`
`void`	`SQLLevelAndScope()`
`static boolean`	`startsWith(String src, String pattern)`
`String`	`strOfNextToken_nonComment_nonEmtpy(int i1)`
`void`	`synchronizeTokenBlockID()`
`static String`	`toLowerCase(String s)`
`String`	`unknownMethod1(int i1)`
`String`	`unknownMethod2(int i1)`
`void`	`unknownMethod3()`

Methods inherited from class Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

output_start_line
```
public String output_start_line
```

output_start_of_each_line

public String output_start_of_each_line

output_end_of_each_line
```
public String output_end_of_each_line
```

output_end_line
```
public String output_end_line
```

literalStr1
```
public String literalStr1
```

precedingBlanksOfLiteral
```
public int precedingBlanksOfLiteral
```

blockCommentStr1
```
public String blockCommentStr1
```

precedingBlanksOfBlockComment

public int precedingBlanksOfBlockComment

doubleQuotesStr1
```
public String doubleQuotesStr1
```

precedingBlanksOfDoubleQuotes

public int precedingBlanksOfDoubleQuotes

inComment1
```
public boolean inComment1
```

inComment2
```
public boolean inComment2
```

findUnnecessaryBracket
```
public boolean findUnnecessaryBracket
```

count1
```
public int count1
```

hostVariableRelatedCount
```
public int hostVariableRelatedCount
```

sqlserverMasterKeyRelatedBoolean

public boolean sqlserverMasterKeyRelatedBoolean

sqlserverMasterKeyRelatedLevel

public int sqlserverMasterKeyRelatedLevel

sqlserverb1
```
public boolean sqlserverb1
```

reduceLevelRelatedB1
```
public boolean reduceLevelRelatedB1
```

reduceLevelRelatedB2
```
public boolean reduceLevelRelatedB2
```

reduceAfterRelatedB1
```
public Boolean reduceAfterRelatedB1
```

reduceLevelRelatedB3
```
public boolean reduceLevelRelatedB3
```

colorRelatedB2
```
public byte colorRelatedB2
```

keywordUpper
```
public boolean keywordUpper
```

onlyKeywordUpper
```
public boolean onlyKeywordUpper
```

keywordLower
```
public boolean keywordLower
```

wholeUpper
```
public boolean wholeUpper
```

wholeLower
```
public boolean wholeLower
```

showIndentionLevel
```
public boolean showIndentionLevel
```

removeUnnecessayWhiteSpaces

public boolean removeUnnecessayWhiteSpaces

breaksAroundUnionIntersect

public boolean breaksAroundUnionIntersect

linebreakBeforeComma
```
public boolean linebreakBeforeComma
```

linebreakAfterComma
```
public boolean linebreakAfterComma
```

linebreakAfterANDOR
```
public boolean linebreakAfterANDOR
```

linebreakBeforeAndOr
```
public boolean linebreakBeforeAndOr
```

linebreakBeforeConcatenations

public boolean linebreakBeforeConcatenations

linebreakAfterConcatenations

public boolean linebreakAfterConcatenations

showLineNumber
```
public boolean showLineNumber
```

breakAfterMasterKeyword
```
public boolean breakAfterMasterKeyword
```

useTab
```
public boolean useTab
```

formatSQLOn1Line
```
public boolean formatSQLOn1Line
```

literalQuote
```
public String literalQuote
```

outVariableName
```
public String outVariableName
```

genericIndentSize
```
public short genericIndentSize
```

SQLFromProgram
```
public boolean SQLFromProgram
```

charEncloseSQL
```
public String charEncloseSQL
```

outputFormat
```
public String outputFormat
```

maxLineWidth
```
public int maxLineWidth
```

numberOfIdentifiersPerLine
```
public int numberOfIdentifiersPerLine
```

valuesPerLineForINLists
```
public int valuesPerLineForINLists
```

caseCustomizedKeywords
```
public String caseCustomizedKeywords
```

caseCustomizedVariableType

public String caseCustomizedVariableType

dbname
```
public EDbVendor dbname
```

indentSubquery
```
public boolean indentSubquery
```

linebreakBeforeStartParenthesisOfSubquery

public boolean linebreakBeforeStartParenthesisOfSubquery

linebreakAfterLeftBracketsOfSubSelect

public boolean linebreakAfterLeftBracketsOfSubSelect

linebreakBeforeStartParenthesisOfCondition

public boolean linebreakBeforeStartParenthesisOfCondition

linebreakBeforeEndParenthesisOfSubquery

public boolean linebreakBeforeEndParenthesisOfSubquery

linebreakAfterEndParenthesisOfSubquery

public boolean linebreakAfterEndParenthesisOfSubquery

linebreakBeforeEndParenthesisOfCondition

public boolean linebreakBeforeEndParenthesisOfCondition

linebreakAfterEndParenthesisOfCondition

public boolean linebreakAfterEndParenthesisOfCondition

indentConditionInParenthesis

public boolean indentConditionInParenthesis

linebreakAfterLeftBracketOfACondition

public boolean linebreakAfterLeftBracketOfACondition

indentMasterKeyword
```
public boolean indentMasterKeyword
```

indentANDOR
```
public boolean indentANDOR
```

indentCaseThen
```
public boolean indentCaseThen
```

indentCaseElse
```
public boolean indentCaseElse
```

colouredSQL
```
public boolean colouredSQL
```

linebreakForCase
```
public boolean linebreakForCase
```

linebreakBeforeCaseThen
```
public boolean linebreakBeforeCaseThen
```

linebreakBeforeCaseWhen
```
public boolean linebreakBeforeCaseWhen
```

linebreakBeforeCaseANDOR

public boolean linebreakBeforeCaseANDOR

linebreakBeforeCaseElse
```
public boolean linebreakBeforeCaseElse
```

breakBeforeONkeyword
```
public boolean breakBeforeONkeyword
```

alignEqualSigns
```
public boolean alignEqualSigns
```

alignOperator
```
public boolean alignOperator
```

alignAliasName
```
public boolean alignAliasName
```

alignCommaInList
```
public boolean alignCommaInList
```

alignLineComment
```
public boolean alignLineComment
```

alignConcateOP
```
public boolean alignConcateOP
```

SPAlignDeclareVariable
```
public boolean SPAlignDeclareVariable
```

rightAlignMasterKeywords

public boolean rightAlignMasterKeywords

deleteComments
```
public boolean deleteComments
```

putCommentBetweenSlashStar

public boolean putCommentBetweenSlashStar

isRemoveUnnecessaryBracket

public boolean isRemoveUnnecessaryBracket

spaceAroundBracketOption
```
public String spaceAroundBracketOption
```

spaceAroundCommaOption
```
public String spaceAroundCommaOption
```

spaceAroundOperatorOption

public String spaceAroundOperatorOption

smallSQLLen
```
public int smallSQLLen
```

additionalIndent
```
public int additionalIndent
```

linebreakBeforeLineComment

public boolean linebreakBeforeLineComment

linebreakBeforeBlockComment

public boolean linebreakBeforeBlockComment

colorRelatedB1
```
public boolean colorRelatedB1
```

indentJoinStatement
```
public boolean indentJoinStatement
```

indentOnStatement
```
public boolean indentOnStatement
```

escapeCharacter
```
public boolean escapeCharacter
```

keepEmptyLine
```
public boolean keepEmptyLine
```

alignAliasNameAtPredefinedPos

public boolean alignAliasNameAtPredefinedPos

alignAliasNamePos
```
public int alignAliasNamePos
```

replaceHostVariable
```
public boolean replaceHostVariable
```

putHostVariableBetweenSlashStar

public boolean putHostVariableBetweenSlashStar

showPseudoCode
```
public boolean showPseudoCode
```

flexibleSpaceCalculation

public boolean flexibleSpaceCalculation

keepFirstLineIndent
```
public boolean keepFirstLineIndent
```

SPLinebreakBeforeStartParenthesisofCondition

public boolean SPLinebreakBeforeStartParenthesisofCondition

SPLinebreakAfterStartParenthesisofCondition

public boolean SPLinebreakAfterStartParenthesisofCondition

SPLinebreakBeforeEndParenthesisofCondition

public boolean SPLinebreakBeforeEndParenthesisofCondition

SPLinebreakAfterEndParenthesisofCondition

public boolean SPLinebreakAfterEndParenthesisofCondition

SPLinebreakBeforeANDORofCondition

public boolean SPLinebreakBeforeANDORofCondition

SPLinebreakAfterANDORofCondition

public boolean SPLinebreakAfterANDORofCondition

SPIndentConditionInBracket

public boolean SPIndentConditionInBracket

SPLinebreakBeforeStartParenthesisofParameters

public boolean SPLinebreakBeforeStartParenthesisofParameters

SPLinebreakAfterStartParenthesisofParameters

public boolean SPLinebreakAfterStartParenthesisofParameters

SPIndentParameterInBracket

public boolean SPIndentParameterInBracket

SPLinebreakBeforeEndParenthesisofParameters

public boolean SPLinebreakBeforeEndParenthesisofParameters

enableNonFormat
```
public boolean enableNonFormat
```

nonFormatStartTag
```
public String nonFormatStartTag
```

nonFormatEndTag
```
public String nonFormatEndTag
```

linebreakBeforeStartParenthesisOfInsert

public boolean linebreakBeforeStartParenthesisOfInsert

linebreakAfterStartParenthesisOfInsert

public boolean linebreakAfterStartParenthesisOfInsert

linebreakBeforeEndParenthesisOfInsert

public boolean linebreakBeforeEndParenthesisOfInsert

linebreakAfterEndParenthesisOfInsert

public boolean linebreakAfterEndParenthesisOfInsert

indentColumnValueOfInsert

public boolean indentColumnValueOfInsert

linebreakBeforeStartParenthesisOfCase

public boolean linebreakBeforeStartParenthesisOfCase

linebreakAfterStartParenthesisOfCase

public boolean linebreakAfterStartParenthesisOfCase

linebreakBeforeEndParenthesisOfCase

public boolean linebreakBeforeEndParenthesisOfCase

linebreakAfterEndParenthesisOfCase

public boolean linebreakAfterEndParenthesisOfCase

indentCaseInBracket
```
public boolean indentCaseInBracket
```

leftAlignBlockComment
```
public boolean leftAlignBlockComment
```

indentBlockComment
```
public boolean indentBlockComment
```

moveComma2colsToTheLeft
```
public boolean moveComma2colsToTheLeft
```

alwaysPut1SpaceAfterComma

public boolean alwaysPut1SpaceAfterComma

colorOfMasterKeyword
```
public int colorOfMasterKeyword
```

colorOfLineComment
```
public int colorOfLineComment
```

colorOfBlockComment
```
public int colorOfBlockComment
```

colorOfCASEKeyword
```
public int colorOfCASEKeyword
```

colorOfLiteral
```
public int colorOfLiteral
```

colorOfReservedWords
```
public int colorOfReservedWords
```

SPACE
```
public static final char SPACE
```
See Also:

Constant Field Values

FORM_FEED
```
public static final char FORM_FEED
```
See Also:

Constant Field Values

BACKSPACE
```
public static final char BACKSPACE
```
See Also:

Constant Field Values

CARRIAGE_RETURN
```
public static final char CARRIAGE_RETURN
```
See Also:

Constant Field Values

LINE_FEED
```
public static final char LINE_FEED
```
See Also:

Constant Field Values

BACKSLASH
```
public static final char BACKSLASH
```
See Also:

Constant Field Values

LEFT_PARENTHESIS
```
public static final char LEFT_PARENTHESIS
```
See Also:

Constant Field Values

tokenSeparatorArray

public static final String[] tokenSeparatorArray

c_char_exclamation

public static final String c_char_exclamation

c_char_pound

public static final String c_char_pound

c_char_percent

public static final String c_char_percent

c_char_left_paren

public static final String c_char_left_paren

c_char_right_paren

public static final String c_char_right_paren

c_char_star
```
public static final String c_char_star
```

c_char_plus
```
public static final String c_char_plus
```

c_char_coma
```
public static final String c_char_coma
```

c_char_minus

public static final String c_char_minus

c_char_dot
```
public static final String c_char_dot
```

c_char_divide

public static final String c_char_divide

c_char_colon

public static final String c_char_colon

c_char_semicolon

public static final String c_char_semicolon

c_char_less
```
public static final String c_char_less
```

c_char_equal

public static final String c_char_equal

c_char_great

public static final String c_char_great

c_char_question_mark

public static final String c_char_question_mark

c_char_at
```
public static final String c_char_at
```

c_char_vertical_bar

public static final String c_char_vertical_bar

c_predefined_sep

public static final String c_predefined_sep

encrypt_key
```
public static final int encrypt_key
```
See Also:

Constant Field Values

Constructor Detail

SQLion

public SQLion(EDbVendor vendor,
              GFmtOpt option)

Method Detail

decode

public static String decode(String input)

preProcess

public static String preProcess(String s)

internalDecrypt

public static String internalDecrypt(String s,
                                     int key)

decrypt

public static String decrypt(String input,
                             int key)

myDecrypt

public static String myDecrypt(String input)

encode

public static String encode(String s)

postProcess

public static String postProcess(String s)

internalEncrypt

public static String internalEncrypt(String s,
                                     int key)

encrypt

public static String encrypt(String s,
                             int key)

includeStr

public static boolean includeStr(String substr,
                                 String str)

replaceAll

public static String replaceAll(String s,
                                String search,
                                String replace)

myequals

public static boolean myequals(String src,
                               String dest)

equalsIgnoreCase

public static boolean equalsIgnoreCase(String src,
                                       String dest)

equalsToChar

public static boolean equalsToChar(String src,
                                   char dest)

equalsToChar

public static boolean equalsToChar(String src,
                                   String dest)

toLowerCase

public static String toLowerCase(String s)

startsWith

public static boolean startsWith(String src,
                                 String pattern)

endsWith

public static boolean endsWith(String src,
                               String pattern)

myTryStrToInt

public static boolean myTryStrToInt(String S,
                                    int[] Value)

resetBlockIDToSameBracketsLevelNotStartWithMasterKey

public int resetBlockIDToSameBracketsLevelNotStartWithMasterKey(int pBlockID)

synchronizeTokenBlockID
```
public void synchronizeTokenBlockID()
```

setSQLBlock
```
public void setSQLBlock()
```

changePrecedingBlankFrom0to1

public void changePrecedingBlankFrom0to1()

calculateSQLLen
```
public void calculateSQLLen()
```

combineSomeKeywordIntoOne

public void combineSomeKeywordIntoOne()

concateSpecialChar
```
public void concateSpecialChar()
```

concatTokens

public String concatTokens(int startPos,
                           int len,
                           String numberOfSpace)

detectAlias
```
public void detectAlias()
```

detectColumn
```
public void detectColumn()
```

setKeyword1
```
public void setKeyword1()
```

setTrueCanGetLineBreakAfter

public void setTrueCanGetLineBreakAfter()

setFalseCanGetLineBreakAfter

public void setFalseCanGetLineBreakAfter()

unknownMethod1
```
public String unknownMethod1(int i1)
```

setSPKeyword
```
public void setSPKeyword(String s1)
```

unknownMethod2
```
public String unknownMethod2(int i1)
```

doFormatSpace
```
public void doFormatSpace()
```

findMasterSQL
```
public void findMasterSQL()
```

myStrToStrings

public void myStrToStrings(String S,
                           String Sep,
                           List<String> List,
                           boolean AllowEmptyString)

formatsqltext

public void formatsqltext(String sqltext)

getLastNoBracketnoCommentPos

public int getLastNoBracketnoCommentPos(int i1)

initBlockRelatedArray

public void initBlockRelatedArray(int i1)

initStatementRelatedArray

public void initStatementRelatedArray()

initTokenArray
```
public void initTokenArray()
```

initArrayIndexByToken
```
public void initArrayIndexByToken()
```

isFunction

public boolean isFunction(String s1,
                          ArrayList<String> functionList)

isInsertToken

public boolean isInsertToken(String s1)

isSelectToken

public boolean isSelectToken(String s1)

isUpdateToken

public boolean isUpdateToken(String s1)

setNonFormatZone
```
public void setNonFormatZone()
```

matchByPatternYieldString

public boolean matchByPatternYieldString(String pattern,
                                         boolean caseInsensitive,
                                         int startPos,
                                         int len,
                                         String numberOfSpace)

matchByPatternYieldStringAndTokenNum

public boolean matchByPatternYieldStringAndTokenNum(String pattern,
                                                    boolean caseInsensitive,
                                                    int startPos,
                                                    int len,
                                                    String numberOfSpace)

next2SolidToken

public int next2SolidToken(int startPos)

nextSolidToken
```
public String nextSolidToken(int i1)
```

nextToken_nocomment_noempty_noleftbracket

public String nextToken_nocomment_noempty_noleftbracket(int i1)

posOfNextToken_nocomment_noempty_noleftbracket

public int posOfNextToken_nocomment_noempty_noleftbracket(int i1)

posOfNextToken_nonComment_nonEmpty

public int posOfNextToken_nonComment_nonEmpty(int i1)

posOfPrevToken_nonEmpty

public int posOfPrevToken_nonEmpty(int i1)

prevToken_nonComment_noEmpty

public String prevToken_nonComment_noEmpty(int i1)

prevToken_nonComment_noEmpty_returnPos

public int prevToken_nonComment_noEmpty_returnPos(int i1)

prevToken_nonComment_nonEmpty_nonLeftBracket

public String prevToken_nonComment_nonEmpty_nonLeftBracket(int i1)

prevToken_nonEmpty

public String prevToken_nonEmpty(int i1)

mergeSquareBracketIntoOneToken

public void mergeSquareBracketIntoOneToken()

setCaseSegment
```
public void setCaseSegment()
```

processCaseRelated2
```
public void processCaseRelated2()
```

mergeSignOfComment
```
public void mergeSignOfComment()
```

mergeDoubleQuoteIntoOneToken

public void mergeDoubleQuoteIntoOneToken()

mergeEscapeChar
```
public void mergeEscapeChar()
```

mergeLiteralIntoOneToken

public void mergeLiteralIntoOneToken()

mergeQualifiedIdentifier

public void mergeQualifiedIdentifier()

removeUnnecessaryBracket

public void removeUnnecessaryBracket()

resetSomeBracketArrayIfNotInASQL

public void resetSomeBracketArrayIfNotInASQL()

selectStatementClauseScope

public void selectStatementClauseScope()

setBlockRelatedArray
```
public void setBlockRelatedArray()
```

setJoinScope
```
public void setJoinScope()
```

setNonFormatZoneSQLServer

public void setNonFormatZoneSQLServer()

setPrecedingTokenOfLeftBracket_masterkey

public void setPrecedingTokenOfLeftBracket_masterkey()

setToEmptyTokenInThisRange

public void setToEmptyTokenInThisRange(int startPos,
                                       int range)

skipToNextNonEmptyToken

public int skipToNextNonEmptyToken(int i1)

skipToNonEmptyToken

public int skipToNonEmptyToken(int i1)

SQLLevelAndScope
```
public void SQLLevelAndScope()
```

strOfNextToken_nonComment_nonEmtpy

public String strOfNextToken_nonComment_nonEmtpy(int i1)

checkOutputSQLBuffer
```
public void checkOutputSQLBuffer()
```

doAddProcessedTokenToStringBuilder

public void doAddProcessedTokenToStringBuilder()

doAlign
```
public void doAlign()
```

doApplyDebugInstruction
```
public void doApplyDebugInstruction()
```

doCalculateNbrOfPrecedingBlanks1

public void doCalculateNbrOfPrecedingBlanks1()

doCalculatePrecedingSpace1

public void doCalculatePrecedingSpace1()

doColorSQL
```
public void doColorSQL()
```

doIndentRelated
```
public void doIndentRelated()
```

doModifyCase
```
public void doModifyCase()
```

prepareForNextToken
```
public void prepareForNextToken()
```

processDB2Linebreak
```
public void processDB2Linebreak()
```

processLinebreak
```
public void processLinebreak()
```

processMySQLLinebreak
```
public void processMySQLLinebreak()
```

processSQLServerLinebreak

public void processSQLServerLinebreak()

unknownMethod3
```
public void unknownMethod3()
```

formatLinebreak
```
public void formatLinebreak()
```

prevNonCommentToken

public String prevNonCommentToken(int i1)

alignToken

public void alignToken(int pTokenPos,
                       int pAlignType,
                       String pDirection,
                       String pIgnoreBracketLevel)

initNextTokenOfThisAlignType

public void initNextTokenOfThisAlignType(int i1,
                                         int j1)

addFunctions

public void addFunctions(ArrayList<String> functionList,
                         String[] functionArray)

matchByPattern

public boolean matchByPattern(String pattern,
                              boolean caseInsensitive,
                              int startPos,
                              int len,
                              String numberOfSpace)

matchByPattern2

public boolean matchByPattern2(String pattern,
                               boolean caseInsensitive,
                               int startPos,
                               int len,
                               String numberOfSpace)

isValidIdentifier

public boolean isValidIdentifier(String str,
                                 boolean caseInsensitive)

outputFormattedSQL
```
public void outputFormattedSQL()
```

addToFormattedSQL

public void addToFormattedSQL(String str)

getFormattedSQL
```
public String getFormattedSQL()
```

initFormatOptions

public void initFormatOptions(EDbVendor vendor,
                              GFmtOpt option)

main

public static void main(String[] args)

Class SQLion

Nested Class Summary

Field Summary

Constructor Summary

Method Summary

Methods inherited from class Object

Field Detail

output_start_line

output_start_of_each_line

output_end_of_each_line

output_end_line

literalStr1

precedingBlanksOfLiteral

blockCommentStr1

precedingBlanksOfBlockComment

doubleQuotesStr1

precedingBlanksOfDoubleQuotes

inComment1

inComment2

findUnnecessaryBracket

count1

hostVariableRelatedCount

sqlserverMasterKeyRelatedBoolean

sqlserverMasterKeyRelatedLevel

sqlserverb1

reduceLevelRelatedB1

reduceLevelRelatedB2

reduceAfterRelatedB1

reduceLevelRelatedB3

colorRelatedB2

keywordUpper

onlyKeywordUpper

keywordLower

wholeUpper

wholeLower

showIndentionLevel

removeUnnecessayWhiteSpaces

breaksAroundUnionIntersect

linebreakBeforeComma

linebreakAfterComma

linebreakAfterANDOR

linebreakBeforeAndOr

linebreakBeforeConcatenations

linebreakAfterConcatenations

showLineNumber

breakAfterMasterKeyword

useTab

formatSQLOn1Line

literalQuote

outVariableName

genericIndentSize

SQLFromProgram

charEncloseSQL

outputFormat

maxLineWidth

numberOfIdentifiersPerLine

valuesPerLineForINLists

caseCustomizedKeywords

caseCustomizedVariableType

dbname

indentSubquery

linebreakBeforeStartParenthesisOfSubquery

linebreakAfterLeftBracketsOfSubSelect

linebreakBeforeStartParenthesisOfCondition

linebreakBeforeEndParenthesisOfSubquery

linebreakAfterEndParenthesisOfSubquery

linebreakBeforeEndParenthesisOfCondition

linebreakAfterEndParenthesisOfCondition

indentConditionInParenthesis

linebreakAfterLeftBracketOfACondition

indentMasterKeyword

indentANDOR

indentCaseThen

indentCaseElse

colouredSQL

linebreakForCase

linebreakBeforeCaseThen

linebreakBeforeCaseWhen

linebreakBeforeCaseANDOR

linebreakBeforeCaseElse