Lines Matching defs:db
117 private static final String DB_NAME = "recents.db";
129 public void onCreate(SQLiteDatabase db) {
131 db.execSQL("CREATE TABLE " + TABLE_RECENT + " (" +
137 db.execSQL("CREATE TABLE " + TABLE_STATE + " (" +
147 db.execSQL("CREATE TABLE " + TABLE_RESUME + " (" +
156 public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
158 db.execSQL("DROP TABLE IF EXISTS " + TABLE_RECENT);
159 db.execSQL("DROP TABLE IF EXISTS " + TABLE_STATE);
160 db.execSQL("DROP TABLE IF EXISTS " + TABLE_RESUME);
161 onCreate(db);
174 final SQLiteDatabase db = mHelper.getReadableDatabase();
178 return db.query(TABLE_RECENT, projection, RecentColumns.TIMESTAMP + ">" + cutoff,
184 return db.query(TABLE_STATE, projection, StateColumns.AUTHORITY + "=? AND "
189 return db.query(TABLE_RESUME, projection, ResumeColumns.PACKAGE_NAME + "=?",
203 final SQLiteDatabase db = mHelper.getWritableDatabase();
208 db.insert(TABLE_RECENT, null, values);
210 db.delete(TABLE_RECENT, RecentColumns.TIMESTAMP + "<" + cutoff, null);
222 db.insertWithOnConflict(TABLE_STATE, null, key, SQLiteDatabase.CONFLICT_IGNORE);
223 db.update(TABLE_STATE, values, StateColumns.AUTHORITY + "=? AND "
235 db.insertWithOnConflict(TABLE_RESUME, null, key, SQLiteDatabase.CONFLICT_IGNORE);
236 db.update(TABLE_RESUME, values, ResumeColumns.PACKAGE_NAME + "=?",
307 final SQLiteDatabase db = mHelper.getWritableDatabase();
310 Cursor cursor = db.query(TABLE_RECENT, null, null, null, null, null, null);
320 db.delete(TABLE_RECENT, RecentColumns.KEY + "=?", new String[] { key });
329 cursor = db.query(TABLE_STATE, new String[] {
335 db.delete(TABLE_STATE, StateColumns.AUTHORITY + "=?", new String[] {
344 cursor = db.query(TABLE_RESUME, null, null, null, null, null, null);
355 db.delete(TABLE_RESUME, ResumeColumns.PACKAGE_NAME + "=?",