| /frameworks/base/core/java/android/database/sqlite/ |
| SQLiteStatement.java | 53 if (!mDatabase.isOpen()) {
54 throw new IllegalStateException("database " + mDatabase.getPath() + " already closed");
57 mDatabase.lock();
62 mDatabase.logTimeStat(mSql, timeStart);
65 mDatabase.unlock();
80 if (!mDatabase.isOpen()) {
81 throw new IllegalStateException("database " + mDatabase.getPath() + " already closed");
84 mDatabase.lock();
89 mDatabase.logTimeStat(mSql, timeStart);
90 return (mDatabase.lastChangeCount() > 0) ? mDatabase.lastInsertRow() : -1
[all...] |
| SQLiteOpenHelper.java | 52 private SQLiteDatabase mDatabase = null;
96 if (mDatabase != null && mDatabase.isOpen() && !mDatabase.isReadOnly()) {
97 return mDatabase; // The database is already open for business
112 if (mDatabase != null) mDatabase.lock();
147 if (mDatabase != null) {
148 try { mDatabase.close(); } catch (Exception e) { }
149 mDatabase.unlock()
[all...] |
| SQLiteProgram.java | 35 protected SQLiteDatabase mDatabase;
62 mDatabase = db;
119 mDatabase.releaseReference();
120 mDatabase.removeSQLiteClosable(this);
126 mDatabase.releaseReference();
133 synchronized(mDatabase.mCompiledQueries) {
134 if (!mDatabase.mCompiledQueries.containsValue(mCompiledSql)) {
179 if (!mDatabase.isOpen()) {
180 throw new IllegalStateException("database " + mDatabase.getPath() + " already closed");
198 if (!mDatabase.isOpen())
[all...] |
| SQLiteCompiledSql.java | 35 /* package */ SQLiteDatabase mDatabase;
61 mDatabase = db;
82 if (!mDatabase.isOpen()) {
83 throw new IllegalStateException("database " + mDatabase.getPath() + " already closed");
88 mDatabase.lock();
94 mDatabase.unlock();
107 mDatabase.lock();
111 mDatabase.unlock();
|
| SQLiteDirectCursorDriver.java | 29 private SQLiteDatabase mDatabase;
35 mDatabase = db;
42 SQLiteQuery query = new SQLiteQuery(mDatabase, mSql, 0, selectionArgs);
53 mCursor = new SQLiteCursor(mDatabase, this, mEditTable, query);
55 mCursor = factory.newCursor(mDatabase, this, mEditTable, query);
|
| SQLiteCursor.java | 58 private SQLiteDatabase mDatabase;
215 mDatabase = db;
251 return mDatabase;
349 mDatabase.lock();
352 mDatabase.delete(mEditTable, mColumns[mRowIdColumnIndex] + "=?",
368 mDatabase.unlock();
424 mDatabase.beginTransaction();
468 mDatabase.execSQL(sql.toString(), bindings);
469 mDatabase.rowUpdated(mEditTable, rowId);
471 mDatabase.setTransactionSuccessful()
[all...] |
| SQLiteQuery.java | 64 mDatabase.lock();
65 mDatabase.logTimeStat(mSql, timeStart, SQLiteDatabase.GET_LOCK_LOG_PREFIX);
80 mDatabase.logTimeStat(mSql, timeStart);
86 mDatabase.onCorruption();
93 mDatabase.unlock();
|
| /frameworks/base/core/tests/coretests/src/android/database/ |
| DatabaseGeneralTest.java | 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())
[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 | 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")
[all...] |
| DatabasePerformanceTests.java | 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])
[all...] |
| NewDatabasePerformanceTests.java | 42 protected SQLiteDatabase mDatabase;
50 mDatabase =
53 assertTrue(mDatabase != null);
54 mDatabase.setVersion(CURRENT_DATABASE_VERSION);
58 mDatabase.close();
124 mDatabase
130 mDatabase.execSQL(statements[i]);
156 mDatabase
158 mDatabase.execSQL("CREATE INDEX i1c ON t1(c)");
163 mDatabase.execSQL(statements[i])
[all...] |
| DatabaseLockTest.java | 43 private SQLiteDatabase mDatabase;
56 mDatabase = SQLiteDatabase.openOrCreateDatabase(mDatabaseFile.getPath(), null);
57 assertNotNull(mDatabase);
62 mDatabase.close();
79 mDatabase.beginTransaction();
90 mDatabase.endTransaction();
106 mDatabase.beginTransaction();
113 mDatabase.endTransaction();
132 mDatabase.beginTransaction();
144 mDatabase.endTransaction()
[all...] |
| DatabaseCursorTest.java | 53 private SQLiteDatabase mDatabase;
65 mDatabase = SQLiteDatabase.openOrCreateDatabase(mDatabaseFile.getPath(), null);
66 assertNotNull(mDatabase);
67 mDatabase.setVersion(CURRENT_DATABASE_VERSION);
72 mDatabase.close();
87 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, data TEXT);");
89 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString1 + "');");
90 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString2 + "');");
91 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString3 + "');");
96 mDatabase.execSQL
[all...] |
| 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);
|
| /cts/tests/tests/database/src/android/database/sqlite/cts/ |
| SQLiteDatabaseTest.java | 48 private SQLiteDatabase mDatabase;
79 mDatabase = SQLiteDatabase.openOrCreateDatabase(mDatabaseFile, null);
80 assertNotNull(mDatabase);
89 mDatabase.close();
216 mDatabase.execSQL("CREATE TABLE test (num INTEGER);");
217 mDatabase.execSQL("INSERT INTO test (num) VALUES (0)");
225 assertFalse(mDatabase.inTransaction());
226 mDatabase.beginTransaction();
227 assertTrue(mDatabase.inTransaction());
229 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 | 40 private SQLiteDatabase mDatabase;
47 mDatabase = getContext().openOrCreateDatabase(DATABASE_NAME, Context.MODE_PRIVATE, null);
48 assertNotNull(mDatabase);
49 mDatabase.setVersion(CURRENT_DATABASE_VERSION);
54 mDatabase.close();
60 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, data TEXT);");
71 Cursor c = mDatabase.query("test", null, null, null, null, null, null);
75 SQLiteStatement statement = mDatabase.compileStatement(
79 c = mDatabase.query("test", null, null, null, null, null, null);
86 statement = mDatabase.compileStatement
[all...] |
| SQLiteProgramTest.java | 38 private SQLiteDatabase mDatabase;
48 mDatabase = getContext().openOrCreateDatabase(DATABASE_NAME, Context.MODE_PRIVATE, null);
49 assertNotNull(mDatabase);
54 mDatabase.close();
67 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, text1 TEXT, text2 TEXT, " +
70 SQLiteStatement statementOne = mDatabase.compileStatement(statement);
71 SQLiteStatement statementTwo = mDatabase.compileStatement(statement);
78 statementOne = mDatabase.compileStatement(statement);
81 statementTwo = mDatabase.compileStatement(statement);
86 SQLiteStatement statement1 = mDatabase.compileStatement("DELETE FROM test WHERE _id=1;")
[all...] |
| SQLiteQueryBuilderTest.java | 38 private SQLiteDatabase mDatabase;
48 mDatabase = getContext().openOrCreateDatabase(DATABASE_FILE, Context.MODE_PRIVATE, null);
49 assertNotNull(mDatabase);
54 mDatabase.close();
168 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, " +
170 mDatabase.execSQL("INSERT INTO test (name, age, address) VALUES ('Mike', '20', 'LA');");
171 mDatabase.execSQL("INSERT INTO test (name, age, address) VALUES ('jack', '40', 'LA');");
175 Cursor cursor = sqliteQueryBuilder.query(mDatabase, new String[] { "name", "age" },
188 cursor = sqliteQueryBuilder.query(mDatabase, new String[] { "name", "age" },
280 mDatabase.execSQL("CREATE TABLE employee (_id INTEGER PRIMARY KEY, "
[all...] |
| SQLiteCursorTest.java | 42 private SQLiteDatabase mDatabase;
55 mDatabase = getContext().openOrCreateDatabase(DATABASE_FILE, Context.MODE_PRIVATE, null);
62 mDatabase.close();
78 SQLiteDirectCursorDriver cursorDriver = new SQLiteDirectCursorDriver(mDatabase,
81 new SQLiteCursor(mDatabase, cursorDriver, TABLE_NAME, null);
203 mDatabase.execSQL(DELETE_1);
211 mDatabase.execSQL(DELETE_2);
250 assertSame(mDatabase, cursor.getDatabase());
262 SQLiteCursor cursor = (SQLiteCursor) mDatabase.query(TABLE_NAME, null, SELECTION,
284 mDatabase.execSQL(sql)
[all...] |
| /cts/tests/tests/database/src/android/database/cts/ |
| DatabaseCursorTest.java | 52 private SQLiteDatabase mDatabase;
66 mDatabase = SQLiteDatabase.openOrCreateDatabase(mDatabaseFile.getPath(), null);
67 assertNotNull(mDatabase);
68 mDatabase.setVersion(CURRENT_DATABASE_VERSION);
73 mDatabase.close();
102 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, data TEXT);");
104 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString1 + "');");
105 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString2 + "');");
106 mDatabase.execSQL("INSERT INTO test (data) VALUES ('" + sString3 + "');");
111 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, d INTEGER, s INTEGER);")
[all...] |
| DatabaseUtilsTest.java | 45 private SQLiteDatabase mDatabase;
62 mDatabase = SQLiteDatabase.openOrCreateDatabase(mDatabaseFile.getPath(), null);
63 assertNotNull(mDatabase);
64 mDatabase.execSQL("CREATE TABLE test (_id INTEGER PRIMARY KEY, " +
70 mDatabase.close();
135 Cursor cursor = mDatabase.query("test", TEST_PROJECTION, null, null, null, null, null);
140 SQLiteStatement statement = mDatabase.compileStatement(sql);
147 cursor = mDatabase.query("test", TEST_PROJECTION, null, null, null, null, null);
188 mDatabase.execSQL("INSERT INTO test (name, age, address) VALUES ('Mike', '20', 'LA');");
189 Cursor cursor = mDatabase.query("test", TEST_PROJECTION, null, null, null, null, null)
[all...] |
| /frameworks/base/core/tests/coretests/src/android/database/sqlite/ |
| SQLiteGeneralTest.java | 28 private SQLiteDatabase mDatabase;
41 mDatabase = SQLiteDatabase.openOrCreateDatabase(mDatabaseFile.getPath(), null);
42 assertNotNull(mDatabase);
47 mDatabase.close();
54 mDatabase.execSQL("CREATE TABLE test_pstmt (i INTEGER PRIMARY KEY, j text);");
70 SQLiteStatement s1 = mDatabase.compileStatement(stmt);
96 mDatabase.execSQL("CREATE TABLE test_pstmt (i INTEGER PRIMARY KEY, j text);");
100 final SQLiteStatement s1 = mDatabase.compileStatement(stmt);
|
| /frameworks/base/core/java/android/webkit/ |
| WebViewDatabase.java | 61 private static SQLiteDatabase mDatabase = null;
184 mDatabase = context
189 mDatabase = context.openOrCreateDatabase(DATABASE_FILE, 0,
194 // mDatabase should not be null,
196 if (mDatabase != null && mDatabase.getVersion() != DATABASE_VERSION) {
197 mDatabase.beginTransaction();
200 mDatabase.setTransactionSuccessful();
202 mDatabase.endTransaction();
206 if (mDatabase != null)
[all...] |
