Package gudusoft.gsqlparser.pp.stmtformatter

Class SQLion

Object

gudusoft.gsqlparser.pp.stmtformatter.SQLion

public class SQLion
extends Object

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static class	SQLion.TStringTokenizer
static class	SQLion.TTextTokenizer

Field Summary

Fields

Modifier and Type	Field	Description
int	additionalIndent
boolean	alignAliasName
boolean	alignAliasNameAtPredefinedPos
int	alignAliasNamePos
boolean	alignCommaInList
boolean	alignConcateOP
boolean	alignEqualSigns
boolean	alignLineComment
boolean	alignOperator
boolean	alwaysPut1SpaceAfterComma
static final char	BACKSLASH
static final char	BACKSPACE
String	blockCommentStr1
boolean	breakAfterMasterKeyword
boolean	breakBeforeONkeyword
boolean	breaksAroundUnionIntersect
static final String	c_char_at
static final String	c_char_colon
static final String	c_char_coma
static final String	c_char_divide
static final String	c_char_dot
static final String	c_char_equal
static final String	c_char_exclamation
static final String	c_char_great
static final String	c_char_left_paren
static final String	c_char_less
static final String	c_char_minus
static final String	c_char_percent
static final String	c_char_plus
static final String	c_char_pound
static final String	c_char_question_mark
static final String	c_char_right_paren
static final String	c_char_semicolon
static final String	c_char_star
static final String	c_char_vertical_bar
static final String	c_predefined_sep
static final 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 final int	encrypt_key
boolean	escapeCharacter
boolean	findUnnecessaryBracket
boolean	flexibleSpaceCalculation
static final 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 final char	LEFT_PARENTHESIS
boolean	leftAlignBlockComment
static final 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 final 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 final String[]	tokenSeparatorArray
boolean	useTab
int	valuesPerLineForINLists
boolean	wholeLower
boolean	wholeUpper

Constructor Summary

Constructors

Constructor	Description
SQLion(EDbVendor vendor, GFmtOpt option)

Method Summary

Modifier and Type	Method	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)
String	prevToken_nonComment_noEmpty(int i1)
int	prevToken_nonComment_noEmpty_returnPos(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 java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Details

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 Details

SQLion

public SQLion(EDbVendor vendor,
 GFmtOpt option)

Method Details

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)