com.querydsl.sql.dml

Class AbstractSQLInsertClause<C extends AbstractSQLInsertClause<C>>

java.lang.Object

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

com.querydsl.sql.dml.AbstractSQLInsertClause<C>

Type Parameters:

C - The type extending this class.

All Implemented Interfaces:

DMLClause<C>, InsertClause<C>, StoreClause<C>

Direct Known Subclasses:

SQLInsertClause

public abstract class AbstractSQLInsertClause<C extends AbstractSQLInsertClause<C>>
extends AbstractSQLClause<C>
implements InsertClause<C>

Provides a base class for dialect-specific INSERT clauses.

Author:

tiwe

Field Summary

Fields

Modifier and Type	Field and Description
protected List<SQLInsertBatch>	batches
protected boolean	batchToBulk
protected List<Path<?>>	columns
protected List<Object>	constants
protected RelationalPath<?>	entity
protected static org.slf4j.Logger	logger
protected QueryMetadata	metadata
protected String	queryString
protected SubQueryExpression<?>	subQuery
protected SQLQuery<?>	subQueryBuilder
protected List<Expression<?>>	values

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

configuration, context, listeners, useLiterals

Constructor Summary

Constructors

Constructor and Description
AbstractSQLInsertClause(Connection connection, Configuration configuration, RelationalPath<?> entity)
AbstractSQLInsertClause(Connection connection, Configuration configuration, RelationalPath<?> entity, SQLQuery<?> subQuery)
AbstractSQLInsertClause(javax.inject.Provider<Connection> connection, Configuration configuration, RelationalPath<?> entity)
AbstractSQLInsertClause(javax.inject.Provider<Connection> connection, Configuration configuration, RelationalPath<?> entity, SQLQuery<?> subQuery)

Method Summary

Modifier and Type	Method and Description
C	addBatch() Add the current state of bindings as a batch item
C	addFlag(QueryFlag.Position position, Expression<?> flag) Add the given Expression at the given position as a query flag
C	addFlag(QueryFlag.Position position, String flag) Add the given String literal at the given position as a query flag
void	clear() Clear the internal state of the clause
C	columns(Path<?>... columns) Define the columns to be populated
protected PreparedStatement	createStatement(boolean withKeys)
protected Collection<PreparedStatement>	createStatements(boolean withKeys)
long	execute() Execute the clause and return the amount of affected rows
<T> T	executeWithKey(Class<T> type) Execute the clause and return the generated key cast to the given type.
protected <T> T	executeWithKey(Class<T> type, Path<T> path)
<T> T	executeWithKey(Path<T> path) Execute the clause and return the generated key with the type of the given path.
ResultSet	executeWithKeys() Execute the clause and return the generated keys as a ResultSet
<T> List<T>	executeWithKeys(Class<T> type)
protected <T> List<T>	executeWithKeys(Class<T> type, Path<T> path)
<T> List<T>	executeWithKeys(Path<T> path) Execute the clause and return the generated key with the type of the given path.
int	getBatchCount()
List<SQLBindings>	getSQL() Get the SQL string and bindings
boolean	isEmpty() Returns true, if no bindings have been set, otherwise false.
C	populate(Object bean) Populate the INSERT clause with the properties of the given bean.
<T> C	populate(T obj, Mapper<T> mapper) Populate the INSERT clause with the properties of the given bean using the given Mapper.
protected PreparedStatement	prepareStatementAndSetParameters(SQLSerializer serializer, boolean withKeys)
C	select(SubQueryExpression<?> sq) Define the populate via subquery
<T> C	set(Path<T> path, Expression<? extends T> expression) Add an expression binding
<T> C	set(Path<T> path, T value) Add a value binding
void	setBatchToBulk(boolean b) Set whether batches should be optimized into a single bulk operation.
<T> C	setNull(Path<T> path) Bind the given path to null
String	toString()
C	values(Object... v) Define the value bindings

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

addListener, cleanupMDC, 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 org.slf4j.Logger logger

entity

protected final RelationalPath<?> entity

metadata

protected final QueryMetadata metadata

subQuery

@Nullable
protected SubQueryExpression<?> subQuery

subQueryBuilder

@Nullable
protected SQLQuery<?> subQueryBuilder

batches

protected final List<SQLInsertBatch> batches

columns

protected final List<Path<?>> columns

values

protected final List<Expression<?>> values

queryString

protected transient String queryString

constants

protected transient List<Object> constants

batchToBulk

protected transient boolean batchToBulk

Constructor Detail

AbstractSQLInsertClause

public AbstractSQLInsertClause(Connection connection,
                               Configuration configuration,
                               RelationalPath<?> entity,
                               SQLQuery<?> subQuery)

AbstractSQLInsertClause

public AbstractSQLInsertClause(Connection connection,
                               Configuration configuration,
                               RelationalPath<?> entity)

AbstractSQLInsertClause

public AbstractSQLInsertClause(javax.inject.Provider<Connection> connection,
                               Configuration configuration,
                               RelationalPath<?> entity,
                               SQLQuery<?> subQuery)

AbstractSQLInsertClause

public AbstractSQLInsertClause(javax.inject.Provider<Connection> connection,
                               Configuration configuration,
                               RelationalPath<?> entity)

Method Detail

addFlag

@WithBridgeMethods(value=SQLInsertClause.class,
                   castRequired=true)
public C addFlag(QueryFlag.Position position,
                                                                                                       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

@WithBridgeMethods(value=SQLInsertClause.class,
                   castRequired=true)
public C 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

addBatch

@WithBridgeMethods(value=SQLInsertClause.class,
                   castRequired=true)
public C addBatch()

Add the current state of bindings as a batch item

Returns:

the current object

setBatchToBulk

public void setBatchToBulk(boolean b)

Set whether batches should be optimized into a single bulk operation. Will revert to batches, if bulk is not supported

clear

public void clear()

Description copied from class: AbstractSQLClause

Clear the internal state of the clause

Specified by:

clear in class AbstractSQLClause<C extends AbstractSQLInsertClause<C>>

columns

@WithBridgeMethods(value=SQLInsertClause.class,
                   castRequired=true)
public C columns(Path<?>... columns)

Description copied from interface: InsertClause

Define the columns to be populated

Specified by:

columns in interface InsertClause<C extends AbstractSQLInsertClause<C>>

Parameters:

columns - columns to be populated

Returns:

the current object

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(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(Class<T> type,
                               @Nullable
                               Path<T> path)

executeWithKeys

public <T> 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> List<T> executeWithKeys(Class<T> type)

executeWithKeys

protected <T> List<T> executeWithKeys(Class<T> type,
                                      @Nullable
                                      Path<T> path)

createStatement

protected PreparedStatement createStatement(boolean withKeys)
                                     throws SQLException

Throws:

SQLException

createStatements

protected Collection<PreparedStatement> createStatements(boolean withKeys)
                                                  throws SQLException

Throws:

SQLException

prepareStatementAndSetParameters

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

Throws:

SQLException

executeWithKeys

public ResultSet executeWithKeys()

Execute the clause and return the generated keys as a ResultSet

Returns:

result set with generated keys

execute

public long execute()

Description copied from interface: DMLClause

Execute the clause and return the amount of affected rows

Specified by:

execute in interface DMLClause<C extends AbstractSQLInsertClause<C>>

Returns:

amount of affected rows

getSQL

public List<SQLBindings> getSQL()

Description copied from class: AbstractSQLClause

Get the SQL string and bindings

Specified by:

getSQL in class AbstractSQLClause<C extends AbstractSQLInsertClause<C>>

Returns:

SQL and bindings

select

@WithBridgeMethods(value=SQLInsertClause.class,
                   castRequired=true)
public C select(SubQueryExpression<?> sq)

Description copied from interface: InsertClause

Define the populate via subquery

Specified by:

select in interface InsertClause<C extends AbstractSQLInsertClause<C>>

Parameters:

sq - sub query to be used for population

Returns:

the current object

set

@WithBridgeMethods(value=SQLInsertClause.class,
                   castRequired=true)
public <T> C set(Path<T> path,
                                                                                                       T value)

Description copied from interface: StoreClause

Add a value binding

Specified by:

set in interface StoreClause<C extends AbstractSQLInsertClause<C>>

Parameters:

path - path to be updated

value - value to set

Returns:

the current object

set

@WithBridgeMethods(value=SQLInsertClause.class,
                   castRequired=true)
public <T> C set(Path<T> path,
                                                                                                       Expression<? extends T> expression)

Description copied from interface: StoreClause

Add an expression binding

Specified by:

set in interface StoreClause<C extends AbstractSQLInsertClause<C>>

Parameters:

path - path to be updated

expression - binding

Returns:

the current object

setNull

@WithBridgeMethods(value=SQLInsertClause.class,
                   castRequired=true)
public <T> C setNull(Path<T> path)

Description copied from interface: StoreClause

Bind the given path to null

Specified by:

setNull in interface StoreClause<C extends AbstractSQLInsertClause<C>>

Parameters:

path - path to be updated

Returns:

the current object

values

@WithBridgeMethods(value=SQLInsertClause.class,
                   castRequired=true)
public C values(Object... v)

Description copied from interface: InsertClause

Define the value bindings

Specified by:

values in interface InsertClause<C extends AbstractSQLInsertClause<C>>

Parameters:

v - values to be inserted

Returns:

the current object

toString

public String toString()

Overrides:

toString in class Object

populate

@WithBridgeMethods(value=SQLInsertClause.class,
                   castRequired=true)
public C populate(Object bean)

Populate the INSERT clause with the properties of the given bean. The properties need to match the fields of the clause's entity instance.

Parameters:

bean - bean to use for population

Returns:

the current object

populate

@WithBridgeMethods(value=SQLInsertClause.class,
                   castRequired=true)
public <T> C populate(T obj,
                                                                                                            Mapper<T> mapper)

Populate the INSERT clause with the properties of the given bean using the given Mapper.

Parameters:

obj - object to use for population

mapper - mapper to use

Returns:

the current object

isEmpty

public boolean isEmpty()

Description copied from interface: StoreClause

Returns true, if no bindings have been set, otherwise false.

Specified by:

isEmpty in interface StoreClause<C extends AbstractSQLInsertClause<C>>

Returns:

true, if empty, false, if not

getBatchCount

public int getBatchCount()

Specified by:

getBatchCount in class AbstractSQLClause<C extends AbstractSQLInsertClause<C>>