Package | Description |
---|---|
gudusoft.gsqlparser |
Provides the class
gudusoft.gsqlparser.TGSqlParserr necessary to create a SQL Parser and the classes a SQL Parser uses
internally to handle different SQL dialects. |
gudusoft.gsqlparser.nodes |
Provides the classes represents various SQL query parse tree node.
|
gudusoft.gsqlparser.nodes.hive | |
gudusoft.gsqlparser.nodes.mdx | |
gudusoft.gsqlparser.nodes.mssql | |
gudusoft.gsqlparser.nodes.mysql | |
gudusoft.gsqlparser.nodes.oracle | |
gudusoft.gsqlparser.nodes.teradata | |
gudusoft.gsqlparser.scriptWriter | |
gudusoft.gsqlparser.stmt |
Provides the classes represent various SQL statements.
|
gudusoft.gsqlparser.stmt.hive | |
gudusoft.gsqlparser.stmt.mssql | |
gudusoft.gsqlparser.stmt.oracle | |
gudusoft.gsqlparser.stmt.teradata |
Modifier and Type | Field and Description |
---|---|
TSourceToken |
TSourceToken.alternativeToken
Deprecated.
since v1.8.8.0, use scriptWriter technology to modify the node
|
Modifier and Type | Method and Description |
---|---|
TSourceToken |
TSourceTokenList.get(int index) |
TSourceToken |
TSourceToken.getAlternativeToken()
Deprecated.
since v1.8.8.0, use scriptWriter technology to modify the node
If you find a start token of parse tree node has an alternativetoken, then text of this node should be modified by using TParseTreeNode.setString(String sqlSegment)
1. new string will be tokenized into a list of source tokens: stlist 2. link alternativetoken of start token of this node to the first token in stlist generated in step 1. 3. link back alternativetoken of last token in stlist to the last token of this node. |
TSourceToken |
TSourceToken.getLinkToken()
Gets the linked token.
|
TSourceToken |
TSourceToken.getReplaceToken()
Used in sql formatter package only
|
TSourceToken |
TSourceTokenList.next() |
TSourceToken |
TSourceToken.nextSolidToken()
The next token whose
tokentype is not ttreturn,ttwhitespace,ttsimplecomment and ttbracketedcomment. |
TSourceToken |
TSourceToken.nextSolidToken(boolean treatCommentAsSolidToken)
The next token whose
tokentype is not ttreturn,ttwhitespace,ttsimplecomment and ttbracketedcomment. |
TSourceToken |
TSourceTokenList.nextsolidtoken(int ptokenpos,
int pstep,
boolean pcmtissolidtoken)
Find solid token start from ptoken, distance is pstep.
|
TSourceToken |
TSourceTokenList.nextsolidtoken(TSourceToken ptoken,
int pstep,
boolean pcmtissolidtoken)
Find solid token start from ptoken, distance is pstep.
|
TSourceToken |
TSourceToken.nextToken() |
TSourceToken |
TSourceToken.prevSolidToken()
The previous token whose
tokentype is not ttreturn,ttwhitespace,ttsimplecomment and ttbracketedcomment. |
TSourceToken |
TSourceToken.prevSolidToken(boolean treatCommentAsSolidToken)
The previous token whose
tokentype is not ttreturn,ttwhitespace,ttsimplecomment and ttbracketedcomment |
TSourceToken |
TSourceToken.searchToken(int targetTokenCode,
int range)
Search a token before or after this token in the same source token list.
|
TSourceToken |
TSourceTokenList.searchToken(int targetTokenCode,
String targetTokenText,
TSourceToken startToken,
int range) |
TSourceToken |
TSourceToken.searchToken(String targetTokenText,
int range)
Search a token before or after this token in the same source token list.
|
TSourceToken |
TSourceToken.searchTokenAfterObjectName()
Search the first non-solid token after the next objectName.
|
TSourceToken |
TSourceTokenList.solidtokenbefore(int pStart)
Search solid token before pStart.
|
Modifier and Type | Method and Description |
---|---|
void |
TSourceTokenList.add(int index,
TSourceToken st) |
void |
TSourceTokenList.add(TSourceToken st) |
ESqlStatementType |
TSqlCmds.findmssqlcmdusedbyyacc(TSourceToken pcst) |
ESqlStatementType |
TSqlCmds.findsybasecmdusedbyyacc(TSourceToken pcst) |
int |
TSourceTokenList.indexOf(TSourceToken pst) |
TCustomSqlStatement |
TSqlCmds.issql(TSourceToken pcst,
EDbVendor pdbvendor,
EFindSqlStateType pstate,
TCustomSqlStatement psqlstatement) |
TSourceToken |
TSourceTokenList.nextsolidtoken(TSourceToken ptoken,
int pstep,
boolean pcmtissolidtoken)
Find solid token start from ptoken, distance is pstep.
|
boolean |
ITokenHandle.processToken(TSourceToken st) |
void |
TSourceTokenList.remove(TSourceToken st) |
TSourceToken |
TSourceTokenList.searchToken(int targetTokenCode,
String targetTokenText,
TSourceToken startToken,
int range) |
void |
TSourceToken.setAlternativeToken(TSourceToken alternativeToken)
Deprecated.
since v1.8.8.0, use scriptWriter technology to modify the node
|
void |
TSourceToken.setLinkToken(TSourceToken linkToken)
Create a link between two tokens.
|
void |
TSourceToken.setReplaceToken(TSourceToken replaceToken)
Used in sql formatter package only
|
Modifier and Type | Field and Description |
---|---|
TSourceToken |
TColumnReference.sourcetoken |
TSourceToken |
TTableReference.sourcetoken |
TSourceToken |
TDummy.st1 |
TSourceToken |
TDummy.st2 |
TSourceToken |
TDummy.st3 |
Modifier and Type | Method and Description |
---|---|
TSourceToken |
TExpression.getAndOrTokenBeforeExpr() |
TSourceToken |
TAliasClause.getAsToken() |
TSourceToken |
TObjectName.getAtsign() |
TSourceToken |
TConstant.getBind1() |
TSourceToken |
TConstant.getBind2() |
TSourceToken |
TTrimArgument.getBoth_trailing_leading() |
TSourceToken |
TGroupBy.getBY() |
TSourceToken |
TCollectStatisticsSqlNode.getColumn_or_index() |
TSourceToken |
TObjectName.getColumnToken()
It's the same as
TObjectName.getPartToken() if TObjectName.getDbObjectType() is EDbObjectType.column |
TSourceToken |
TObjectName.getCommentString() |
TSourceToken |
TExpression.getComparisonOperator() |
TSourceToken |
TCreateDatabaseSqlNode.getDatabase() |
TSourceToken |
TObjectName.getDatabaseToken()
The database part of this objectName: [server.][database.][schema.]object
|
TSourceToken |
TDeleteSqlNode.getDeleteToken() |
TSourceToken |
TDescribeSqlNode.getDescToken() |
TSourceToken |
TDropSchemaSqlNode.getDropBehavior() |
TSourceToken |
TParseTreeNode.getEndToken()
The last token of the node
|
TSourceToken |
TParseTreeNodeList.getEndToken() |
TSourceToken |
TIndirection.getEndToken() |
TSourceToken |
TResultColumnList.getEndToken() |
TSourceToken |
TPTNodeList.getEndToken() |
TSourceToken |
TObjectName.getExclamationmark() |
TSourceToken |
TFunctionCall.getExtract_time_token()
one of the YEAR/MONTH/DAY, HOUR/MINUTE/SECOND keywords in extract function
|
TSourceToken |
TIntoClause.getFilename() |
TSourceToken |
TKeepDenseRankClause.getFirstLast() |
TSourceToken |
TExpression.getFractionalSecondsPrecision() |
TSourceToken |
TConstant.getFractionalSecondsPrecision()
the number of digits in the fractional part of the SECOND datetime field in a interval day to second constant.
|
TSourceToken |
TGroupBy.getGROUP() |
TSourceToken |
TGroupBy.getHAVING() |
TSourceToken |
TInsertSqlNode.getIgnore() |
TSourceToken |
TConstant.getIndicator() |
TSourceToken |
TInsertSqlNode.getInsertToken() |
TSourceToken |
TExpression.getLeadingPrecision() |
TSourceToken |
TConstant.getLeadingPrecision()
the maximum number of digits in the leading field of a interval constant.
|
TSourceToken |
TExecuteAsSqlNode.getLoginToken() |
TSourceToken |
TObjectName.getMethodToken() |
TSourceToken |
TAlterTableOption.getMySQLIndexTypeToken()
MySQL, unique, fulltext or spatial keyword used in add key/index clause when option type is
EAlterTableOptionType.AddConstraintIndex |
TSourceToken |
TExecuteAsSqlNode.getNameToken() |
TSourceToken |
TExpression.getNotToken() |
TSourceToken |
TObjectName.getObjectToken()
The object part of this objectName such as table name, view name.
|
TSourceToken |
TColumnReference.getObjectToken() |
TSourceToken |
TRelationExpr.getOnly() |
TSourceToken |
TExpression.getOperatorToken()
Operator token used in expression such as +,-,*,/ and etc
|
TSourceToken |
TObjectName.getPackageToken()
Oracle package name
|
TSourceToken |
TObjectName.getPartToken()
The column name of this objectName if
TObjectName.getDbObjectType() is EDbObjectType.column . |
TSourceToken |
TTableSample.getPercent() |
TSourceToken |
TInsertSqlNode.getPriority_delayed() |
TSourceToken |
TObjectName.getPropertyToken() |
TSourceToken |
TExpression.getQuantifier()
one of the following quantifier keywords: SOME, ANY, ALL
|
TSourceToken |
TObjectName.getSchemaToken()
The schema name of this objectName.
|
TSourceToken |
TSelectSqlNode.getSelectToken() |
TSourceToken |
TObjectName.getServerToken()
The server part of this objectName: [server.][database.][schema.]object
|
TSourceToken |
TConstant.getSign()
The '+' or '-' before this constant.
|
TSourceToken |
TObjectName.getSortType()
When this object is column in primary key(column,...), unique key(column,...) in sql server
there maybe sort information like column asc, column desc
this token represents for ASC, DESC if specified.
|
TSourceToken |
TExpression.getSourcetokenOperand() |
TSourceToken |
TParseTreeNode.getStartToken()
The first token in this parse tree node
|
TSourceToken |
TParseTreeNodeList.getStartToken() |
TSourceToken |
TIndirection.getStartToken() |
TSourceToken |
TResultColumnList.getStartToken()
In teradata, the whole result column can be null, so this result column
should be ingored when get start token in result column list.
|
TSourceToken |
TPTNodeList.getStartToken() |
TSourceToken |
TCreateViewSqlNode.getStForce() |
TSourceToken |
TCreateViewSqlNode.getStReplace() |
TSourceToken |
TObjectName.getTableToken()
The table name of this objectName, it's the same value as
TObjectName.getObjectToken() if TObjectName.getDbObjectType()
is EDbObjectType.table |
TSourceToken |
TOpenDatasource.getTableToken() |
TSourceToken |
TMySQLIndexStorageType.getTypeToken() |
TSourceToken |
TUpdateSqlNode.getUpdateToken() |
TSourceToken |
TConstant.getValueToken()
The value of this constant represented by a source token.
|
TSourceToken |
TColumnDefinition.getXmlTableColumnPath()
Oracle, path of xml table column
|
TSourceToken |
TXmlTableParameter.getXQueryString() |
Modifier and Type | Method and Description |
---|---|
TColumnReference |
TNodeFactory.createColumnReference(TSourceToken objectname) |
TParseTreeNode |
TNodeFactory.createConstant(TSourceToken st,
ENodeType ent) |
TObjectName |
TNodeFactory.createObjectName(TSourceToken schema,
TSourceToken object,
TSourceToken part)
create a database object with schema, object and part name, type of this object will be
determined later in the context where it appears.
|
TObjectName |
TNodeFactory.createObjectNameWithObject(TSourceToken object) |
TObjectName |
TNodeFactory.createObjectNameWithPart(TSourceToken part) |
TObjectName |
TNodeFactory.createObjectNameWithPartAndObject(TSourceToken object,
TSourceToken part) |
TParseTreeNode |
TNodeFactory.createSimpleExpression(TSourceToken st) |
static EComparisonType |
TExpression.getComparisonType(TSourceToken comparisonOperator) |
boolean |
TObjectName.isAttributeNameInObjectName(TSourceToken leftparen,
TSourceToken rightparen) |
protected int |
TParseTreeNode.removeAllMyTokensFromTokenList(TSourceToken additionalToken)
Deprecated.
since v1.8.8.0, use scriptWriter technology to modify the node
|
void |
TAliasClause.setAsToken(TSourceToken asToken) |
void |
TObjectName.setAtsign(TSourceToken atsign) |
void |
TConstant.setBind1(TSourceToken bind1) |
void |
TConstant.setBind2(TSourceToken bind2) |
void |
TGroupBy.setBY(TSourceToken BY) |
void |
TTypeName.setCharsetNameByToken(TSourceToken st) |
void |
TTypeName.setCharUnit(TSourceToken st) |
void |
TConstraint.setClusteredToken(TSourceToken clusteredToken) |
void |
TCreateIndexSqlNode.setClusteredToken(TSourceToken st) |
void |
TObjectName.setCommentString(TSourceToken commentString) |
void |
TExpression.setComparisonOperator(TSourceToken comparisonOperator) |
void |
TCreateDatabaseSqlNode.setDatabase(TSourceToken database) |
void |
TObjectName.setDatabaseToken(TSourceToken databaseToken) |
void |
TOpenDatasource.setDatabaseToken(TSourceToken databaseToken) |
void |
TTypeName.setDataTypeByToken(TSourceToken st) |
void |
TDeleteSqlNode.setDeleteToken(TSourceToken deleteToken) |
void |
TDescribeSqlNode.setDescToken(TSourceToken descToken) |
void |
TDropTableSqlNode.setDropBehavior(TSourceToken st) |
void |
TDropSchemaSqlNode.setDropBehavior(TSourceToken dropBehavior) |
void |
TAlterTableOption.setDropRestrictType(TSourceToken st) |
void |
TParseTreeNode.setEndToken(TSourceToken endToken) |
void |
TObjectName.setExclamationmark(TSourceToken exclamationmark) |
void |
TFunctionCall.setExtract_time_token(TSourceToken extract_time_token)
set one of the YEAR/MONTH/DAY, HOUR/MINUTE/SECOND keyword in extract function
|
void |
TExpression.setFractionalSecondsPrecision(TSourceToken fractionalSecondsPrecision) |
void |
TConstant.setFractionalSecondsPrecision(TSourceToken fractionalSecondsPrecision)
set the fractional precision which is the number of digits in the fractional part of the SECOND datetime field
in a interval day to second constant.
|
void |
TGroupBy.setGROUP(TSourceToken GROUP) |
void |
TGroupBy.setHAVING(TSourceToken HAVING) |
void |
TInsertSqlNode.setIgnore(TSourceToken ignore) |
void |
TCreateIndexSqlNode.setIndexTypeViaToken(TSourceToken st) |
void |
TConstant.setIndicator(TSourceToken indicator) |
void |
TInsertSqlNode.setInsertAllOrFirst(TSourceToken st) |
void |
TInsertSqlNode.setInsertToken(TSourceToken insertToken) |
void |
TExpression.setLeadingPrecision(TSourceToken leadingPrecision) |
void |
TConstant.setLeadingPrecision(TSourceToken leadingPrecision)
set the precision which is the maximum number of digits in the leading field of a interval constant.
|
void |
TObjectName.setMethodToken(TSourceToken methodToken) |
void |
TAlterTableOption.setMySQLIndexTypeToken(TSourceToken mySQLIndexTypeToken) |
void |
TExpression.setNotToken(TSourceToken notToken) |
void |
TObjectName.setObjectToken(TSourceToken objectToken) |
void |
TRelationExpr.setOnly(TSourceToken only) |
void |
TExpression.setOperatorToken(TSourceToken operatorToken) |
void |
TObjectName.setPackageToken(TSourceToken packageToken) |
void |
TObjectName.setPartToken(TSourceToken partToken) |
void |
TInsertSqlNode.setPriority_delayed(TSourceToken priority_delayed) |
void |
TObjectName.setPropertyToken(TSourceToken propertyToken) |
void |
TExpression.setQuantifier(TSourceToken quantifier) |
void |
TObjectName.setSchemaToken(TSourceToken schemaToken) |
void |
TOpenDatasource.setSchemaToken(TSourceToken schemaToken) |
void |
TSelectSqlNode.setSelectToken(TSourceToken selectToken) |
void |
TObjectName.setServerToken(TSourceToken serverToken) |
void |
TConstant.setSign(TSourceToken sign)
The '+' or '-' before this constant.
|
void |
TObjectName.setSortType(TSourceToken sortType) |
void |
TOrderByItem.setSortTypeByToken(TSourceToken st) |
void |
TExpression.setSourcetokenOperand(TSourceToken sourcetokenOperand) |
void |
TParseTreeNode.setStartToken(TSourceToken startToken) |
void |
TCreateViewSqlNode.setStForce(TSourceToken stForce) |
void |
TCreateViewSqlNode.setStReplace(TSourceToken stReplace) |
void |
TCreateTableSqlNode.setTableKindByToken(TSourceToken st) |
void |
TFromTable.setTableonly(TSourceToken tableonly) |
void |
TOpenDatasource.setTableToken(TSourceToken tableToken) |
void |
TUpdateSqlNode.setUpdateToken(TSourceToken updateToken) |
void |
TConstant.setValueToken(TSourceToken valueToken)
set value of this constant
|
void |
TTypeName.setVarying(TSourceToken st) |
void |
TColumnDefinition.setXmlTableColumnPath(TSourceToken xmlTableColumnPath) |
Constructor and Description |
---|
TConstant(ELiteralType literalType,
TSourceToken valueToken)
Class constructor, set the type and value of this constant when creating a new instance of the constant
|
TConstant(ELiteralType literalType,
TSourceToken valueToken,
EIntervalType intervalType)
Class constructor, set the type and value of this constant when creating a new instance of the constant.
|
TObjectName(TSourceToken token,
EDbObjectType dbObjectType)
Class constructor specifying object name and object type.
|
TObjectName(TSourceToken pObjectToken,
TSourceToken pPartToken,
EDbObjectType dbObjectType)
Class constructor specifying object, part name and object type.
|
Modifier and Type | Method and Description |
---|---|
TSourceToken |
THiveDropDBSqlNode.getDatabaseToken() |
TSourceToken |
THiveTerminatedIdentifier.getEscapeString() |
TSourceToken |
THiveKeyValueProperty.getKeyString() |
TSourceToken |
THiveDropDBSqlNode.getRestrictCascadeToken() |
TSourceToken |
THiveRecordWriter.getStringLiteral() |
TSourceToken |
THiveRecordReader.getStringLiteral() |
TSourceToken |
THiveGrantSqlNode.getTableToken() |
TSourceToken |
THiveShowGrantSqlNode.getTableToken() |
TSourceToken |
THiveTerminatedIdentifier.getTerminateString() |
TSourceToken |
THiveTransformClause.getUsingString() |
TSourceToken |
THiveKeyValueProperty.getValueString() |
Modifier and Type | Method and Description |
---|---|
void |
THiveDescribeSqlNode.setDescOption(TSourceToken token) |
Modifier and Type | Method and Description |
---|---|
TSourceToken |
TMdxFloatConstNode.getDoubleToken() |
TSourceToken |
TMdxIntegerConstNode.getIntToken() |
TSourceToken |
TMdxAxisNode.getName_OR_Number()
Depreciated since v1.9.8.0, replaced by
TMdxAxisNode.getAxis() |
TSourceToken |
TMdxUnaryOpNode.getOperator() |
TSourceToken |
TMdxBinOpNode.getOperator() |
TSourceToken |
TMdxStringConstNode.getStringToken() |
Modifier and Type | Method and Description |
---|---|
TSourceToken |
TMssqlCreateTriggerUpdateColumn.getAnd_or_nullToken() |
TSourceToken |
TMssqlCreateTriggerUpdateColumn.getNotToken() |
Modifier and Type | Method and Description |
---|---|
void |
TMssqlCreateTypeSqlNode.setNullNotNull(TSourceToken st) |
Modifier and Type | Method and Description |
---|---|
TSourceToken |
TGroupConcatParam.getSeparatorToken() |
Modifier and Type | Method and Description |
---|---|
void |
TGroupConcatParam.setSeparatorToken(TSourceToken separatorToken) |
Modifier and Type | Method and Description |
---|---|
TSourceToken |
TOracleCacheClause.getCacheToken() |
TSourceToken |
TSegmentAttributesItem.getLoggingToken()
Depreciated since v1.9.5.9.
|
TSourceToken |
TStorageItem.getNullToken() |
TSourceToken |
TErrorLoggingClause.getRejectLimitToken() |
TSourceToken |
TSizeClause.getSizeUnit() |
TSourceToken |
TStorageItem.getUnlimitedToken() |
Modifier and Type | Method and Description |
---|---|
TSourceToken |
TTeradataLockClause.getDatabase_table_view() |
TSourceToken |
TTeradataLockClause.getLockMode() |
Modifier and Type | Method and Description |
---|---|
void |
TScriptWriter.addToken(TSourceToken st) |
Modifier and Type | Method and Description |
---|---|
TSourceToken |
TCreateDatabaseSqlStatement.getDatabase() |
TSourceToken |
TDeleteSqlStatement.getDeleteToken()
DELETE keyword of the delete statement.
|
TSourceToken |
TDescribeStmt.getDescToken() |
TSourceToken |
TDropSchemaSqlStatement.getDropBehavior() |
TSourceToken |
TInsertSqlStatement.getIgnore()
IGNORE keyword used in the insert statement.
|
TSourceToken |
TInsertSqlStatement.getInsertToken()
INSERT keyword
|
TSourceToken |
TInsertSqlStatement.getPriority_delayed()
DELAY, LOW_PRIORITY, HIGH_PRIORITY keyword used in insert statement.
|
TSourceToken |
TSelectSqlStatement.getSelectToken() |
TSourceToken |
TCreateViewSqlStatement.getStForce() |
TSourceToken |
TCreateViewSqlStatement.getStReplace() |
TSourceToken |
TUpdateSqlStatement.getUpdateToken()
UPDATE keyword
|
Modifier and Type | Method and Description |
---|---|
void |
TDeleteSqlStatement.setDeleteToken(TSourceToken deleteToken) |
void |
TInsertSqlStatement.setInsertToken(TSourceToken insertToken) |
void |
TSelectSqlStatement.setSelectToken(TSourceToken selectToken) |
void |
TCreateViewSqlStatement.setStForce(TSourceToken stForce) |
void |
TCreateViewSqlStatement.setStReplace(TSourceToken stReplace) |
void |
TUpdateSqlStatement.setUpdateToken(TSourceToken updateToken) |
Modifier and Type | Method and Description |
---|---|
TSourceToken |
THiveDropDatabase.getDatabaseToken() |
TSourceToken |
THiveDropDatabase.getRestrictCascadeToken() |
TSourceToken |
THiveShowGrant.getTableToken() |
TSourceToken |
THiveRevoke.getTableToken() |
TSourceToken |
THiveGrant.getTableToken() |
Modifier and Type | Method and Description |
---|---|
TSourceToken |
TMssqlCommit.getTrans_or_work() |
TSourceToken |
TMssqlRollback.getTrans_or_work() |
TSourceToken |
TMssqlSaveTran.getTrans_or_work() |
Modifier and Type | Method and Description |
---|---|
static ESqlPlusCmd |
TSqlplusCmdStatement.searchCmd(String cmdStr,
TSourceToken nextToken) |
Modifier and Type | Method and Description |
---|---|
TSourceToken |
TTeradataLock.getDatabase_table_view() |
TSourceToken |
TTeradataLock.getLockMode() |
Copyright © 2019. All rights reserved.