Package org.h2.command.dml

Class Merge

java.lang.Object

org.h2.command.Prepared

org.h2.command.dml.DataChangeStatement

org.h2.command.dml.CommandWithValues

org.h2.command.dml.Merge

public final class Merge
extends CommandWithValues

This class represents the statement MERGE or the MySQL compatibility statement REPLACE

Field Summary

Fields

Modifier and Type	Field	Description
private Column[]	columns
private boolean	isReplace
private Column[]	keys
private Query	query
private Table	table
private Update	update

Fields inherited from class org.h2.command.dml.CommandWithValues

valuesExpressionList

Fields inherited from class org.h2.command.Prepared

create, parameters, prepareAlways, session, sqlStatement, sqlTokens

Constructor Summary

Constructors

Constructor	Description
Merge(SessionLocal session, boolean isReplace)

Method Summary

Modifier and Type	Method	Description
void	collectDependencies(HashSet<DbObject> dependencies)	Find and collect all DbObjects, this Prepared depends on.
String	getPlanSQL(int sqlFlags)	Get the SQL statement with the execution plan.
String	getStatementName()	Return the name of this statement.
Table	getTable()	Return the target table.
int	getType()	Get the command type as defined in CommandInterface
private int	merge(Row row, Expression[] expressions, ResultTarget deltaChangeCollector, DataChangeDeltaTable.ResultOption deltaChangeCollectionMode)	Updates an existing row or inserts a new one.
void	prepare()	Prepare this statement.
void	setColumns(Column[] columns)
void	setCommand(Command command)	Set the command.
void	setKeys(Column[] keys)
void	setQuery(Query query)
void	setTable(Table table)
long	update(ResultTarget deltaChangeCollector, DataChangeDeltaTable.ResultOption deltaChangeCollectionMode)	Execute the statement with specified delta change collector and collection mode.

Methods inherited from class org.h2.command.dml.CommandWithValues

addRow

Methods inherited from class org.h2.command.dml.DataChangeStatement

isCacheable, isTransactional, queryMeta, update

Methods inherited from class org.h2.command.Prepared

checkCanceled, checkParameters, getCteCleanups, getCurrentRowNumber, getObjectId, getParameters, getPersistedObjectId, getSession, getSimpleSQL, getSQL, getSQLTokens, isQuery, isReadOnly, needRecompile, query, setCteCleanups, setCurrentRowNumber, setParameterList, setPersistedObjectId, setPrepareAlways, setRow, setSession, setSQL, toString

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Details

isReplace

private boolean isReplace

table

private Table table

columns

private Column[] columns

keys

private Column[] keys

query

private Query query

update

private Update update

Constructor Details

Merge

public Merge(SessionLocal session,
 boolean isReplace)

Method Details

setCommand

public void setCommand(Command command)

Description copied from class: Prepared

Set the command.

Overrides:

setCommand in class Prepared

Parameters:

command - the new command

getTable

public Table getTable()

Description copied from class: DataChangeStatement

Return the target table.

Specified by:

getTable in class DataChangeStatement

Returns:

the target table

setTable

public void setTable(Table table)

setColumns

public void setColumns(Column[] columns)

setKeys

public void setKeys(Column[] keys)

setQuery

public void setQuery(Query query)

update

public long update(ResultTarget deltaChangeCollector,
 DataChangeDeltaTable.ResultOption deltaChangeCollectionMode)

Description copied from class: DataChangeStatement

Execute the statement with specified delta change collector and collection mode.

Specified by:

update in class DataChangeStatement

Parameters:

deltaChangeCollector - target result

deltaChangeCollectionMode - collection mode

Returns:

the update count

merge

private int merge(Row row,
 Expression[] expressions,
 ResultTarget deltaChangeCollector,
 DataChangeDeltaTable.ResultOption deltaChangeCollectionMode)

Updates an existing row or inserts a new one.

Parameters:

row - row to replace

expressions - source expressions, or null

deltaChangeCollector - target result

deltaChangeCollectionMode - collection mode

Returns:

1 if row was inserted, 1 if row was updated by a MERGE statement, and 2 if row was updated by a REPLACE statement

getPlanSQL

public String getPlanSQL(int sqlFlags)

Description copied from class: Prepared

Get the SQL statement with the execution plan.

Overrides:

getPlanSQL in class Prepared

Parameters:

sqlFlags - formatting flags

Returns:

the execution plan

prepare

public void prepare()

Description copied from class: Prepared

Prepare this statement.

Overrides:

prepare in class Prepared

getType

public int getType()

Description copied from class: Prepared

Get the command type as defined in CommandInterface

Specified by:

getType in class Prepared

Returns:

the statement type

getStatementName

public String getStatementName()

Description copied from class: DataChangeStatement

Return the name of this statement.

Specified by:

getStatementName in class DataChangeStatement

Returns:

the short name of this statement.

collectDependencies

public void collectDependencies(HashSet<DbObject> dependencies)

Description copied from class: Prepared

Find and collect all DbObjects, this Prepared depends on.

Overrides:

collectDependencies in class Prepared

Parameters:

dependencies - collection of dependencies to populate