Uses of Class
org.datanucleus.store.rdbms.sql.SQLTable
Packages that use SQLTable
Package
Description
Provides mappings of all supported databases to aspects of the database that determines the SQL generation.
Package providing the querying mechanism for DataNucleus for RDBMS datastores.
Provides the mechanism of communicating with the database using JDBC.
Series of classes used to generate SQL statements.
Series of expressions representing conditions in SQL statements.
-
Uses of SQLTable in org.datanucleus.store.rdbms.adapter
Methods in org.datanucleus.store.rdbms.adapter with parameters of type SQLTableModifier and TypeMethodDescriptionBaseDatastoreAdapter.getDeleteTableStatement
(SQLTable tbl) Method to return the basic SQL for a DELETE TABLE statement.DatastoreAdapter.getDeleteTableStatement
(SQLTable tbl) Method to return the basic SQL for a DELETE TABLE statement.MySQLAdapter.getDeleteTableStatement
(SQLTable tbl) Method to return the basic SQL for a DELETE TABLE statement.SQLAnywhereAdapter.getDeleteTableStatement
(SQLTable tbl) Method to return the basic SQL for a DELETE TABLE statement.SQLiteAdapter.getDeleteTableStatement
(SQLTable tbl) Method to return the basic SQL for a DELETE TABLE statement.SQLServerAdapter.getDeleteTableStatement
(SQLTable tbl) Method to return the basic SQL for a DELETE TABLE statement.SybaseAdapter.getDeleteTableStatement
(SQLTable tbl) Method to return the basic SQL for a DELETE TABLE statement.BaseDatastoreAdapter.getUpdateTableStatement
(SQLTable tbl, SQLText setSQL) Method to return the SQLText for an UPDATE TABLE statement.DatastoreAdapter.getUpdateTableStatement
(SQLTable tbl, SQLText setSQL) Method to return the basic SQL for an UPDATE TABLE statement.SQLAnywhereAdapter.getUpdateTableStatement
(SQLTable tbl, SQLText setSQL) Method to return the SQLText for an UPDATE TABLE statement.SQLiteAdapter.getUpdateTableStatement
(SQLTable tbl, SQLText setSQL) Method to return the SQLText for an UPDATE TABLE statement.SQLServerAdapter.getUpdateTableStatement
(SQLTable tbl, SQLText setSQL) Method to return the SQLText for an UPDATE TABLE statement.SybaseAdapter.getUpdateTableStatement
(SQLTable tbl, SQLText setSQL) Method to return the SQLText for an UPDATE TABLE statement. -
Uses of SQLTable in org.datanucleus.store.rdbms.query
Fields in org.datanucleus.store.rdbms.query declared as SQLTableModifier and TypeFieldDescription(package private) SQLTable
QueryToSQLMapper.SQLTableMapping.table
Methods in org.datanucleus.store.rdbms.query with parameters of type SQLTableModifier and TypeMethodDescriptionvoid
QueryGenerator.bindVariable
(String varName, org.datanucleus.metadata.AbstractClassMetaData cmd, SQLTable sqlTbl, JavaTypeMapping mapping) Method to bind the specified variable to the table and mapping.void
QueryToSQLMapper.bindVariable
(String varName, org.datanucleus.metadata.AbstractClassMetaData cmd, SQLTable sqlTbl, JavaTypeMapping mapping) Method to bind the specified variable to the table and mapping.QueryToSQLMapper.getAliasForSQLTable
(SQLTable tbl) Returns the alias used for the specified SQLTable.protected void
QueryToSQLMapper.processFromClauseSubquery
(org.datanucleus.store.query.expression.ClassExpression clsExpr, SQLTable candSqlTbl, org.datanucleus.metadata.MetaDataManager mmgr) Method to process a ClassExpression where it represents a subquery.Constructors in org.datanucleus.store.rdbms.query with parameters of type SQLTableModifierConstructorDescriptionSQLTableMapping
(SQLTable tbl, org.datanucleus.metadata.AbstractClassMetaData cmd, org.datanucleus.metadata.AbstractMemberMetaData mmd, JavaTypeMapping m) Constructor for use when we have a Map field.SQLTableMapping
(SQLTable tbl, org.datanucleus.metadata.AbstractClassMetaData cmd, JavaTypeMapping m) -
Uses of SQLTable in org.datanucleus.store.rdbms.request
Methods in org.datanucleus.store.rdbms.request with parameters of type SQLTableModifier and TypeMethodDescriptionprotected int
FetchRequest.processMembersOfClass
(SelectStatement sqlStatement, org.datanucleus.FetchPlanForClass fpClass, org.datanucleus.metadata.AbstractMemberMetaData[] mmds, org.datanucleus.metadata.AbstractMemberMetaData[] mmdsToStore, DatastoreClass table, SQLTable sqlTbl, StatementClassMapping mappingDef, Collection<MappingCallbacks> fetchCallbacks, org.datanucleus.ClassLoaderResolver clr, List<Integer> memberNumbersToStore) Method to process the supplied members of the class, adding to the SQLStatement as required.(package private) boolean
FetchRequest.processMemberToFetch
(org.datanucleus.metadata.AbstractMemberMetaData mmd, org.datanucleus.FetchPlanForClass fpClass, org.datanucleus.ClassLoaderResolver clr, Collection<MappingCallbacks> fetchCallbacks, SelectStatement sqlStmt, SQLTable sqlTbl, StatementClassMapping mappingDef, List<Integer> memberNumbersToStore) Method to process the specified member.(package private) boolean
FetchRequest.processMemberToStore
(org.datanucleus.metadata.AbstractMemberMetaData mmd, org.datanucleus.FetchPlanForClass fpClass, org.datanucleus.ClassLoaderResolver clr, Collection<MappingCallbacks> fetchCallbacks, SelectStatement sqlStmt, SQLTable sqlTbl, StatementClassMapping mappingDef, List<Integer> memberNumbersToStore) Method to process the specified member. -
Uses of SQLTable in org.datanucleus.store.rdbms.sql
Fields in org.datanucleus.store.rdbms.sql declared as SQLTableModifier and TypeFieldDescriptionprotected SQLTable
SQLStatement.primaryTable
Primary table for this statement.private SQLTable
SQLJoin.sourceTable
The current table that we are joining from to introduce this table.protected SQLTable
SQLColumn.table
The SQL Table that we are selecting columns from.private SQLTable
SQLJoin.targetTable
Table we are joining to.Fields in org.datanucleus.store.rdbms.sql with type parameters of type SQLTableModifier and TypeFieldDescriptionSQLStatement.tables
Map of tables referenced in this statement, keyed by their alias.SQLTableGroup.tablesByAlias
Map of tables in this group, keyed by their alias.Methods in org.datanucleus.store.rdbms.sql that return SQLTableModifier and TypeMethodDescriptionstatic SQLTable
SQLStatementHelper.addJoinForOneToOneRelation
(SQLStatement stmt, JavaTypeMapping sourceMapping, SQLTable sourceSqlTbl, JavaTypeMapping targetMapping, Table targetTable, String targetAlias, Object[] discrimValues, String targetTablegroupName, SQLJoin.JoinType joinType) Convenience method to add a join across a 1-1 relation to the provided SQLStatement.SQLStatement.getPrimaryTable()
Accessor for the primary table of the statement.SQLJoin.getSourceTable()
Accessor for the table we are joining from.static SQLTable
SQLStatementHelper.getSQLTableForMappingOfTable
(SQLStatement stmt, SQLTable sqlTbl, JavaTypeMapping mapping) Method to return the SQLTable where the specified mapping (in the same table group as the provided SQLTable) is defined.SQLColumn.getTable()
Accessor for the SQLTable object with the specified alias (if defined for this statement).Accessor for the SQLTable object for the specified table (if defined for this statement) in the specified table group.SQLStatement.getTableForDatastoreContainer
(Table table) Convenience method to find a registered SQLTable that is for the specified tableSQLTable[]
SQLTableGroup.getTables()
SQLJoin.getTargetTable()
Accessor for the table we are joining to.SelectStatement.join
(SQLJoin.JoinType joinType, SQLTable sourceTable, JavaTypeMapping sourceMapping, JavaTypeMapping sourceParentMapping, Table target, String targetAlias, JavaTypeMapping targetMapping, JavaTypeMapping targetParentMapping, Object[] discrimValues, String tableGrpName, boolean applyToUnions, SQLJoin parentJoin) SelectStatement.join
(SQLJoin.JoinType joinType, SQLTable sourceTable, Table target, String targetAlias, String tableGrpName, BooleanExpression joinCondition, boolean applyToUnions) SQLStatement.join
(SQLJoin.JoinType joinType, SQLTable sourceTable, JavaTypeMapping sourceMapping, JavaTypeMapping sourceParentMapping, Table target, String targetAlias, JavaTypeMapping targetMapping, JavaTypeMapping targetParentMapping, Object[] discrimValues, String tableGrpName, boolean applyToUnions, SQLJoin parentJoin) Method to form a join to the specified table using the provided mappings, with the join condition derived from the source-target mappings.SQLStatement.join
(SQLJoin.JoinType joinType, SQLTable sourceTable, JavaTypeMapping sourceMapping, Table target, String targetAlias, JavaTypeMapping targetMapping, Object[] discrimValues, String tableGrpName) Method to form a join to the specified table using the provided mappings, with the join also being applied to any UNIONed statements.SQLStatement.join
(SQLJoin.JoinType joinType, SQLTable sourceTable, JavaTypeMapping sourceMapping, Table target, String targetAlias, JavaTypeMapping targetMapping, Object[] discrimValues, String tableGrpName, boolean applyToUnions) Method to form a join to the specified table using the provided mappings.SQLStatement.join
(SQLJoin.JoinType joinType, SQLTable sourceTable, JavaTypeMapping sourceMapping, Table target, String targetAlias, JavaTypeMapping targetMapping, Object[] discrimValues, String tableGrpName, boolean applyToUnions, SQLJoin parentJoin) Method to form a join to the specified table using the provided mappings.SQLStatement.join
(SQLJoin.JoinType joinType, SQLTable sourceTable, JavaTypeMapping sourceMapping, Table target, String targetAlias, JavaTypeMapping targetMapping, Object[] discrimValues, String tableGrpName, SQLJoin parentJoin) Method to form a join to the specified table using the provided mappings, with the join also being applied to any UNIONed statements.SQLStatement.join
(SQLJoin.JoinType joinType, SQLTable sourceTable, Table target, String targetAlias, String tableGrpName, BooleanExpression joinCondition, boolean applyToUnions) Method to form a join to the specified table using the provided mappings and applying the provided join condition (rather than generating one from the source/target mappings).Methods in org.datanucleus.store.rdbms.sql with parameters of type SQLTableModifier and TypeMethodDescriptionvoid
SelectStatement.addAndConditionToJoinForTable
(SQLTable sqlTbl, BooleanExpression andCondition, boolean applyToUnions) Method to find the JOIN for the specified table and add the specified 'and' condition to the JOIN as an 'ON' clause.void
SQLStatement.addAndConditionToJoinForTable
(SQLTable sqlTbl, BooleanExpression andCondition, boolean applyToUnions) Method to find the JOIN for the specified table and add the specified 'and' condition to the JOIN as an 'ON' clause.protected void
SQLStatement.addJoin
(SQLJoin.JoinType joinType, SQLTable sourceTable, SQLTable targetTable, BooleanExpression joinCondition, SQLJoin parentJoin) Internal method to form a join to the specified table using the provided mappings.static SQLTable
SQLStatementHelper.addJoinForOneToOneRelation
(SQLStatement stmt, JavaTypeMapping sourceMapping, SQLTable sourceSqlTbl, JavaTypeMapping targetMapping, Table targetTable, String targetAlias, Object[] discrimValues, String targetTablegroupName, SQLJoin.JoinType joinType) Convenience method to add a join across a 1-1 relation to the provided SQLStatement.void
static BooleanExpression
SQLStatementHelper.getExpressionForDiscriminatorForClass
(SQLStatement stmt, String className, org.datanucleus.metadata.DiscriminatorMetaData dismd, JavaTypeMapping discriminatorMapping, SQLTable discrimSqlTbl, org.datanucleus.ClassLoaderResolver clr) Convenience method to generate a BooleanExpression for the associated discriminator value for the specified class.protected BooleanExpression
SQLStatement.getJoinConditionForJoin
(SQLTable sourceTable, JavaTypeMapping sourceMapping, JavaTypeMapping sourceParentMapping, SQLTable targetTable, JavaTypeMapping targetMapping, JavaTypeMapping targetParentMapping, Object[] discrimValues) Convenience method to generate the join condition between source and target tables for the supplied mappings.SQLStatement.getJoinForTable
(SQLTable sqlTbl) Accessor for the type of join used for the specified table.static SQLJoin.JoinType
SQLStatementHelper.getJoinTypeForOneToOneRelationJoin
(JavaTypeMapping sourceMapping, SQLTable sourceSqlTbl, SQLJoin.JoinType joinType) Convenience method to return the join type to use for the specified 1-1 relation.SQLStatement.getJoinTypeForTable
(SQLTable sqlTbl) Accessor for the type of join used for the specified table.static SQLTable
SQLStatementHelper.getSQLTableForMappingOfTable
(SQLStatement stmt, SQLTable sqlTbl, JavaTypeMapping mapping) Method to return the SQLTable where the specified mapping (in the same table group as the provided SQLTable) is defined.SelectStatement.join
(SQLJoin.JoinType joinType, SQLTable sourceTable, JavaTypeMapping sourceMapping, JavaTypeMapping sourceParentMapping, Table target, String targetAlias, JavaTypeMapping targetMapping, JavaTypeMapping targetParentMapping, Object[] discrimValues, String tableGrpName, boolean applyToUnions, SQLJoin parentJoin) SelectStatement.join
(SQLJoin.JoinType joinType, SQLTable sourceTable, Table target, String targetAlias, String tableGrpName, BooleanExpression joinCondition, boolean applyToUnions) SQLStatement.join
(SQLJoin.JoinType joinType, SQLTable sourceTable, JavaTypeMapping sourceMapping, JavaTypeMapping sourceParentMapping, Table target, String targetAlias, JavaTypeMapping targetMapping, JavaTypeMapping targetParentMapping, Object[] discrimValues, String tableGrpName, boolean applyToUnions, SQLJoin parentJoin) Method to form a join to the specified table using the provided mappings, with the join condition derived from the source-target mappings.SQLStatement.join
(SQLJoin.JoinType joinType, SQLTable sourceTable, JavaTypeMapping sourceMapping, Table target, String targetAlias, JavaTypeMapping targetMapping, Object[] discrimValues, String tableGrpName) Method to form a join to the specified table using the provided mappings, with the join also being applied to any UNIONed statements.SQLStatement.join
(SQLJoin.JoinType joinType, SQLTable sourceTable, JavaTypeMapping sourceMapping, Table target, String targetAlias, JavaTypeMapping targetMapping, Object[] discrimValues, String tableGrpName, boolean applyToUnions) Method to form a join to the specified table using the provided mappings.SQLStatement.join
(SQLJoin.JoinType joinType, SQLTable sourceTable, JavaTypeMapping sourceMapping, Table target, String targetAlias, JavaTypeMapping targetMapping, Object[] discrimValues, String tableGrpName, boolean applyToUnions, SQLJoin parentJoin) Method to form a join to the specified table using the provided mappings.SQLStatement.join
(SQLJoin.JoinType joinType, SQLTable sourceTable, JavaTypeMapping sourceMapping, Table target, String targetAlias, JavaTypeMapping targetMapping, Object[] discrimValues, String tableGrpName, SQLJoin parentJoin) Method to form a join to the specified table using the provided mappings, with the join also being applied to any UNIONed statements.SQLStatement.join
(SQLJoin.JoinType joinType, SQLTable sourceTable, Table target, String targetAlias, String tableGrpName, BooleanExpression joinCondition, boolean applyToUnions) Method to form a join to the specified table using the provided mappings and applying the provided join condition (rather than generating one from the source/target mappings).protected void
SQLStatement.putSQLTableInGroup
(SQLTable sqlTbl, String groupName, SQLJoin.JoinType joinType) Convenience method to add the SQLTable to the specified group.SelectStatement.removeCrossJoin
(SQLTable targetSqlTbl) SQLStatement.removeCrossJoin
(SQLTable targetSqlTbl) Method to remove a cross join for the specified table (if joined via cross join).int[]
SelectStatement.select
(SQLTable table, JavaTypeMapping mapping, String alias) Add a select clause for the specified field (via its mapping) and apply to unions.int[]
SelectStatement.select
(SQLTable table, JavaTypeMapping mapping, String alias, boolean applyToUnions) Add a select clause for the specified field (via its mapping).int
Add a select clause for the specified column.private static boolean
SQLStatementHelper.selectFetchPlanFieldsOfFKRelatedObject
(SelectStatement stmt, StatementClassMapping mappingDefinition, org.datanucleus.FetchPlan fetchPlan, SQLTable sourceSqlTbl, org.datanucleus.metadata.AbstractMemberMetaData mmd, org.datanucleus.ClassLoaderResolver clr, int maxFetchPlanLimit, JavaTypeMapping m, String tableGroupName, StatementMappingIndex stmtMapping, SQLTable sqlTbl, SQLJoin.JoinType inputJoinType) Convenience method to join to and select all required FP fields of a related object where linked via an FK at this side.static void
SQLStatementHelper.selectFetchPlanOfSourceClassInStatement
(SelectStatement stmt, StatementClassMapping mappingDefinition, org.datanucleus.FetchPlan fetchPlan, SQLTable sourceSqlTbl, org.datanucleus.metadata.AbstractClassMetaData sourceCmd, int maxFetchDepth) Method to select all fetch plan members for the "source" class.static void
SQLStatementHelper.selectFetchPlanOfSourceClassInStatement
(SelectStatement stmt, StatementClassMapping mappingDefinition, org.datanucleus.FetchPlan fetchPlan, SQLTable sourceSqlTbl, org.datanucleus.metadata.AbstractClassMetaData sourceCmd, int maxFetchDepth, SQLJoin.JoinType inputJoinType) Method to select all fetch plan members for the "source" class.static void
SQLStatementHelper.selectMemberOfSourceInStatement
(SelectStatement stmt, StatementClassMapping mappingDefinition, org.datanucleus.FetchPlan fetchPlan, SQLTable sourceSqlTbl, org.datanucleus.metadata.AbstractMemberMetaData mmd, org.datanucleus.ClassLoaderResolver clr, int maxFetchPlanLimit, SQLJoin.JoinType inputJoinType) Method to select the specified member (field/property) of the source table in the passed SQL statement.Constructors in org.datanucleus.store.rdbms.sql with parameters of type SQLTableModifierConstructorDescriptionSQLColumn
(SQLTable table, Column col, DatastoreIdentifier alias) Constructor for a column reference.SQLJoin
(SQLJoin.JoinType type, SQLTable targetTbl, SQLTable sourceTbl, BooleanExpression condition) Constructor for a join. -
Uses of SQLTable in org.datanucleus.store.rdbms.sql.expression
Fields in org.datanucleus.store.rdbms.sql.expression declared as SQLTableModifier and TypeFieldDescriptionprotected SQLTable
SQLExpression.table
Table in the SQL statement that this mapping applies to.Methods in org.datanucleus.store.rdbms.sql.expression that return SQLTableMethods in org.datanucleus.store.rdbms.sql.expression with parameters of type SQLTableModifier and TypeMethodDescriptionSQLExpressionFactory.newExpression
(SQLStatement stmt, SQLTable sqlTbl, JavaTypeMapping mapping) Factory for an expression representing a mapping on a table.SQLExpressionFactory.newExpression
(SQLStatement stmt, SQLTable sqlTbl, JavaTypeMapping mapping, JavaTypeMapping parentMapping) Factory for an expression representing a mapping on a table.Constructors in org.datanucleus.store.rdbms.sql.expression with parameters of type SQLTableModifierConstructorDescriptionArrayExpression
(SQLStatement stmt, SQLTable table, JavaTypeMapping mapping) Constructor for an SQL expression for a (field) mapping in a specified table.BinaryExpression
(SQLStatement stmt, SQLTable table, JavaTypeMapping mapping) Constructor for an SQL expression for a (field) mapping in a specified table.BooleanExpression
(SQLStatement stmt, SQLTable table, JavaTypeMapping mapping) Constructor for a boolean expression for the specified mapping of the table.ByteExpression
(SQLStatement stmt, SQLTable table, JavaTypeMapping mapping) Constructor for an SQL expression for a (field) mapping in a specified table.CharacterExpression
(SQLStatement stmt, SQLTable table, JavaTypeMapping mapping) Constructor for an SQL expression for a (field) mapping in a specified table.CollectionExpression
(SQLStatement stmt, SQLTable table, JavaTypeMapping mapping) Constructor for an SQL expression for a (field) mapping in a specified table.protected
ColumnExpression
(SQLStatement stmt, SQLTable table, Column col) Constructor for an SQL expression for a column.DelegatedExpression
(SQLStatement stmt, SQLTable table, JavaTypeMapping mapping) EnumExpression
(SQLStatement stmt, SQLTable table, JavaTypeMapping mapping) Constructor for an expression for an enum field/property.MapExpression
(SQLStatement stmt, SQLTable table, JavaTypeMapping mapping) Constructor.NumericExpression
(SQLStatement stmt, SQLTable table, JavaTypeMapping mapping) Constructor for a numeric expression for the mapping in the specified table.ObjectExpression
(SQLStatement stmt, SQLTable table, JavaTypeMapping mapping) Constructor for an SQL expression for a (field) mapping in a specified table.OptionalExpression
(SQLStatement stmt, SQLTable table, JavaTypeMapping mapping) SingleCollectionExpression
(SQLStatement stmt, SQLTable table, JavaTypeMapping mapping) protected
SQLExpression
(SQLStatement stmt, SQLTable table, JavaTypeMapping mapping) Constructor for an SQL expression for a (field) mapping in a specified table.StringExpression
(SQLStatement stmt, SQLTable table, JavaTypeMapping mapping) Constructor for an SQL expression for a (field) mapping in a specified table.StringNumericExpression
(SQLStatement stmt, SQLTable table, JavaTypeMapping mapping) Constructor for an expression for a field/property that can be represented as String or numeric.StringTemporalExpression
(SQLStatement stmt, SQLTable table, JavaTypeMapping mapping) Constructor for an expression for a field/property represented as String/Temporal.TemporalExpression
(SQLStatement stmt, SQLTable table, JavaTypeMapping mapping) Constructor for an SQL expression for a (field) mapping in a specified table.TypeConverterExpression
(SQLStatement stmt, SQLTable table, JavaTypeMapping mapping) TypeConverterMultiExpression
(SQLStatement stmt, SQLTable table, JavaTypeMapping mapping)