SQLiteQuery.java revision 0732f7912ccec9a1cc379b535ac0b56ae50972b3
19066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project/* 29066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Copyright (C) 2006 The Android Open Source Project 39066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 49066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Licensed under the Apache License, Version 2.0 (the "License"); 59066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * you may not use this file except in compliance with the License. 69066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * You may obtain a copy of the License at 79066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 89066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * http://www.apache.org/licenses/LICENSE-2.0 99066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 109066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Unless required by applicable law or agreed to in writing, software 119066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * distributed under the License is distributed on an "AS IS" BASIS, 129066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. 139066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * See the License for the specific language governing permissions and 149066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * limitations under the License. 159066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 169066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 179066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectpackage android.database.sqlite; 189066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 199066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.database.CursorWindow; 206a353876178ca2fe4bc61f128130067d2c2574d1Brad Fitzpatrickimport android.os.SystemClock; 219066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 229066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project/** 239066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * A SQLite program that represents a query that reads the resulting rows into a CursorWindow. 249066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * This class is used by SQLiteCursor and isn't useful itself. 25f3ca9a5c7e87319c934b5815566054d2e5c2085fJeff Hamilton * 26f3ca9a5c7e87319c934b5815566054d2e5c2085fJeff Hamilton * SQLiteQuery is not internally synchronized so code using a SQLiteQuery from multiple 27f3ca9a5c7e87319c934b5815566054d2e5c2085fJeff Hamilton * threads should perform its own synchronization when using the SQLiteQuery. 289066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 299066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectpublic class SQLiteQuery extends SQLiteProgram { 300732f7912ccec9a1cc379b535ac0b56ae50972b3Vasu Nori private static final String TAG = "SQLiteQuery"; 319066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 329066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** The index of the unbound OFFSET parameter */ 330732f7912ccec9a1cc379b535ac0b56ae50972b3Vasu Nori private int mOffsetIndex = 0; 349066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 359066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private boolean mClosed = false; 369066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 379066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 389066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Create a persistent query object. 390732f7912ccec9a1cc379b535ac0b56ae50972b3Vasu Nori * 409066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param db The database that this query object is associated with 419066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param query The SQL string for this query. 429066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param offsetIndex The 1-based index to the OFFSET parameter, 439066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 449066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /* package */ SQLiteQuery(SQLiteDatabase db, String query, int offsetIndex, String[] bindArgs) { 459066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project super(db, query); 469066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mOffsetIndex = offsetIndex; 470732f7912ccec9a1cc379b535ac0b56ae50972b3Vasu Nori bindAllArgsAsStrings(bindArgs); 489066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 499066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 509066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 5165a8883f0e605bb8a73a692987b47ce5da632e72Vasu Nori * Constructor used to create new instance to replace a given instance of this class. 5265a8883f0e605bb8a73a692987b47ce5da632e72Vasu Nori * This constructor is used when the current Query object is now associated with a different 5365a8883f0e605bb8a73a692987b47ce5da632e72Vasu Nori * {@link SQLiteDatabase} object. 5465a8883f0e605bb8a73a692987b47ce5da632e72Vasu Nori * 5565a8883f0e605bb8a73a692987b47ce5da632e72Vasu Nori * @param db The database that this query object is associated with 5665a8883f0e605bb8a73a692987b47ce5da632e72Vasu Nori * @param query the instance of {@link SQLiteQuery} to be replaced 5765a8883f0e605bb8a73a692987b47ce5da632e72Vasu Nori */ 5865a8883f0e605bb8a73a692987b47ce5da632e72Vasu Nori /* package */ SQLiteQuery(SQLiteDatabase db, SQLiteQuery query) { 590732f7912ccec9a1cc379b535ac0b56ae50972b3Vasu Nori super(db, query.mSql); 600732f7912ccec9a1cc379b535ac0b56ae50972b3Vasu Nori this.mBindArgs = query.mBindArgs; 6165a8883f0e605bb8a73a692987b47ce5da632e72Vasu Nori } 6265a8883f0e605bb8a73a692987b47ce5da632e72Vasu Nori 6365a8883f0e605bb8a73a692987b47ce5da632e72Vasu Nori /** 649066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Reads rows into a buffer. This method acquires the database lock. 65722802e76b8805da523a612ad3482450fd327db0Brad Fitzpatrick * 669066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param window The window to fill into 679066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @return number of total rows in the query 689066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 69722802e76b8805da523a612ad3482450fd327db0Brad Fitzpatrick /* package */ int fillWindow(CursorWindow window, 709066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project int maxRead, int lastPos) { 716a353876178ca2fe4bc61f128130067d2c2574d1Brad Fitzpatrick long timeStart = SystemClock.uptimeMillis(); 729066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mDatabase.lock(); 73722802e76b8805da523a612ad3482450fd327db0Brad Fitzpatrick mDatabase.logTimeStat(mSql, timeStart, SQLiteDatabase.GET_LOCK_LOG_PREFIX); 749066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project try { 759066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project acquireReference(); 769066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project try { 779066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project window.acquireReference(); 78722802e76b8805da523a612ad3482450fd327db0Brad Fitzpatrick // if the start pos is not equal to 0, then most likely window is 799066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // too small for the data set, loading by another thread 809066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // is not safe in this situation. the native code will ignore maxRead 819066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project int numRows = native_fill_window(window, window.getStartPosition(), mOffsetIndex, 829066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project maxRead, lastPos); 8312311959c6ec6898e3b40d4e8958b29ec0b72da9Dan Egnor mDatabase.logTimeStat(mSql, timeStart); 849066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return numRows; 859066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } catch (IllegalStateException e){ 869066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // simply ignore it 879066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return 0; 889066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } catch (SQLiteDatabaseCorruptException e) { 899066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mDatabase.onCorruption(); 909066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project throw e; 919066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } finally { 92722802e76b8805da523a612ad3482450fd327db0Brad Fitzpatrick window.releaseReference(); 939066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 949066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } finally { 959066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project releaseReference(); 969066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mDatabase.unlock(); 979066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 989066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 999066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1009066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 1019066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Get the column count for the statement. Only valid on query based 1029066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * statements. The database must be locked 1039066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * when calling this method. 1049066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 1059066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @return The number of column in the statement's result set. 1069066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 1079066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /* package */ int columnCountLocked() { 1089066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project acquireReference(); 1099066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project try { 1109066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return native_column_count(); 1119066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } finally { 1129066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project releaseReference(); 1139066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1149066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1159066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1169066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 1179066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Retrieves the column name for the given column index. The database must be locked 1189066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * when calling this method. 1199066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 1209066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param columnIndex the index of the column to get the name for 1219066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @return The requested column's name 1229066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 1239066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /* package */ String columnNameLocked(int columnIndex) { 1249066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project acquireReference(); 1259066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project try { 1269066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return native_column_name(columnIndex); 1279066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } finally { 1289066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project releaseReference(); 1299066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1309066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1319066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1329066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project @Override 1339066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public String toString() { 1345a03f36ef845f73eb4473193dbb0f93dd12a51afVasu Nori return "SQLiteQuery: " + mSql; 1359066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1369066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1379066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project @Override 1389066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public void close() { 1399066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project super.close(); 1409066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mClosed = true; 1419066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1429066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1439066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 1449066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Called by SQLiteCursor when it is requeried. 1459066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 1469066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /* package */ void requery() { 1470732f7912ccec9a1cc379b535ac0b56ae50972b3Vasu Nori if (mClosed) { 1480732f7912ccec9a1cc379b535ac0b56ae50972b3Vasu Nori throw new IllegalStateException("requerying a closed cursor"); 1499066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1500732f7912ccec9a1cc379b535ac0b56ae50972b3Vasu Nori compileAndbindAllArgs(); 1519066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1529066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1530732f7912ccec9a1cc379b535ac0b56ae50972b3Vasu Nori private final native int native_fill_window(CursorWindow window, 1549066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project int startPos, int offsetParam, int maxRead, int lastPos); 1559066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1569066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private final native int native_column_count(); 1579066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1589066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private final native String native_column_name(int columnIndex); 1599066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project} 160