Lines Matching refs:db
46 private static final String DATABASE_NAME = "alarms.db";
54 public void onCreate(SQLiteDatabase db) {
55 db.execSQL("CREATE TABLE alarms (" +
70 db.execSQL(insertMe + "(8, 30, 31, 0, 0, 1, '', '');");
71 db.execSQL(insertMe + "(9, 00, 96, 0, 0, 1, '', '');");
75 public void onUpgrade(SQLiteDatabase db, int oldVersion, int currentVersion) {
80 db.execSQL("DROP TABLE IF EXISTS alarms");
81 onCreate(db);
114 SQLiteDatabase db = mOpenHelper.getReadableDatabase();
115 Cursor ret = qb.query(db, projectionIn, selection, selectionArgs,
145 SQLiteDatabase db = mOpenHelper.getWritableDatabase();
150 count = db.update("alarms", values, "_id=" + rowId, null);
171 SQLiteDatabase db = mOpenHelper.getWritableDatabase();
172 long rowId = db.insert("alarms", Alarm.Columns.MESSAGE, values);
184 SQLiteDatabase db = mOpenHelper.getWritableDatabase();
189 count = db.delete("alarms", where, whereArgs);
199 count = db.delete("alarms", where, whereArgs);