Lines Matching refs:mDatabase
40 private SQLiteDatabase mDatabase;
52 mDatabase = SQLiteDatabase.openOrCreateDatabase(mDatabaseFile.getPath(), null);
53 assertNotNull(mDatabase);
54 mDatabase.setVersion(CURRENT_DATABASE_VERSION);
59 mDatabase.close();
74 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, data TEXT);");
76 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString1 + "');");
77 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString2 + "');");
78 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString3 + "');");
84 SQLiteStatement statement = mDatabase.compileStatement("DELETE FROM test");
87 Cursor c = mDatabase.query("test", null, null, null, null, null, null);
95 mDatabase.execSQL("CREATE TABLE test (num INTEGER NOT NULL, str TEXT NOT NULL);");
96 mDatabase.execSQL("INSERT INTO test VALUES (1234, 'hello');");
98 mDatabase.compileStatement("SELECT num FROM test WHERE str = ?");
100 mDatabase.compileStatement("SELECT str FROM test WHERE num = ?");
132 mDatabase.execSQL("CREATE TABLE test (num INTEGER);");
133 SQLiteStatement statement = mDatabase.compileStatement("INSERT INTO test (num) VALUES (?)");
141 Cursor c = mDatabase.query("test", null, null, null, null, null, null);
154 mDatabase.execSQL("CREATE TABLE test (num TEXT);");
155 SQLiteStatement statement = mDatabase.compileStatement("INSERT INTO test (num) VALUES (?)");
163 Cursor c = mDatabase.query("test", null, null, null, null, null, null);
176 mDatabase.execSQL("CREATE TABLE test (num INTEGER);");
177 SQLiteStatement statement = mDatabase.compileStatement("INSERT INTO test (num) VALUES (?)");
186 Cursor c = mDatabase.query("test", null, null, null, null, null, "ROWID");
198 mDatabase.execSQL("CREATE TABLE test (num TEXT, value TEXT);");
206 mDatabase.execSQL(statement, args);
208 Cursor c = mDatabase.query("test", null, null, null, null, null, null);
222 mDatabase.execSQL("CREATE TABLE test (num INTEGER, str TEXT);");
224 mDatabase.compileStatement("INSERT INTO test (num, str) VALUES (?, ?)");
233 Cursor c = mDatabase.query("test", null, null, null, null, null, "ROWID");
248 private SQLiteDatabase mDatabase;
253 mDatabase = db;
259 mDatabase.beginTransaction();
265 mDatabase.setTransactionSuccessful();
266 mDatabase.endTransaction();
268 Cursor c = mDatabase.query("test", null, null, null, null, null, "ROWID");
285 mDatabase.execSQL("CREATE TABLE test (num INTEGER, str TEXT);");
287 mDatabase.compileStatement("INSERT INTO test (num, str) VALUES (?, ?)");
289 StatementTestThread thread = new StatementTestThread(mDatabase, statement);
300 mDatabase.execSQL("CREATE TABLE test (num INTEGER NOT NULL);");
301 SQLiteStatement statement = mDatabase.compileStatement("INSERT INTO test (num) VALUES (?)");
317 Cursor c = mDatabase.query("test", null, null, null, null, null, null);
