Lines Matching defs:db
122 private static final String DB_NAME = "recents.db";
134 public void onCreate(SQLiteDatabase db) {
136 db.execSQL("CREATE TABLE " + TABLE_RECENT + " (" +
142 db.execSQL("CREATE TABLE " + TABLE_STATE + " (" +
152 db.execSQL("CREATE TABLE " + TABLE_RESUME + " (" +
161 public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
163 db.execSQL("DROP TABLE IF EXISTS " + TABLE_RECENT);
164 db.execSQL("DROP TABLE IF EXISTS " + TABLE_STATE);
165 db.execSQL("DROP TABLE IF EXISTS " + TABLE_RESUME);
166 onCreate(db);
179 final SQLiteDatabase db = mHelper.getReadableDatabase();
183 return db.query(TABLE_RECENT, projection, RecentColumns.TIMESTAMP + ">" + cutoff,
189 return db.query(TABLE_STATE, projection, StateColumns.AUTHORITY + "=? AND "
194 return db.query(TABLE_RESUME, projection, ResumeColumns.PACKAGE_NAME + "=?",
208 final SQLiteDatabase db = mHelper.getWritableDatabase();
213 db.insert(TABLE_RECENT, null, values);
215 db.delete(TABLE_RECENT, RecentColumns.TIMESTAMP + "<" + cutoff, null);
227 db.insertWithOnConflict(TABLE_STATE, null, key, SQLiteDatabase.CONFLICT_IGNORE);
228 db.update(TABLE_STATE, values, StateColumns.AUTHORITY + "=? AND "
240 db.insertWithOnConflict(TABLE_RESUME, null, key, SQLiteDatabase.CONFLICT_IGNORE);
241 db.update(TABLE_RESUME, values, ResumeColumns.PACKAGE_NAME + "=?",
312 final SQLiteDatabase db = mHelper.getWritableDatabase();
315 Cursor cursor = db.query(TABLE_RECENT, null, null, null, null, null, null);
325 db.delete(TABLE_RECENT, RecentColumns.KEY + "=?", new String[] { key });
334 cursor = db.query(TABLE_STATE, new String[] {
340 db.delete(TABLE_STATE, StateColumns.AUTHORITY + "=?", new String[] {
349 cursor = db.query(TABLE_RESUME, null, null, null, null, null, null);
360 db.delete(TABLE_RESUME, ResumeColumns.PACKAGE_NAME + "=?",