HyperSQL Database 2.7.4 · org.hsqldb.StatementDML · APIdia, the JavaDoc alternative

Modifier and Type	Field and Description
pack-priv int[]	generatedIndexes column indexes for generated values
pack-priv ResultMetaData	generatedInputMetaData
pack-priv ResultMetaData	generatedResultMetaData ResultMetaData for generated values
pack-priv int	generatedType
pack-priv boolean	isMergeDeleteFirst
pack-priv boolean	isSimpleInsert
pack-priv boolean	isTruncate
pack-priv Expression	mergeDeleteCondition
pack-priv Expression	mergeInsertCondition
pack-priv Expression	mergeUpdateCondition
pack-priv SortAndSlice	sortAndSlice
pack-priv Expression[]	targets

Constructor Summary

Access	Constructor and Description
public	StatementDML(int type, HsqlNameManager.HsqlName schemaName)
pack-priv	StatementDML(Session session, Table targetTable, RangeVariable targetRange, RangeVariable[] rangeVars, ParserDQL.CompileContext compileContext, boolean restartIdentity, int type, SortAndSlice sortAndSlice) Instantiate this as a DELETE statement
pack-priv	StatementDML(Session session, Expression[] targets, Table targetTable, RangeVariable targetRange, RangeVariable[] rangeVars, int[] updateColumnMap, Expression[] colExpressions, boolean[] checkColumns, ParserDQL.CompileContext compileContext, SortAndSlice sortAndSlice) Instantiate this as an UPDATE statement.
pack-priv	StatementDML(Session session, Expression[] targets, RangeVariable sourceRange, RangeVariable targetRange, RangeVariable[] rangeVars, int[] insertColMap, int[] updateColMap, boolean[] checkColumns, Expression mergeCondition, Expression insertExpr, Expression[] updateExpr, boolean deleteFirst, Expression insertCondition, Expression updateCondition, Expression deleteCondition, ParserDQL.CompileContext compileContext) Instantiate this as a MERGE statement.
pack-priv	StatementDML() Instantiate this as a CURSOR operation statement.

Method Summary

Modifier and Type	Method and Description
public void	clearStructures(Session session) Overrides org.hsqldb.StatementDMQL.clearStructures.
pack-priv void	collectTableNamesForRead(OrderedHashSet<HsqlNameManager.HsqlName> set) Implements abstract org.hsqldb.StatementDMQL.collectTableNamesForRead.
pack-priv void	collectTableNamesForWrite(OrderedHashSet<HsqlNameManager.HsqlName> set) Implements abstract org.hsqldb.StatementDMQL.collectTableNamesForWrite.
pack-priv int	delete(Session session, Table table, RowSetNavigatorDataChange navigator, RowSetNavigator generatedNavigator) Highest level multiple row delete method.
pack-priv Result	Returns: the result of executing the statement executeDeleteStatement(Session session, int limit) Executes a DELETE statement.
pack-priv Result	executeDeleteTruncateStatement(Session session)
pack-priv Result	Returns: Result object executeMergeStatement(Session session) Executes a MERGE statement.
pack-priv Result	Returns: Result object executeUpdateStatement(Session session, int limit) Executes an UPDATE statement.
public ResultMetaData	generatedResultMetaData() Overrides org.hsqldb.Statement.generatedResultMetaData.
pack-priv static String[]	getConstraintInfo(Constraint c)
pack-priv Object[]	getGeneratedColumns(Object[] data)
pack-priv Object[]	getInsertData(Session session, Type[] colTypes, Expression[] rowArgs)
pack-priv Result	getResult(Session session) Implements abstract org.hsqldb.StatementDMQL.getResult.
pack-priv void	getTriggerTableNames(OrderedHashSet<HsqlNameManager.HsqlName> set, boolean write)
pack-priv static void	getUpdatedData(Session session, Expression[] targets, Table targetTable, int[] columnMap, Expression[] colExpressions, Type[] colTypes, final Object[] data)
public boolean	hasGeneratedColumns() Overrides org.hsqldb.Statement.hasGeneratedColumns.
pack-priv void	insertRowSet(Session session, RowSetNavigator generatedNavigator, RowSetNavigator newData)
pack-priv Result	insertSingleRow(Session session, PersistentStore store, Object[] data)
pack-priv void	performIntegrityChecks(Session session, Table table, Object[] oldData, Object[] newData, int[] updatedColumns)
pack-priv static void	performReferentialActions(Session session, RowSetNavigatorDataChange navigator, Row row, Object[] data, int[] changedCols, HashSet<Constraint> path, boolean deleteCascade)
public void	setGeneratedColumnInfo(int generate, ResultMetaData meta) Overrides org.hsqldb.Statement.setGeneratedColumnInfo.
pack-priv void	setupChecks()
pack-priv int	Returns: int update(Session Session session, Table Table table, RowSetNavigatorDataChange navigator, RowSetNavigator generatedNavigator) Highest level multiple row update method.

Inherited from org.hsqldb.StatementDMQL:: checkAccessRights describe describeImpl execute getInsertOrUpdateColumnCheckList getParametersMetaData getResultMetaData getSubqueries isCatalogChange isCatalogLock materializeSubQueries resolve setBaseIndexColumnMap setDatabaseObjects

Field Detail

generatedIndexes	back to summary
pack-priv int[] generatedIndexes column indexes for generated values

generatedInputMetaData	back to summary
pack-priv ResultMetaData generatedInputMetaData

generatedResultMetaData	back to summary
pack-priv ResultMetaData generatedResultMetaData ResultMetaData for generated values

generatedType	back to summary
pack-priv int generatedType

isMergeDeleteFirst	back to summary
pack-priv boolean isMergeDeleteFirst

isSimpleInsert	back to summary
pack-priv boolean isSimpleInsert

isTruncate	back to summary
pack-priv boolean isTruncate

mergeDeleteCondition	back to summary
pack-priv Expression mergeDeleteCondition

mergeInsertCondition	back to summary
pack-priv Expression mergeInsertCondition

mergeUpdateCondition	back to summary
pack-priv Expression mergeUpdateCondition

sortAndSlice	back to summary
pack-priv SortAndSlice sortAndSlice

targets	back to summary
pack-priv Expression[] targets

Constructor Detail

StatementDML	back to summary
public StatementDML(int type, HsqlNameManager.HsqlName schemaName)

StatementDML	back to summary
pack-priv StatementDML(Session session, Table targetTable, RangeVariable targetRange, RangeVariable[] rangeVars, ParserDQL.CompileContext compileContext, boolean restartIdentity, int type, SortAndSlice sortAndSlice) Instantiate this as a DELETE statement

StatementDML	back to summary
pack-priv StatementDML(Session session, Expression[] targets, Table targetTable, RangeVariable targetRange, RangeVariable[] rangeVars, int[] updateColumnMap, Expression[] colExpressions, boolean[] checkColumns, ParserDQL.CompileContext compileContext, SortAndSlice sortAndSlice) Instantiate this as an UPDATE statement.

StatementDML	back to summary
pack-priv StatementDML(Session session, Expression[] targets, RangeVariable sourceRange, RangeVariable targetRange, RangeVariable[] rangeVars, int[] insertColMap, int[] updateColMap, boolean[] checkColumns, Expression mergeCondition, Expression insertExpr, Expression[] updateExpr, boolean deleteFirst, Expression insertCondition, Expression updateCondition, Expression deleteCondition, ParserDQL.CompileContext compileContext) Instantiate this as a MERGE statement.

StatementDML

back to summary

pack-priv StatementDML(Session session, Expression[] targets, RangeVariable sourceRange, RangeVariable targetRange, RangeVariable[] rangeVars, int[] insertColMap, int[] updateColMap, boolean[] checkColumns, Expression mergeCondition, Expression insertExpr, Expression[] updateExpr, boolean deleteFirst, Expression insertCondition, Expression updateCondition, Expression deleteCondition, ParserDQL.CompileContext compileContext)

Instantiate this as a MERGE statement.

StatementDML	back to summary
pack-priv StatementDML() Instantiate this as a CURSOR operation statement.

Method Detail

clearStructures	back to summary
public void clearStructures(Session session) Overrides org.hsqldb.StatementDMQL.clearStructures.

collectTableNamesForRead	back to summary
pack-priv void collectTableNamesForRead(OrderedHashSet<HsqlNameManager.HsqlName> set) Implements abstract org.hsqldb.StatementDMQL.collectTableNamesForRead.

collectTableNamesForWrite	back to summary
pack-priv void collectTableNamesForWrite(OrderedHashSet<HsqlNameManager.HsqlName> set) Implements abstract org.hsqldb.StatementDMQL.collectTableNamesForWrite.

delete	back to summary
pack-priv int delete(Session session, Table table, RowSetNavigatorDataChange navigator, RowSetNavigator generatedNavigator) Highest level multiple row delete method. Corresponds to an SQL DELETE.

executeDeleteStatement	back to summary
pack-priv Result executeDeleteStatement(Session session, int limit) Executes a DELETE statement. Returns:Result the result of executing the statement

executeDeleteStatement

back to summary

pack-priv Result executeDeleteStatement(Session session, int limit)

Executes a DELETE statement.

Returns:Result: the result of executing the statement

executeDeleteTruncateStatement	back to summary
pack-priv Result executeDeleteTruncateStatement(Session session)

executeMergeStatement	back to summary
pack-priv Result executeMergeStatement(Session session) Executes a MERGE statement. Returns:Result Result object

executeMergeStatement

back to summary

pack-priv Result executeMergeStatement(Session session)

Executes a MERGE statement.

Returns:Result: Result object

executeUpdateStatement	back to summary
pack-priv Result executeUpdateStatement(Session session, int limit) Executes an UPDATE statement. Returns:Result Result object

executeUpdateStatement

back to summary

pack-priv Result executeUpdateStatement(Session session, int limit)

Executes an UPDATE statement.

Returns:Result: Result object

generatedResultMetaData	back to summary
public ResultMetaData generatedResultMetaData() Overrides org.hsqldb.Statement.generatedResultMetaData.

getConstraintInfo	back to summary
pack-priv static String[] getConstraintInfo(Constraint c)

getGeneratedColumns	back to summary
pack-priv Object[] getGeneratedColumns(Object[] data)

getInsertData	back to summary
pack-priv Object[] getInsertData(Session session, Type[] colTypes, Expression[] rowArgs)

getResult	back to summary
pack-priv Result getResult(Session session) Implements abstract org.hsqldb.StatementDMQL.getResult.

getTriggerTableNames	back to summary
pack-priv void getTriggerTableNames(OrderedHashSet<HsqlNameManager.HsqlName> set, boolean write)

getUpdatedData	back to summary
pack-priv static void getUpdatedData(Session session, Expression[] targets, Table targetTable, int[] columnMap, Expression[] colExpressions, Type[] colTypes, final Object[] data)

hasGeneratedColumns	back to summary
public boolean hasGeneratedColumns() Overrides org.hsqldb.Statement.hasGeneratedColumns.

insertRowSet	back to summary
pack-priv void insertRowSet(Session session, RowSetNavigator generatedNavigator, RowSetNavigator newData)

insertSingleRow	back to summary
pack-priv Result insertSingleRow(Session session, PersistentStore store, Object[] data)

performIntegrityChecks	back to summary
pack-priv void performIntegrityChecks(Session session, Table table, Object[] oldData, Object[] newData, int[] updatedColumns)

performReferentialActions	back to summary
pack-priv static void performReferentialActions(Session session, RowSetNavigatorDataChange navigator, Row row, Object[] data, int[] changedCols, HashSet<Constraint> path, boolean deleteCascade)

setGeneratedColumnInfo	back to summary
public void setGeneratedColumnInfo(int generate, ResultMetaData meta) Overrides org.hsqldb.Statement.setGeneratedColumnInfo.

setupChecks	back to summary
pack-priv void setupChecks()

update	back to summary
pack-priv int update(Session session, Table table, RowSetNavigatorDataChange navigator, RowSetNavigator generatedNavigator) Highest level multiple row update method. Following clauses from SQL Standard section 11.8 are enforced 9) Let ISS be the innermost SQL-statement being executed. 10) If evaluation of these General Rules during the execution of ISS would cause an update of some site to a value that is distinct from the value to which that site was previously updated during the execution of ISS, then an exception condition is raised: triggered data change violation. 11) If evaluation of these General Rules during the execution of ISS would cause deletion of a row containing a site that is identified for replacement in that row, then an exception condition is raised: triggered data change violation. Parameters session:Session Session table:Table Table Returns:int int

update

back to summary

pack-priv int update(Session session, Table table, RowSetNavigatorDataChange navigator, RowSetNavigator generatedNavigator)

Highest level multiple row update method.

Following clauses from SQL Standard section 11.8 are enforced 9) Let ISS be the innermost SQL-statement being executed. 10) If evaluation of these General Rules during the execution of ISS would cause an update of some site to a value that is distinct from the value to which that site was previously updated during the execution of ISS, then an exception condition is raised: triggered data change violation. 11) If evaluation of these General Rules during the execution of ISS would cause deletion of a row containing a site that is identified for replacement in that row, then an exception condition is raised: triggered data change violation.

Parameters

session:Session: Session
table:Table: Table

Returns:int

int

public Class StatementDML

Field Summary

Constructor Summary

Method Summary

Field Detail

Constructor Detail

Method Detail