Lines Matching refs:mDatabase
80 protected SQLiteDatabase mDatabase;
90 mDatabase = SQLiteDatabase.openOrCreateDatabase(mDatabaseFile.getPath(), null);
91 Assert.assertTrue(mDatabase != null);
92 mDatabase.setVersion(CURRENT_DATABASE_VERSION);
96 mDatabase.close();
213 mDatabase
220 mDatabase.execSQL(statements[i]);
246 mDatabase
248 mDatabase.execSQL("CREATE INDEX i1c ON t1(c)");
254 mDatabase.execSQL(statements[i]);
274 mDatabase
279 mDatabase.execSQL("INSERT INTO t1 VALUES(" + i + "," + r + ",'"
293 mDatabase
314 mDatabase
319 mDatabase.execSQL("INSERT INTO t1 VALUES(" + i + "," + r + ",'"
331 mDatabase
352 mDatabase
354 mDatabase.execSQL("CREATE INDEX i1b ON t1(b)");
358 mDatabase.execSQL("INSERT INTO t1 VALUES(" + i + "," + r + ",'"
372 mDatabase
391 mDatabase
393 mDatabase
398 mDatabase.execSQL("INSERT INTO t1 VALUES(" + i + "," + r + ",'"
404 mDatabase.execSQL("INSERT INTO t2 VALUES(" + i + "," + r + ",'"
411 mDatabase.query("t1 INNER JOIN t2 ON t1.b = t2.b", COLUMNS, null,
429 mDatabase
431 mDatabase
434 mDatabase.execSQL("CREATE INDEX i1b ON t1(b)");
438 mDatabase.execSQL("INSERT INTO t1 VALUES(" + i + "," + r + ",'"
444 mDatabase.execSQL("INSERT INTO t2 VALUES(" + i + "," + r + ",'"
451 mDatabase.query("t1 INNER JOIN t2 ON t1.b = t2.b", COLUMNS, null,
469 mDatabase
471 mDatabase
474 mDatabase.execSQL("CREATE INDEX i1b ON t1(b)");
478 mDatabase.execSQL("INSERT INTO t1 VALUES(" + i + "," + r + ",'"
484 mDatabase.execSQL("INSERT INTO t2 VALUES(" + i + "," + r + ",'"
491 mDatabase.query("t1 INNER JOIN t2 ON t1.c = t2.c", COLUMNS, null,
511 mDatabase
513 mDatabase
516 mDatabase.execSQL("CREATE INDEX i2b ON t2(b)");
520 mDatabase.execSQL("INSERT INTO t1 VALUES(" + i + "," + r + ",'"
526 mDatabase.execSQL("INSERT INTO t2 VALUES(" + i + "," + r + ",'"
542 mDatabase
563 mDatabase
565 mDatabase.execSQL("CREATE INDEX i3c ON t1(c)");
569 mDatabase.execSQL("INSERT INTO t1 VALUES(" + i + "," + r + ",'"
581 mDatabase
602 mDatabase
607 mDatabase.execSQL("INSERT INTO t1 VALUES(" + i + "," + r + ",'"
616 mDatabase.query("t1", COLUMNS, null, null, null, null, null);
636 mDatabase
641 mDatabase.execSQL("INSERT INTO t1 VALUES(" + i + "," + r + ",'"
650 mDatabase.query("t1", COLUMNS, null, null, null, null, null);
668 mDatabase
670 mDatabase.execSQL("CREATE INDEX i1b on t1(b)");
674 mDatabase.execSQL("INSERT INTO t1 VALUES(" + i + "," + r + ",'"
683 mDatabase.query("t1", COLUMNS, null, null, null, null, null);
701 mDatabase
703 mDatabase.execSQL("CREATE INDEX i1c ON t1(c)");
707 mDatabase.execSQL("INSERT INTO t1 VALUES(" + i + "," + r + ",'"
716 mDatabase.query("t1", COLUMNS, null, null, null, null, null);
735 mDatabase
737 mDatabase.execSQL("CREATE INDEX i1c ON t1(c)");
741 mDatabase.execSQL("INSERT INTO t1 VALUES(" + i + "," + r + ",'"
756 mDatabase
775 mDatabase
777 mDatabase.execSQL("CREATE INDEX i3c ON t1(c)");
781 mDatabase.execSQL("INSERT INTO t1 VALUES(" + i + "," + r + ",'"
790 mDatabase.delete("t1", null, null);
808 mDatabase
813 mDatabase.execSQL("INSERT INTO t1 VALUES(" + i + "," + r + ",'"
822 mDatabase.delete("t1", null, null);
840 mDatabase
845 mDatabase.execSQL("INSERT INTO t1 VALUES(" + i + "," + r + ",'"
859 mDatabase.delete("t1", where[i], null);
877 mDatabase
879 mDatabase.execSQL("CREATE INDEX i1b ON t1(b)");
883 mDatabase.execSQL("INSERT INTO t1 VALUES(" + i + "," + r + ",'"
897 mDatabase.delete("t1", where[i], null);
916 mDatabase
918 mDatabase.execSQL("CREATE INDEX i1b ON t1(b)");
922 mDatabase.execSQL("INSERT INTO t1 VALUES(" + i + "," + r + ",'"
941 mDatabase.update("t1", mValues[i], where[i], null);
960 mDatabase
965 mDatabase.execSQL("INSERT INTO t1 VALUES(" + i + "," + r + ",'"
983 mDatabase.update("t1", mValues[i], where[i], null);
1001 mDatabase
1015 mDatabase.insert("t1", null, mValues[i]);
1033 mDatabase
1035 mDatabase.execSQL("CREATE INDEX i1a ON t1(a)");
1048 mDatabase.insert("t1", null, mValues[i]);
1066 mDatabase
1080 mDatabase.insert("t1", null, mValues[i]);
1098 mDatabase
1100 mDatabase.execSQL("CREATE INDEX i1a ON t1(a)");
1113 mDatabase.insert("t1", null, mValues[i]);
1133 mDatabase
1138 mDatabase.execSQL("INSERT INTO t3 VALUES('"
1152 mDatabase.query("t3", COLUMNS, where[i], null, null, null, null);
1171 mDatabase
1173 mDatabase.execSQL("CREATE INDEX i3a ON t3(a)");
1177 mDatabase.execSQL("INSERT INTO t3 VALUES('"
1191 mDatabase.query("t3", COLUMNS, where[i], null, null, null, null);
1210 mDatabase
1215 mDatabase.execSQL("INSERT INTO t4 VALUES(" + r + ")");
1225 mDatabase.query("t4", COLUMNS, where[i], null, null, null, null);
1244 mDatabase
1246 mDatabase.execSQL("CREATE INDEX i4a ON t4(a)");
1250 mDatabase.execSQL("INSERT INTO t4 VALUES(" + r + ")");
1262 mDatabase.query("t4", COLUMNS, where[i], null, null, null, null);
1282 mDatabase
1287 mDatabase.execSQL("INSERT INTO t3 VALUES('"
1300 mDatabase.query("t3", COLUMNS, where[i], null, null, null, null);
1319 mDatabase
1321 mDatabase.execSQL("CREATE INDEX i3a ON t3(a)");
1325 mDatabase.execSQL("INSERT INTO t3 VALUES('"
1339 mDatabase.query("t3", COLUMNS, where[i], null, null, null, null);
