sirius.db.jdbc.batch

Class BatchSQLQuery

java.lang.Object

sirius.db.jdbc.BaseSQLQuery

sirius.db.jdbc.batch.BatchSQLQuery

public class BatchSQLQuery
extends BaseSQLQuery

Represents an sql query which can be used within a BatchContext by creating a CustomQuery.

Field Summary

Fields

Modifier and Type	Field and Description
protected CustomQuery	query

Fields inherited from class sirius.db.jdbc.BaseSQLQuery

dbs, fieldNames

Constructor Summary

Constructors

Modifier	Constructor and Description
protected	BatchSQLQuery(CustomQuery customQuery)

Method Summary

Modifier and Type	Method and Description
void	iterate(Function<Row,Boolean> handler, sirius.kernel.commons.Limit limit) Executes the given query by invoking the given handler for each result row.
protected void	writeBlobToParameter(String name, Blob blob)

Methods inherited from class sirius.db.jdbc.BaseSQLQuery

first, iterateAll, loadIntoRow, processResultSet, queryFirst, queryList, queryList

Methods inherited from class java.lang.Object

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

Field Detail

query

protected CustomQuery query

Constructor Detail

BatchSQLQuery

protected BatchSQLQuery(CustomQuery customQuery)

Method Detail

iterate

public void iterate(Function<Row,Boolean> handler,
                    @Nullable
                    sirius.kernel.commons.Limit limit)
             throws SQLException

Description copied from class: BaseSQLQuery

Executes the given query by invoking the given handler for each result row.

Consider using the method instead of BaseSQLQuery.queryList() if a large result set is expected as this method. As this method only processes one row at a time, this might be much more memory efficient.

Specified by:

iterate in class BaseSQLQuery

Parameters:

handler - the row handler invoked for each row

limit - the limit which controls which and how many rows are output. Can be null to indicate that there is no limit.

Throws:

SQLException - in case of a database error

writeBlobToParameter

protected void writeBlobToParameter(String name,
                                    Blob blob)
                             throws SQLException

Specified by:

writeBlobToParameter in class BaseSQLQuery

Throws:

SQLException