com.datastax.driver.core.querybuilder

Class Select

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

public class Select
extends BuiltStatement

A built SELECT statement.

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	Select.Builder An in-construction SELECT statement.
static class	Select.Selection An Selection clause for an in-construction SELECT statement.
static class	Select.SelectionOrAlias An Selection clause for an in-construction SELECT statement.
static class	Select.Where The WHERE clause of a SELECT statement.

Field Summary

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

idempotent, NULL_PAYLOAD_VALUE

Method Summary

Modifier and Type	Method and Description
Select	allowFiltering() Adds an ALLOW FILTERING directive to this statement.
Select	limit(BindMarker marker) Adds a prepared LIMIT clause to this statement.
Select	limit(int limit) Adds a LIMIT clause to this statement.
Select	orderBy(Ordering... orderings) Adds an ORDER BY clause to this statement.
Select.Where	where() Returns a Where statement for this query without adding clause.
Select.Where	where(Clause clause) Adds a WHERE clause to this statement.

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

escapeId, getKeyspace, getQueryString, getRoutingKey, getValues, hasValues, isIdempotent, setForceNoValues, toString

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

disableTracing, enableTracing, getConsistencyLevel, getDefaultTimestamp, getFetchSize, getRetryPolicy, getSerialConsistencyLevel, isTracing, setConsistencyLevel, setDefaultTimestamp, setFetchSize, setIdempotent, setOutgoingPayload, setPagingState, setPagingStateUnsafe, setRetryPolicy, setSerialConsistencyLevel

Methods inherited from class java.lang.Object

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

Method Detail

where

public Select.Where where(Clause clause)

Adds a WHERE clause to this statement. This is a shorter/more readable version for where().and(clause).

Parameters:

clause - the clause to add.

Returns:

the where clause of this query to which more clause can be added.

where

public Select.Where where()

Returns a Where statement for this query without adding clause.

Returns:

the where clause of this query to which more clause can be added.

orderBy

public Select orderBy(Ordering... orderings)

Adds an ORDER BY clause to this statement.

Parameters:

orderings - the orderings to define for this query.

Returns:

this statement.

Throws:

IllegalStateException - if an ORDER BY clause has already been provided.

limit

public Select limit(int limit)

Adds a LIMIT clause to this statement.

Parameters:

limit - the limit to set.

Returns:

this statement.

Throws:

IllegalArgumentException - if limit &gte; 0.

IllegalStateException - if a LIMIT clause has already been provided.

limit

public Select limit(BindMarker marker)

Adds a prepared LIMIT clause to this statement.

Parameters:

marker - the marker to use for the limit.

Returns:

this statement.

Throws:

IllegalStateException - if a LIMIT clause has already been provided.

allowFiltering

public Select allowFiltering()

Adds an ALLOW FILTERING directive to this statement.

Returns:

this statement.