SQLiteQueryBuilder

SQLiteQueryBuilder

SQLiteQueryBuilder ()

appendColumns

void appendColumns (StringBuilder s, 
                String[] columns)

Add the names that are non-null in columns to s, separating them with commas.

appendWhere

void appendWhere (CharSequence inWhere)

Append a chunk to the WHERE clause of the query. All chunks appended are surrounded by parenthesis and ANDed with the selection passed to query(SQLiteDatabase, String[], String, String[], String, String, String). The final WHERE clause looks like: WHERE (<append chunk 1><append chunk2>) AND (<query() selection parameter>)

appendWhereEscapeString

void appendWhereEscapeString (String inWhere)

Append a chunk to the WHERE clause of the query. All chunks appended are surrounded by parenthesis and ANDed with the selection passed to query(SQLiteDatabase, String[], String, String[], String, String, String). The final WHERE clause looks like: WHERE (<append chunk 1><append chunk2>) AND (<query() selection parameter>)

buildQuery

String buildQuery (String[] projectionIn, 
                String selection, 
                String groupBy, 
                String having, 
                String sortOrder, 
                String limit)

Construct a SELECT statement suitable for use in a group of SELECT statements that will be joined through UNION operators in buildUnionQuery.

buildQuery

String buildQuery (String[] projectionIn, 
                String selection, 
                String[] selectionArgs, 
                String groupBy, 
                String having, 
                String sortOrder, 
                String limit)

This method was deprecated in API level 11.
This method's signature is misleading since no SQL parameter substitution is carried out. The selection arguments parameter does not get used at all. To avoid confusion, call buildQuery(String[], String, String, String, String, String) instead.

buildQueryString

String buildQueryString (boolean distinct, 
                String tables, 
                String[] columns, 
                String where, 
                String groupBy, 
                String having, 
                String orderBy, 
                String limit)

Build an SQL query string from the given clauses.

buildUnionQuery

String buildUnionQuery (String[] subQueries, 
                String sortOrder, 
                String limit)

Given a set of subqueries, all of which are SELECT statements, construct a query that returns the union of what those subqueries return.

buildUnionSubQuery

String buildUnionSubQuery (String typeDiscriminatorColumn, 
                String[] unionColumns, 
                Set<String> columnsPresentInTable, 
                int computedColumnsOffset, 
                String typeDiscriminatorValue, 
                String selection, 
                String[] selectionArgs, 
                String groupBy, 
                String having)

This method was deprecated in API level 11.
This method's signature is misleading since no SQL parameter substitution is carried out. The selection arguments parameter does not get used at all. To avoid confusion, call buildUnionSubQuery(String, String[], Set, int, String, String, String, String) instead.

buildUnionSubQuery

String buildUnionSubQuery (String typeDiscriminatorColumn, 
                String[] unionColumns, 
                Set<String> columnsPresentInTable, 
                int computedColumnsOffset, 
                String typeDiscriminatorValue, 
                String selection, 
                String groupBy, 
                String having)

Construct a SELECT statement suitable for use in a group of SELECT statements that will be joined through UNION operators in buildUnionQuery.

getTables

String getTables ()

Returns the list of tables being queried

query

Cursor query (SQLiteDatabase db, 
                String[] projectionIn, 
                String selection, 
                String[] selectionArgs, 
                String groupBy, 
                String having, 
                String sortOrder)

Perform a query by combining all current settings and the information passed into this method.

query

Cursor query (SQLiteDatabase db, 
                String[] projectionIn, 
                String selection, 
                String[] selectionArgs, 
                String groupBy, 
                String having, 
                String sortOrder, 
                String limit)

Perform a query by combining all current settings and the information passed into this method.

query

Cursor query (SQLiteDatabase db, 
                String[] projectionIn, 
                String selection, 
                String[] selectionArgs, 
                String groupBy, 
                String having, 
                String sortOrder, 
                String limit, 
                CancellationSignal cancellationSignal)

Perform a query by combining all current settings and the information passed into this method.

setCursorFactory

void setCursorFactory (SQLiteDatabase.CursorFactory factory)

Sets the cursor factory to be used for the query. You can use one factory for all queries on a database but it is normally easier to specify the factory when doing this query.

setDistinct

void setDistinct (boolean distinct)

Mark the query as DISTINCT.

setProjectionMap

void setProjectionMap (Map<String, String> columnMap)

Sets the projection map for the query. The projection map maps from column names that the caller passes into query to database column names. This is useful for renaming columns as well as disambiguating column names when doing joins. For example you could map "name" to "people.name". If a projection map is set it must contain all column names the user may request, even if the key and value are the same.

setStrict

void setStrict (boolean flag)

When set, the selection is verified against malicious arguments. When using this class to create a statement using buildQueryString(boolean, String, String[], String, String, String, String, String), non-numeric limits will raise an exception. If a projection map is specified, fields not in that map will be ignored. If this class is used to execute the statement directly using query(SQLiteDatabase, String[], String, String[], String, String, String) or query(SQLiteDatabase, String[], String, String[], String, String, String, String), additionally also parenthesis escaping selection are caught. To summarize: To get maximum protection against malicious third party apps (for example content provider consumers), make sure to do the following:

• Set this value to true
• Use a projection map
• Use one of the query overloads instead of getting the statement as a sql string

setTables

void setTables (String inTables)

Sets the list of tables to query. Multiple tables can be specified to perform a join. For example: setTables("foo, bar") setTables("foo LEFT OUTER JOIN bar ON (foo.id = bar.foo_id)")