Lines Matching defs:query
56 * Mark the query as DISTINCT.
58 * @param distinct if true the query is DISTINCT, otherwise it isn't
74 * Sets the list of tables to query. Multiple tables can be specified to perform a join.
79 * @param inTables the list of tables to query on
86 * Append a chunk to the WHERE clause of the query. All chunks appended are surrounded
87 * by parenthesis and ANDed with the selection passed to {@link #query}. The final
90 * WHERE (<append chunk 1><append chunk2>) AND (<query() selection parameter>)
105 * Append a chunk to the WHERE clause of the query. All chunks appended are surrounded
106 * by parenthesis and ANDed with the selection passed to {@link #query}. The final
109 * WHERE (<append chunk 1><append chunk2>) AND (<query() selection parameter>)
125 * Sets the projection map for the query. The projection map maps
126 * from column names that the caller passes into query to database
140 * Sets the cursor factory to be used for the query. You can use
142 * easier to specify the factory when doing this query.
157 * {@link #query(SQLiteDatabase, String[], String, String[], String, String, String)}
159 * {@link #query(SQLiteDatabase, String[], String, String[], String, String, String, String)},
167 * <li>Use one of the query overloads instead of getting the statement as a sql string</li>
176 * Build an SQL query string from the given clauses.
179 * @param tables The table names to compile the query against.
197 * @param limit Limits the number of rows returned by the query,
199 * @return the SQL query string
212 StringBuilder query = new StringBuilder(120);
214 query.append("SELECT ");
216 query.append("DISTINCT ");
219 appendColumns(query, columns);
221 query.append("* ");
223 query.append("FROM ");
224 query.append(tables);
225 appendClause(query, " WHERE ", where);
226 appendClause(query, " GROUP BY ", groupBy);
227 appendClause(query, " HAVING ", having);
228 appendClause(query, " ORDER BY ", orderBy);
229 appendClause(query, " LIMIT ", limit);
231 return query.toString();
262 * Perform a query by combining all current settings and the
265 * @param db the database to query on
288 * @see android.content.ContentResolver#query(android.net.Uri, String[],
291 public Cursor query(SQLiteDatabase db, String[] projectionIn,
294 return query(db, projectionIn, selection, selectionArgs, groupBy, having, sortOrder,
299 * Perform a query by combining all current settings and the
302 * @param db the database to query on
324 * @param limit Limits the number of rows returned by the query,
327 * @see android.content.ContentResolver#query(android.net.Uri, String[],
330 public Cursor query(SQLiteDatabase db, String[] projectionIn,
333 return query(db, projectionIn, selection, selectionArgs,
338 * Perform a query by combining all current settings and the
341 * @param db the database to query on
363 * @param limit Limits the number of rows returned by the query,
367 * when the query is executed.
369 * @see android.content.ContentResolver#query(android.net.Uri, String[],
372 public Cursor query(SQLiteDatabase db, String[] projectionIn,
390 cancellationSignal); // will throw if query is invalid
398 Log.d(TAG, "Performing query: " + sql);
403 cancellationSignal); // will throw if query is invalid
440 * @param limit Limits the number of rows returned by the query,
497 * appear in one of the other tables in the UNION query that we
582 * construct a query that returns the union of what those
595 StringBuilder query = new StringBuilder(128);
601 query.append(unionOperator);
603 query.append(subQueries[i]);
605 appendClause(query, " ORDER BY ", sortOrder);
606 appendClause(query, " LIMIT ", limit);
607 return query.toString();