Lines Matching defs:qb
1112 private boolean queryThumbnail(SQLiteQueryBuilder qb, Uri uri, String table,
1114 qb.setTables(table);
1118 qb.appendWhere("_id = " + uri.getPathSegments().get(3));
1175 qb.appendWhere(column + " = " + origId);
1313 SQLiteQueryBuilder qb = new SQLiteQueryBuilder();
1332 qb.setDistinct(true);
1339 qb.setTables("images");
1341 qb.setDistinct(true);
1344 //qb.setProjectionMap(mImagesProjectionMap, true);
1348 qb.setTables("images");
1350 qb.setDistinct(true);
1353 //qb.setProjectionMap(mImagesProjectionMap, true);
1354 qb.appendWhere("_id=?");
1361 if (!queryThumbnail(qb, uri, "thumbnails", "image_id", hasThumbnailId)) {
1373 qb.setTables("audio_meta");
1375 qb.setTables("audio");
1378 qb.appendWhere(" AND ");
1380 qb.appendWhere(MediaStore.Audio.Media.ARTIST_KEY +
1389 qb.setTables("audio");
1390 qb.appendWhere("_id=?");
1395 qb.setTables("audio_genres");
1396 qb.appendWhere("_id IN (SELECT genre_id FROM " +
1402 qb.setTables("audio_genres");
1403 qb.appendWhere("_id=?");
1408 qb.setTables("audio_playlists");
1409 qb.appendWhere("_id IN (SELECT playlist_id FROM " +
1415 qb.setTables("audio_playlists");
1416 qb.appendWhere("_id=?");
1421 qb.setTables("audio_genres");
1425 qb.setTables("audio_genres");
1426 qb.appendWhere("_id=?");
1455 qb.setTables("audio_genres_map_noid");
1457 qb.appendWhere("genre_id=?");
1461 qb.setTables("audio_genres_map_noid, audio");
1462 qb.appendWhere("audio._id = audio_id");
1464 qb.appendWhere(" AND genre_id=?");
1468 qb.appendWhere(" AND ");
1469 qb.appendWhere(MediaStore.Audio.Media.ARTIST_KEY +
1480 qb.setTables("audio_playlists");
1484 qb.setTables("audio_playlists");
1485 qb.appendWhere("_id=?");
1509 qb.setTables("audio_playlists_map");
1510 qb.appendWhere("playlist_id=?");
1513 qb.setTables("audio_playlists_map, audio");
1514 qb.appendWhere("audio._id = audio_id AND playlist_id=?");
1517 qb.appendWhere(" AND ");
1518 qb.appendWhere(MediaStore.Audio.Media.ARTIST_KEY +
1526 qb.appendWhere(" AND audio_playlists_map._id=?");
1532 qb.setTables("video");
1535 qb.setTables("video");
1536 qb.appendWhere("_id=?");
1543 if (!queryThumbnail(qb, uri, "videothumbnails", "video_id", hasThumbnailId)) {
1554 qb.setTables("audio_meta");
1556 qb.appendWhere("is_music=1");
1558 qb.setTables("artist_info");
1561 qb.appendWhere(" AND ");
1563 qb.appendWhere(MediaStore.Audio.Media.ARTIST_KEY +
1571 qb.setTables("artist_info");
1572 qb.appendWhere("_id=?");
1578 qb.setTables("audio LEFT OUTER JOIN album_art ON" +
1580 qb.appendWhere("is_music=1 AND audio.album_id IN (SELECT album_id FROM " +
1584 qb.appendWhere(" AND ");
1585 qb.appendWhere(MediaStore.Audio.Media.ARTIST_KEY +
1594 qb.setProjectionMap(sArtistAlbumsMap);
1603 qb.setTables("audio_meta");
1605 qb.appendWhere("is_music=1");
1607 qb.setTables("album_info");
1610 qb.appendWhere(" AND ");
1612 qb.appendWhere(MediaStore.Audio.Media.ARTIST_KEY +
1621 qb.setTables("album_info");
1622 qb.appendWhere("_id=?");
1627 qb.setTables("album_art");
1628 qb.appendWhere("album_id=?");
1637 return doAudioSearch(db, qb, uri, projectionIn, selection,
1642 qb.appendWhere("_id=?");
1647 qb.setTables("files");
1658 // Log.v(TAG, "query = "+ qb.buildQuery(projectionIn, selection,
1660 Cursor c = qb.query(db, projectionIn, selection,
1690 private Cursor doAudioSearch(SQLiteDatabase db, SQLiteQueryBuilder qb,
1723 qb.setTables("search");
1732 return qb.query(db, cols, where, wildcardWords, null, null, null, limit);
3840 SQLiteQueryBuilder qb = new SQLiteQueryBuilder();
3842 qb.setTables("audio_meta");
3843 qb.appendWhere("_id=" + songid);
3844 Cursor c = qb.query(db,
3888 SQLiteQueryBuilder qb = new SQLiteQueryBuilder();
3890 qb.setTables("audio_meta");
3891 qb.appendWhere("album_id=" + albumid);
3892 Cursor c = qb.query(db,