Lines Matching refs:mDatabase
81 protected SQLiteDatabase mDatabase;
91 mDatabase = SQLiteDatabase.openOrCreateDatabase(mDatabaseFile.getPath(), null);
92 Assert.assertTrue(mDatabase != null);
93 mDatabase.setVersion(CURRENT_DATABASE_VERSION);
97 mDatabase.close();
214 mDatabase
221 mDatabase.execSQL(statements[i]);
247 mDatabase
249 mDatabase.execSQL("CREATE INDEX i1c ON t1(c)");
255 mDatabase.execSQL(statements[i]);
275 mDatabase
280 mDatabase.execSQL("INSERT INTO t1 VALUES(" + i + "," + r + ",'"
294 mDatabase
315 mDatabase
320 mDatabase.execSQL("INSERT INTO t1 VALUES(" + i + "," + r + ",'"
332 mDatabase
353 mDatabase
355 mDatabase.execSQL("CREATE INDEX i1b ON t1(b)");
359 mDatabase.execSQL("INSERT INTO t1 VALUES(" + i + "," + r + ",'"
373 mDatabase
392 mDatabase
394 mDatabase
399 mDatabase.execSQL("INSERT INTO t1 VALUES(" + i + "," + r + ",'"
405 mDatabase.execSQL("INSERT INTO t2 VALUES(" + i + "," + r + ",'"
412 mDatabase.query("t1 INNER JOIN t2 ON t1.b = t2.b", COLUMNS, null,
430 mDatabase
432 mDatabase
435 mDatabase.execSQL("CREATE INDEX i1b ON t1(b)");
439 mDatabase.execSQL("INSERT INTO t1 VALUES(" + i + "," + r + ",'"
445 mDatabase.execSQL("INSERT INTO t2 VALUES(" + i + "," + r + ",'"
452 mDatabase.query("t1 INNER JOIN t2 ON t1.b = t2.b", COLUMNS, null,
470 mDatabase
472 mDatabase
475 mDatabase.execSQL("CREATE INDEX i1b ON t1(b)");
479 mDatabase.execSQL("INSERT INTO t1 VALUES(" + i + "," + r + ",'"
485 mDatabase.execSQL("INSERT INTO t2 VALUES(" + i + "," + r + ",'"
492 mDatabase.query("t1 INNER JOIN t2 ON t1.c = t2.c", COLUMNS, null,
512 mDatabase
514 mDatabase
517 mDatabase.execSQL("CREATE INDEX i2b ON t2(b)");
521 mDatabase.execSQL("INSERT INTO t1 VALUES(" + i + "," + r + ",'"
527 mDatabase.execSQL("INSERT INTO t2 VALUES(" + i + "," + r + ",'"
543 mDatabase
564 mDatabase
566 mDatabase.execSQL("CREATE INDEX i3c ON t1(c)");
570 mDatabase.execSQL("INSERT INTO t1 VALUES(" + i + "," + r + ",'"
582 mDatabase
603 mDatabase
608 mDatabase.execSQL("INSERT INTO t1 VALUES(" + i + "," + r + ",'"
617 mDatabase.query("t1", COLUMNS, null, null, null, null, null);
637 mDatabase
642 mDatabase.execSQL("INSERT INTO t1 VALUES(" + i + "," + r + ",'"
651 mDatabase.query("t1", COLUMNS, null, null, null, null, null);
669 mDatabase
671 mDatabase.execSQL("CREATE INDEX i1b on t1(b)");
675 mDatabase.execSQL("INSERT INTO t1 VALUES(" + i + "," + r + ",'"
684 mDatabase.query("t1", COLUMNS, null, null, null, null, null);
702 mDatabase
704 mDatabase.execSQL("CREATE INDEX i1c ON t1(c)");
708 mDatabase.execSQL("INSERT INTO t1 VALUES(" + i + "," + r + ",'"
717 mDatabase.query("t1", COLUMNS, null, null, null, null, null);
736 mDatabase
738 mDatabase.execSQL("CREATE INDEX i1c ON t1(c)");
742 mDatabase.execSQL("INSERT INTO t1 VALUES(" + i + "," + r + ",'"
757 mDatabase
776 mDatabase
778 mDatabase.execSQL("CREATE INDEX i3c ON t1(c)");
782 mDatabase.execSQL("INSERT INTO t1 VALUES(" + i + "," + r + ",'"
791 mDatabase.delete("t1", null, null);
809 mDatabase
814 mDatabase.execSQL("INSERT INTO t1 VALUES(" + i + "," + r + ",'"
823 mDatabase.delete("t1", null, null);
841 mDatabase
846 mDatabase.execSQL("INSERT INTO t1 VALUES(" + i + "," + r + ",'"
860 mDatabase.delete("t1", where[i], null);
878 mDatabase
880 mDatabase.execSQL("CREATE INDEX i1b ON t1(b)");
884 mDatabase.execSQL("INSERT INTO t1 VALUES(" + i + "," + r + ",'"
898 mDatabase.delete("t1", where[i], null);
917 mDatabase
919 mDatabase.execSQL("CREATE INDEX i1b ON t1(b)");
923 mDatabase.execSQL("INSERT INTO t1 VALUES(" + i + "," + r + ",'"
942 mDatabase.update("t1", mValues[i], where[i], null);
961 mDatabase
966 mDatabase.execSQL("INSERT INTO t1 VALUES(" + i + "," + r + ",'"
984 mDatabase.update("t1", mValues[i], where[i], null);
1002 mDatabase
1016 mDatabase.insert("t1", null, mValues[i]);
1034 mDatabase
1036 mDatabase.execSQL("CREATE INDEX i1a ON t1(a)");
1049 mDatabase.insert("t1", null, mValues[i]);
1067 mDatabase
1081 mDatabase.insert("t1", null, mValues[i]);
1099 mDatabase
1101 mDatabase.execSQL("CREATE INDEX i1a ON t1(a)");
1114 mDatabase.insert("t1", null, mValues[i]);
1134 mDatabase
1139 mDatabase.execSQL("INSERT INTO t3 VALUES('"
1153 mDatabase.query("t3", COLUMNS, where[i], null, null, null, null);
1172 mDatabase
1174 mDatabase.execSQL("CREATE INDEX i3a ON t3(a)");
1178 mDatabase.execSQL("INSERT INTO t3 VALUES('"
1192 mDatabase.query("t3", COLUMNS, where[i], null, null, null, null);
1211 mDatabase
1216 mDatabase.execSQL("INSERT INTO t4 VALUES(" + r + ")");
1226 mDatabase.query("t4", COLUMNS, where[i], null, null, null, null);
1245 mDatabase
1247 mDatabase.execSQL("CREATE INDEX i4a ON t4(a)");
1251 mDatabase.execSQL("INSERT INTO t4 VALUES(" + r + ")");
1263 mDatabase.query("t4", COLUMNS, where[i], null, null, null, null);
1283 mDatabase
1288 mDatabase.execSQL("INSERT INTO t3 VALUES('"
1301 mDatabase.query("t3", COLUMNS, where[i], null, null, null, null);
1320 mDatabase
1322 mDatabase.execSQL("CREATE INDEX i3a ON t3(a)");
1326 mDatabase.execSQL("INSERT INTO t3 VALUES('"
1340 mDatabase.query("t3", COLUMNS, where[i], null, null, null, null);