Lines Matching defs:mDatabase
48 private SQLiteDatabase mDatabase;
60 mDatabase = SQLiteDatabase.openOrCreateDatabase(mDatabaseFile.getPath(), null);
61 assertNotNull(mDatabase);
62 mDatabase.setVersion(CURRENT_DATABASE_VERSION);
67 mDatabase.close();
82 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, data TEXT);");
84 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString1 + "');");
85 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString2 + "');");
86 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString3 + "');");
92 mDatabase.execSQL(
110 mDatabase.execSQL(sql, args);
112 Cursor c = mDatabase.query("test", null, null, null, null, null, null);
130 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, data REAL);");
133 long id = mDatabase.insert("test", "data", values);
135 Cursor c = mDatabase.rawQuery("SELECT data FROM test", null);
146 Cursor c = mDatabase.query("test", null, null, null, null, null, null);
210 Cursor c = mDatabase.query("test", null, "_id > 1000", null, null, null, null);
237 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, data TEXT);");
248 mDatabase.execSQL(sql.toString());
250 Cursor c = mDatabase.query("test", null, null, null, null, null, null);
293 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, data INT);");
296 mDatabase.execSQL("BEGIN Transaction;");
298 mDatabase.execSQL("INSERT INTO test (data) VALUES (" + i + ");");
300 mDatabase.execSQL("COMMIT;");
302 Cursor c = mDatabase.query("test", new String[]{"data"}, null, null, null, null, null);
319 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, data TEXT);");
332 mDatabase.execSQL("BEGIN Transaction;");
334 mDatabase.execSQL(sql.toString());
336 mDatabase.execSQL("COMMIT;");
338 Cursor c = mDatabase.query("test", new String[]{"data"}, null, null, null, null, null);
353 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, txt TEXT, data INT);");
363 mDatabase.execSQL("BEGIN Transaction;");
371 mDatabase.execSQL(sql.toString());
373 mDatabase.execSQL("COMMIT;");
375 Cursor c = mDatabase.query("test", new String[]{"txt", "data"}, null, null, null, null, null);
393 Cursor c = mDatabase.rawQuery("SELECT * FROM test", null);
406 Cursor c = mDatabase.rawQuery("SELECT data FROM test WHERE data = '" + sString1 + "'",
424 Cursor c = mDatabase.rawQuery("SELECT data FROM test WHERE data = ?",
458 Cursor c = mDatabase.rawQueryWithFactory(
487 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, data TEXT);");
488 mDatabase.execSQL("INSERT INTO test values(1, 'test');");
494 Cursor cursor = mDatabase.rawQuery("select * from test", null);