RecentsProvider.java revision 54ca29a5b94c2edf461c5433825d4ae17469fd7c
1/* 2 * Copyright (C) 2013 The Android Open Source Project 3 * 4 * Licensed under the Apache License, Version 2.0 (the "License"); 5 * you may not use this file except in compliance with the License. 6 * You may obtain a copy of the License at 7 * 8 * http://www.apache.org/licenses/LICENSE-2.0 9 * 10 * Unless required by applicable law or agreed to in writing, software 11 * distributed under the License is distributed on an "AS IS" BASIS, 12 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. 13 * See the License for the specific language governing permissions and 14 * limitations under the License. 15 */ 16 17package com.android.documentsui; 18 19import android.content.ContentProvider; 20import android.content.ContentResolver; 21import android.content.ContentValues; 22import android.content.Context; 23import android.content.UriMatcher; 24import android.database.Cursor; 25import android.database.sqlite.SQLiteDatabase; 26import android.database.sqlite.SQLiteOpenHelper; 27import android.net.Uri; 28import android.text.format.DateUtils; 29import android.util.Log; 30 31public class RecentsProvider extends ContentProvider { 32 private static final String TAG = "RecentsProvider"; 33 34 // TODO: offer view of recents that handles backend root resolution before 35 // returning cursor, include extra columns 36 37 public static final String AUTHORITY = "com.android.documentsui.recents"; 38 39 private static final UriMatcher sMatcher = new UriMatcher(UriMatcher.NO_MATCH); 40 41 private static final int URI_RECENT_OPEN = 1; 42 private static final int URI_RECENT_CREATE = 2; 43 private static final int URI_RESUME = 3; 44 45 static { 46 sMatcher.addURI(AUTHORITY, "recent_open", URI_RECENT_OPEN); 47 sMatcher.addURI(AUTHORITY, "recent_create", URI_RECENT_CREATE); 48 sMatcher.addURI(AUTHORITY, "resume/*", URI_RESUME); 49 } 50 51 private static final String TABLE_RECENT_OPEN = "recent_open"; 52 private static final String TABLE_RECENT_CREATE = "recent_create"; 53 private static final String TABLE_RESUME = "resume"; 54 55 /** 56 * String of URIs pointing at a storage backend, stored as a JSON array, 57 * starting with root. 58 */ 59 public static final String COL_PATH = "path"; 60 public static final String COL_URI = "uri"; 61 public static final String COL_PACKAGE_NAME = "package_name"; 62 public static final String COL_TIMESTAMP = "timestamp"; 63 64 public static Uri buildRecentOpen() { 65 return new Uri.Builder().scheme(ContentResolver.SCHEME_CONTENT) 66 .authority(AUTHORITY).appendPath("recent_open").build(); 67 } 68 69 public static Uri buildRecentCreate() { 70 return new Uri.Builder().scheme(ContentResolver.SCHEME_CONTENT) 71 .authority(AUTHORITY).appendPath("recent_create").build(); 72 } 73 74 public static Uri buildResume(String packageName) { 75 return new Uri.Builder().scheme(ContentResolver.SCHEME_CONTENT) 76 .authority(AUTHORITY).appendPath("resume").appendPath(packageName).build(); 77 } 78 79 private DatabaseHelper mHelper; 80 81 private static class DatabaseHelper extends SQLiteOpenHelper { 82 private static final String DB_NAME = "recents.db"; 83 84 private static final int VERSION_INIT = 1; 85 86 public DatabaseHelper(Context context) { 87 super(context, DB_NAME, null, VERSION_INIT); 88 } 89 90 @Override 91 public void onCreate(SQLiteDatabase db) { 92 db.execSQL("CREATE TABLE " + TABLE_RECENT_OPEN + " (" + 93 COL_URI + " TEXT PRIMARY KEY ON CONFLICT REPLACE," + 94 COL_TIMESTAMP + " INTEGER" + 95 ")"); 96 97 db.execSQL("CREATE TABLE " + TABLE_RECENT_CREATE + " (" + 98 COL_PATH + " TEXT PRIMARY KEY ON CONFLICT REPLACE," + 99 COL_TIMESTAMP + " INTEGER" + 100 ")"); 101 102 db.execSQL("CREATE TABLE " + TABLE_RESUME + " (" + 103 COL_PACKAGE_NAME + " TEXT PRIMARY KEY ON CONFLICT REPLACE," + 104 COL_PATH + " TEXT," + 105 COL_TIMESTAMP + " INTEGER" + 106 ")"); 107 } 108 109 @Override 110 public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { 111 Log.w(TAG, "Upgrading database; wiping app data"); 112 db.execSQL("DROP TABLE IF EXISTS " + TABLE_RECENT_OPEN); 113 db.execSQL("DROP TABLE IF EXISTS " + TABLE_RECENT_CREATE); 114 db.execSQL("DROP TABLE IF EXISTS " + TABLE_RESUME); 115 onCreate(db); 116 } 117 } 118 119 @Override 120 public boolean onCreate() { 121 mHelper = new DatabaseHelper(getContext()); 122 return true; 123 } 124 125 @Override 126 public Cursor query(Uri uri, String[] projection, String selection, String[] selectionArgs, 127 String sortOrder) { 128 final SQLiteDatabase db = mHelper.getReadableDatabase(); 129 switch (sMatcher.match(uri)) { 130 case URI_RECENT_OPEN: { 131 return db.query(TABLE_RECENT_OPEN, projection, 132 buildWhereYounger(DateUtils.WEEK_IN_MILLIS), null, null, null, null); 133 } 134 case URI_RECENT_CREATE: { 135 return db.query(TABLE_RECENT_CREATE, projection, 136 buildWhereYounger(DateUtils.WEEK_IN_MILLIS), null, null, null, null); 137 } 138 case URI_RESUME: { 139 final String packageName = uri.getPathSegments().get(1); 140 return db.query(TABLE_RESUME, projection, COL_PACKAGE_NAME + "=?", 141 new String[] { packageName }, null, null, null); 142 } 143 default: { 144 throw new UnsupportedOperationException("Unsupported Uri " + uri); 145 } 146 } 147 } 148 149 @Override 150 public String getType(Uri uri) { 151 return null; 152 } 153 154 @Override 155 public Uri insert(Uri uri, ContentValues values) { 156 final SQLiteDatabase db = mHelper.getWritableDatabase(); 157 switch (sMatcher.match(uri)) { 158 case URI_RECENT_OPEN: { 159 values.put(COL_TIMESTAMP, System.currentTimeMillis()); 160 db.insert(TABLE_RECENT_OPEN, null, values); 161 db.delete(TABLE_RECENT_OPEN, buildWhereOlder(DateUtils.WEEK_IN_MILLIS), null); 162 return uri; 163 } 164 case URI_RECENT_CREATE: { 165 values.put(COL_TIMESTAMP, System.currentTimeMillis()); 166 db.insert(TABLE_RECENT_CREATE, null, values); 167 db.delete(TABLE_RECENT_CREATE, buildWhereOlder(DateUtils.WEEK_IN_MILLIS), null); 168 return uri; 169 } 170 case URI_RESUME: { 171 final String packageName = uri.getPathSegments().get(1); 172 values.put(COL_PACKAGE_NAME, packageName); 173 values.put(COL_TIMESTAMP, System.currentTimeMillis()); 174 db.insert(TABLE_RESUME, null, values); 175 return uri; 176 } 177 default: { 178 throw new UnsupportedOperationException("Unsupported Uri " + uri); 179 } 180 } 181 } 182 183 @Override 184 public int update(Uri uri, ContentValues values, String selection, String[] selectionArgs) { 185 throw new UnsupportedOperationException("Unsupported Uri " + uri); 186 } 187 188 @Override 189 public int delete(Uri uri, String selection, String[] selectionArgs) { 190 throw new UnsupportedOperationException("Unsupported Uri " + uri); 191 } 192 193 private static String buildWhereOlder(long deltaMillis) { 194 return COL_TIMESTAMP + "<" + (System.currentTimeMillis() - deltaMillis); 195 } 196 197 private static String buildWhereYounger(long deltaMillis) { 198 return COL_TIMESTAMP + ">" + (System.currentTimeMillis() - deltaMillis); 199 } 200} 201