| /cts/tests/tests/database/src/android/database/sqlite/cts/ |
| SQLiteDatabaseTest.java | 51 private SQLiteDatabase mDatabase;
82 mDatabase = SQLiteDatabase.openOrCreateDatabase(mDatabaseFile, null);
83 assertNotNull(mDatabase);
97 mDatabase.close();
169 mDatabase.execSQL("CREATE TABLE test (num INTEGER);");
170 mDatabase.execSQL("INSERT INTO test (num) VALUES (0)");
178 assertFalse(mDatabase.inTransaction());
179 mDatabase.beginTransaction();
180 assertTrue(mDatabase.inTransaction());
182 mDatabase.setTransactionSuccessful()
[all...] |
| DatabaseStatementTest.java | 44 private SQLiteDatabase mDatabase;
51 mDatabase = getContext().openOrCreateDatabase(DATABASE_NAME, Context.MODE_PRIVATE, null);
52 assertNotNull(mDatabase);
53 mDatabase.setVersion(CURRENT_DATABASE_VERSION);
58 mDatabase.close();
73 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, data TEXT);");
75 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString1 + "');");
76 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString2 + "');");
77 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString3 + "');");
83 SQLiteStatement statement = mDatabase.compileStatement("DELETE FROM test")
[all...] |
| SQLiteStatementTest.java | 51 private SQLiteDatabase mDatabase;
58 mDatabase = getContext().openOrCreateDatabase(DATABASE_NAME, Context.MODE_PRIVATE, null);
59 assertNotNull(mDatabase);
60 mDatabase.setVersion(CURRENT_DATABASE_VERSION);
65 mDatabase.close();
71 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, data TEXT);");
75 mDatabase.execSQL("CREATE TABLE blob_test (_id INTEGER PRIMARY KEY, data BLOB)");
80 mDatabase.insert("blob_test", null, values);
85 mDatabase.disableWriteAheadLogging();
88 assertEquals(0, DatabaseUtils.longForQuery(mDatabase, "select count(*) from test", null))
[all...] |
| SQLiteProgramTest.java | 33 private SQLiteDatabase mDatabase;
40 mDatabase = getContext().openOrCreateDatabase(DATABASE_NAME, Context.MODE_PRIVATE, null);
41 assertNotNull(mDatabase);
46 mDatabase.close();
53 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, text1 TEXT, text2 TEXT, " +
55 mDatabase.execSQL("INSERT INTO test (text1, text2, num1, num2, image) " +
57 mDatabase.execSQL("INSERT INTO test (text1, text2, num1, num2, image) " +
61 statement = mDatabase.compileStatement("SELECT num1 FROM test WHERE num2 = ?;");
70 statement = mDatabase.compileStatement("SELECT text1 FROM test WHERE text2 = ?;");
92 cursor = mDatabase.query("test", new String[]{"text1"}, "where text1='a'"
[all...] |
| SQLiteCursorTest.java | 37 private SQLiteDatabase mDatabase;
50 mDatabase = getContext().openOrCreateDatabase(DATABASE_FILE, Context.MODE_PRIVATE, null);
57 mDatabase.close();
63 SQLiteDirectCursorDriver cursorDriver = new SQLiteDirectCursorDriver(mDatabase,
66 new SQLiteCursor(mDatabase, cursorDriver, TABLE_NAME, null);
147 mDatabase.execSQL(DELETE_1);
155 mDatabase.execSQL(DELETE_2);
166 mDatabase.disableWriteAheadLogging();
167 mDatabase.execSQL("create table testRequery2 (i int);");
168 mDatabase.execSQL("insert into testRequery2 values(1);")
[all...] |
| SQLiteFtsTest.java | 41 private SQLiteDatabase mDatabase;
46 mDatabase = getContext().openOrCreateDatabase("CTS_FTS", Context.MODE_PRIVATE, null);
52 final String path = mDatabase.getPath();
53 mDatabase.close();
106 mDatabase.execSQL(
115 mDatabase.insert(table, null, values);
120 return mDatabase.query(table, new String[] { "snippet(" + table + ")" },
|
| SQLiteQueryBuilderTest.java | 36 private SQLiteDatabase mDatabase;
46 mDatabase = getContext().openOrCreateDatabase(DATABASE_FILE, Context.MODE_PRIVATE, null);
47 assertNotNull(mDatabase);
52 mDatabase.close();
128 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, " +
130 mDatabase.execSQL("INSERT INTO test (name, age, address) VALUES ('Mike', '20', 'LA');");
131 mDatabase.execSQL("INSERT INTO test (name, age, address) VALUES ('jack', '40', 'LA');");
135 Cursor cursor = sqliteQueryBuilder.query(mDatabase, new String[] { "name", "age" },
148 cursor = sqliteQueryBuilder.query(mDatabase, new String[] { "name", "age" },
209 Cursor cursor = sqliteQueryBuilder.query(mDatabase,
[all...] |
| /frameworks/base/packages/MtpDocumentsProvider/tests/src/com/android/mtp/ |
| MtpDatabaseTest.java | 57 MtpDatabase mDatabase;
61 mDatabase = new MtpDatabase(getContext(), MtpDatabaseConstants.FLAG_DATABASE_IN_MEMORY);
66 mDatabase.close();
67 mDatabase = null;
85 mDatabase.getMapper().startAddingDocuments("1");
86 mDatabase.getMapper().putStorageDocuments("1", OPERATIONS_SUPPORTED, new MtpRoot[] {
89 mDatabase.getMapper().stopAddingDocuments("1");
92 final Cursor cursor = mDatabase.queryRootDocuments(COLUMN_NAMES);
116 final Cursor cursor = mDatabase.queryRoots(resources, new String [] {
147 mDatabase.getMapper().startAddingDocuments("1")
[all...] |
| /frameworks/base/core/tests/coretests/src/android/database/ |
| DatabaseGeneralTest.java | 58 private SQLiteDatabase mDatabase;
69 mDatabase = SQLiteDatabase.openOrCreateDatabase(mDatabaseFile.getPath(), null);
70 assertNotNull(mDatabase);
71 mDatabase.setVersion(CURRENT_DATABASE_VERSION);
76 mDatabase.close();
91 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, data TEXT);");
93 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString1 + "');");
94 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString2 + "');");
95 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString3 + "');");
100 assertEquals(CURRENT_DATABASE_VERSION, mDatabase.getVersion())
[all...] |
| DatabaseStressTest.java | 34 private SQLiteDatabase mDatabase;
47 mDatabase = c.openOrCreateDatabase("database_test.db", 0, null);
49 assertNotNull(mDatabase);
50 mDatabase.setVersion(CURRENT_DATABASE_VERSION);
52 mDatabase.execSQL("CREATE TABLE IF NOT EXISTS test (_id INTEGER PRIMARY KEY, data TEXT);");
58 mDatabase.close();
71 mDatabase.execSQL("INSERT INTO test (data) VALUES (?)", strArr);
72 mDatabase.execSQL("delete from test;");
93 mDatabase.execSQL("INSERT INTO test (data) VALUES (?)", strArr);
|
| DatabaseStatementTest.java | 38 private SQLiteDatabase mDatabase;
50 mDatabase = SQLiteDatabase.openOrCreateDatabase(mDatabaseFile.getPath(), null);
51 assertNotNull(mDatabase);
52 mDatabase.setVersion(CURRENT_DATABASE_VERSION);
57 mDatabase.close();
72 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, data TEXT);");
74 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString1 + "');");
75 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString2 + "');");
76 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString3 + "');");
82 SQLiteStatement statement = mDatabase.compileStatement("DELETE FROM test")
[all...] |
| DatabaseLockTest.java | 38 private SQLiteDatabase mDatabase;
51 mDatabase = SQLiteDatabase.openOrCreateDatabase(mDatabaseFile.getPath(), null);
52 assertNotNull(mDatabase);
57 mDatabase.close();
74 mDatabase.beginTransaction();
85 mDatabase.endTransaction();
101 mDatabase.beginTransaction();
108 mDatabase.endTransaction();
126 mDatabase.beginTransaction();
138 mDatabase.endTransaction()
[all...] |
| NewDatabasePerformanceTests.java | 65 protected SQLiteDatabase mDatabase;
81 mDatabase = SQLiteDatabase.openDatabase(mDatabaseFile, params.build());
83 assertTrue("Cannot enable WAL", mDatabase.isWriteAheadLoggingEnabled());
85 mDatabase.setVersion(CURRENT_DATABASE_VERSION);
86 mDatabase.beginTransactionNonExclusive();
88 mDatabase.setTransactionSuccessful();
89 mDatabase.endTransaction();
102 mDatabase.close();
166 mDatabase.execSQL("CREATE TABLE " + t + "(a INTEGER, b INTEGER, c VARCHAR(100))");
167 mDatabase.execSQL("INSERT INTO " + t + " VALUES(" + i + "," + i + ",'
[all...] |
| DatabaseErrorHandlerTest.java | 33 private SQLiteDatabase mDatabase;
46 mDatabase = SQLiteDatabase.openOrCreateDatabase(mDatabaseFile.getPath(), null,
48 assertNotNull(mDatabase);
53 mDatabase.close();
59 new MyDatabaseCorruptionHandler().onCorruption(mDatabase);
66 mDatabase.execSQL("create table t (i int);");
75 mDatabase.execSQL("select * from t;");
|
| DatabaseLocaleTest.java | 33 private SQLiteDatabase mDatabase;
48 mDatabase = SQLiteDatabase.create(null);
49 mDatabase.execSQL(
55 mDatabase.execSQL("INSERT INTO test (data) VALUES('" + s + "');");
61 mDatabase.close();
67 Cursor c = mDatabase.rawQuery(sql, null);
91 mDatabase.setLocale(new Locale("en", "US"));
114 mDatabase.execSQL("INSERT INTO test(id, data) VALUES(1, '" + expectedString + "')");
115 cursor = mDatabase.rawQuery("SELECT data FROM test WHERE id = 1", null);
|
| DatabaseCursorTest.java | 49 private SQLiteDatabase mDatabase;
61 mDatabase = SQLiteDatabase.openOrCreateDatabase(mDatabaseFile.getPath(), null);
62 assertNotNull(mDatabase);
63 mDatabase.setVersion(CURRENT_DATABASE_VERSION);
68 mDatabase.close();
83 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, data TEXT);");
85 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString1 + "');");
86 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString2 + "');");
87 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString3 + "');");
93 mDatabase.execSQL
[all...] |
| /frameworks/base/core/tests/coretests/src/android/database/sqlite/ |
| SQLiteCursorTest.java | 30 private SQLiteDatabase mDatabase;
42 mDatabase = SQLiteDatabase.openOrCreateDatabase(mDatabaseFile.getPath(), null);
43 assertNotNull(mDatabase);
45 mDatabase.execSQL("CREATE TABLE " + TABLE_NAME + " (i int, j int);");
50 mDatabase.close();
62 mDatabase.beginTransaction();
63 mDatabase.execSQL("CREATE TABLE " + testTable + " (col1 int, desc text not null);");
64 mDatabase.setTransactionSuccessful();
65 mDatabase.endTransaction();
82 mDatabase.beginTransaction()
[all...] |
| /frameworks/support/room/integration-tests/testapp/src/androidTest/java/android/arch/persistence/room/integration/testapp/test/ |
| TestDatabaseTest.java | 36 protected TestDatabase mDatabase;
49 mDatabase = Room.inMemoryDatabaseBuilder(context, TestDatabase.class).build();
50 mUserDao = mDatabase.getUserDao();
51 mPetDao = mDatabase.getPetDao();
52 mUserPetDao = mDatabase.getUserPetDao();
53 mSchoolDao = mDatabase.getSchoolDao();
54 mPetCoupleDao = mDatabase.getPetCoupleDao();
55 mToyDao = mDatabase.getToyDao();
56 mSpecificDogDao = mDatabase.getSpecificDogDao();
57 mWithClauseDao = mDatabase.getWithClauseDao()
[all...] |
| PrimaryKeyTest.java | 44 private PKeyTestDatabase mDatabase;
48 mDatabase = Room.inMemoryDatabaseBuilder(InstrumentationRegistry.getTargetContext(),
56 mDatabase.integerPKeyDao().insertMe(entity);
57 IntegerAutoIncPKeyEntity loaded = mDatabase.integerPKeyDao().getMe(1);
67 mDatabase.integerPKeyDao().insertMe(entity);
68 IntegerAutoIncPKeyEntity loaded = mDatabase.integerPKeyDao().getMe(0);
77 mDatabase.intPKeyDao().insertMe(entity);
78 IntAutoIncPKeyEntity loaded = mDatabase.intPKeyDao().getMe(1);
87 final long id = mDatabase.intPKeyDao().insertAndGetId(entity);
88 assertThat(mDatabase.intPKeyDao().getMe((int) id).data, is("foo"))
[all...] |
| /frameworks/support/room/runtime/src/main/java/android/arch/persistence/room/ |
| SharedSQLiteStatement.java | 39 private final RoomDatabase mDatabase;
49 mDatabase = database;
60 mDatabase.assertNotMainThread();
65 return mDatabase.compileStatement(query);
|
| /frameworks/base/core/java/android/database/sqlite/ |
| SQLiteOpenHelper.java | 55 private SQLiteDatabase mDatabase;
157 if (mDatabase != null && mDatabase.isOpen() && !mDatabase.isReadOnly()) {
159 mDatabase.enableWriteAheadLogging();
161 mDatabase.disableWriteAheadLogging();
189 if (mDatabase != null && mDatabase.isOpen()) {
209 if (mDatabase != null && mDatabase.isOpen())
[all...] |
| SQLiteDirectCursorDriver.java | 31 private final SQLiteDatabase mDatabase;
39 mDatabase = db;
46 final SQLiteQuery query = new SQLiteQuery(mDatabase, mSql, mCancellationSignal);
54 cursor = factory.newCursor(mDatabase, this, mEditTable, query);
|
| /frameworks/base/packages/MtpDocumentsProvider/src/com/android/mtp/ |
| RootScanner.java | 56 final MtpDatabase mDatabase;
67 mDatabase = database;
138 mDatabase.getMapper().startAddingDocuments(null /* parentDocumentId */);
140 if (mDatabase.getMapper().putDeviceDocument(device)) {
144 if (mDatabase.getMapper().stopAddingDocuments(
157 final String documentId = mDatabase.getDocumentIdForDevice(device.deviceId);
162 mDatabase.getMapper().startAddingDocuments(documentId);
163 if (mDatabase.getMapper().putStorageDocuments(
167 if (mDatabase.getMapper().stopAddingDocuments(documentId)) {
|
| /cts/tests/tests/database/src/android/database/cts/ |
| DatabaseUtilsTest.java | 43 private SQLiteDatabase mDatabase;
61 mDatabase = SQLiteDatabase.openOrCreateDatabase(mDatabaseFile.getPath(), null);
62 assertNotNull(mDatabase);
63 mDatabase.execSQL("CREATE TABLE " + TABLE_NAME + " (_id INTEGER PRIMARY KEY, " +
65 mDatabase.execSQL(
67 mDatabase.execSQL(
73 mDatabase.close();
118 Cursor cursor = mDatabase.query(TABLE_NAME, TEST_PROJECTION,
124 SQLiteStatement statement = mDatabase.compileStatement(sql);
131 cursor = mDatabase.query(TABLE_NAME, TEST_PROJECTION, null, null, null, null, null)
[all...] |
| /frameworks/support/room/integration-tests/testapp/src/main/java/android/arch/persistence/room/integration/testapp/ |
| CustomerViewModel.java | 38 private SampleDatabase mDatabase;
47 mDatabase = Room.databaseBuilder(this.getApplication(),
54 int customerCount = mDatabase.getCustomerDao().countCustomers();
60 mDatabase.getCustomerDao().insertAll(initialCustomers);
79 mDatabase.getCustomerDao().insert(createCustomer());
86 mLiveCustomerList = mDatabase.getCustomerDao()
101 return new LastNameAscCustomerDataSource(mDatabase);
|
