belongs to Maven artifact android.arch.persistence:db:1.1.0-beta2
SupportSQLiteQueryBuilder
public
final
class
SupportSQLiteQueryBuilder
extends Object
java.lang.Object | |
↳ | android.arch.persistence.db.SupportSQLiteQueryBuilder |
A simple query builder to create SQL SELECT queries.
Summary
Public methods | |
---|---|
static
SupportSQLiteQueryBuilder
|
builder(String tableName)
Creates a query for the given table name. |
SupportSQLiteQueryBuilder
|
columns(String[] columns)
Sets the given list of columns as the columns that will be returned. |
SupportSQLiteQuery
|
create()
Creates the |
SupportSQLiteQueryBuilder
|
distinct()
Adds DISTINCT keyword to the query. |
SupportSQLiteQueryBuilder
|
groupBy(String groupBy)
Adds a GROUP BY statement. |
SupportSQLiteQueryBuilder
|
having(String having)
Adds a HAVING statement. |
SupportSQLiteQueryBuilder
|
limit(String limit)
Adds a LIMIT statement. |
SupportSQLiteQueryBuilder
|
orderBy(String orderBy)
Adds an ORDER BY statement. |
SupportSQLiteQueryBuilder
|
selection(String selection, Object[] bindArgs)
Sets the arguments for the WHERE clause. |
Inherited methods | |
---|---|
Public methods
builder
SupportSQLiteQueryBuilder builder (String tableName)
Creates a query for the given table name.
Parameters | |
---|---|
tableName |
String : The table name(s) to query. |
Returns | |
---|---|
SupportSQLiteQueryBuilder |
A builder to create a query. |
columns
SupportSQLiteQueryBuilder columns (String[] columns)
Sets the given list of columns as the columns that will be returned.
Parameters | |
---|---|
columns |
String : The list of column names that should be returned. |
Returns | |
---|---|
SupportSQLiteQueryBuilder |
this |
create
SupportSQLiteQuery create ()
Creates the SupportSQLiteQuery
that can be passed into
query(SupportSQLiteQuery)
.
Returns | |
---|---|
SupportSQLiteQuery |
a new query |
distinct
SupportSQLiteQueryBuilder distinct ()
Adds DISTINCT keyword to the query.
Returns | |
---|---|
SupportSQLiteQueryBuilder |
this |
groupBy
SupportSQLiteQueryBuilder groupBy (String groupBy)
Adds a GROUP BY statement.
Parameters | |
---|---|
groupBy |
String : The value of the GROUP BY statement. |
Returns | |
---|---|
SupportSQLiteQueryBuilder |
this |
having
SupportSQLiteQueryBuilder having (String having)
Adds a HAVING statement. You must also provide groupBy(String)
for this to work.
Parameters | |
---|---|
having |
String : The having clause. |
Returns | |
---|---|
SupportSQLiteQueryBuilder |
this |
limit
SupportSQLiteQueryBuilder limit (String limit)
Adds a LIMIT statement.
Parameters | |
---|---|
limit |
String : The limit value. |
Returns | |
---|---|
SupportSQLiteQueryBuilder |
this |
orderBy
SupportSQLiteQueryBuilder orderBy (String orderBy)
Adds an ORDER BY statement.
Parameters | |
---|---|
orderBy |
String : The order clause. |
Returns | |
---|---|
SupportSQLiteQueryBuilder |
this |
selection
SupportSQLiteQueryBuilder selection (String selection, Object[] bindArgs)
Sets the arguments for the WHERE clause.
Parameters | |
---|---|
selection |
String : The list of selection columns |
bindArgs |
Object : The list of bind arguments to match against these columns |
Returns | |
---|---|
SupportSQLiteQueryBuilder |
this |
Interfaces
Classes