sirius.db.jdbc.batch

Class CustomQuery

java.lang.Object

sirius.db.jdbc.batch.BatchQuery<SQLEntity>

sirius.db.jdbc.batch.CustomQuery

public class CustomQuery
extends BatchQuery<SQLEntity>

Wraps a SQL statement as BatchSQLQuery.

Field Summary

Fields inherited from class sirius.db.jdbc.batch.BatchQuery

avarage, batchBacklog, batchBacklogLimit, context, descriptor, mappings, MAX_BATCH_BACKLOG, mixing, oma, properties, query, stmt, type

Constructor Summary

Constructors

Modifier	Constructor and Description
protected	CustomQuery(BatchContext context, Class<? extends SQLEntity> type, boolean fetchId, String sql)

Method Summary

Modifier and Type	Method and Description
protected void	buildSQL() Determines the SQL statement to prepare in BatchQuery.prepareStmt().
void	clearParameters() Resets all previously set parameters.
void	executeBatchUpdate() Executes the statement as batched update.
Row	executeUpdate() Executes the prepared statement as update (or delete).
BatchSQLQuery	query() Executes the statement as query.
void	setParameter(int oneBasedIndex, Object value) Sets the given parameter to the given value.

Methods inherited from class sirius.db.jdbc.batch.BatchQuery

addBatch, close, commit, createStmt, getDescriptor, getProperties, prepareStmt, safeClose, toString, tryCommit, withCustomBatchLimit

Methods inherited from class java.lang.Object

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

Constructor Detail

CustomQuery

protected CustomQuery(BatchContext context,
                      Class<? extends SQLEntity> type,
                      boolean fetchId,
                      String sql)

Method Detail

clearParameters

public void clearParameters()
                     throws SQLException

Resets all previously set parameters.

Throws:

SQLException - in case of a database error

setParameter

public void setParameter(int oneBasedIndex,
                         Object value)
                  throws SQLException

Sets the given parameter to the given value.

Parameters:

oneBasedIndex - the one-based index of the parameter to set

value - the parameter value to set

Throws:

SQLException - in case of a database error

executeUpdate

@Nullable
public Row executeUpdate()
                            throws SQLException

Executes the prepared statement as update (or delete).

Returns:

a row containing the generated keys or nullif fetching is disabled

Throws:

SQLException - in case of a database error

executeBatchUpdate

public void executeBatchUpdate()
                        throws SQLException

Executes the statement as batched update.

Throws:

SQLException - in case of a database error

query

public BatchSQLQuery query()

Executes the statement as query.

Returns:

the statement as query

buildSQL

protected void buildSQL()
                 throws SQLException

Description copied from class: BatchQuery

Determines the SQL statement to prepare in BatchQuery.prepareStmt().

Specified by:

buildSQL in class BatchQuery<SQLEntity>

Throws:

SQLException - in case of a database error