com.querydsl.sql.dml

Class SQLMergeClause

java.lang.Object

com.querydsl.sql.dml.AbstractSQLClause<SQLMergeClause>

com.querydsl.sql.dml.SQLMergeClause

All Implemented Interfaces:

DMLClause<SQLMergeClause>, StoreClause<SQLMergeClause>

public class SQLMergeClause
extends AbstractSQLClause<SQLMergeClause>
implements StoreClause<SQLMergeClause>

SQLMergeClause defines an MERGE INTO clause

Author:

tiwe

Field Summary

Fields

Modifier and Type	Field and Description
protected java.util.List<SQLMergeBatch>	batches
protected java.util.List<Path<?>>	columns
protected java.util.List<java.lang.Object>	constants
protected RelationalPath<?>	entity
protected java.util.List<Path<?>>	keys
protected static java.util.logging.Logger	logger
protected QueryMetadata	metadata
protected java.lang.String	queryString
protected @Nullable SubQueryExpression<?>	subQuery
protected java.util.List<Expression<?>>	values

Fields inherited from class com.querydsl.sql.dml.AbstractSQLClause

configuration, context, listeners, useLiterals

Constructor Summary

Constructors

Constructor and Description
SQLMergeClause(java.sql.Connection connection, Configuration configuration, RelationalPath<?> entity)
SQLMergeClause(java.sql.Connection connection, SQLTemplates templates, RelationalPath<?> entity)
SQLMergeClause(java.util.function.Supplier<java.sql.Connection> connection, Configuration configuration, RelationalPath<?> entity)

Method Summary

Modifier and Type	Method and Description
SQLMergeClause	addBatch() Add the current state of bindings as a batch item
SQLMergeClause	addFlag(QueryFlag.Position position, Expression<?> flag) Add the given Expression at the given position as a query flag
SQLMergeClause	addFlag(QueryFlag.Position position, java.lang.String flag) Add the given String literal at the given position as a query flag
protected void	addKeyConditions(FilteredClause<?> query)
protected void	addListeners(AbstractSQLClause<?> clause)
void	clear() Clear the internal state of the clause
SQLMergeClause	columns(Path<?>... columns)
protected java.sql.PreparedStatement	createStatement(boolean withKeys)
protected java.util.Collection<java.sql.PreparedStatement>	createStatements(boolean withKeys)
long	execute()
protected long	executeCompositeMerge()
protected long	executeNativeMerge()
<T> T	executeWithKey(java.lang.Class<T> type) Execute the clause and return the generated key cast to the given type.
protected <T> T	executeWithKey(java.lang.Class<T> type, @Nullable Path<T> path)
<T> T	executeWithKey(Path<T> path) Execute the clause and return the generated key with the type of the given path.
java.sql.ResultSet	executeWithKeys() Execute the clause and return the generated keys as a ResultSet
<T> java.util.List<T>	executeWithKeys(java.lang.Class<T> type)
protected <T> java.util.List<T>	executeWithKeys(java.lang.Class<T> type, @Nullable Path<T> path)
<T> java.util.List<T>	executeWithKeys(Path<T> path) Execute the clause and return the generated key with the type of the given path.
int	getBatchCount()
protected java.util.List<? extends Path<?>>	getKeys()
java.util.List<SQLBindings>	getSQL() Get the SQL string and bindings
protected boolean	hasRow()
boolean	isEmpty()
SQLMergeClause	keys(Path<?>... paths) Set the keys to be used in the MERGE clause
protected void	populate(StoreClause<?> clause)
protected java.sql.PreparedStatement	prepareStatementAndSetParameters(SQLSerializer serializer, boolean withKeys)
SQLMergeClause	select(SubQueryExpression<?> subQuery)
<T> SQLMergeClause	set(Path<T> path, Expression<? extends T> expression)
<T> SQLMergeClause	set(Path<T> path, T value)
<T> SQLMergeClause	setNull(Path<T> path)
java.lang.String	toString()
SQLMergeClause	values(java.lang.Object... v)

Methods inherited from class com.querydsl.sql.dml.AbstractSQLClause

addListener, close, close, close, connection, createBindings, createSerializer, endContext, executeBatch, logQuery, onException, reset, setParameters, setUseLiterals, startContext

Methods inherited from class java.lang.Object

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

Field Detail

logger

protected static final java.util.logging.Logger logger

columns

protected final java.util.List<Path<?>> columns

entity

protected final RelationalPath<?> entity

metadata

protected final QueryMetadata metadata

keys

protected final java.util.List<Path<?>> keys

subQuery

@Nullable
protected @Nullable SubQueryExpression<?> subQuery

batches

protected final java.util.List<SQLMergeBatch> batches

values

protected final java.util.List<Expression<?>> values

queryString

protected transient java.lang.String queryString

constants

protected transient java.util.List<java.lang.Object> constants

Constructor Detail

SQLMergeClause

public SQLMergeClause(java.sql.Connection connection,
                      SQLTemplates templates,
                      RelationalPath<?> entity)

SQLMergeClause

public SQLMergeClause(java.sql.Connection connection,
                      Configuration configuration,
                      RelationalPath<?> entity)

SQLMergeClause

public SQLMergeClause(java.util.function.Supplier<java.sql.Connection> connection,
                      Configuration configuration,
                      RelationalPath<?> entity)

Method Detail

addFlag

public SQLMergeClause addFlag(QueryFlag.Position position,
                              java.lang.String flag)

Add the given String literal at the given position as a query flag

Parameters:

position - position

flag - query flag

Returns:

the current object

addFlag

public SQLMergeClause addFlag(QueryFlag.Position position,
                              Expression<?> flag)

Add the given Expression at the given position as a query flag

Parameters:

position - position

flag - query flag

Returns:

the current object

getKeys

protected java.util.List<? extends Path<?>> getKeys()

addBatch

public SQLMergeClause addBatch()

Add the current state of bindings as a batch item

Returns:

the current object

clear

public void clear()

Description copied from class: AbstractSQLClause

Clear the internal state of the clause

Specified by:

clear in class AbstractSQLClause<SQLMergeClause>

columns

public SQLMergeClause columns(Path<?>... columns)

executeWithKey

@Nullable
public <T> T executeWithKey(Path<T> path)

Execute the clause and return the generated key with the type of the given path. If no rows were created, null is returned, otherwise the key of the first row is returned.

Type Parameters:

T -

Parameters:

path - path for key

Returns:

generated key

executeWithKey

public <T> T executeWithKey(java.lang.Class<T> type)

Execute the clause and return the generated key cast to the given type. If no rows were created, null is returned, otherwise the key of the first row is returned.

Type Parameters:

T -

Parameters:

type - type of key

Returns:

generated key

executeWithKey

protected <T> T executeWithKey(java.lang.Class<T> type,
                               @Nullable
                               @Nullable Path<T> path)

executeWithKeys

public <T> java.util.List<T> executeWithKeys(Path<T> path)

Execute the clause and return the generated key with the type of the given path. If no rows were created, or the referenced column is not a generated key, null is returned. Otherwise, the key of the first row is returned.

Type Parameters:

T -

Parameters:

path - path for key

Returns:

generated keys

executeWithKeys

public <T> java.util.List<T> executeWithKeys(java.lang.Class<T> type)

executeWithKeys

protected <T> java.util.List<T> executeWithKeys(java.lang.Class<T> type,
                                                @Nullable
                                                @Nullable Path<T> path)

executeWithKeys

public java.sql.ResultSet executeWithKeys()

Execute the clause and return the generated keys as a ResultSet

Returns:

result set with generated keys

execute

public long execute()

Specified by:

execute in interface DMLClause<SQLMergeClause>

getSQL

public java.util.List<SQLBindings> getSQL()

Description copied from class: AbstractSQLClause

Get the SQL string and bindings

Specified by:

getSQL in class AbstractSQLClause<SQLMergeClause>

Returns:

SQL and bindings

hasRow

protected boolean hasRow()

addKeyConditions

protected void addKeyConditions(FilteredClause<?> query)

executeCompositeMerge

protected long executeCompositeMerge()

addListeners

protected void addListeners(AbstractSQLClause<?> clause)

populate

protected void populate(StoreClause<?> clause)

createStatement

protected java.sql.PreparedStatement createStatement(boolean withKeys)
                                              throws java.sql.SQLException

Throws:

java.sql.SQLException

createStatements

protected java.util.Collection<java.sql.PreparedStatement> createStatements(boolean withKeys)
                                                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

prepareStatementAndSetParameters

protected java.sql.PreparedStatement prepareStatementAndSetParameters(SQLSerializer serializer,
                                                                      boolean withKeys)
                                                               throws java.sql.SQLException

Throws:

java.sql.SQLException

executeNativeMerge

protected long executeNativeMerge()

keys

public SQLMergeClause keys(Path<?>... paths)

Set the keys to be used in the MERGE clause

Parameters:

paths - keys

Returns:

the current object

select

public SQLMergeClause select(SubQueryExpression<?> subQuery)

set

public <T> SQLMergeClause set(Path<T> path,
                              @Nullable
                              T value)

Specified by:

set in interface StoreClause<SQLMergeClause>

set

public <T> SQLMergeClause set(Path<T> path,
                              Expression<? extends T> expression)

Specified by:

set in interface StoreClause<SQLMergeClause>

setNull

public <T> SQLMergeClause setNull(Path<T> path)

Specified by:

setNull in interface StoreClause<SQLMergeClause>

toString

public java.lang.String toString()

Overrides:

toString in class java.lang.Object

values

public SQLMergeClause values(java.lang.Object... v)

isEmpty

public boolean isEmpty()

Specified by:

isEmpty in interface StoreClause<SQLMergeClause>

getBatchCount

public int getBatchCount()

Specified by:

getBatchCount in class AbstractSQLClause<SQLMergeClause>