public interface CqlOperations
CqlTemplate
. Not often used directly, but
a useful option to enhance testability, as it can easily be mocked or stubbed.CqlTemplate
Modifier and Type | Method and Description |
---|---|
List<RingMember> |
describeRing()
Describe the current Ring.
|
<T> Collection<T> |
describeRing(HostMapper<T> hostMapper)
Describe the current Ring.
|
boolean |
execute(PreparedStatementCreator psc)
Issue a single CQL execute operation (such as an insert, update or delete statement) using a
PreparedStatementCreator to provide CQL and any required parameters. |
<T> T |
execute(PreparedStatementCreator preparedStatementCreator,
PreparedStatementCallback<T> action)
Execute a CQL data access operation, implemented as callback action working on a CQL
PreparedStatement . |
<T> T |
execute(SessionCallback<T> action)
Execute a CQL data access operation, implemented as callback action working on a
CqlSession . |
boolean |
execute(com.datastax.oss.driver.api.core.cql.Statement<?> statement)
Issue a single CQL execute, typically a DDL statement, insert, update or delete statement.
|
boolean |
execute(String cql)
Issue a single CQL execute, typically a DDL statement, insert, update or delete statement.
|
boolean |
execute(String cql,
Object... args)
Issue a single CQL operation (such as an insert, update or delete statement) via a prepared statement, binding the
given arguments.
|
boolean |
execute(String cql,
PreparedStatementBinder psb)
Issue an statement using a
PreparedStatementBinder to set bind parameters, with given CQL. |
<T> T |
execute(String cql,
PreparedStatementCallback<T> action)
Execute a CQL data access operation, implemented as callback action working on a CQL
PreparedStatement . |
<T> T |
query(PreparedStatementCreator preparedStatementCreator,
PreparedStatementBinder psb,
ResultSetExtractor<T> resultSetExtractor)
Query using a prepared statement and a
PreparedStatementBinder implementation that knows how to bind values
to the query, reading the ResultSet with a ResultSetExtractor . |
void |
query(PreparedStatementCreator preparedStatementCreator,
PreparedStatementBinder psb,
RowCallbackHandler rowCallbackHandler)
Query using a prepared statement and a
PreparedStatementBinder implementation that knows how to bind values
to the query, reading the ResultSet on a per-row basis with a RowCallbackHandler . |
<T> List<T> |
query(PreparedStatementCreator preparedStatementCreator,
PreparedStatementBinder psb,
RowMapper<T> rowMapper)
Query using a prepared statement and a
PreparedStatementBinder implementation that knows how to bind values
to the query, mapping each row to a Java object via a RowMapper . |
<T> T |
query(PreparedStatementCreator preparedStatementCreator,
ResultSetExtractor<T> resultSetExtractor)
Query using a prepared statement, reading the
ResultSet with a ResultSetExtractor . |
void |
query(PreparedStatementCreator preparedStatementCreator,
RowCallbackHandler rowCallbackHandler)
Query using a prepared statement, reading the
ResultSet on a per-row basis with a
RowCallbackHandler . |
<T> List<T> |
query(PreparedStatementCreator preparedStatementCreator,
RowMapper<T> rowMapper)
Query using a prepared statement, mapping each row to a Java object via a
RowMapper . |
<T> T |
query(com.datastax.oss.driver.api.core.cql.Statement<?> statement,
ResultSetExtractor<T> resultSetExtractor)
Execute a query given static CQL, reading the
ResultSet with a ResultSetExtractor . |
void |
query(com.datastax.oss.driver.api.core.cql.Statement<?> statement,
RowCallbackHandler rowCallbackHandler)
Execute a query given static CQL, reading the
ResultSet on a per-row basis with a
RowCallbackHandler . |
<T> List<T> |
query(com.datastax.oss.driver.api.core.cql.Statement<?> statement,
RowMapper<T> rowMapper)
Execute a query given static CQL, mapping each row to a Java object via a
RowMapper . |
<T> T |
query(String cql,
PreparedStatementBinder psb,
ResultSetExtractor<T> resultSetExtractor)
Query using a prepared statement, reading the
ResultSet with a ResultSetExtractor . |
void |
query(String cql,
PreparedStatementBinder psb,
RowCallbackHandler rowCallbackHandler)
Query given CQL to create a prepared statement from CQL and a
PreparedStatementBinder implementation that
knows how to bind values to the query, reading the ResultSet on a per-row basis with a
RowCallbackHandler . |
<T> List<T> |
query(String cql,
PreparedStatementBinder psb,
RowMapper<T> rowMapper)
Query given CQL to create a prepared statement from CQL and a
PreparedStatementBinder implementation that
knows how to bind values to the query, mapping each row to a Java object via a RowMapper . |
<T> T |
query(String cql,
ResultSetExtractor<T> resultSetExtractor)
Execute a query given static CQL, reading the
ResultSet with a ResultSetExtractor . |
<T> T |
query(String cql,
ResultSetExtractor<T> resultSetExtractor,
Object... args)
Query given CQL to create a prepared statement from CQL and a list of arguments to bind to the query, reading the
ResultSet with a ResultSetExtractor . |
void |
query(String cql,
RowCallbackHandler rowCallbackHandler)
Execute a query given static CQL, reading the
ResultSet on a per-row basis with a
RowCallbackHandler . |
void |
query(String cql,
RowCallbackHandler rowCallbackHandler,
Object... args)
Query given CQL to create a prepared statement from CQL and a list of arguments to bind to the query, reading the
ResultSet on a per-row basis with a RowCallbackHandler . |
<T> List<T> |
query(String cql,
RowMapper<T> rowMapper)
Execute a query given static CQL, mapping each row to a Java object via a
RowMapper . |
<T> List<T> |
query(String cql,
RowMapper<T> rowMapper,
Object... args)
Query given CQL to create a prepared statement from CQL and a list of arguments to bind to the query, mapping each
row to a Java object via a
RowMapper . |
List<Map<String,Object>> |
queryForList(com.datastax.oss.driver.api.core.cql.Statement<?> statement)
Execute a query for a result
List , given static CQL. |
<T> List<T> |
queryForList(com.datastax.oss.driver.api.core.cql.Statement<?> statement,
Class<T> elementType)
Execute a query for a result
List , given static CQL. |
List<Map<String,Object>> |
queryForList(String cql)
Execute a query for a result
List , given static CQL. |
<T> List<T> |
queryForList(String cql,
Class<T> elementType)
Execute a query for a result
List , given static CQL. |
<T> List<T> |
queryForList(String cql,
Class<T> elementType,
Object... args)
Query given CQL to create a prepared statement from CQL and a list of arguments to bind to the query, expecting a
result
List . |
List<Map<String,Object>> |
queryForList(String cql,
Object... args)
Query given CQL to create a prepared statement from CQL and a list of arguments to bind to the query, expecting a
result
List . |
Map<String,Object> |
queryForMap(com.datastax.oss.driver.api.core.cql.Statement<?> statement)
Execute a query for a result Map, given static CQL.
|
Map<String,Object> |
queryForMap(String cql)
Execute a query for a result Map, given static CQL.
|
Map<String,Object> |
queryForMap(String cql,
Object... args)
Query given CQL to create a prepared statement from CQL and a list of arguments to bind to the query, expecting a
result Map.
|
<T> T |
queryForObject(com.datastax.oss.driver.api.core.cql.Statement<?> statement,
Class<T> requiredType)
Execute a query for a result object, given static CQL.
|
<T> T |
queryForObject(com.datastax.oss.driver.api.core.cql.Statement<?> statement,
RowMapper<T> rowMapper)
Execute a query given static CQL, mapping a single result row to a Java object via a
RowMapper . |
<T> T |
queryForObject(String cql,
Class<T> requiredType)
Execute a query for a result object, given static CQL.
|
<T> T |
queryForObject(String cql,
Class<T> requiredType,
Object... args)
Query given CQL to create a prepared statement from CQL and a list of arguments to bind to the query, expecting a
result object.
|
<T> T |
queryForObject(String cql,
RowMapper<T> rowMapper)
Execute a query given static CQL, mapping a single result row to a Java object via a
RowMapper . |
<T> T |
queryForObject(String cql,
RowMapper<T> rowMapper,
Object... args)
Query given CQL to create a prepared statement from CQL and a list of arguments to bind to the query, mapping a
single result row to a Java object via a
RowMapper . |
com.datastax.oss.driver.api.core.cql.ResultSet |
queryForResultSet(com.datastax.oss.driver.api.core.cql.Statement<?> statement)
Execute a query for a ResultSet, given static CQL.
|
com.datastax.oss.driver.api.core.cql.ResultSet |
queryForResultSet(String cql)
Execute a query for a ResultSet, given static CQL.
|
com.datastax.oss.driver.api.core.cql.ResultSet |
queryForResultSet(String cql,
Object... args)
Query given CQL to create a prepared statement from CQL and a list of arguments to bind to the query, expecting a
ResultSet.
|
Iterable<com.datastax.oss.driver.api.core.cql.Row> |
queryForRows(com.datastax.oss.driver.api.core.cql.Statement<?> statement)
Execute a query for Rows, given static CQL.
|
Iterable<com.datastax.oss.driver.api.core.cql.Row> |
queryForRows(String cql)
Execute a query for Rows, given static CQL.
|
Iterable<com.datastax.oss.driver.api.core.cql.Row> |
queryForRows(String cql,
Object... args)
Query given CQL to create a prepared statement from CQL and a list of arguments to bind to the query, expecting
Rows.
|
<T> Stream<T> |
queryForStream(PreparedStatementCreator preparedStatementCreator,
PreparedStatementBinder psb,
RowMapper<T> rowMapper)
Query using a prepared statement and a
PreparedStatementBinder implementation that knows how to bind values
to the query, mapping each row to a Java object via a RowMapper and turning it into an iterable
Stream . |
<T> Stream<T> |
queryForStream(PreparedStatementCreator preparedStatementCreator,
RowMapper<T> rowMapper)
|
<T> Stream<T> |
queryForStream(com.datastax.oss.driver.api.core.cql.Statement<?> statement,
RowMapper<T> rowMapper)
|
<T> Stream<T> |
queryForStream(String cql,
RowMapper<T> rowMapper,
Object... args)
|
@Nullable <T> T execute(SessionCallback<T> action) throws DataAccessException
CqlSession
. This allows for implementing arbitrary data access operations,
within Spring's managed CQL environment: that is, converting CQL
DriverException
s into Spring's DataAccessException
hierarchy.
The callback action can return a result object, for example a domain object or a collection of domain objects.
action
- the callback object that specifies the action.DataAccessException
- if there is any problem executing the query.boolean execute(String cql) throws DataAccessException
cql
- static CQL to execute, must not be empty or null.DataAccessException
- if there is any problem executing the query.boolean execute(String cql, Object... args) throws DataAccessException
cql
- static CQL to execute, must not be empty or null.args
- arguments to bind to the query (leaving it to the PreparedStatement
to guess the corresponding
CQL type).DataAccessException
- if there is any problem executing the query.boolean execute(String cql, @Nullable PreparedStatementBinder psb) throws DataAccessException
PreparedStatementBinder
to set bind parameters, with given CQL. Simpler than
using a PreparedStatementCreator
as this method will create the PreparedStatement
: The
PreparedStatementBinder
just needs to set parameters.cql
- static CQL to execute, must not be empty or null.psb
- object that knows how to set values on the prepared statement. If this is null, the CQL will
be assumed to contain no bind parameters. Even if there are no bind parameters, this object may be used to
set fetch size and other performance options.DataAccessException
- if there is any problem executing the query.@Nullable <T> T execute(String cql, PreparedStatementCallback<T> action) throws DataAccessException
PreparedStatement
.
This allows for implementing arbitrary data access operations on a single Statement, within Spring's managed CQL
environment: that is, participating in Spring-managed transactions and converting CQL
DriverException
s into Spring's DataAccessException
hierarchy.
The callback action can return a result object, for example a domain object or a collection of domain objects.
cql
- static CQL to execute, must not be empty or null.action
- callback object that specifies the action, must not be null.DataAccessException
- if there is any problem executing the query.@Nullable <T> T query(String cql, ResultSetExtractor<T> resultSetExtractor) throws DataAccessException
ResultSet
with a ResultSetExtractor
.
Uses a CQL Statement, not a PreparedStatement
. If you want to execute a static query with a
PreparedStatement
, use the overloaded query
method with null as argument array.
cql
- static CQL to execute, must not be empty or null.resultSetExtractor
- object that will extract all rows of results, must not be null.DataAccessException
- if there is any problem executing the query.query(String, ResultSetExtractor, Object...)
void query(String cql, RowCallbackHandler rowCallbackHandler) throws DataAccessException
ResultSet
on a per-row basis with a
RowCallbackHandler
.
Uses a CQL Statement, not a PreparedStatement
. If you want to execute a static query with a
PreparedStatement
, use the overloaded query
method with null as argument array.
cql
- static CQL to execute, must not be empty or null.rowCallbackHandler
- object that will extract results, one row at a time, must not be null.DataAccessException
- if there is any problem executing the query.query(String, RowCallbackHandler, Object[])
<T> List<T> query(String cql, RowMapper<T> rowMapper) throws DataAccessException
RowMapper
.
Uses a CQL Statement, not a PreparedStatement
. If you want to execute a static query with a
PreparedStatement
, use the overloaded query
method with null as argument array.
cql
- static CQL to execute, must not be empty or null.rowMapper
- object that will map one object per row, must not be null.List
, containing mapped objects.DataAccessException
- if there is any problem executing the query.query(String, RowMapper, Object[])
@Nullable <T> T query(String cql, ResultSetExtractor<T> resultSetExtractor, Object... args) throws DataAccessException
ResultSet
with a ResultSetExtractor
.cql
- static CQL to execute, must not be empty or null.resultSetExtractor
- object that will extract results, must not be null.args
- arguments to bind to the query (leaving it to the PreparedStatement
to guess the corresponding
CQL type).ResultSetExtractor
DataAccessException
- if there is any problem executing the query.void query(String cql, RowCallbackHandler rowCallbackHandler, Object... args) throws DataAccessException
ResultSet
on a per-row basis with a RowCallbackHandler
.cql
- static CQL to execute, must not be empty or null.rowCallbackHandler
- object that will extract results, one row at a time, must not be null.args
- arguments to bind to the query (leaving it to the PreparedStatement
to guess the corresponding
CQL type)DataAccessException
- if there is any problem executing the query.<T> List<T> query(String cql, RowMapper<T> rowMapper, Object... args) throws DataAccessException
RowMapper
.cql
- static CQL to execute, must not be empty or null.rowMapper
- object that will map one object per rowargs
- arguments to bind to the query (leaving it to the PreparedStatement
to guess the corresponding
CQL type)List
, containing mapped objectsDataAccessException
- if there is any problem executing the query.<T> Stream<T> queryForStream(String cql, RowMapper<T> rowMapper, Object... args) throws DataAccessException
RowMapper
and turning it into an iterable Stream
.cql
- static CQL to execute, must not be empty or null.rowMapper
- object that will map one object per rowargs
- arguments to bind to the query (leaving it to the PreparedStatement
to guess the corresponding
CQL type)Stream
, containing mapped objectsDataAccessException
- if there is any problem executing the query.@Nullable <T> T query(String cql, @Nullable PreparedStatementBinder psb, ResultSetExtractor<T> resultSetExtractor) throws DataAccessException
ResultSet
with a ResultSetExtractor
.cql
- static CQL to execute, must not be empty or null.psb
- object that knows how to set values on the prepared statement. If this is null, the CQL will
be assumed to contain no bind parameters. Even if there are no bind parameters, this object may be used to
set fetch size and other performance options.resultSetExtractor
- object that will extract results, must not be null.ResultSetExtractor
.DataAccessException
- if there is any problem executing the query.void query(String cql, @Nullable PreparedStatementBinder psb, RowCallbackHandler rowCallbackHandler) throws DataAccessException
PreparedStatementBinder
implementation that
knows how to bind values to the query, reading the ResultSet
on a per-row basis with a
RowCallbackHandler
.cql
- static CQL to execute, must not be empty or null.psb
- object that knows how to set values on the prepared statement. If this is null, the CQL will
be assumed to contain no bind parameters. Even if there are no bind parameters, this object may be used to
set fetch size and other performance options.rowCallbackHandler
- object that will extract results, one row at a time, must not be null.DataAccessException
- if there is any problem executing the query.<T> List<T> query(String cql, @Nullable PreparedStatementBinder psb, RowMapper<T> rowMapper) throws DataAccessException
PreparedStatementBinder
implementation that
knows how to bind values to the query, mapping each row to a Java object via a RowMapper
.cql
- static CQL to execute, must not be empty or null.psb
- object that knows how to set values on the prepared statement. If this is null, the CQL will
be assumed to contain no bind parameters. Even if there are no bind parameters, this object may be used to
set fetch size and other performance options.rowMapper
- object that will map one object per row, must not be null.List
, containing mapped objects.DataAccessException
- if there is any problem executing the query.List<Map<String,Object>> queryForList(String cql) throws DataAccessException
List
, given static CQL.
Uses a CQL Statement, not a PreparedStatement
. If you want to execute a static query with a
PreparedStatement
, use the overloaded queryForList
method with null as argument array.
The results will be mapped to a List
(one item for each row) of Map
s (one entry for each column
using the column name as the key). Each item in the List
will be of the form returned by this interface's
queryForMap() methods.
cql
- static CQL to execute, must not be empty or null.List
that contains a Map
per row.DataAccessException
- if there is any problem executing the query.queryForList(String, Object[])
List<Map<String,Object>> queryForList(String cql, Object... args) throws DataAccessException
List
.
The results will be mapped to a List
(one item for each row) of Map
s (one entry for each column,
using the column name as the key). Each item in the List
will be of the form returned by this interface's
queryForMap() methods.
cql
- static CQL to execute, must not be empty or null.args
- arguments to bind to the query (leaving it to the PreparedStatement
to guess the corresponding
CQL type).List
that contains a Map
per rowDataAccessException
- if there is any problem executing the query.queryForList(String)
<T> List<T> queryForList(String cql, Class<T> elementType) throws DataAccessException
List
, given static CQL.
Uses a CQL Statement, not a PreparedStatement
. If you want to execute a static query with a
PreparedStatement
, use the overloaded queryForList
method with null as argument array.
The results will be mapped to a List
(one item for each row) of result objects, each of them matching the
specified element type.
cql
- static CQL to execute, must not be empty or null.elementType
- the required type of element in the result List
(for example, Integer.class
),
must not be null.List
of objects that match the specified element type.DataAccessException
- if there is any problem executing the query.queryForList(String, Class, Object[])
,
SingleColumnRowMapper
<T> List<T> queryForList(String cql, Class<T> elementType, Object... args) throws DataAccessException
List
.
The results will be mapped to a List
(one item for each row) of result objects, each of them matching the
specified element type.
cql
- static CQL to execute, must not be empty or null.elementType
- the required type of element in the result List
(for example, Integer.class
),
must not be null.args
- arguments to bind to the query (leaving it to the PreparedStatement
to guess the corresponding
CQL type).List
of objects that match the specified element type.DataAccessException
- if there is any problem executing the query.queryForList(String, Class)
,
SingleColumnRowMapper
Map<String,Object> queryForMap(String cql) throws DataAccessException
Uses a CQL Statement, not a PreparedStatement
. If you want to execute a static query with a
PreparedStatement
, use the overloaded queryForMap(String, Object...)
method with null
as argument array.
The query is expected to be a single row query; the result row will be mapped to a Map (one entry for each column, using the column name as the key).
cql
- static CQL to execute, must not be empty or null.IncorrectResultSizeDataAccessException
- if the query does not return exactly one row.DataAccessException
- if there is any problem executing the query.queryForMap(String, Object[])
,
ColumnMapRowMapper
Map<String,Object> queryForMap(String cql, Object... args) throws DataAccessException
The query is expected to be a single row query; the result row will be mapped to a Map (one entry for each column, using the column name as the key).
cql
- static CQL to execute, must not be empty or null.args
- arguments to bind to the query (leaving it to the PreparedStatement
to guess the corresponding
CQL type).IncorrectResultSizeDataAccessException
- if the query does not return exactly one rowDataAccessException
- if there is any problem executing the query.queryForMap(String)
,
ColumnMapRowMapper
<T> T queryForObject(String cql, Class<T> requiredType) throws DataAccessException
Uses a CQL Statement, not a PreparedStatement
. If you want to execute a static query with a
PreparedStatement
, use the overloaded queryForObject(String, Class, Object...)
method with
null as argument array.
This method is useful for running static CQL with a known outcome. The query is expected to be a single row/single column query; the returned result will be directly mapped to the corresponding object type.
cql
- static CQL to execute, must not be empty or null.requiredType
- the type that the result object is expected to match, must not be null.IncorrectResultSizeDataAccessException
- if the query does not return exactly one row, or does not return
exactly one column in that row.DataAccessException
- if there is any problem executing the query.queryForObject(String, Class, Object[])
<T> T queryForObject(String cql, Class<T> requiredType, Object... args) throws DataAccessException
The query is expected to be a single row/single column query; the returned result will be directly mapped to the corresponding object type.
cql
- static CQL to execute, must not be empty or null.requiredType
- the type that the result object is expected to match, must not be null.args
- arguments to bind to the query (leaving it to the PreparedStatement to guess the corresponding CQL
type)IncorrectResultSizeDataAccessException
- if the query does not return exactly one row, or does not return
exactly one column in that row.DataAccessException
- if there is any problem executing the query.queryForObject(String, Class)
<T> T queryForObject(String cql, RowMapper<T> rowMapper) throws DataAccessException
RowMapper
.
Uses a CQL Statement, not a PreparedStatement
. If you want to execute a static query with a
PreparedStatement
, use the overloaded queryForObject(String, RowMapper, Object...)
method with
null as argument array.
cql
- static CQL to execute, must not be empty or null.rowMapper
- object that will map one object per row, must not be null.IncorrectResultSizeDataAccessException
- if the query does not return exactly one row.DataAccessException
- if there is any problem executing the query.queryForObject(String, RowMapper, Object[])
<T> T queryForObject(String cql, RowMapper<T> rowMapper, Object... args) throws DataAccessException
RowMapper
.cql
- static CQL to execute, must not be empty or null.rowMapper
- object that will map one object per row, must not be null.args
- arguments to bind to the query (leaving it to the PreparedStatement
to guess the corresponding
CQL type)IncorrectResultSizeDataAccessException
- if the query does not return exactly one row.DataAccessException
- if there is any problem executing the query.com.datastax.oss.driver.api.core.cql.ResultSet queryForResultSet(String cql) throws DataAccessException
Uses a CQL Statement, not a PreparedStatement
. If you want to execute a static query with a
PreparedStatement
, use the overloaded queryForResultSet
method with null as argument
array.
The results will be mapped to an ResultSet
.
cql
- static CQL to execute, must not be empty or null.ResultSet
representation.DataAccessException
- if there is any problem executing the query.queryForResultSet(String, Object[])
com.datastax.oss.driver.api.core.cql.ResultSet queryForResultSet(String cql, Object... args) throws DataAccessException
The results will be mapped to an ResultSet
.
cql
- static CQL to execute, must not be empty or null.args
- arguments to bind to the query (leaving it to the PreparedStatement
to guess the corresponding
CQL type).ResultSet
representation.DataAccessException
- if there is any problem executing the query.queryForResultSet(String)
Iterable<com.datastax.oss.driver.api.core.cql.Row> queryForRows(String cql) throws DataAccessException
Uses a CQL Statement, not a PreparedStatement
. If you want to execute a static query with a
PreparedStatement
, use the overloaded queryForResultSet
method with null as argument
array.
The results will be mapped to Row
s.
cql
- static CQL to execute, must not be empty or null.DataAccessException
- if there is any problem executing the query.queryForResultSet(String, Object[])
Iterable<com.datastax.oss.driver.api.core.cql.Row> queryForRows(String cql, Object... args) throws DataAccessException
The results will be mapped to Row
s.
cql
- static CQL to execute, must not be empty or null.args
- arguments to bind to the query (leaving it to the PreparedStatement
to guess the corresponding
CQL type).Row
representation.DataAccessException
- if there is any problem executing the query.queryForResultSet(String)
boolean execute(com.datastax.oss.driver.api.core.cql.Statement<?> statement) throws DataAccessException
statement
- static CQL Statement
, must not be null.DataAccessException
- if there is any problem executing the query.@Nullable <T> T query(com.datastax.oss.driver.api.core.cql.Statement<?> statement, ResultSetExtractor<T> resultSetExtractor) throws DataAccessException
ResultSet
with a ResultSetExtractor
.
Uses a CQL Statement, not a PreparedStatement
. If you want to execute a static query with a
PreparedStatement
, use the overloaded query
method with null as argument array.
statement
- static CQL Statement
, must not be null.resultSetExtractor
- object that will extract all rows of results, must not be null.DataAccessException
- if there is any problem executing the query.query(String, ResultSetExtractor, Object...)
void query(com.datastax.oss.driver.api.core.cql.Statement<?> statement, RowCallbackHandler rowCallbackHandler) throws DataAccessException
ResultSet
on a per-row basis with a
RowCallbackHandler
.
Uses a CQL Statement, not a PreparedStatement
. If you want to execute a static query with a
PreparedStatement
, use the overloaded query
method with null as argument array.
statement
- static CQL Statement
, must not be null.rowCallbackHandler
- object that will extract results, one row at a time, must not be null.DataAccessException
- if there is any problem executing the query.query(String, RowCallbackHandler, Object[])
<T> List<T> query(com.datastax.oss.driver.api.core.cql.Statement<?> statement, RowMapper<T> rowMapper) throws DataAccessException
RowMapper
.
Uses a CQL Statement, not a PreparedStatement
. If you want to execute a static query with a
PreparedStatement
, use the overloaded query
method with null as argument array.
statement
- static CQL Statement
, must not be null.rowMapper
- object that will map one object per row, must not be null.List
, containing mapped objects.DataAccessException
- if there is any problem executing the query.query(String, RowMapper, Object[])
<T> Stream<T> queryForStream(com.datastax.oss.driver.api.core.cql.Statement<?> statement, RowMapper<T> rowMapper) throws DataAccessException
RowMapper
and turning it into an
iterable Stream
.
Uses a CQL Statement, not a PreparedStatement
. If you want to execute a static query with a
PreparedStatement
, use the overloaded query
method with null as argument array.
statement
- static CQL Statement
, must not be null.rowMapper
- object that will map one object per row, must not be null.Stream
, containing mapped objects.DataAccessException
- if there is any problem executing the query.queryForStream(String, RowMapper, Object...)
List<Map<String,Object>> queryForList(com.datastax.oss.driver.api.core.cql.Statement<?> statement) throws DataAccessException
List
, given static CQL.
Uses a CQL Statement, not a PreparedStatement
. If you want to execute a static query with a
PreparedStatement
, use the overloaded queryForList
method with null as argument array.
The results will be mapped to a List
(one item for each row) of Map
s (one entry for each column
using the column name as the key). Each item in the List
will be of the form returned by this interface's
queryForMap() methods.
statement
- static CQL Statement
to execute, must not be empty or null.List
that contains a Map
per row.DataAccessException
- if there is any problem executing the query.queryForList(String, Object[])
<T> List<T> queryForList(com.datastax.oss.driver.api.core.cql.Statement<?> statement, Class<T> elementType) throws DataAccessException
List
, given static CQL.
Uses a CQL Statement, not a PreparedStatement
. If you want to execute a static query with a
PreparedStatement
, use the overloaded queryForList
method with null as argument array.
The results will be mapped to a List
(one item for each row) of result objects, each of them matching the
specified element type.
statement
- static CQL Statement
, must not be null.elementType
- the required type of element in the result List
(for example, Integer.class
),
must not be null.List
of objects that match the specified element type.DataAccessException
- if there is any problem executing the query.queryForList(String, Class, Object[])
,
SingleColumnRowMapper
Map<String,Object> queryForMap(com.datastax.oss.driver.api.core.cql.Statement<?> statement) throws DataAccessException
Uses a CQL Statement, not a PreparedStatement
. If you want to execute a static query with a
PreparedStatement
, use the overloaded queryForMap(String, Object...)
method with null
as argument array.
The query is expected to be a single row query; the result row will be mapped to a Map (one entry for each column, using the column name as the key).
statement
- static CQL Statement
, must not be null.IncorrectResultSizeDataAccessException
- if the query does not return exactly one row.DataAccessException
- if there is any problem executing the query.queryForMap(String, Object[])
,
ColumnMapRowMapper
<T> T queryForObject(com.datastax.oss.driver.api.core.cql.Statement<?> statement, Class<T> requiredType) throws DataAccessException
Uses a CQL Statement, not a PreparedStatement
. If you want to execute a static query with a
PreparedStatement
, use the overloaded queryForObject(String, Class, Object...)
method with
null as argument array.
This method is useful for running static CQL with a known outcome. The query is expected to be a single row/single column query; the returned result will be directly mapped to the corresponding object type.
statement
- static CQL Statement
, must not be null.requiredType
- the type that the result object is expected to match, must not be null.IncorrectResultSizeDataAccessException
- if the query does not return exactly one row, or does not return
exactly one column in that row.DataAccessException
- if there is any problem executing the query.queryForObject(String, Class, Object[])
<T> T queryForObject(com.datastax.oss.driver.api.core.cql.Statement<?> statement, RowMapper<T> rowMapper) throws DataAccessException
RowMapper
.
Uses a CQL Statement, not a PreparedStatement
. If you want to execute a static query with a
PreparedStatement
, use the overloaded queryForObject(String, RowMapper, Object...)
method with
null as argument array.
statement
- static CQL Statement
, must not be null.rowMapper
- object that will map one object per row, must not be null.IncorrectResultSizeDataAccessException
- if the query does not return exactly one row.DataAccessException
- if there is any problem executing the query.queryForObject(String, RowMapper, Object[])
com.datastax.oss.driver.api.core.cql.ResultSet queryForResultSet(com.datastax.oss.driver.api.core.cql.Statement<?> statement) throws DataAccessException
Uses a CQL Statement, not a PreparedStatement
. If you want to execute a static query with a
PreparedStatement
, use the overloaded queryForResultSet
method with null as argument
array.
The results will be mapped to an ResultSet
.
statement
- static CQL Statement
, must not be null.ResultSet
representation.DataAccessException
- if there is any problem executing the query.queryForResultSet(String, Object[])
Iterable<com.datastax.oss.driver.api.core.cql.Row> queryForRows(com.datastax.oss.driver.api.core.cql.Statement<?> statement) throws DataAccessException
Uses a CQL Statement, not a PreparedStatement
. If you want to execute a static query with a
PreparedStatement
, use the overloaded queryForResultSet
method with null as argument
array.
The results will be mapped to Row
s.
statement
- static CQL Statement
, must not be null.DataAccessException
- if there is any problem executing the query.queryForResultSet(String, Object[])
boolean execute(PreparedStatementCreator psc) throws DataAccessException
PreparedStatementCreator
to provide CQL and any required parameters.psc
- object that provides CQL and any necessary parameters, must not be null.DataAccessException
- if there is any problem executing the query.@Nullable <T> T execute(PreparedStatementCreator preparedStatementCreator, PreparedStatementCallback<T> action) throws DataAccessException
PreparedStatement
.
This allows for implementing arbitrary data access operations on a single PreparedStatement
, within
Spring's managed CQL environment: that is, participating in Spring-managed transactions and converting CQL
DriverException
s into Spring's DataAccessException
hierarchy.
The callback action can return a result object, for example a domain object or a collection of domain objects.
preparedStatementCreator
- object that can create a PreparedStatement
given a
CqlSession
, must not be null.action
- callback object that specifies the action, must not be null.DataAccessException
- if there is any problem executing the query.@Nullable <T> T query(PreparedStatementCreator preparedStatementCreator, ResultSetExtractor<T> resultSetExtractor) throws DataAccessException
ResultSet
with a ResultSetExtractor
.preparedStatementCreator
- object that can create a PreparedStatement
given a
CqlSession
, must not be null.resultSetExtractor
- object that will extract results, must not be null.ResultSetExtractor
DataAccessException
- if there is any problem executing the query.void query(PreparedStatementCreator preparedStatementCreator, RowCallbackHandler rowCallbackHandler) throws DataAccessException
ResultSet
on a per-row basis with a
RowCallbackHandler
.preparedStatementCreator
- object that can create a PreparedStatement
given a
CqlSession
, must not be null.rowCallbackHandler
- object that will extract results, one row at a time, must not be null.DataAccessException
- if there is any problem executing the query.<T> List<T> query(PreparedStatementCreator preparedStatementCreator, RowMapper<T> rowMapper) throws DataAccessException
RowMapper
.preparedStatementCreator
- object that can create a PreparedStatement
given a
CqlSession
, must not be null.rowMapper
- object that will map one object per row, must not be null.List
, containing mapped objects.DataAccessException
- if there is any problem executing the query.<T> Stream<T> queryForStream(PreparedStatementCreator preparedStatementCreator, RowMapper<T> rowMapper) throws DataAccessException
RowMapper
and turning it into an
iterable Stream
.preparedStatementCreator
- object that can create a PreparedStatement
given a
CqlSession
, must not be null.rowMapper
- object that will map one object per row, must not be null.Stream
, containing mapped objects.DataAccessException
- if there is any problem executing the query.@Nullable <T> T query(PreparedStatementCreator preparedStatementCreator, @Nullable PreparedStatementBinder psb, ResultSetExtractor<T> resultSetExtractor) throws DataAccessException
PreparedStatementBinder
implementation that knows how to bind values
to the query, reading the ResultSet
with a ResultSetExtractor
.preparedStatementCreator
- object that can create a PreparedStatement
given a
CqlSession
, must not be null.psb
- object that knows how to set values on the prepared statement. If this is null, the CQL will
be assumed to contain no bind parameters. Even if there are no bind parameters, this object may be used to
set fetch size and other performance options.resultSetExtractor
- object that will extract results, must not be null.ResultSetExtractor
.DataAccessException
- if there is any problem executing the query.void query(PreparedStatementCreator preparedStatementCreator, @Nullable PreparedStatementBinder psb, RowCallbackHandler rowCallbackHandler) throws DataAccessException
PreparedStatementBinder
implementation that knows how to bind values
to the query, reading the ResultSet
on a per-row basis with a RowCallbackHandler
.preparedStatementCreator
- object that can create a PreparedStatement
given a
CqlSession
, must not be null.psb
- object that knows how to set values on the prepared statement. If this is null, the CQL will
be assumed to contain no bind parameters. Even if there are no bind parameters, this object may be used to
set fetch size and other performance options.rowCallbackHandler
- object that will extract results, one row at a time, must not be null.DataAccessException
- if there is any problem executing the query.<T> List<T> query(PreparedStatementCreator preparedStatementCreator, @Nullable PreparedStatementBinder psb, RowMapper<T> rowMapper) throws DataAccessException
PreparedStatementBinder
implementation that knows how to bind values
to the query, mapping each row to a Java object via a RowMapper
.preparedStatementCreator
- object that can create a PreparedStatement
given a
CqlSession
, must not be null.psb
- object that knows how to set values on the prepared statement. If this is null, the CQL will
be assumed to contain no bind parameters. Even if there are no bind parameters, this object may be used to
set fetch size and other performance options.rowMapper
- object that will map one object per row, must not be null.List
, containing mapped objects.DataAccessException
- if there is any problem executing the query.<T> Stream<T> queryForStream(PreparedStatementCreator preparedStatementCreator, @Nullable PreparedStatementBinder psb, RowMapper<T> rowMapper) throws DataAccessException
PreparedStatementBinder
implementation that knows how to bind values
to the query, mapping each row to a Java object via a RowMapper
and turning it into an iterable
Stream
.preparedStatementCreator
- object that can create a PreparedStatement
given a
CqlSession
, must not be null.psb
- object that knows how to set values on the prepared statement. If this is null, the CQL will
be assumed to contain no bind parameters. Even if there are no bind parameters, this object may be used to
set fetch size and other performance options.rowMapper
- object that will map one object per row, must not be null.Stream
, containing mapped objects.DataAccessException
- if there is any problem executing the query.List<RingMember> describeRing() throws DataAccessException
RingMemberHostMapper
to provide the basics of the
Cassandra Ring topology.DataAccessException
- if there is any problem executing the query.<T> Collection<T> describeRing(HostMapper<T> hostMapper) throws DataAccessException
HostMapper
implementation to process the
lists of hosts returned by the Cassandra Cluster Metadata.hostMapper
- The implementation to use for host mapping.DataAccessException
- if there is any problem executing the query.Copyright © 2011–2020 Pivotal Software, Inc.. All rights reserved.