Lines Matching refs:db
112 public void writeKeyValue(SQLiteDatabase db, String key, String value, int userId) {
118 db.beginTransaction();
120 db.delete(TABLE, COLUMN_KEY + "=? AND " + COLUMN_USERID + "=?",
122 db.insert(TABLE, null, cv);
123 db.setTransactionSuccessful();
126 db.endTransaction();
142 SQLiteDatabase db = mOpenHelper.getReadableDatabase();
143 if ((cursor = db.query(TABLE, COLUMNS_FOR_QUERY,
167 SQLiteDatabase db = mOpenHelper.getReadableDatabase();
168 if ((cursor = db.query(TABLE, COLUMNS_FOR_PREFETCH,
422 SQLiteDatabase db = mOpenHelper.getWritableDatabase();
449 db.beginTransaction();
450 db.delete(TABLE, COLUMN_USERID + "='" + userId + "'", null);
451 db.setTransactionSuccessful();
454 db.endTransaction();
469 void initialize(SQLiteDatabase db);
474 private static final String DATABASE_NAME = "locksettings.db";
486 private void createTable(SQLiteDatabase db) {
487 db.execSQL("CREATE TABLE " + TABLE + " (" +
496 public void onCreate(SQLiteDatabase db) {
497 createTable(db);
498 mCallback.initialize(db);
502 public void onUpgrade(SQLiteDatabase db, int oldVersion, int currentVersion) {