SupportSQLiteQueryBuilder

Added in 2.0.0

Kotlin |Java

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`	`create()` Creates the `SupportSQLiteQuery` that can be passed into `SupportSQLiteDatabase.query`.
`final @NonNull SupportSQLiteQueryBuilder`	`distinct()` 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`	`limit(@NonNull String limit)` 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