Uses of Class
org.datanucleus.store.rdbms.sql.SQLTable
-
Packages that use SQLTable Package Description org.datanucleus.store.rdbms.adapter Provides mappings of all supported databases to aspects of the database that determines the SQL generation.org.datanucleus.store.rdbms.query Package providing the querying mechanism for DataNucleus for RDBMS datastores.org.datanucleus.store.rdbms.request Provides the mechanism of communicating with the database using JDBC.org.datanucleus.store.rdbms.sql Series of classes used to generate SQL statements.org.datanucleus.store.rdbms.sql.expression 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 SQLTable Modifier and Type Method Description String
BaseDatastoreAdapter. getDeleteTableStatement(SQLTable tbl)
Method to return the basic SQL for a DELETE TABLE statement.String
DatastoreAdapter. getDeleteTableStatement(SQLTable tbl)
Method to return the basic SQL for a DELETE TABLE statement.String
MySQLAdapter. getDeleteTableStatement(SQLTable tbl)
Method to return the basic SQL for a DELETE TABLE statement.String
SQLAnywhereAdapter. getDeleteTableStatement(SQLTable tbl)
Method to return the basic SQL for a DELETE TABLE statement.String
SQLiteAdapter. getDeleteTableStatement(SQLTable tbl)
Method to return the basic SQL for a DELETE TABLE statement.String
SQLServerAdapter. getDeleteTableStatement(SQLTable tbl)
Method to return the basic SQL for a DELETE TABLE statement.String
SybaseAdapter. getDeleteTableStatement(SQLTable tbl)
Method to return the basic SQL for a DELETE TABLE statement.SQLText
BaseDatastoreAdapter. getUpdateTableStatement(SQLTable tbl, SQLText setSQL)
Method to return the SQLText for an UPDATE TABLE statement.SQLText
DatastoreAdapter. getUpdateTableStatement(SQLTable tbl, SQLText setSQL)
Method to return the basic SQL for an UPDATE TABLE statement.SQLText
SQLAnywhereAdapter. getUpdateTableStatement(SQLTable tbl, SQLText setSQL)
Method to return the SQLText for an UPDATE TABLE statement.SQLText
SQLiteAdapter. getUpdateTableStatement(SQLTable tbl, SQLText setSQL)
Method to return the SQLText for an UPDATE TABLE statement.SQLText
SQLServerAdapter. getUpdateTableStatement(SQLTable tbl, SQLText setSQL)
Method to return the SQLText for an UPDATE TABLE statement.SQLText
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
Methods in org.datanucleus.store.rdbms.query with parameters of type SQLTable Modifier and Type Method Description void
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.String
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. -
Uses of SQLTable in org.datanucleus.store.rdbms.request
Methods in org.datanucleus.store.rdbms.request with parameters of type SQLTable Modifier and Type Method Description protected 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 fetchCallbacks, org.datanucleus.ClassLoaderResolver clr, List<Integer> memberNumbersToStore)
Method to process the supplied members of the class, adding to the SQLStatement as required. -
Uses of SQLTable in org.datanucleus.store.rdbms.sql
Fields in org.datanucleus.store.rdbms.sql declared as SQLTable Modifier and Type Field Description protected SQLTable
SQLStatement. primaryTable
Primary table for this statement.protected SQLTable
SQLColumn. table
The SQL Table that we are selecting columns from.Fields in org.datanucleus.store.rdbms.sql with type parameters of type SQLTable Modifier and Type Field Description protected Map<String,SQLTable>
SQLStatement. tables
Map of tables referenced in this statement, keyed by their alias.Methods in org.datanucleus.store.rdbms.sql that return SQLTable Modifier and Type Method Description 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.SQLTable
SQLStatement. getPrimaryTable()
Accessor for the primary table of the statement.SQLTable
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.SQLTable
SQLColumn. getTable()
SQLTable
SQLStatement. getTable(String alias)
Accessor for the SQLTable object with the specified alias (if defined for this statement).SQLTable
SQLStatement. getTable(Table table, String groupName)
Accessor for the SQLTable object for the specified table (if defined for this statement) in the specified table group.SQLTable
SQLStatement. getTableForDatastoreContainer(Table table)
Convenience method to find a registered SQLTable that is for the specified tableSQLTable[]
SQLTableGroup. getTables()
SQLTable
SQLJoin. getTargetTable()
Accessor for the table we are joining to.SQLTable
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)
SQLTable
SelectStatement. join(SQLJoin.JoinType joinType, SQLTable sourceTable, Table target, String targetAlias, String tableGrpName, BooleanExpression joinCondition, boolean applyToUnions)
SQLTable
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.SQLTable
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.SQLTable
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.SQLTable
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.SQLTable
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.SQLTable
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 SQLTable Modifier and Type Method Description void
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
SQLTableGroup. addTable(SQLTable tbl)
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.SQLJoin
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.SQLJoin.JoinType
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.SQLTable
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)
SQLTable
SelectStatement. join(SQLJoin.JoinType joinType, SQLTable sourceTable, Table target, String targetAlias, String tableGrpName, BooleanExpression joinCondition, boolean applyToUnions)
SQLTable
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.SQLTable
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.SQLTable
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.SQLTable
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.SQLTable
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.SQLTable
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.String
SelectStatement. removeCrossJoin(SQLTable targetSqlTbl)
String
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
SelectStatement. select(SQLTable table, Column column, String alias)
Add a select clause for the specified column.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 SQLTable Constructor Description SQLColumn(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 SQLTable Modifier and Type Field Description protected SQLTable
SQLExpression. table
Table in the SQL statement that this mapping applies to.Methods in org.datanucleus.store.rdbms.sql.expression that return SQLTable Modifier and Type Method Description SQLTable
SQLExpression. getSQLTable()
Methods in org.datanucleus.store.rdbms.sql.expression with parameters of type SQLTable Modifier and Type Method Description SQLExpression
SQLExpressionFactory. newExpression(SQLStatement stmt, SQLTable sqlTbl, JavaTypeMapping mapping)
Factory for an expression representing a mapping on a table.SQLExpression
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 SQLTable Constructor Description ArrayExpression(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.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)
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)
-