Lines Matching defs:where

282                             String where = FileColumns.STORAGE_ID + "=?";
285 db.update("files", values, where, whereArgs);
288 int numpurged = db.delete("files", where, whereArgs);
1054 "SELECT _id FROM audio where mime_type='audio/mp4' AND " +
1550 "DELETE from files where _id=old._id;" +
1551 "DELETE from audio_playlists_map where audio_id=old._id;" +
1552 "DELETE from audio_genres_map where audio_id=old._id;" +
1992 * @param values the content values, where the bucked id name and bucket display name are updated.
2016 * @param values the content values, where the display name is updated.
2032 * @param values the content values, where taken time is updated.
2696 String where = "";
2699 where = "match LIKE ? ESCAPE '\\'";
2701 where += " AND match LIKE ? ESCAPE '\\'";
2714 return qb.query(db, cols, where, wildcardWords, null, null, null, limit);
3819 public String where;
3827 String where = null;
3831 where = FileColumns.MEDIA_TYPE + "=" + FileColumns.MEDIA_TYPE_IMAGE;
3836 where = "_id = " + uri.getPathSegments().get(3);
3840 where = "_id=" + uri.getPathSegments().get(3);
3847 where = FileColumns.MEDIA_TYPE + "=" + FileColumns.MEDIA_TYPE_AUDIO;
3852 where = "_id=" + uri.getPathSegments().get(3);
3857 where = "audio_id=" + uri.getPathSegments().get(3);
3862 where = "audio_id=" + uri.getPathSegments().get(3) +
3868 where = "audio_id=" + uri.getPathSegments().get(3);
3873 where = "audio_id=" + uri.getPathSegments().get(3) +
3883 where = "_id=" + uri.getPathSegments().get(3);
3888 where = "genre_id=" + uri.getPathSegments().get(3);
3893 where = FileColumns.MEDIA_TYPE + "=" + FileColumns.MEDIA_TYPE_PLAYLIST;
3898 where = "_id=" + uri.getPathSegments().get(3);
3903 where = "playlist_id=" + uri.getPathSegments().get(3);
3908 where = "playlist_id=" + uri.getPathSegments().get(3) +
3914 where = "album_id=" + uri.getPathSegments().get(3);
3919 where = FileColumns.MEDIA_TYPE + "=" + FileColumns.MEDIA_TYPE_VIDEO;
3924 where = "_id=" + uri.getPathSegments().get(3);
3928 where = "_id=" + uri.getPathSegments().get(3);
3935 where = "_id=" + uri.getPathSegments().get(2);
3948 if (!TextUtils.isEmpty(where)) {
3949 out.where = where + " AND (" + userWhere + ")";
3951 out.where = userWhere;
3954 out.where = where;
4017 sGetTableAndWhereParam.where, whereArgs, null, null, null);
4095 count = db.delete("files", sGetTableAndWhereParam.where, whereArgs);
4103 sGetTableAndWhereParam.where, whereArgs);
4113 sGetTableAndWhereParam.where, whereArgs, null, null, null);
4125 sGetTableAndWhereParam.where, whereArgs);
4131 sGetTableAndWhereParam.where, whereArgs);
4207 sGetTableAndWhereParam.where, whereArgs);
4343 sGetTableAndWhereParam.where, whereArgs);
4375 sGetTableAndWhereParam.where, whereArgs);
4382 READY_FLAG_PROJECTION, sGetTableAndWhereParam.where,
4419 sGetTableAndWhereParam.where, whereArgs);