Lines Matching refs:mDatabase
48 private SQLiteDatabase mDatabase;
59 mDatabase = SQLiteDatabase.openOrCreateDatabase(mDatabaseFile.getPath(), null);
60 assertNotNull(mDatabase);
61 mDatabase.setVersion(CURRENT_DATABASE_VERSION);
66 mDatabase.close();
81 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, data TEXT);");
83 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString1 + "');");
84 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString2 + "');");
85 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString3 + "');");
90 assertEquals(CURRENT_DATABASE_VERSION, mDatabase.getVersion());
91 mDatabase.setVersion(11);
92 assertEquals(11, mDatabase.getVersion());
101 assertEquals(1, mDatabase.update("test", values, "_id=1", null));
102 Cursor c = mDatabase.query("test", null, "_id=1", null, null, null, null);
112 mDatabase.execSQL("CREATE TABLE phones (num TEXT);");
113 mDatabase.execSQL("INSERT INTO phones (num) VALUES ('911');");
114 mDatabase.execSQL("INSERT INTO phones (num) VALUES ('5555');");
115 mDatabase.execSQL("INSERT INTO phones (num) VALUES ('+" + PHONE_NUMBER + "');");
120 c = mDatabase.query("phones", null,
125 c = mDatabase.query("phones", null,
134 c = mDatabase.query("phones", null,
143 c = mDatabase.query("phones", null,
148 c = mDatabase.query("phones", null,
157 c = mDatabase.query("phones", null,
166 c = mDatabase.query("phones", null,
176 c = mDatabase.query("phones", null,
186 c = mDatabase.query("phones", null,
195 c = mDatabase.query("phones", null,
211 Cursor cursor = mDatabase.rawQuery(
317 mDatabase.execSQL("CREATE TABLE guess (numi INTEGER, numf FLOAT, str TEXT);");
318 mDatabase.execSQL(
320 mDatabase.execSQL("INSERT INTO guess (numi,numf,str) VALUES (2000000000,3.1415926535,'');");
324 mDatabase.execSQL("INSERT INTO guess (numi,numf,str) VALUES (-32768,-1.0,?)", arr);
328 c = mDatabase.rawQuery("SELECT * FROM guess", null);
369 SQLiteDatabase db1 = mDatabase;
385 SQLiteDatabase db1 = mDatabase;
411 SQLiteDatabase db1 = mDatabase;
510 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, data TEXT);");
513 mDatabase.insert("test", "data", values);
516 mDatabase.insert("test", "data", values);
517 Cursor c = mDatabase.query(
527 mDatabase.query("test", new String[]{"_id"},
538 mDatabase.execSQL("CREATE TABLE tokens (" +
544 mDatabase.execSQL("CREATE TABLE tokens_no_index (" +
549 Assert.assertEquals(0, DatabaseUtils.longForQuery(mDatabase,
551 Assert.assertEquals(0, DatabaseUtils.longForQuery(mDatabase,
553 Assert.assertEquals(0, DatabaseUtils.longForQuery(mDatabase,
555 Assert.assertEquals(0, DatabaseUtils.longForQuery(mDatabase,
558 Assert.assertEquals(3, DatabaseUtils.longForQuery(mDatabase,
560 Assert.assertEquals(2, DatabaseUtils.longForQuery(mDatabase,
563 Assert.assertEquals(3, DatabaseUtils.longForQuery(mDatabase,
565 Assert.assertEquals(3, DatabaseUtils.longForQuery(mDatabase,
570 Assert.assertEquals(2, DatabaseUtils.longForQuery(mDatabase,
575 Assert.assertEquals(2, DatabaseUtils.longForQuery(mDatabase,
578 Assert.assertEquals(9, DatabaseUtils.longForQuery(mDatabase,
582 Assert.assertEquals(1, DatabaseUtils.longForQuery(mDatabase,
584 Assert.assertEquals(13, DatabaseUtils.longForQuery(mDatabase,
586 Assert.assertEquals(0, DatabaseUtils.longForQuery(mDatabase,
589 Assert.assertEquals(1, DatabaseUtils.longForQuery(mDatabase,
591 Assert.assertEquals(13, DatabaseUtils.longForQuery(mDatabase,
593 Assert.assertEquals(1, DatabaseUtils.longForQuery(mDatabase,
597 Assert.assertEquals(1, DatabaseUtils.longForQuery(mDatabase,
599 Assert.assertEquals(11, DatabaseUtils.longForQuery(mDatabase,
601 Assert.assertEquals(0, DatabaseUtils.longForQuery(mDatabase,
603 Assert.assertEquals("foo", DatabaseUtils.stringForQuery(mDatabase,
606 Assert.assertEquals(1, DatabaseUtils.longForQuery(mDatabase,
608 Assert.assertEquals(11, DatabaseUtils.longForQuery(mDatabase,
610 Assert.assertEquals(1, DatabaseUtils.longForQuery(mDatabase,
612 Assert.assertEquals("foo", DatabaseUtils.stringForQuery(mDatabase,
615 Assert.assertEquals(1, DatabaseUtils.longForQuery(mDatabase,
617 Assert.assertEquals(11, DatabaseUtils.longForQuery(mDatabase,
619 Assert.assertEquals(2, DatabaseUtils.longForQuery(mDatabase,
621 Assert.assertEquals("foo", DatabaseUtils.stringForQuery(mDatabase,
625 Assert.assertEquals(1, DatabaseUtils.longForQuery(mDatabase,
627 Assert.assertEquals(11, DatabaseUtils.longForQuery(mDatabase,
629 Assert.assertEquals(0, DatabaseUtils.longForQuery(mDatabase,
631 Assert.assertEquals("bar", DatabaseUtils.stringForQuery(mDatabase,
634 Assert.assertEquals(1, DatabaseUtils.longForQuery(mDatabase,
636 Assert.assertEquals(11, DatabaseUtils.longForQuery(mDatabase,
638 Assert.assertEquals(1, DatabaseUtils.longForQuery(mDatabase,
640 Assert.assertEquals("bar", DatabaseUtils.stringForQuery(mDatabase,
646 Assert.assertEquals(1, DatabaseUtils.longForQuery(mDatabase,
648 Assert.assertEquals(12, DatabaseUtils.longForQuery(mDatabase,
650 Assert.assertEquals(0, DatabaseUtils.longForQuery(mDatabase,
653 Assert.assertEquals(1, DatabaseUtils.longForQuery(mDatabase,
655 Assert.assertEquals(12, DatabaseUtils.longForQuery(mDatabase,
657 Assert.assertEquals(0, DatabaseUtils.longForQuery(mDatabase,
660 Assert.assertEquals(1, DatabaseUtils.longForQuery(mDatabase,
662 Assert.assertEquals(12, DatabaseUtils.longForQuery(mDatabase,
664 Assert.assertEquals(0, DatabaseUtils.longForQuery(mDatabase,
667 Assert.assertEquals(1, DatabaseUtils.longForQuery(mDatabase,
669 Assert.assertEquals(12, DatabaseUtils.longForQuery(mDatabase,
671 Assert.assertEquals(0, DatabaseUtils.longForQuery(mDatabase,
675 Assert.assertEquals(1, DatabaseUtils.longForQuery(mDatabase,
677 Assert.assertEquals(12, DatabaseUtils.longForQuery(mDatabase,
679 Assert.assertEquals(0, DatabaseUtils.longForQuery(mDatabase,
684 Assert.assertEquals(1, DatabaseUtils.longForQuery(mDatabase,
686 Assert.assertEquals(12, DatabaseUtils.longForQuery(mDatabase,
688 Assert.assertEquals(1, DatabaseUtils.longForQuery(mDatabase,
691 Assert.assertEquals(0, DatabaseUtils.longForQuery(mDatabase,
695 Assert.assertEquals(1, DatabaseUtils.longForQuery(mDatabase,
697 Assert.assertEquals(20, DatabaseUtils.longForQuery(mDatabase,
701 Assert.assertEquals(1, DatabaseUtils.longForQuery(mDatabase,
703 Assert.assertEquals(21, DatabaseUtils.longForQuery(mDatabase,
709 mDatabase.execSQL("CREATE TABLE test (num INTEGER);");
710 mDatabase.execSQL("INSERT INTO test (num) VALUES (0)");
718 mDatabase.beginTransaction();
720 mDatabase.setTransactionSuccessful();
721 mDatabase.endTransaction();
723 Assert.assertFalse(mDatabase.isDbLockedByCurrentThread());
727 mDatabase.beginTransaction();
729 mDatabase.endTransaction();
731 Assert.assertFalse(mDatabase.isDbLockedByCurrentThread());
735 mDatabase.endTransaction();
740 mDatabase.setTransactionSuccessful();
743 mDatabase.beginTransaction();
744 mDatabase.setTransactionSuccessful();
747 mDatabase.setTransactionSuccessful();
751 mDatabase.beginTransaction();
753 mDatabase.endTransaction();
754 Assert.assertFalse(mDatabase.isDbLockedByCurrentThread());
758 mDatabase.beginTransaction();
759 mDatabase.beginTransaction();
761 mDatabase.setTransactionSuccessful();
762 mDatabase.endTransaction();
763 mDatabase.setTransactionSuccessful();
764 mDatabase.endTransaction();
766 Assert.assertFalse(mDatabase.isDbLockedByCurrentThread());
770 mDatabase.beginTransaction();
771 mDatabase.beginTransaction();
773 mDatabase.endTransaction();
774 mDatabase.setTransactionSuccessful();
775 mDatabase.endTransaction();
777 Assert.assertFalse(mDatabase.isDbLockedByCurrentThread());
781 mDatabase.beginTransaction();
782 mDatabase.beginTransaction();
784 mDatabase.setTransactionSuccessful();
785 mDatabase.endTransaction();
786 mDatabase.endTransaction();
788 Assert.assertFalse(mDatabase.isDbLockedByCurrentThread());
792 mDatabase.execSQL("UPDATE test SET num = " + num);
797 num, DatabaseUtils.longForQuery(mDatabase, "SELECT num FROM test", null));
815 Cursor cursor = mDatabase.query("test", null, null, null, null, null, null);
827 Cursor cursor = mDatabase.query("test", null, null, null, null, null, null);
838 Cursor cursor = mDatabase.query("test", null, null, null, null, null, null);
867 mDatabase.execSQL("CREATE TABLE pragma_test (" +
874 Cursor cur = mDatabase.rawQuery("PRAGMA table_info(pragma_test)", null);
919 mDatabase.execSQL("CREATE TABLE insert_test (" +
928 new DatabaseUtils.InsertHelper(mDatabase, "insert_test");
933 cur = mDatabase.rawQuery("SELECT * FROM insert_test WHERE _id == " + row, null);
946 cur = mDatabase.rawQuery("SELECT * FROM insert_test WHERE _id == " + row, null);
966 cur = mDatabase.rawQuery("SELECT * FROM insert_test WHERE _id == " + row, null);
981 cur = mDatabase.rawQuery("SELECT * FROM insert_test WHERE _id == " + row, null);
993 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, text1 TEXT, text2 TEXT, " +
996 SQLiteStatement statementDoNotClose = mDatabase.compileStatement(statement);
1002 * mDatabase.close() in tearDown() should release it.
1008 mDatabase.execSQL("CREATE TABLE pragma_test (" +
1016 Cursor cur = mDatabase.rawQuery("PRAGMA database_list;", null);
1019 cur = mDatabase.rawQuery("PRAGMA database_list;;", null);
1071 mDatabase.execSQL("CREATE TABLE " + dbName + " (" +
1075 new DatabaseUtils.InsertHelper(mDatabase, dbName);
1095 Cursor cur = mDatabase.rawQuery(
