Uses of Class
gudusoft.gsqlparser.nodes.TTable
Packages that use TTable
Package
Description
Provides the class
TGSqlParser necessary to create a SQL Parser and the classes a SQL Parser uses
internally to handle different SQL dialects.Provides the classes represents various SQL query parse tree node.
Provides the classes represent various SQL statements.
-
Uses of TTable in gudusoft.gsqlparser
Fields in gudusoft.gsqlparser declared as TTableMethods in gudusoft.gsqlparser that return TTableModifier and TypeMethodDescriptionTCustomSqlStatement.analyzeFromTable(TFromTable pfromTable, Boolean addToTableList) TCustomSqlStatement.analyzeFromTable(TFromTable pfromTable, Boolean addToTableList, ESqlClause pLocation) TCustomSqlStatement.analyzeTablename(TObjectName tableName) TCustomSqlStatement.findTable(ETableEffectType[] tableEffectTypes) TCustomSqlStatement.getFirstPhysicalTable()TCustomSqlStatement.getFromSourceTable()This is table in from clause if only one table is listed in the from clause, If more than one table is listed in from clause, please checkTCustomSqlStatement.getFromSourceJoin()instead.TAttributeNode.getTable_ref()TCustomSqlStatement.getTargetTable()target table in the delete/insert/update/create table statement.Methods in gudusoft.gsqlparser that return types with arguments of type TTableModifier and TypeMethodDescriptionTCustomSqlStatement.getRelations()Relations that used in from clause of select statement.Methods in gudusoft.gsqlparser with parameters of type TTableModifier and TypeMethodDescriptionvoidTCustomSqlStatement.addToTables(TTable pTable) TCustomSqlStatement.getColumnsInTable(TTable lcTable) Deprecated.protected booleanTCustomSqlStatement.isTableACTE(TTable pTable) voidTCustomSqlStatement.setTargetTable(TTable targetTable) Constructors in gudusoft.gsqlparser with parameters of type TTableModifierConstructorDescriptionTAttributeNode(String n, TTable table) TAttributeNode(String n, TTable table, TColumnDefinition columnDef, TResultColumn resultColumn) TAttributeNode(String n, TTable table, TResultColumn attribute) TAttributeNode(String n, TTable table, TResultColumn attribute, int index) TAttributeNode(String n, TTable table, TSQLColumn columnDef) TAttributeNode(String n, TTable table, TSQLColumn columnDef, TResultColumn attribute) TAttributeNode(String n, TTable table, TSQLColumn columnDef, TResultColumn attribute, int index) -
Uses of TTable in gudusoft.gsqlparser.dlineage
Methods in gudusoft.gsqlparser.dlineage with parameters of type TTableModifier and TypeMethodDescriptionprotected voidDataFlowAnalyzer.analyzeTableSubquery(TTable table) -
Uses of TTable in gudusoft.gsqlparser.dlineage.dataflow.model
Methods in gudusoft.gsqlparser.dlineage.dataflow.model that return TTableModifier and TypeMethodDescriptionModelBindingManager.getTable(TCustomSqlStatement stmt, TObjectName column) ModelBindingManager.getTableFromColumn(TObjectName column) QueryTable.getTableObject()Table.getTableObject()ModelBindingManager.guessTable(TCustomSqlStatement stmt, TObjectName column) Methods in gudusoft.gsqlparser.dlineage.dataflow.model that return types with arguments of type TTableModifier and TypeMethodDescriptionModelBindingManager.getBaseTables()ModelBindingManager.getTableWithSelectSetResultSets()Methods in gudusoft.gsqlparser.dlineage.dataflow.model with parameters of type TTableModifier and TypeMethodDescriptionvoidModelBindingManager.bindCreateModel(TTable table, Table tableModel) ModelFactory.createJsonTable(TTable table) ModelFactory.createQueryTable(TTable table) ModelFactory.createTable(TTable table) ModelFactory.createTable(TTable table, TObjectName tableBinding) ModelFactory.createTableFromCreateDDL(TTable table, boolean fromDDL) ModelFactory.createTableFromCreateDDL(TTable table, boolean fromDDL, String tableName) ModelFactory.createTriggerOnTable(TTable table) ModelBindingManager.getCreateModel(TTable table) ModelBindingManager.getCreateTable(TTable table) ModelBindingManager.getTableColumns(TTable table) protected voidModelBindingManager.updateTableAliasMap(TTable table) Constructors in gudusoft.gsqlparser.dlineage.dataflow.model with parameters of type TTable -
Uses of TTable in gudusoft.gsqlparser.nodes
Subclasses of TTable in gudusoft.gsqlparser.nodesModifier and TypeClassDescriptionclassA common table expression permits defining a result table with a table-name that can be specified as a table name in any FROM clause of the fullselect that follows.Fields in gudusoft.gsqlparser.nodes declared as TTableMethods in gudusoft.gsqlparser.nodes that return TTableModifier and TypeMethodDescriptionTLateralView.createATable(TCustomSqlStatement sql) TCreateTableSqlNode.getAsTable()TJoinExpr.getLeftTable()TTable.getLinkTable()TCreateTriggerSqlNode.getOnTable()Deprecated.As of v2.0.1.0, useTCreateTriggerSqlNode.getTriggeringClause()insteadTColumnWithSortOrder.getOwnerTable()TPivotClause.getPivotTable()TAlterTableOption.getReferencedTable()referenced table in foreign key clauseTJoinExpr.getRightTable()TObjectName.getSourceTable()Get the immediate source table where this column is visible in the current scope.TTable.getSourceTableOfPivot()TCreateTableSqlNode.getTable()TInsertIntoValue.getTable()TJoin.getTable()Deprecated.TJoinItem.getTable()Deprecated.Valid whenTJoinItem.getKind()=TBaseType.join_source_table, means this joinitem start with a table.TTableList.getTable(int position) TCaseJoinItem.getTableReference()TPivotedTable.getTableSource()Methods in gudusoft.gsqlparser.nodes that return types with arguments of type TTableModifier and TypeMethodDescriptionTObjectName.getCandidateTableDdlStatus()Get DDL verification status for all candidate tables.TObjectName.getCandidateTables2()Get all candidate tables (for ambiguous columns)TFromClause.getRelations()TPivotedTable.getRelations()TObjectName.getSourceTableList()source table list for star column,
select * from emp,dept
* column will be list to both emp and dept table.Methods in gudusoft.gsqlparser.nodes with parameters of type TTableModifier and TypeMethodDescriptionvoidintTObjectName.getDdlVerificationStatus(TTable table) Check DDL verification status for a candidate table.voidTUnpivotInClause.linkColumnToPivotSourceTable(TTable table) voidTPivotInClause.linkColumnToTable(TTable table, TSQLTable sqlTable) voidvoidbooleanTObjectName.resolveWithThisTable(TTable pTable) This column must be in this syntax: table.column, otherwise, this method always return false.booleanTCTE.searchColumnInResultSet(TCustomSqlStatement pSql, TTable pTable, TObjectName pColumn, boolean pMustIn) voidTJoinExpr.setLeftTable(TTable leftTable) voidTTable.setLinkTable(TTable linkTable) voidTColumnWithSortOrder.setOwnerTable(TTable ownerTable) voidTTableHint.setOwnerTable(TTable ownerTable) voidTJoinExpr.setRightTable(TTable rightTable) voidTObjectName.setSourceTable(TTable sourceTable) Set the table this column belongs to.voidTObjectName.setSourceTableBySQLResolver(TCustomSqlStatement sqlStatement, TAttributeNode attributeNode, TTable newSourceTable) voidTTable.setSourceTableOfPivot(TTable sourceTableOfPivot) voidvoidDeprecated.voidDeprecated.voidTPivotedTable.setTableSource(TTable tableSource) Constructor parameters in gudusoft.gsqlparser.nodes with type arguments of type TTable -
Uses of TTable in gudusoft.gsqlparser.nodes.dax
Methods in gudusoft.gsqlparser.nodes.dax that return TTableMethods in gudusoft.gsqlparser.nodes.dax with parameters of type TTableModifier and TypeMethodDescriptionvoidTDaxFunction.setDefaultTable(TTable defaultTable) voidTDaxFunction.setReturnTable(TTable returnTable) -
Uses of TTable in gudusoft.gsqlparser.nodes.functions
Methods in gudusoft.gsqlparser.nodes.functions that return TTable -
Uses of TTable in gudusoft.gsqlparser.nodes.teradata
Methods in gudusoft.gsqlparser.nodes.teradata that return TTableModifier and TypeMethodDescriptionTTDUnpivot.getTdUnpivotOutputTable()TTDUnpivot.getUnPivotTable()Methods in gudusoft.gsqlparser.nodes.teradata with parameters of type TTableModifier and TypeMethodDescriptionvoidTTDUnpivot.setTdUnpivotOutputTable(TTable table) Set the TD_UNPIVOT output table. -
Uses of TTable in gudusoft.gsqlparser.resolver
Methods in gudusoft.gsqlparser.resolver with parameters of type TTableModifier and TypeMethodDescriptionvoidvoidvoidvoidvoid处理表节点,根据表类型收集相应的属性。 这是属性收集的核心方法。voidMethod parameters in gudusoft.gsqlparser.resolver with type arguments of type TTableModifier and TypeMethodDescriptionvoidTAttributeResolver.resolveInThoseRelations(TObjectName attribute, ArrayList<TTable> relations) -
Uses of TTable in gudusoft.gsqlparser.resolver2
Methods in gudusoft.gsqlparser.resolver2 that return TTableModifier and TypeMethodDescriptionScopeBuildResult.getUsingColumnLeftTable(TObjectName column) Get the left-side table for a USING column.ScopeBuildResult.getUsingColumnRightTable(TObjectName column) Get the right-side table for a USING column.Methods in gudusoft.gsqlparser.resolver2 that return types with arguments of type TTableModifier and TypeMethodDescriptionScopeBuildResult.getCTASTargetTables()Get all CTAS target tablesScopeBuildResult.getTableToNamespaceMap()Get all TTable -> INamespace mappingsScopeBuildResult.getUsingColumnToLeftTable()Get all USING column -> left-side table mappingsScopeBuilder.getUsingColumnToRightTable()Get the mapping of USING columns to their right-side tables.ScopeBuildResult.getUsingColumnToRightTable()Get all USING column -> right-side table mappingsScopeBuilder.getVirtualTriggerTables()Get the set of virtual trigger tables (deleted/inserted in SQL Server triggers).TSQLResolver2.getVirtualTriggerTables()Get the set of virtual trigger tables (deleted/inserted in SQL Server triggers).Methods in gudusoft.gsqlparser.resolver2 with parameters of type TTableModifier and TypeMethodDescriptionScopeBuildResult.getNamespaceForTable(TTable table) Get the namespace for a specific table.booleanScopeBuildResult.isCTASTargetTable(TTable table) Check if a table is a CTAS target table (table being created by CREATE TABLE AS SELECT).voidvoidConstructor parameters in gudusoft.gsqlparser.resolver2 with type arguments of type TTableModifierConstructorDescriptionScopeBuildResult(GlobalScope globalScope, Map<TObjectName, IScope> columnToScopeMap, List<TObjectName> allColumnReferences, Map<TSelectSqlStatement, SelectScope> statementScopeMap, Map<TObjectName, TTable> usingColumnToRightTable, Map<TObjectName, TTable> usingColumnToLeftTable, Map<TTable, INamespace> tableToNamespaceMap, Set<TTable> ctasTargetTables) -
Uses of TTable in gudusoft.gsqlparser.resolver2.format
Methods in gudusoft.gsqlparser.resolver2.format with parameters of type TTableModifier and TypeMethodDescriptionDisplayNameNormalizer.getTableDisplayName(TTable table) Get a display name for a table, handling various TTable configurations.DisplayNameNormalizer.normalizeTableName(TTable table) Normalize a table name for display. -
Uses of TTable in gudusoft.gsqlparser.resolver2.inference
Methods in gudusoft.gsqlparser.resolver2.inference with parameters of type TTableModifier and TypeMethodDescriptionInferenceEngine.createInferredColumnSource(String tableName, String columnName, TTable table) Create an inferred ColumnSource for a table.column. -
Uses of TTable in gudusoft.gsqlparser.resolver2.model
Methods in gudusoft.gsqlparser.resolver2.model that return TTableModifier and TypeMethodDescriptionFromScopeIndex.findTableByQualifier(String qualifier) Gets the TTable from a ScopeChild by qualifier, if the namespace represents a table.ColumnSource.getFinalTable()Get the final physical table this column originates from after tracing through all subqueries and CTEs.ColumnSource.getOverrideTable()Get the override table, if set.Methods in gudusoft.gsqlparser.resolver2.model that return types with arguments of type TTableModifier and TypeMethodDescriptionColumnSource.getAllFinalTables()Get all physical tables that this column might originate from.ResolutionContext.getAllReferencedTables()Get all tables that have been referencedColumnSource.getCandidateTableDdlStatus()Get DDL verification status for all candidate tables.ColumnSource.getCandidateTables()Get the candidate tables for ambiguous columns.Methods in gudusoft.gsqlparser.resolver2.model with parameters of type TTableModifier and TypeMethodDescriptionstatic intColumnSource.getDdlVerificationStatus(TTable table, String columnName) Check DDL verification status for a candidate table.ResolutionContext.getReferencesTo(TTable table) Get all column references to a specific table.ResolutionContext.getReferencesTo(TTable table, String columnName) Get all column references to a specific table.column.intResolutionContext.getTableReferenceCount(TTable table) Get reference count for a specific tablestatic booleanColumnSource.hasTableDdl(TTable table) Check if a table has DDL metadata available (from CREATE TABLE in same script).static booleanColumnSource.isColumnInTableDdl(TTable table, String columnName) Check if a column exists in a table's DDL definition.Resolve a TTable's name to a fully qualified name.Method parameters in gudusoft.gsqlparser.resolver2.model with type arguments of type TTableModifier and TypeMethodDescriptionColumnSource.withCandidateTables(List<TTable> candidates) Creates a copy with candidate tables.Constructors in gudusoft.gsqlparser.resolver2.model with parameters of type TTableModifierConstructorDescriptionColumnSource(INamespace sourceNamespace, String exposedName, TParseTreeNode definitionNode, double confidence, String evidence, TTable overrideTable) ColumnSource(INamespace sourceNamespace, String exposedName, TParseTreeNode definitionNode, double confidence, String evidence, TTable overrideTable, List<TTable> candidateTables) ColumnSource(INamespace sourceNamespace, String exposedName, TParseTreeNode definitionNode, double confidence, String evidence, TTable overrideTable, List<TTable> candidateTables, ResolutionEvidence evidenceDetail) Full constructor with all fields including ResolutionEvidence.ColumnSource(INamespace sourceNamespace, String exposedName, TParseTreeNode definitionNode, double confidence, String evidence, TTable overrideTable, List<TTable> candidateTables, ResolutionEvidence evidenceDetail, FieldPath fieldPath) Full constructor with all fields including ResolutionEvidence and FieldPath.ColumnSource(INamespace sourceNamespace, String exposedName, TParseTreeNode definitionNode, ResolutionEvidence evidenceDetail, TTable overrideTable) Constructor with ResolutionEvidence and override table.Constructor parameters in gudusoft.gsqlparser.resolver2.model with type arguments of type TTableModifierConstructorDescriptionColumnSource(INamespace sourceNamespace, String exposedName, TParseTreeNode definitionNode, double confidence, String evidence, TTable overrideTable, List<TTable> candidateTables) ColumnSource(INamespace sourceNamespace, String exposedName, TParseTreeNode definitionNode, double confidence, String evidence, TTable overrideTable, List<TTable> candidateTables, ResolutionEvidence evidenceDetail) Full constructor with all fields including ResolutionEvidence.ColumnSource(INamespace sourceNamespace, String exposedName, TParseTreeNode definitionNode, double confidence, String evidence, TTable overrideTable, List<TTable> candidateTables, ResolutionEvidence evidenceDetail, FieldPath fieldPath) Full constructor with all fields including ResolutionEvidence and FieldPath. -
Uses of TTable in gudusoft.gsqlparser.resolver2.namespace
Methods in gudusoft.gsqlparser.resolver2.namespace that return TTableModifier and TypeMethodDescriptionCTENamespace.getFinalTable()DynamicStarSource.getFinalTable()INamespace.getFinalTable()Get the final physical table this namespace represents.OraclePackageNamespace.getFinalTable()PivotNamespace.getFinalTable()PlsqlVariableNamespace.getFinalTable()SubqueryNamespace.getFinalTable()TableNamespace.getFinalTable()UnionNamespace.getFinalTable()UnnestNamespace.getFinalTable()ValuesNamespace.getFinalTable()PivotNamespace.getPivotTable()Get the pivot table.CTENamespace.getReferencingTable()Get the TTable that references this CTE in a FROM clause.CTENamespace.getSourceTable()Get the TTable that this namespace is associated with.default TTableINamespace.getSourceTable()Get the TTable that this namespace is associated with.PivotNamespace.getSourceTable()Get the TTable that this namespace is associated with.SubqueryNamespace.getSourceTable()TableNamespace.getSourceTable()UnnestNamespace.getSourceTable()Get the TTable that this namespace is associated with.TableNamespace.getTable()ValuesNamespace.getTable()PivotNamespace.getUnderlyingSourceTable()Get the underlying table that PIVOT operates on.UnnestNamespace.getUnnestTable()Methods in gudusoft.gsqlparser.resolver2.namespace that return types with arguments of type TTableModifier and TypeMethodDescriptionAbstractNamespace.getAllFinalTables()CTENamespace.getAllFinalTables()INamespace.getAllFinalTables()Get all final physical tables this namespace depends on.OraclePackageNamespace.getAllFinalTables()PivotNamespace.getAllFinalTables()PlsqlVariableNamespace.getAllFinalTables()SubqueryNamespace.getAllFinalTables()UnionNamespace.getAllFinalTables()UnnestNamespace.getAllFinalTables()ValuesNamespace.getAllFinalTables()Methods in gudusoft.gsqlparser.resolver2.namespace with parameters of type TTableModifier and TypeMethodDescriptionvoidCTENamespace.setReferencingTable(TTable table) Set the TTable that references this CTE in a FROM clause.voidSubqueryNamespace.setSourceTable(TTable sourceTable) Set the TTable that wraps this subquery.Constructors in gudusoft.gsqlparser.resolver2.namespace with parameters of type TTableModifierConstructorDescriptionDynamicStarSource(TTable table, INameMatcher nameMatcher) PivotNamespace(TTable pivotTable, TPivotClause pivotClause, TTable sourceTable, String alias, INameMatcher nameMatcher) TableNamespace(TTable table) TableNamespace(TTable table, INameMatcher nameMatcher) TableNamespace(TTable table, INameMatcher nameMatcher, TSQLEnv sqlEnv) TableNamespace(TTable table, INameMatcher nameMatcher, TSQLEnv sqlEnv, EDbVendor vendor) Create a TableNamespace with full qualified name resolution support.UnnestNamespace(TTable unnestTable, String alias) UnnestNamespace(TTable unnestTable, String alias, INameMatcher nameMatcher) ValuesNamespace(TTable table, String alias) ValuesNamespace(TTable table, String alias, INameMatcher nameMatcher) -
Uses of TTable in gudusoft.gsqlparser.resolver2.result
Methods in gudusoft.gsqlparser.resolver2.result that return types with arguments of type TTableModifier and TypeMethodDescriptionIResolutionResult.getTables(TCustomSqlStatement stmt) 获取指定语句中涉及的所有表 默认过滤:排除 JOIN 容器,包含物理表IResolutionResult.getTables(TCustomSqlStatement stmt, TableFilterOptions options) 获取指定语句中涉及的所有表(带过滤选项)ResolutionResultImpl.getTables(TCustomSqlStatement stmt) ResolutionResultImpl.getTables(TCustomSqlStatement stmt, TableFilterOptions options) Methods in gudusoft.gsqlparser.resolver2.result with parameters of type TTableModifier and TypeMethodDescriptionIResolutionResult.getColumnsForTable(TCustomSqlStatement stmt, TTable table) 获取关联到指定表的列ResolutionResultImpl.getColumnsForTable(TCustomSqlStatement stmt, TTable table) static StringResolutionUtils.getFullTableName(TTable table) Get the full table name (including schema)static StringResolutionUtils.getTableDisplayName(TTable table) Get the display name of a table Format: schema.table, alias(subquery), cte_name(CTE)static booleanCheck if it is a CTE referencestatic booleanResolutionUtils.isFunction(TTable table) Check if it is a function tablestatic booleanResolutionUtils.isPhysicalTable(TTable table) Check if it is a physical tablestatic booleanResolutionUtils.isSubquery(TTable table) Check if it is a subquery -
Uses of TTable in gudusoft.gsqlparser.scriptWriter
Methods in gudusoft.gsqlparser.scriptWriter with parameters of type TTable -
Uses of TTable in gudusoft.gsqlparser.stmt
Methods in gudusoft.gsqlparser.stmt that return TTableModifier and TypeMethodDescriptionTCreateTableSqlStatement.getAsTable()Netezza, Teradata, as table name.TCreateTriggerStmt.getOnTable()Deprecated.As of v2.0.1.0, useTCreateTriggerStmt.getTriggeringClause()insteadTAnalyzeStmt.getTable()TLockTableStmt.getTalbe()TMergeSqlStatement.getUsingTable()Source table in the using clause.Methods in gudusoft.gsqlparser.stmt that return types with arguments of type TTableMethods in gudusoft.gsqlparser.stmt with parameters of type TTableModifier and TypeMethodDescriptionvoidTCreateTableSqlStatement.setAsTable(TTable asTable) voidTCreateTriggerStmt.setOnTable(TTable onTable) voidvoidvoidTMergeSqlStatement.setUsingTable(TTable usingTable) -
Uses of TTable in gudusoft.gsqlparser.stmt.dax
Methods in gudusoft.gsqlparser.stmt.dax that return TTableMethods in gudusoft.gsqlparser.stmt.dax with parameters of type TTable -
Uses of TTable in gudusoft.gsqlparser.stmt.db2
Methods in gudusoft.gsqlparser.stmt.db2 that return TTableMethods in gudusoft.gsqlparser.stmt.db2 with parameters of type TTable -
Uses of TTable in gudusoft.gsqlparser.stmt.hive
Methods in gudusoft.gsqlparser.stmt.hive that return TTableModifier and TypeMethodDescriptionTHiveExportTable.getTable()THiveGrant.getTable()THiveImportTable.getTable()THiveLoad.getTable()THiveRevoke.getTable()Methods in gudusoft.gsqlparser.stmt.hive with parameters of type TTable -
Uses of TTable in gudusoft.gsqlparser.stmt.mssql
Methods in gudusoft.gsqlparser.stmt.mssql that return TTableMethods in gudusoft.gsqlparser.stmt.mssql with parameters of type TTableModifier and TypeMethodDescriptionvoidTMssqlCreateTrigger.setOnTable(TTable onTable) Deprecated. -
Uses of TTable in gudusoft.gsqlparser.stmt.mysql
Methods in gudusoft.gsqlparser.stmt.mysql that return TTableMethods in gudusoft.gsqlparser.stmt.mysql with parameters of type TTableModifier and TypeMethodDescriptionvoidTMySQLCreateTrigger.setOnTable(TTable onTable) Deprecated. -
Uses of TTable in gudusoft.gsqlparser.stmt.postgresql
Methods in gudusoft.gsqlparser.stmt.postgresql that return TTableMethods in gudusoft.gsqlparser.stmt.postgresql with parameters of type TTableModifier and TypeMethodDescriptionvoidTPlsqlCreateTriggerSqlStatement.setOnTable(TTable onTable) Deprecated. -
Uses of TTable in gudusoft.gsqlparser.stmt.teradata
Methods in gudusoft.gsqlparser.stmt.teradata with parameters of type TTable
getExpandedStarColumns()instead.