com.querydsl.sql.dml

Class SQLInsertClause

java.lang.Object

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

com.querydsl.sql.dml.SQLInsertClause

All Implemented Interfaces:

DMLClause<SQLInsertClause>, InsertClause<SQLInsertClause>, StoreClause<SQLInsertClause>

Direct Known Subclasses:

MySQLReplaceClause

public class SQLInsertClause
extends AbstractSQLClause<SQLInsertClause>
implements InsertClause<SQLInsertClause>

SQLInsertClause defines an INSERT INTO clause

Author:

tiwe

Field Summary

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

configuration, context, listeners, useLiterals

Constructor Summary

Constructors

Constructor and Description
SQLInsertClause(Connection connection, Configuration configuration, RelationalPath<?> entity)
SQLInsertClause(Connection connection, Configuration configuration, RelationalPath<?> entity, SQLQuery<?> subQuery)
SQLInsertClause(Connection connection, SQLTemplates templates, RelationalPath<?> entity)
SQLInsertClause(Connection connection, SQLTemplates templates, RelationalPath<?> entity, SQLQuery<?> subQuery)

Method Summary

Modifier and Type	Method and Description
SQLInsertClause	addBatch() Add the current state of bindings as a batch item
SQLInsertClause	addFlag(QueryFlag.Position position, Expression<?> flag) Add the given Expression at the given position as a query flag
SQLInsertClause	addFlag(QueryFlag.Position position, String flag) Add the given String literal at the given position as a query flag
SQLInsertClause	columns(Path<?>... columns)
long	execute()
<T> T	executeWithKey(Class<T> type) Execute the clause and return the generated key cast to the given type.
<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)
<T> List<T>	executeWithKeys(Path<T> path) Execute the clause and return the generated key with the type of the given path.
List<SQLBindings>	getSQL() Get the SQL string and bindings
boolean	isEmpty()
SQLInsertClause	populate(Object bean) Populate the INSERT clause with the properties of the given bean.
<T> SQLInsertClause	populate(T obj, Mapper<T> mapper) Populate the INSERT clause with the properties of the given bean using the given Mapper.
SQLInsertClause	select(SubQueryExpression<?> sq)
<T> SQLInsertClause	set(Path<T> path, Expression<? extends T> expression)
<T> SQLInsertClause	set(Path<T> path, T value)
<T> SQLInsertClause	setNull(Path<T> path)
String	toString()
SQLInsertClause	values(Object... v)

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

addListener, cleanupMDC, close, close, close, 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

Constructor Detail

SQLInsertClause

public SQLInsertClause(Connection connection,
                       SQLTemplates templates,
                       RelationalPath<?> entity)

SQLInsertClause

public SQLInsertClause(Connection connection,
                       SQLTemplates templates,
                       RelationalPath<?> entity,
                       SQLQuery<?> subQuery)

SQLInsertClause

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

SQLInsertClause

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

Method Detail

addFlag

public SQLInsertClause 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

public SQLInsertClause 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

public SQLInsertClause addBatch()

Add the current state of bindings as a batch item

Returns:

the current object

columns

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

Specified by:

columns in interface InsertClause<SQLInsertClause>

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

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

public 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<SQLInsertClause>

getSQL

public List<SQLBindings> getSQL()

Description copied from class: AbstractSQLClause

Get the SQL string and bindings

Specified by:

getSQL in class AbstractSQLClause<SQLInsertClause>

Returns:

SQL and bindings

select

public SQLInsertClause select(SubQueryExpression<?> sq)

Specified by:

select in interface InsertClause<SQLInsertClause>

set

public <T> SQLInsertClause set(Path<T> path,
                               T value)

Specified by:

set in interface StoreClause<SQLInsertClause>

set

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

Specified by:

set in interface StoreClause<SQLInsertClause>

setNull

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

Specified by:

setNull in interface StoreClause<SQLInsertClause>

values

public SQLInsertClause values(Object... v)

Specified by:

values in interface InsertClause<SQLInsertClause>

toString

public String toString()

Overrides:

toString in class Object

populate

public SQLInsertClause 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

public <T> SQLInsertClause 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()

Specified by:

isEmpty in interface StoreClause<SQLInsertClause>