SQLiteQuery.java revision 7ce745248d4de0e6543a559c93423df899832100
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; 21b18f27dbf43ee9028a11cafbca23d3fa318e278bVasu Noriimport android.util.Log; 229066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 239066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project/** 249066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * A SQLite program that represents a query that reads the resulting rows into a CursorWindow. 259066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * This class is used by SQLiteCursor and isn't useful itself. 26f3ca9a5c7e87319c934b5815566054d2e5c2085fJeff Hamilton * 27f3ca9a5c7e87319c934b5815566054d2e5c2085fJeff Hamilton * SQLiteQuery is not internally synchronized so code using a SQLiteQuery from multiple 28f3ca9a5c7e87319c934b5815566054d2e5c2085fJeff Hamilton * threads should perform its own synchronization when using the SQLiteQuery. 299066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 309066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectpublic class SQLiteQuery extends SQLiteProgram { 310732f7912ccec9a1cc379b535ac0b56ae50972b3Vasu Nori private static final String TAG = "SQLiteQuery"; 329066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 337ce745248d4de0e6543a559c93423df899832100Jeff Brown private static native int nativeFillWindow(int databasePtr, int statementPtr, int windowPtr, 347ce745248d4de0e6543a559c93423df899832100Jeff Brown int startPos, int offsetParam); 357ce745248d4de0e6543a559c93423df899832100Jeff Brown private static native int nativeColumnCount(int statementPtr); 367ce745248d4de0e6543a559c93423df899832100Jeff Brown private static native String nativeColumnName(int statementPtr, int columnIndex); 377ce745248d4de0e6543a559c93423df899832100Jeff Brown 389066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** The index of the unbound OFFSET parameter */ 390732f7912ccec9a1cc379b535ac0b56ae50972b3Vasu Nori private int mOffsetIndex = 0; 409066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 419066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private boolean mClosed = false; 429066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 439066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 449066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Create a persistent query object. 450732f7912ccec9a1cc379b535ac0b56ae50972b3Vasu Nori * 469066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param db The database that this query object is associated with 479066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param query The SQL string for this query. 489066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param offsetIndex The 1-based index to the OFFSET parameter, 499066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 509066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /* package */ SQLiteQuery(SQLiteDatabase db, String query, int offsetIndex, String[] bindArgs) { 519066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project super(db, query); 529066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mOffsetIndex = offsetIndex; 530732f7912ccec9a1cc379b535ac0b56ae50972b3Vasu Nori bindAllArgsAsStrings(bindArgs); 549066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 559066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 569066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 5765a8883f0e605bb8a73a692987b47ce5da632e72Vasu Nori * Constructor used to create new instance to replace a given instance of this class. 5865a8883f0e605bb8a73a692987b47ce5da632e72Vasu Nori * This constructor is used when the current Query object is now associated with a different 5965a8883f0e605bb8a73a692987b47ce5da632e72Vasu Nori * {@link SQLiteDatabase} object. 6065a8883f0e605bb8a73a692987b47ce5da632e72Vasu Nori * 6165a8883f0e605bb8a73a692987b47ce5da632e72Vasu Nori * @param db The database that this query object is associated with 6265a8883f0e605bb8a73a692987b47ce5da632e72Vasu Nori * @param query the instance of {@link SQLiteQuery} to be replaced 6365a8883f0e605bb8a73a692987b47ce5da632e72Vasu Nori */ 6465a8883f0e605bb8a73a692987b47ce5da632e72Vasu Nori /* package */ SQLiteQuery(SQLiteDatabase db, SQLiteQuery query) { 650732f7912ccec9a1cc379b535ac0b56ae50972b3Vasu Nori super(db, query.mSql); 660732f7912ccec9a1cc379b535ac0b56ae50972b3Vasu Nori this.mBindArgs = query.mBindArgs; 67b18f27dbf43ee9028a11cafbca23d3fa318e278bVasu Nori this.mOffsetIndex = query.mOffsetIndex; 6865a8883f0e605bb8a73a692987b47ce5da632e72Vasu Nori } 6965a8883f0e605bb8a73a692987b47ce5da632e72Vasu Nori 7065a8883f0e605bb8a73a692987b47ce5da632e72Vasu Nori /** 719066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Reads rows into a buffer. This method acquires the database lock. 72722802e76b8805da523a612ad3482450fd327db0Brad Fitzpatrick * 739066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param window The window to fill into 749066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @return number of total rows in the query 759066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 767ce745248d4de0e6543a559c93423df899832100Jeff Brown /* package */ int fillWindow(CursorWindow window) { 7716057fad00d47e920fc20721b70c7cafb765f7f8Vasu Nori mDatabase.lock(mSql); 786a353876178ca2fe4bc61f128130067d2c2574d1Brad Fitzpatrick long timeStart = SystemClock.uptimeMillis(); 799066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project try { 809066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project acquireReference(); 819066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project try { 829066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project window.acquireReference(); 837ce745248d4de0e6543a559c93423df899832100Jeff Brown int numRows = nativeFillWindow(nHandle, nStatement, window.mWindowPtr, 847ce745248d4de0e6543a559c93423df899832100Jeff Brown window.getStartPosition(), mOffsetIndex); 8512311959c6ec6898e3b40d4e8958b29ec0b72da9Dan Egnor mDatabase.logTimeStat(mSql, timeStart); 869066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return numRows; 879066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } catch (IllegalStateException e){ 889066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // simply ignore it 899066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return 0; 909066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } catch (SQLiteDatabaseCorruptException e) { 919066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mDatabase.onCorruption(); 929066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project throw e; 93b18f27dbf43ee9028a11cafbca23d3fa318e278bVasu Nori } catch (SQLiteException e) { 94b18f27dbf43ee9028a11cafbca23d3fa318e278bVasu Nori Log.e(TAG, "exception: " + e.getMessage() + "; query: " + mSql); 95b18f27dbf43ee9028a11cafbca23d3fa318e278bVasu Nori throw e; 969066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } finally { 97722802e76b8805da523a612ad3482450fd327db0Brad Fitzpatrick window.releaseReference(); 989066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 999066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } finally { 1009066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project releaseReference(); 1019066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mDatabase.unlock(); 1029066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1039066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1049066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1059066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 1069066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Get the column count for the statement. Only valid on query based 1079066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * statements. The database must be locked 1089066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * when calling this method. 1099066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 1109066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @return The number of column in the statement's result set. 1119066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 1129066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /* package */ int columnCountLocked() { 1139066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project acquireReference(); 1149066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project try { 1157ce745248d4de0e6543a559c93423df899832100Jeff Brown return nativeColumnCount(nStatement); 1169066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } finally { 1179066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project releaseReference(); 1189066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1199066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1209066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1219066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 1229066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Retrieves the column name for the given column index. The database must be locked 1239066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * when calling this method. 1249066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 1259066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param columnIndex the index of the column to get the name for 1269066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @return The requested column's name 1279066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 1289066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /* package */ String columnNameLocked(int columnIndex) { 1299066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project acquireReference(); 1309066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project try { 1317ce745248d4de0e6543a559c93423df899832100Jeff Brown return nativeColumnName(nStatement, columnIndex); 1329066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } finally { 1339066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project releaseReference(); 1349066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1359066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1367ce745248d4de0e6543a559c93423df899832100Jeff Brown 1379066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project @Override 1389066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public String toString() { 1395a03f36ef845f73eb4473193dbb0f93dd12a51afVasu Nori return "SQLiteQuery: " + mSql; 1409066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1417ce745248d4de0e6543a559c93423df899832100Jeff Brown 1429066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project @Override 1439066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public void close() { 1449066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project super.close(); 1459066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mClosed = true; 1469066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1479066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1489066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 1499066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Called by SQLiteCursor when it is requeried. 1509066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 1519066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /* package */ void requery() { 1520732f7912ccec9a1cc379b535ac0b56ae50972b3Vasu Nori if (mClosed) { 1530732f7912ccec9a1cc379b535ac0b56ae50972b3Vasu Nori throw new IllegalStateException("requerying a closed cursor"); 1549066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1550732f7912ccec9a1cc379b535ac0b56ae50972b3Vasu Nori compileAndbindAllArgs(); 1569066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1579066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project} 158