Class SQLion
Object
gudusoft.gsqlparser.pp.stmtformatter.SQLion
-
Nested Class Summary
Nested ClassesModifier and TypeClassDescriptionstatic classstatic class -
Field Summary
FieldsModifier and TypeFieldDescriptionintbooleanbooleanintbooleanbooleanbooleanbooleanbooleanbooleanstatic final charstatic final charbooleanbooleanbooleanstatic final Stringstatic final Stringstatic final Stringstatic final Stringstatic final Stringstatic final Stringstatic final Stringstatic final Stringstatic final Stringstatic final Stringstatic final Stringstatic final Stringstatic final Stringstatic final Stringstatic final Stringstatic final Stringstatic final Stringstatic final Stringstatic final Stringstatic final Stringstatic final charintintintintintintbooleanbytebooleanintbooleanbooleanstatic final intbooleanbooleanbooleanstatic final charbooleanshortintbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanstatic final charbooleanstatic final charbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanintbooleanintbooleanintintintbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanintstatic final charbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanbooleanintstatic final String[]booleanintbooleanboolean -
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionvoidaddFunctions(ArrayList<String> functionList, String[] functionArray) voidaddToFormattedSQL(String str) voidalignToken(int pTokenPos, int pAlignType, String pDirection, String pIgnoreBracketLevel) voidvoidvoidvoidvoidconcatTokens(int startPos, int len, String numberOfSpace) static Stringstatic StringvoidvoidvoidvoiddoAlign()voidvoidvoidvoidvoidvoidvoidstatic Stringstatic Stringstatic booleanstatic booleanequalsIgnoreCase(String src, String dest) static booleanequalsToChar(String src, char dest) static booleanequalsToChar(String src, String dest) voidvoidvoidformatsqltext(String sqltext) intgetLastNoBracketnoCommentPos(int i1) static booleanincludeStr(String substr, String str) voidvoidinitBlockRelatedArray(int i1) voidinitFormatOptions(EDbVendor vendor, GFmtOpt option) voidinitNextTokenOfThisAlignType(int i1, int j1) voidvoidstatic StringinternalDecrypt(String s, int key) static StringinternalEncrypt(String s, int key) booleanisFunction(String s1, ArrayList<String> functionList) booleanisInsertToken(String s1) booleanisSelectToken(String s1) booleanisUpdateToken(String s1) booleanisValidIdentifier(String str, boolean caseInsensitive) static voidbooleanmatchByPattern(String pattern, boolean caseInsensitive, int startPos, int len, String numberOfSpace) booleanmatchByPattern2(String pattern, boolean caseInsensitive, int startPos, int len, String numberOfSpace) booleanmatchByPatternYieldString(String pattern, boolean caseInsensitive, int startPos, int len, String numberOfSpace) booleanmatchByPatternYieldStringAndTokenNum(String pattern, boolean caseInsensitive, int startPos, int len, String numberOfSpace) voidvoidvoidvoidvoidvoidstatic Stringstatic booleanvoidmyStrToStrings(String S, String Sep, List<String> List, boolean AllowEmptyString) static booleanmyTryStrToInt(String S, int[] Value) intnext2SolidToken(int startPos) nextSolidToken(int i1) voidintintintposOfPrevToken_nonEmpty(int i1) static Stringvoidstatic StringpreProcess(String s) prevNonCommentToken(int i1) prevToken_nonComment_noEmpty(int i1) intprevToken_nonEmpty(int i1) voidvoidvoidvoidvoidvoidstatic StringreplaceAll(String s, String search, String replace) intresetBlockIDToSameBracketsLevelNotStartWithMasterKey(int pBlockID) voidvoidvoidvoidvoidvoidvoidvoidvoidvoidvoidsetSPKeyword(String s1) voidvoidsetToEmptyTokenInThisRange(int startPos, int range) voidintskipToNextNonEmptyToken(int i1) intskipToNonEmptyToken(int i1) voidstatic booleanstartsWith(String src, String pattern) voidstatic StringunknownMethod1(int i1) unknownMethod2(int i1) void
-
Field Details
-
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
-
breakBeforeONkeyword
-
alignEqualSigns
-
alignOperator
-
alignAliasName
-
alignCommaInList
-
alignLineComment
-
alignConcateOP
-
SPAlignDeclareVariable
-
rightAlignMasterKeywords
-
deleteComments
-
putCommentBetweenSlashStar
-
isRemoveUnnecessaryBracket
-
spaceAroundBracketOption
-
spaceAroundCommaOption
-
spaceAroundOperatorOption
-
smallSQLLen
-
additionalIndent
-
linebreakBeforeLineComment
-
linebreakBeforeBlockComment
-
colorRelatedB1
-
indentJoinStatement
-
indentOnStatement
-
escapeCharacter
-
keepEmptyLine
-
alignAliasNameAtPredefinedPos
-
alignAliasNamePos
-
replaceHostVariable
-
putHostVariableBetweenSlashStar
-
showPseudoCode
-
flexibleSpaceCalculation
-
keepFirstLineIndent
-
SPLinebreakBeforeStartParenthesisofCondition
-
SPLinebreakAfterStartParenthesisofCondition
-
SPLinebreakBeforeEndParenthesisofCondition
-
SPLinebreakAfterEndParenthesisofCondition
-
SPLinebreakBeforeANDORofCondition
-
SPLinebreakAfterANDORofCondition
-
SPIndentConditionInBracket
-
SPLinebreakBeforeStartParenthesisofParameters
-
SPLinebreakAfterStartParenthesisofParameters
-
SPIndentParameterInBracket
-
SPLinebreakBeforeEndParenthesisofParameters
-
enableNonFormat
-
nonFormatStartTag
-
nonFormatEndTag
-
linebreakBeforeStartParenthesisOfInsert
-
linebreakAfterStartParenthesisOfInsert
-
linebreakBeforeEndParenthesisOfInsert
-
linebreakAfterEndParenthesisOfInsert
-
indentColumnValueOfInsert
-
linebreakBeforeStartParenthesisOfCase
-
linebreakAfterStartParenthesisOfCase
-
linebreakBeforeEndParenthesisOfCase
-
linebreakAfterEndParenthesisOfCase
-
indentCaseInBracket
-
leftAlignBlockComment
-
indentBlockComment
-
moveComma2colsToTheLeft
-
alwaysPut1SpaceAfterComma
-
colorOfMasterKeyword
-
colorOfLineComment
-
colorOfBlockComment
-
colorOfCASEKeyword
-
colorOfLiteral
-
colorOfReservedWords
-
SPACE
- See Also:
-
FORM_FEED
- See Also:
-
BACKSPACE
- See Also:
-
CARRIAGE_RETURN
- See Also:
-
LINE_FEED
- See Also:
-
BACKSLASH
- See Also:
-
LEFT_PARENTHESIS
- See Also:
-
tokenSeparatorArray
-
c_char_exclamation
-
c_char_pound
-
c_char_percent
-
c_char_left_paren
-
c_char_right_paren
-
c_char_star
-
c_char_plus
-
c_char_coma
-
c_char_minus
-
c_char_dot
-
c_char_divide
-
c_char_colon
-
c_char_semicolon
-
c_char_less
-
c_char_equal
-
c_char_great
-
c_char_question_mark
-
c_char_at
-
c_char_vertical_bar
-
c_predefined_sep
-
encrypt_key
- See Also:
-
-
Constructor Details
-
SQLion
-
-
Method Details
-
decode
-
preProcess
-
internalDecrypt
-
decrypt
-
myDecrypt
-
encode
-
postProcess
-
internalEncrypt
-
encrypt
-
includeStr
-
replaceAll
-
myequals
-
equalsIgnoreCase
-
equalsToChar
-
equalsToChar
-
toLowerCase
-
startsWith
-
endsWith
-
myTryStrToInt
-
resetBlockIDToSameBracketsLevelNotStartWithMasterKey
-
synchronizeTokenBlockID
-
setSQLBlock
-
changePrecedingBlankFrom0to1
-
calculateSQLLen
-
combineSomeKeywordIntoOne
-
concateSpecialChar
-
concatTokens
-
detectAlias
-
detectColumn
-
setKeyword1
-
setTrueCanGetLineBreakAfter
-
setFalseCanGetLineBreakAfter
-
unknownMethod1
-
setSPKeyword
-
unknownMethod2
-
doFormatSpace
-
findMasterSQL
-
myStrToStrings
-
formatsqltext
-
getLastNoBracketnoCommentPos
-
initBlockRelatedArray
-
initStatementRelatedArray
-
initTokenArray
-
initArrayIndexByToken
-
isFunction
-
isInsertToken
-
isSelectToken
-
isUpdateToken
-
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
-
nextSolidToken
-
nextToken_nocomment_noempty_noleftbracket
-
posOfNextToken_nocomment_noempty_noleftbracket
-
posOfNextToken_nonComment_nonEmpty
-
posOfPrevToken_nonEmpty
-
prevToken_nonComment_noEmpty
-
prevToken_nonComment_noEmpty_returnPos
-
prevToken_nonComment_nonEmpty_nonLeftBracket
-
prevToken_nonEmpty
-
mergeSquareBracketIntoOneToken
-
setCaseSegment
-
processCaseRelated2
-
mergeSignOfComment
-
mergeDoubleQuoteIntoOneToken
-
mergeEscapeChar
-
mergeLiteralIntoOneToken
-
mergeQualifiedIdentifier
-
removeUnnecessaryBracket
-
resetSomeBracketArrayIfNotInASQL
-
selectStatementClauseScope
-
setBlockRelatedArray
-
setJoinScope
-
setNonFormatZoneSQLServer
-
setPrecedingTokenOfLeftBracket_masterkey
-
setToEmptyTokenInThisRange
-
skipToNextNonEmptyToken
-
skipToNonEmptyToken
-
SQLLevelAndScope
-
strOfNextToken_nonComment_nonEmtpy
-
checkOutputSQLBuffer
-
doAddProcessedTokenToStringBuilder
-
doAlign
-
doApplyDebugInstruction
-
doCalculateNbrOfPrecedingBlanks1
-
doCalculatePrecedingSpace1
-
doColorSQL
-
doIndentRelated
-
doModifyCase
-
prepareForNextToken
-
processDB2Linebreak
-
processLinebreak
-
processMySQLLinebreak
-
processSQLServerLinebreak
-
unknownMethod3
-
formatLinebreak
-
prevNonCommentToken
-
alignToken
public void alignToken(int pTokenPos, int pAlignType, String pDirection, String pIgnoreBracketLevel) -
initNextTokenOfThisAlignType
-
addFunctions
-
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
-
outputFormattedSQL
-
addToFormattedSQL
-
getFormattedSQL
-
initFormatOptions
-
main
-