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 and Description
String	MySQLAdapter.getDeleteTableStatement(SQLTable tbl) Method to return the basic SQL for a DELETE TABLE statement.
String	MSSQLServerAdapter.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	DatastoreAdapter.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	BaseDatastoreAdapter.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	MSSQLServerAdapter.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	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	BaseDatastoreAdapter.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 and Description
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.
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.
String	QueryToSQLMapper.getAliasForSQLTable(SQLTable tbl) Returns the alias used for the specified SQLTable.

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 and Description
protected int	FetchRequest.processMembersOfClass(SQLStatement sqlStatement, org.datanucleus.metadata.AbstractMemberMetaData[] mmds, DatastoreClass table, SQLTable sqlTbl, StatementClassMapping mappingDef, Collection fetchCallbacks, org.datanucleus.ClassLoaderResolver clr) 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 and 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 and 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 and 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.crossJoin(Table target, String targetAlias, String tableGrpName) Method to form a right outer join to the specified table using the provided mappings.
SQLTable	SQLJoin.getJoinedTable()
SQLTable	SQLStatement.getPrimaryTable() Accessor for the primary table of the statement.
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	SQLJoin.getTable()
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 table
SQLTable[]	SQLTableGroup.getTables()
SQLTable	SQLStatement.innerJoin(SQLTable sourceTable, JavaTypeMapping sourceMapping, JavaTypeMapping sourceParentMapping, Table target, String targetAlias, JavaTypeMapping targetMapping, JavaTypeMapping targetParentMapping, Object[] discrimValues, String tableGrpName) Method to form an inner join to the specified table using the provided mappings.
SQLTable	SQLStatement.innerJoin(SQLTable sourceTable, JavaTypeMapping sourceMapping, Table target, String targetAlias, JavaTypeMapping targetMapping, Object[] discrimValues, String tableGrpName) Method to form an inner join to the specified table using the provided mappings.
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) 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) 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.leftOuterJoin(SQLTable sourceTable, JavaTypeMapping sourceMapping, JavaTypeMapping sourceParentMapping, Table target, String targetAlias, JavaTypeMapping targetMapping, JavaTypeMapping targetParentMapping, Object[] discrimValues, String tableGrpName) Method to form a left outer join to the specified table using the provided mappings.
SQLTable	SQLStatement.leftOuterJoin(SQLTable sourceTable, JavaTypeMapping sourceMapping, Table target, String targetAlias, JavaTypeMapping targetMapping, Object[] discrimValues, String tableGrpName) Method to form a left outer join to the specified table using the provided mappings.
SQLTable	SQLStatement.rightOuterJoin(SQLTable sourceTable, JavaTypeMapping sourceMapping, JavaTypeMapping sourceParentMapping, Table target, String targetAlias, JavaTypeMapping targetMapping, JavaTypeMapping targetParentMapping, Object[] discrimValues, String tableGrpName) Method to form a right outer join to the specified table using the provided mappings.
SQLTable	SQLStatement.rightOuterJoin(SQLTable sourceTable, JavaTypeMapping sourceMapping, Table target, String targetAlias, JavaTypeMapping targetMapping, Object[] discrimValues, String tableGrpName) Method to form a right outer join to the specified table using the provided mappings.

Methods in org.datanucleus.store.rdbms.sql with parameters of type SQLTable

Modifier and Type	Method and Description
protected void	SQLStatement.addJoin(SQLJoin.JoinType joinType, SQLTable sourceTable, JavaTypeMapping sourceMapping, JavaTypeMapping sourceParentMapping, SQLTable targetTable, JavaTypeMapping targetMapping, JavaTypeMapping targetParentMapping, Object[] discrimValues) 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	SQLStatement.innerJoin(SQLTable sourceTable, JavaTypeMapping sourceMapping, JavaTypeMapping sourceParentMapping, Table target, String targetAlias, JavaTypeMapping targetMapping, JavaTypeMapping targetParentMapping, Object[] discrimValues, String tableGrpName) Method to form an inner join to the specified table using the provided mappings.
SQLTable	SQLStatement.innerJoin(SQLTable sourceTable, JavaTypeMapping sourceMapping, Table target, String targetAlias, JavaTypeMapping targetMapping, Object[] discrimValues, String tableGrpName) Method to form an inner join to the specified table using the provided mappings.
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) 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) 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.leftOuterJoin(SQLTable sourceTable, JavaTypeMapping sourceMapping, JavaTypeMapping sourceParentMapping, Table target, String targetAlias, JavaTypeMapping targetMapping, JavaTypeMapping targetParentMapping, Object[] discrimValues, String tableGrpName) Method to form a left outer join to the specified table using the provided mappings.
SQLTable	SQLStatement.leftOuterJoin(SQLTable sourceTable, JavaTypeMapping sourceMapping, Table target, String targetAlias, JavaTypeMapping targetMapping, Object[] discrimValues, String tableGrpName) Method to form a left outer join to the specified table using the provided mappings.
String	SQLStatement.removeCrossJoin(SQLTable targetSqlTbl) Method to remove a cross join for the specified table (if joined via cross join).
SQLTable	SQLStatement.rightOuterJoin(SQLTable sourceTable, JavaTypeMapping sourceMapping, JavaTypeMapping sourceParentMapping, Table target, String targetAlias, JavaTypeMapping targetMapping, JavaTypeMapping targetParentMapping, Object[] discrimValues, String tableGrpName) Method to form a right outer join to the specified table using the provided mappings.
SQLTable	SQLStatement.rightOuterJoin(SQLTable sourceTable, JavaTypeMapping sourceMapping, Table target, String targetAlias, JavaTypeMapping targetMapping, Object[] discrimValues, String tableGrpName) Method to form a right outer join to the specified table using the provided mappings.
int	SQLStatement.select(SQLTable table, Column column, String alias) Add a select clause for the specified column.
int[]	SQLStatement.select(SQLTable table, JavaTypeMapping mapping, String alias) Add a select clause for the specified field (via its mapping) and apply to unions.
int[]	SQLStatement.select(SQLTable table, JavaTypeMapping mapping, String alias, boolean applyToUnions) Add a select clause for the specified field (via its mapping).
static void	SQLStatementHelper.selectFetchPlanOfSourceClassInStatement(SQLStatement 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(SQLStatement 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(SQLStatement 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 and Description
SQLColumn(SQLTable table, Column col, DatastoreIdentifier alias) Constructor for a column reference.
SQLJoin(SQLJoin.JoinType type, SQLTable tbl, SQLTable joinedTbl, 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 and 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 and Description
SQLTable	SQLExpression.getSQLTable()

Methods in org.datanucleus.store.rdbms.sql.expression with parameters of type SQLTable

Modifier and Type	Method and 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 and 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.
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)