Lines Matching defs:table
265 // entries for that storage from the files table.
840 // create image thumbnail table
979 // Cleans up album_art table entry when an album is deleted
1052 // Create bucket_id and bucket_display_name columns for the video table.
1065 // Create bookmark column for the video table.
1084 // Create is_podcast and bookmark columns for the audio table.
1198 // create video thumbnail table
1364 // table, so we need to create that if we're at 100 or lower. This means
1380 // Create a new table to manage all files in our storage.
1443 // Value of _id from the old media table.
1451 // Copy all data from our obsolete tables to the new files table
1456 // We choose to do this for the audio table because the fragility of Uris
1497 // update the image_id column in the thumbnails table.
1503 // update audio_id in the audio_genres_map table, and
1504 // audio_playlists_map tables and playlist_id in the audio_playlists_map table
1516 // update video_id in the videothumbnails table.
1524 // update indices to work on the files table
1539 // Recreate triggers for our obsolete tables on the new files table
1670 // in table files in version 405 and to recover from problems populating
1712 // in the thumbnail table, which in turn would trigger thumbnails_cleanup
1802 for (String table : tables) {
1803 db.execSQL("UPDATE " + table + " SET " + "_data='" + externalStorage
1816 // table and replaces it with a new one by the same name, we need to also recreate all
1817 // indices and triggers that refer to the files table.
1837 // copy data from old table, squashing entries with duplicate _data
1905 * Write a persistent diagnostic message to the log table.
1991 * Iterate through the rows of a table in a database, ensuring that the
2130 private boolean queryThumbnail(SQLiteQueryBuilder qb, Uri uri, String table,
2132 qb.setTables(table);
2292 int table = URI_MATCHER.match(uri);
2297 if (table == MEDIA_SCANNER) {
2311 if (table == FS_ID) {
2317 if (table == VERSION) {
2355 switch (table) {
2474 if (table == AUDIO_GENRES_ID_MEMBERS) {
2481 if (table == AUDIO_GENRES_ID_MEMBERS) {
2543 if (table == AUDIO_PLAYLISTS_ID_MEMBERS_ID) {
2656 combine(prependArgs, selectionArgs), sort, table, limit);
3072 // Insert the artist into the artist table and remove it from
3304 // first look up the media table and media ID for the object
3389 // genre does not exist, so create the genre in the genre table
3858 public String table;
3870 out.table = "files";
3875 out.table = "files";
3882 out.table = "thumbnails";
3886 out.table = "files";
3891 out.table = "files";
3896 out.table = "audio_genres";
3901 out.table = "audio_genres";
3907 out.table = "audio_playlists";
3912 out.table = "audio_playlists";
3918 out.table = "audio_genres";
3922 out.table = "audio_genres";
3927 out.table = "audio_genres";
3932 out.table = "files";
3937 out.table = "files";
3942 out.table = "audio_playlists_map";
3947 out.table = "audio_playlists_map";
3953 out.table = "album_art";
3958 out.table = "files";
3963 out.table = "files";
3970 out.table = "videothumbnails";
3978 out.table = "files";
4051 if (sGetTableAndWhereParam.table.equals("files")) {
4055 Cursor c = db.query(sGetTableAndWhereParam.table,
4151 Cursor c = db.query(sGetTableAndWhereParam.table,
4164 count = db.delete(sGetTableAndWhereParam.table,
4170 count = db.delete(sGetTableAndWhereParam.table,
4233 Cursor cursor = db.query(sGetTableAndWhereParam.table, PATH_PROJECTION,
4246 count = db.update(sGetTableAndWhereParam.table, initialValues,
4291 // Insert the artist into the artist table and remove it from
4382 count = db.update(sGetTableAndWhereParam.table, values,
4403 // The same names are used for both images and table columns, so
4414 count = db.update(sGetTableAndWhereParam.table, values,
4421 Cursor c = db.query(sGetTableAndWhereParam.table,
4458 count = db.update(sGetTableAndWhereParam.table, initialValues,
5144 * @param table The table to store the key/name pair in.
5149 * @param path The full path to the file being inserted in to the audio table
5158 String table, String keyField, String nameField,
5174 boolean isAlbum = table.equals("albums");
5194 Cursor c = db.query(table, null, keyField + "=?", selargs, null, null, null);
5199 // insert new entry into table
5204 rowId = db.insert(table, "duration", otherValues);
5211 Uri uri = Uri.parse("content://media/" + volume + "/audio/" + table + "/" + rowId);
5222 // currently stored in the table, and update the table if it is.
5226 // update the table with the new name
5230 db.update(table, newValues, "rowid="+Integer.toString((int)rowId), null);
5232 Uri uri = Uri.parse("content://media/" + volume + "/audio/" + table + "/" + rowId);
5239 Log.e(TAG, "Multiple entries in table " + table + " for key " + k);
5556 // are stored in the "files" table, so do not renumber them unless you also add