SupportSQLiteQueryBuilder

public final class SupportSQLiteQueryBuilder

A simple query builder to create SQL SELECT queries.

Summary

Public methods
static final @NonNull SupportSQLiteQueryBuilder
builder(@NonNull String tableName)

Creates a query for the given table name.
final @NonNull SupportSQLiteQueryBuilder
columns(String[] columns)

Sets the given list of columns as the columns that will be returned.
final @NonNull SupportSQLiteQuery

Creates the SupportSQLiteQuery that can be passed into SupportSQLiteDatabase.query.
final @NonNull SupportSQLiteQueryBuilder

Adds DISTINCT keyword to the query.
final @NonNull SupportSQLiteQueryBuilder
groupBy(String groupBy)

Adds a GROUP BY statement.
final @NonNull SupportSQLiteQueryBuilder
having(String having)

Adds a HAVING statement.
final @NonNull SupportSQLiteQueryBuilder

Adds a LIMIT statement.
final @NonNull SupportSQLiteQueryBuilder
orderBy(String orderBy)

Adds an ORDER BY statement.
final @NonNull SupportSQLiteQueryBuilder
selection(String selection, Object[] bindArgs)

Sets the arguments for the WHERE clause.

Public methods

builder

Added in 2.3.0
public static final @NonNull SupportSQLiteQueryBuilder builder(@NonNull String tableName)

Creates a query for the given table name.

Parameters
@NonNull String tableName

The table name(s) to query.
Returns
@NonNull SupportSQLiteQueryBuilder

A builder to create a query.

columns

Added in 2.0.0
public final @NonNull SupportSQLiteQueryBuilder columns(String[] columns)

Sets the given list of columns as the columns that will be returned.

Parameters
String[] columns

The list of column names that should be returned.
Returns
@NonNull SupportSQLiteQueryBuilder

this

create

Added in 2.0.0
public final @NonNull SupportSQLiteQuery create()

Creates the SupportSQLiteQuery that can be passed into SupportSQLiteDatabase.query.

Returns
@NonNull SupportSQLiteQuery

a new query

distinct

Added in 2.0.0
public final @NonNull SupportSQLiteQueryBuilder distinct()

Adds DISTINCT keyword to the query.

Returns
@NonNull SupportSQLiteQueryBuilder

this

groupBy

Added in 2.0.0
public final @NonNull SupportSQLiteQueryBuilder groupBy(String groupBy)

Adds a GROUP BY statement.

Parameters
String groupBy

The value of the GROUP BY statement.
Returns
@NonNull SupportSQLiteQueryBuilder

this

having

Added in 2.0.0
public final @NonNull SupportSQLiteQueryBuilder having(String having)

Adds a HAVING statement. You must also provide groupBy for this to work.

Parameters
String having

The having clause.
Returns
@NonNull SupportSQLiteQueryBuilder

this

limit

Added in 2.0.0
public final @NonNull SupportSQLiteQueryBuilder limit(@NonNull String limit)

Adds a LIMIT statement.

Parameters
@NonNull String limit

The limit value.
Returns
@NonNull SupportSQLiteQueryBuilder

this

orderBy

Added in 2.0.0
public final @NonNull SupportSQLiteQueryBuilder orderBy(String orderBy)

Adds an ORDER BY statement.

Parameters
String orderBy

The order clause.
Returns
@NonNull SupportSQLiteQueryBuilder

this

selection

Added in 2.0.0
public final @NonNull SupportSQLiteQueryBuilder selection(String selection, Object[] bindArgs)

Sets the arguments for the WHERE clause.

Parameters
String selection

The list of selection columns
Object[] bindArgs

The list of bind arguments to match against these columns
Returns
@NonNull SupportSQLiteQueryBuilder

this