Select.Where (DataStax Java Driver for Apache Cassandra

java.lang.Object
- com.datastax.driver.core.Statement
- - com.datastax.driver.core.RegularStatement
  - - com.datastax.driver.core.querybuilder.BuiltStatement
    - - com.datastax.driver.core.querybuilder.Select.Where

Enclosing class:

Select
```
public static class Select.Where
extends BuiltStatement
```
The WHERE clause of a SELECT statement.

Method Summary

Methods
Modifier and Type	Method and Description
`Select.Where`	`and(Clause clause)` Adds the provided clause to this WHERE clause.
`Statement`	`disableTracing()` Disables tracing for this query.
`Statement`	`enableTracing()` Enables tracing for this query.
`ConsistencyLevel`	`getConsistencyLevel()` The consistency level for this query.
`String`	`getKeyspace()` Returns the keyspace this query operates on.
`String`	`getQueryString()` Returns the query string for this statement.
`RetryPolicy`	`getRetryPolicy()` Returns the retry policy sets for this query, if any.
`ByteBuffer`	`getRoutingKey()` Returns the routing key (in binary raw form) to use for token aware routing of this query.
`ByteBuffer[]`	`getValues()` The values to use for this statement.
`boolean`	`isTracing()` Returns whether tracing is enabled for this query or not.
`Select`	`limit(BindMarker limit)` Adds a bind marker for the LIMIT clause to the SELECT statement this Where clause if part of.
`Select`	`limit(int limit)` Adds a LIMIT clause to the SELECT statement this Where clause if part of.
`Select`	`orderBy(Ordering... orderings)` Adds an ORDER BY clause to the SELECT statement this WHERE clause if part of.
`Statement`	`setConsistencyLevel(ConsistencyLevel consistency)` Sets the consistency level for the query.
`RegularStatement`	`setForceNoValues(boolean forceNoValues)` Allows to force this builder to not generate values (through its `getValues()` method).
`Statement`	`setRetryPolicy(RetryPolicy policy)` Sets the retry policy to use for this query.
`String`	`toString()`

Methods inherited from class com.datastax.driver.core.querybuilder.BuiltStatement
escapeId

Methods inherited from class com.datastax.driver.core.Statement
getFetchSize, getSerialConsistencyLevel, setFetchSize, setSerialConsistencyLevel

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

- Method Detail
  - and
```
public Select.Where and(Clause clause)
```
    Adds the provided clause to this WHERE clause.
    
    Parameters:
    clause - the clause to add.
    
    Returns:
    this WHERE clause.
  - orderBy
```
public Select orderBy(Ordering... orderings)
```
    Adds an ORDER BY clause to the SELECT statement this WHERE clause if part of.
    
    Parameters:
    orderings - the orderings to add.
    
    Returns:
    the select statement this Where clause if part of.
    
    Throws:
    
    IllegalStateException - if an ORDER BY clause has already been provided.
  - limit
```
public Select limit(int limit)
```
    Adds a LIMIT clause to the SELECT statement this Where clause if part of.
    
    Parameters:
    limit - the limit to set.
    
    Returns:
    the select statement this Where clause if part of.
    
    Throws:
    
    IllegalArgumentException - if limit &gte; 0.
    
    IllegalStateException - if a LIMIT clause has already been provided.
  - limit
```
public Select limit(BindMarker limit)
```
    Adds a bind marker for the LIMIT clause to the SELECT statement this Where clause if part of.
    
    Parameters:
    limit - the bind marker to use as limit.
    
    Returns:
    the select statement this Where clause if part of.
    
    Throws:
    
    IllegalStateException - if a LIMIT clause has already been provided.
  - getQueryString
```
public String getQueryString()
```
    Description copied from class: RegularStatement
    
    Returns the query string for this statement.
    
    Overrides:
    
    getQueryString in class BuiltStatement
    
    Returns:
    a valid CQL query string.
  - getRoutingKey
```
public ByteBuffer getRoutingKey()
```
    Description copied from class: Statement
    
    Returns the routing key (in binary raw form) to use for token aware routing of this query.
    The routing key is optional in that implementers are free to return null. The routing key is an hint used for token-aware routing (see TokenAwarePolicy), and if provided should correspond to the binary value for the query partition key. However, not providing a routing key never causes a query to fail and if the load balancing policy used is not token aware, then the routing key can be safely ignored.
    
    Overrides:
    
    getRoutingKey in class BuiltStatement
    
    Returns:
    the routing key for this query or null.
  - getKeyspace
```
public String getKeyspace()
```
    Description copied from class: Statement
    
    Returns the keyspace this query operates on.
    Note that not all query specify on which keyspace they operate on, and so this method can always return null. Firstly, some queries do not operate inside a keyspace: keyspace creation, USE queries, user creation, etc. Secondly, even query that operate within a keyspace do not have to specify said keyspace directly, in which case the currently logged in keyspace (the one set through a USE query (or through the use of Cluster.connect(String))). Lastly, as for the routing key, this keyspace information is only a hint for token-aware routing (since replica placement depend on the replication strategy in use which is a per-keyspace property) and having this method return null (or even a bogus keyspace name) will never cause the query to fail.
    
    Overrides:
    
    getKeyspace in class BuiltStatement
    
    Returns:
    the keyspace this query operate on if relevant or null.
  - setForceNoValues
```
public RegularStatement setForceNoValues(boolean forceNoValues)
```
    Description copied from class: BuiltStatement
    
    Allows to force this builder to not generate values (through its getValues() method).
    By default (and unless the protocol version 1 is in use, see below) and for performance reasons, the query builder will not serialize all values provided to strings. This means that the BuiltStatement.getQueryString() may return a query string with bind markers (where and when is at the discretion of the builder) and BuiltStatement.getValues() will return the binary values for those markers. This method allows to force the builder to not generate binary values but rather to serialize them all in the query string. In practice, this means that if you call setForceNoValues(true), you are guaranteed that getValues() will return null and that the string returned by getQueryString() will contain no other bind markers than the one inputted by the user.
    If the native protocol version 1 is in use, the driver will default to not generating values since those are not supported by that version of the protocol. In practice, the driver will automatically call this method with true as argument prior to execution. Hence, calling this method when the protocol version 1 is in use is basically a no-op.
    Note that this method is mainly useful for debugging purpose. In general, the default behavior should be the correct and most efficient one.
    
    Overrides:
    
    setForceNoValues in class BuiltStatement
    
    Parameters:
    forceNoValues - whether or not this builder may generate values.
    
    Returns:
    this statement.
  - setConsistencyLevel
```
public Statement setConsistencyLevel(ConsistencyLevel consistency)
```
    Description copied from class: Statement
    
    Sets the consistency level for the query.
    
    Overrides:
    
    setConsistencyLevel in class Statement
    
    Parameters:
    consistency - the consistency level to set.
    
    Returns:
    this Statement object.
  - getConsistencyLevel
```
public ConsistencyLevel getConsistencyLevel()
```
    Description copied from class: Statement
    
    The consistency level for this query.
    
    Overrides:
    
    getConsistencyLevel in class Statement
    
    Returns:
    the consistency level for this query, or null if no consistency level has been specified (through setConsistencyLevel). In the latter case, the default consistency level will be used.
  - enableTracing
```
public Statement enableTracing()
```
    Description copied from class: Statement
    
    Enables tracing for this query. By default (that is unless you call this method), tracing is not enabled.
    
    Overrides:
    
    enableTracing in class Statement
    
    Returns:
    this Statement object.
  - disableTracing
```
public Statement disableTracing()
```
    Description copied from class: Statement
    
    Disables tracing for this query.
    
    Overrides:
    
    disableTracing in class Statement
    
    Returns:
    this Statement object.
  - isTracing
```
public boolean isTracing()
```
    Description copied from class: Statement
    
    Returns whether tracing is enabled for this query or not.
    
    Overrides:
    
    isTracing in class Statement
    
    Returns:
    true if this query has tracing enabled, false otherwise.
  - setRetryPolicy
```
public Statement setRetryPolicy(RetryPolicy policy)
```
    Description copied from class: Statement
    
    Sets the retry policy to use for this query.
    The default retry policy, if this method is not called, is the one returned by Policies.getRetryPolicy() in the cluster configuration. This method is thus only useful in case you want to punctually override the default policy for this request.
    
    Overrides:
    
    setRetryPolicy in class Statement
    
    Parameters:
    policy - the retry policy to use for this query.
    
    Returns:
    this Statement object.
  - getRetryPolicy
```
public RetryPolicy getRetryPolicy()
```
    Description copied from class: Statement
    
    Returns the retry policy sets for this query, if any.
    
    Overrides:
    
    getRetryPolicy in class Statement
    
    Returns:
    the retry policy sets specifically for this query or null if no query specific retry policy has been set through Statement.setRetryPolicy(com.datastax.driver.core.policies.RetryPolicy) (in which case the Cluster retry policy will apply if necessary).
  - getValues
```
public ByteBuffer[] getValues()
```
    Description copied from class: RegularStatement
    
    The values to use for this statement.
    Note: Values for a RegularStatement (i.e. if this method does not return null) are not supported with the native protocol version 1: you will get an UnsupportedProtocolVersionException when submitting one if version 1 of the protocol is in use (i.e. if you've force version 1 through Cluster.Builder.withProtocolVersion(int) or you use Cassandra 1.2).
    
    Overrides:
    
    getValues in class BuiltStatement
    
    Returns:
    the values to use for this statement or null if there is no such values.
    See Also:
    SimpleStatement.SimpleStatement(String, Object...)
  - toString
```
public String toString()
```
    Overrides:
    
    toString in class BuiltStatement

Class Select.Where

Method Summary

Methods inherited from class com.datastax.driver.core.querybuilder.BuiltStatement

Methods inherited from class com.datastax.driver.core.Statement

Methods inherited from class java.lang.Object

Method Detail

and

orderBy

limit

limit

getQueryString

getRoutingKey

getKeyspace

setForceNoValues

setConsistencyLevel

getConsistencyLevel

enableTracing

disableTracing

isTracing

setRetryPolicy

getRetryPolicy

getValues

toString