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 StringBaseDatastoreAdapter. getDeleteTableStatement(SQLTable tbl)Method to return the basic SQL for a DELETE TABLE statement.StringDatastoreAdapter. getDeleteTableStatement(SQLTable tbl)Method to return the basic SQL for a DELETE TABLE statement.StringMySQLAdapter. getDeleteTableStatement(SQLTable tbl)Method to return the basic SQL for a DELETE TABLE statement.StringSQLAnywhereAdapter. getDeleteTableStatement(SQLTable tbl)Method to return the basic SQL for a DELETE TABLE statement.StringSQLiteAdapter. getDeleteTableStatement(SQLTable tbl)Method to return the basic SQL for a DELETE TABLE statement.StringSQLServerAdapter. getDeleteTableStatement(SQLTable tbl)Method to return the basic SQL for a DELETE TABLE statement.StringSybaseAdapter. getDeleteTableStatement(SQLTable tbl)Method to return the basic SQL for a DELETE TABLE statement.SQLTextBaseDatastoreAdapter. getUpdateTableStatement(SQLTable tbl, SQLText setSQL)Method to return the SQLText for an UPDATE TABLE statement.SQLTextDatastoreAdapter. getUpdateTableStatement(SQLTable tbl, SQLText setSQL)Method to return the basic SQL for an UPDATE TABLE statement.SQLTextSQLAnywhereAdapter. getUpdateTableStatement(SQLTable tbl, SQLText setSQL)Method to return the SQLText for an UPDATE TABLE statement.SQLTextSQLiteAdapter. getUpdateTableStatement(SQLTable tbl, SQLText setSQL)Method to return the SQLText for an UPDATE TABLE statement.SQLTextSQLServerAdapter. getUpdateTableStatement(SQLTable tbl, SQLText setSQL)Method to return the SQLText for an UPDATE TABLE statement.SQLTextSybaseAdapter. 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 voidQueryGenerator. bindVariable(String varName, org.datanucleus.metadata.AbstractClassMetaData cmd, SQLTable sqlTbl, JavaTypeMapping mapping)Method to bind the specified variable to the table and mapping.voidQueryToSQLMapper. bindVariable(String varName, org.datanucleus.metadata.AbstractClassMetaData cmd, SQLTable sqlTbl, JavaTypeMapping mapping)Method to bind the specified variable to the table and mapping.StringQueryToSQLMapper. getAliasForSQLTable(SQLTable tbl)Returns the alias used for the specified SQLTable.protected voidQueryToSQLMapper. 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 intFetchRequest. 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 SQLTableSQLStatement. primaryTablePrimary table for this statement.protected SQLTableSQLColumn. tableThe 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. tablesMap 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 SQLTableSQLStatementHelper. 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.SQLTableSQLStatement. getPrimaryTable()Accessor for the primary table of the statement.SQLTableSQLJoin. getSourceTable()Accessor for the table we are joining from.static SQLTableSQLStatementHelper. 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.SQLTableSQLColumn. getTable()SQLTableSQLStatement. getTable(String alias)Accessor for the SQLTable object with the specified alias (if defined for this statement).SQLTableSQLStatement. getTable(Table table, String groupName)Accessor for the SQLTable object for the specified table (if defined for this statement) in the specified table group.SQLTableSQLStatement. getTableForDatastoreContainer(Table table)Convenience method to find a registered SQLTable that is for the specified tableSQLTable[]SQLTableGroup. getTables()SQLTableSQLJoin. getTargetTable()Accessor for the table we are joining to.SQLTableSelectStatement. 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)SQLTableSelectStatement. join(SQLJoin.JoinType joinType, SQLTable sourceTable, Table target, String targetAlias, String tableGrpName, BooleanExpression joinCondition, boolean applyToUnions)SQLTableSQLStatement. 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.SQLTableSQLStatement. 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.SQLTableSQLStatement. 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.SQLTableSQLStatement. 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.SQLTableSQLStatement. 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.SQLTableSQLStatement. 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 voidSelectStatement. 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.voidSQLStatement. 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 voidSQLStatement. 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 SQLTableSQLStatementHelper. 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.voidSQLTableGroup. addTable(SQLTable tbl)static BooleanExpressionSQLStatementHelper. 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 BooleanExpressionSQLStatement. 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.SQLJoinSQLStatement. getJoinForTable(SQLTable sqlTbl)Accessor for the type of join used for the specified table.static SQLJoin.JoinTypeSQLStatementHelper. getJoinTypeForOneToOneRelationJoin(JavaTypeMapping sourceMapping, SQLTable sourceSqlTbl, SQLJoin.JoinType joinType)Convenience method to return the join type to use for the specified 1-1 relation.SQLJoin.JoinTypeSQLStatement. getJoinTypeForTable(SQLTable sqlTbl)Accessor for the type of join used for the specified table.static SQLTableSQLStatementHelper. 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.SQLTableSelectStatement. 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)SQLTableSelectStatement. join(SQLJoin.JoinType joinType, SQLTable sourceTable, Table target, String targetAlias, String tableGrpName, BooleanExpression joinCondition, boolean applyToUnions)SQLTableSQLStatement. 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.SQLTableSQLStatement. 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.SQLTableSQLStatement. 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.SQLTableSQLStatement. 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.SQLTableSQLStatement. 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.SQLTableSQLStatement. 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 voidSQLStatement. putSQLTableInGroup(SQLTable sqlTbl, String groupName, SQLJoin.JoinType joinType)Convenience method to add the SQLTable to the specified group.StringSelectStatement. removeCrossJoin(SQLTable targetSqlTbl)StringSQLStatement. 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).intSelectStatement. select(SQLTable table, Column column, String alias)Add a select clause for the specified column.static voidSQLStatementHelper. 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 voidSQLStatementHelper. 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 voidSQLStatementHelper. 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 SQLTableSQLExpression. tableTable 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 SQLTableSQLExpression. getSQLTable()Methods in org.datanucleus.store.rdbms.sql.expression with parameters of type SQLTable Modifier and Type Method Description SQLExpressionSQLExpressionFactory. newExpression(SQLStatement stmt, SQLTable sqlTbl, JavaTypeMapping mapping)Factory for an expression representing a mapping on a table.SQLExpressionSQLExpressionFactory. 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)
-