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; 189066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 199066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.content.ContentValues; 209066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.content.Context; 218943737692169f564cd34a9c8d471f3a5d438712Fred Quintanaimport android.content.OperationApplicationException; 229066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.database.sqlite.SQLiteAbortException; 239066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.database.sqlite.SQLiteConstraintException; 249066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.database.sqlite.SQLiteDatabase; 259066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.database.sqlite.SQLiteDatabaseCorruptException; 269066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.database.sqlite.SQLiteDiskIOException; 279066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.database.sqlite.SQLiteException; 289066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.database.sqlite.SQLiteFullException; 299066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.database.sqlite.SQLiteProgram; 309066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.database.sqlite.SQLiteStatement; 31a7771df3696954f0e279407e8894a916a7cb26ccJeff Brownimport android.os.OperationCanceledException; 329066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.os.Parcel; 33a006b47298539d89dc7a06b54c070cb3e986352aBjorn Bringertimport android.os.ParcelFileDescriptor; 349066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.text.TextUtils; 359066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.util.Log; 369066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 379066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport java.io.FileNotFoundException; 389066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport java.io.PrintStream; 399066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport java.text.Collator; 409066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport java.util.HashMap; 416746499f12448433bfe2bc80f7a8715375e64180Elliott Hughesimport java.util.Locale; 429066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport java.util.Map; 439066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 449066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project/** 459066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Static utility methods for dealing with databases and {@link Cursor}s. 469066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 479066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectpublic class DatabaseUtils { 489066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private static final String TAG = "DatabaseUtils"; 499066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 509066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private static final boolean DEBUG = false; 519066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 52ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori /** One of the values returned by {@link #getSqlStatementType(String)}. */ 53ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori public static final int STATEMENT_SELECT = 1; 54ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori /** One of the values returned by {@link #getSqlStatementType(String)}. */ 55ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori public static final int STATEMENT_UPDATE = 2; 56ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori /** One of the values returned by {@link #getSqlStatementType(String)}. */ 57ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori public static final int STATEMENT_ATTACH = 3; 58ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori /** One of the values returned by {@link #getSqlStatementType(String)}. */ 59ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori public static final int STATEMENT_BEGIN = 4; 60ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori /** One of the values returned by {@link #getSqlStatementType(String)}. */ 61ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori public static final int STATEMENT_COMMIT = 5; 62ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori /** One of the values returned by {@link #getSqlStatementType(String)}. */ 63ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori public static final int STATEMENT_ABORT = 6; 64ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori /** One of the values returned by {@link #getSqlStatementType(String)}. */ 654e874edf69ce9900eb847629dc4d3616972a3468Vasu Nori public static final int STATEMENT_PRAGMA = 7; 664e874edf69ce9900eb847629dc4d3616972a3468Vasu Nori /** One of the values returned by {@link #getSqlStatementType(String)}. */ 674e874edf69ce9900eb847629dc4d3616972a3468Vasu Nori public static final int STATEMENT_DDL = 8; 684e874edf69ce9900eb847629dc4d3616972a3468Vasu Nori /** One of the values returned by {@link #getSqlStatementType(String)}. */ 694e874edf69ce9900eb847629dc4d3616972a3468Vasu Nori public static final int STATEMENT_UNPREPARED = 9; 704e874edf69ce9900eb847629dc4d3616972a3468Vasu Nori /** One of the values returned by {@link #getSqlStatementType(String)}. */ 714e874edf69ce9900eb847629dc4d3616972a3468Vasu Nori public static final int STATEMENT_OTHER = 99; 72ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori 739066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 749066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Special function for writing an exception result at the header of 759066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * a parcel, to be used when returning an exception from a transaction. 769066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * exception will be re-thrown by the function in another process 779066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param reply Parcel to write to 789066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param e The Exception to be written. 799066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @see Parcel#writeNoException 809066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @see Parcel#writeException 819066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 829066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static final void writeExceptionToParcel(Parcel reply, Exception e) { 839066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project int code = 0; 849066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project boolean logException = true; 859066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (e instanceof FileNotFoundException) { 869066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project code = 1; 879066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project logException = false; 889066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else if (e instanceof IllegalArgumentException) { 899066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project code = 2; 909066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else if (e instanceof UnsupportedOperationException) { 919066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project code = 3; 929066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else if (e instanceof SQLiteAbortException) { 939066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project code = 4; 949066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else if (e instanceof SQLiteConstraintException) { 959066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project code = 5; 969066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else if (e instanceof SQLiteDatabaseCorruptException) { 979066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project code = 6; 989066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else if (e instanceof SQLiteFullException) { 999066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project code = 7; 1009066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else if (e instanceof SQLiteDiskIOException) { 1019066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project code = 8; 1029066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else if (e instanceof SQLiteException) { 1039066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project code = 9; 1048943737692169f564cd34a9c8d471f3a5d438712Fred Quintana } else if (e instanceof OperationApplicationException) { 1058943737692169f564cd34a9c8d471f3a5d438712Fred Quintana code = 10; 106b19a71a20adb48c084e87d06a1e6b0dcb49170f5Jeff Brown } else if (e instanceof OperationCanceledException) { 107b19a71a20adb48c084e87d06a1e6b0dcb49170f5Jeff Brown code = 11; 108b19a71a20adb48c084e87d06a1e6b0dcb49170f5Jeff Brown logException = false; 1099066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else { 1109066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project reply.writeException(e); 1119066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project Log.e(TAG, "Writing exception to parcel", e); 1129066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return; 1139066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1149066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project reply.writeInt(code); 1159066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project reply.writeString(e.getMessage()); 1169066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1179066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (logException) { 1189066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project Log.e(TAG, "Writing exception to parcel", e); 1199066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1209066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1219066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1229066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 1239066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Special function for reading an exception result from the header of 1249066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * a parcel, to be used after receiving the result of a transaction. This 1259066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * will throw the exception for you if it had been written to the Parcel, 1269066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * otherwise return and let you read the normal result data from the Parcel. 1279066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param reply Parcel to read from 1289066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @see Parcel#writeNoException 1299066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @see Parcel#readException 1309066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 1319066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static final void readExceptionFromParcel(Parcel reply) { 1325b747191ff8ad43a54d41faf50436271d1d7fcc8Brad Fitzpatrick int code = reply.readExceptionCode(); 1339066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (code == 0) return; 1349066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project String msg = reply.readString(); 1359066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project DatabaseUtils.readExceptionFromParcel(reply, msg, code); 1369066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1379066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1389066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static void readExceptionWithFileNotFoundExceptionFromParcel( 1399066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project Parcel reply) throws FileNotFoundException { 1405b747191ff8ad43a54d41faf50436271d1d7fcc8Brad Fitzpatrick int code = reply.readExceptionCode(); 1419066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (code == 0) return; 1429066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project String msg = reply.readString(); 1439066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (code == 1) { 1449066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project throw new FileNotFoundException(msg); 1459066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else { 1469066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project DatabaseUtils.readExceptionFromParcel(reply, msg, code); 1479066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1489066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1499066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1508943737692169f564cd34a9c8d471f3a5d438712Fred Quintana public static void readExceptionWithOperationApplicationExceptionFromParcel( 1518943737692169f564cd34a9c8d471f3a5d438712Fred Quintana Parcel reply) throws OperationApplicationException { 1525b747191ff8ad43a54d41faf50436271d1d7fcc8Brad Fitzpatrick int code = reply.readExceptionCode(); 1538943737692169f564cd34a9c8d471f3a5d438712Fred Quintana if (code == 0) return; 1548943737692169f564cd34a9c8d471f3a5d438712Fred Quintana String msg = reply.readString(); 1558943737692169f564cd34a9c8d471f3a5d438712Fred Quintana if (code == 10) { 1568943737692169f564cd34a9c8d471f3a5d438712Fred Quintana throw new OperationApplicationException(msg); 1578943737692169f564cd34a9c8d471f3a5d438712Fred Quintana } else { 1588943737692169f564cd34a9c8d471f3a5d438712Fred Quintana DatabaseUtils.readExceptionFromParcel(reply, msg, code); 1598943737692169f564cd34a9c8d471f3a5d438712Fred Quintana } 1608943737692169f564cd34a9c8d471f3a5d438712Fred Quintana } 1618943737692169f564cd34a9c8d471f3a5d438712Fred Quintana 1629066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private static final void readExceptionFromParcel(Parcel reply, String msg, int code) { 1639066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project switch (code) { 1649066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project case 2: 1659066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project throw new IllegalArgumentException(msg); 1669066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project case 3: 1679066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project throw new UnsupportedOperationException(msg); 1689066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project case 4: 1699066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project throw new SQLiteAbortException(msg); 1709066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project case 5: 1719066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project throw new SQLiteConstraintException(msg); 1729066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project case 6: 1739066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project throw new SQLiteDatabaseCorruptException(msg); 1749066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project case 7: 1759066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project throw new SQLiteFullException(msg); 1769066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project case 8: 1779066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project throw new SQLiteDiskIOException(msg); 1789066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project case 9: 1799066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project throw new SQLiteException(msg); 180b19a71a20adb48c084e87d06a1e6b0dcb49170f5Jeff Brown case 11: 181b19a71a20adb48c084e87d06a1e6b0dcb49170f5Jeff Brown throw new OperationCanceledException(msg); 1829066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project default: 1839066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project reply.readException(code, msg); 1849066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1859066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1869066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1879066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 1889066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Binds the given Object to the given SQLiteProgram using the proper 1899066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * typing. For example, bind numbers as longs/doubles, and everything else 1909066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * as a string by call toString() on it. 1919066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 1929066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param prog the program to bind the object to 1939066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param index the 1-based index to bind at 1949066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param value the value to bind 1959066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 1969066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static void bindObjectToProgram(SQLiteProgram prog, int index, 1979066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project Object value) { 1989066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (value == null) { 1999066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project prog.bindNull(index); 2009066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else if (value instanceof Double || value instanceof Float) { 2019066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project prog.bindDouble(index, ((Number)value).doubleValue()); 2029066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else if (value instanceof Number) { 2039066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project prog.bindLong(index, ((Number)value).longValue()); 2049066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else if (value instanceof Boolean) { 2059066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project Boolean bool = (Boolean)value; 2069066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (bool) { 2079066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project prog.bindLong(index, 1); 2089066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else { 2099066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project prog.bindLong(index, 0); 2109066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 2119066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else if (value instanceof byte[]){ 2129066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project prog.bindBlob(index, (byte[]) value); 2139066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else { 2149066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project prog.bindString(index, value.toString()); 2159066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 2169066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 2179066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 2189066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 2198b0dd7da360d70920a37802eb455ba41500d3b45Vasu Nori * Returns data type of the given object's value. 2208b0dd7da360d70920a37802eb455ba41500d3b45Vasu Nori *<p> 2218b0dd7da360d70920a37802eb455ba41500d3b45Vasu Nori * Returned values are 2228b0dd7da360d70920a37802eb455ba41500d3b45Vasu Nori * <ul> 2238b0dd7da360d70920a37802eb455ba41500d3b45Vasu Nori * <li>{@link Cursor#FIELD_TYPE_NULL}</li> 2248b0dd7da360d70920a37802eb455ba41500d3b45Vasu Nori * <li>{@link Cursor#FIELD_TYPE_INTEGER}</li> 2258b0dd7da360d70920a37802eb455ba41500d3b45Vasu Nori * <li>{@link Cursor#FIELD_TYPE_FLOAT}</li> 2268b0dd7da360d70920a37802eb455ba41500d3b45Vasu Nori * <li>{@link Cursor#FIELD_TYPE_STRING}</li> 2278b0dd7da360d70920a37802eb455ba41500d3b45Vasu Nori * <li>{@link Cursor#FIELD_TYPE_BLOB}</li> 2288b0dd7da360d70920a37802eb455ba41500d3b45Vasu Nori *</ul> 2298b0dd7da360d70920a37802eb455ba41500d3b45Vasu Nori *</p> 2308b0dd7da360d70920a37802eb455ba41500d3b45Vasu Nori * 2318b0dd7da360d70920a37802eb455ba41500d3b45Vasu Nori * @param obj the object whose value type is to be returned 2328b0dd7da360d70920a37802eb455ba41500d3b45Vasu Nori * @return object value type 2338b0dd7da360d70920a37802eb455ba41500d3b45Vasu Nori * @hide 2348b0dd7da360d70920a37802eb455ba41500d3b45Vasu Nori */ 2358b0dd7da360d70920a37802eb455ba41500d3b45Vasu Nori public static int getTypeOfObject(Object obj) { 2368b0dd7da360d70920a37802eb455ba41500d3b45Vasu Nori if (obj == null) { 2378b0dd7da360d70920a37802eb455ba41500d3b45Vasu Nori return Cursor.FIELD_TYPE_NULL; 2388b0dd7da360d70920a37802eb455ba41500d3b45Vasu Nori } else if (obj instanceof byte[]) { 2398b0dd7da360d70920a37802eb455ba41500d3b45Vasu Nori return Cursor.FIELD_TYPE_BLOB; 2408b0dd7da360d70920a37802eb455ba41500d3b45Vasu Nori } else if (obj instanceof Float || obj instanceof Double) { 2418b0dd7da360d70920a37802eb455ba41500d3b45Vasu Nori return Cursor.FIELD_TYPE_FLOAT; 24280e7b80fa607e13d31d7dab68ddfd4d9f0372e38Jeff Brown } else if (obj instanceof Long || obj instanceof Integer 24380e7b80fa607e13d31d7dab68ddfd4d9f0372e38Jeff Brown || obj instanceof Short || obj instanceof Byte) { 2448b0dd7da360d70920a37802eb455ba41500d3b45Vasu Nori return Cursor.FIELD_TYPE_INTEGER; 2458b0dd7da360d70920a37802eb455ba41500d3b45Vasu Nori } else { 2468b0dd7da360d70920a37802eb455ba41500d3b45Vasu Nori return Cursor.FIELD_TYPE_STRING; 2478b0dd7da360d70920a37802eb455ba41500d3b45Vasu Nori } 2488b0dd7da360d70920a37802eb455ba41500d3b45Vasu Nori } 2498b0dd7da360d70920a37802eb455ba41500d3b45Vasu Nori 2508b0dd7da360d70920a37802eb455ba41500d3b45Vasu Nori /** 25180e7b80fa607e13d31d7dab68ddfd4d9f0372e38Jeff Brown * Fills the specified cursor window by iterating over the contents of the cursor. 25280e7b80fa607e13d31d7dab68ddfd4d9f0372e38Jeff Brown * The window is filled until the cursor is exhausted or the window runs out 25380e7b80fa607e13d31d7dab68ddfd4d9f0372e38Jeff Brown * of space. 25480e7b80fa607e13d31d7dab68ddfd4d9f0372e38Jeff Brown * 25580e7b80fa607e13d31d7dab68ddfd4d9f0372e38Jeff Brown * The original position of the cursor is left unchanged by this operation. 25680e7b80fa607e13d31d7dab68ddfd4d9f0372e38Jeff Brown * 25780e7b80fa607e13d31d7dab68ddfd4d9f0372e38Jeff Brown * @param cursor The cursor that contains the data to put in the window. 25880e7b80fa607e13d31d7dab68ddfd4d9f0372e38Jeff Brown * @param position The start position for filling the window. 25980e7b80fa607e13d31d7dab68ddfd4d9f0372e38Jeff Brown * @param window The window to fill. 26080e7b80fa607e13d31d7dab68ddfd4d9f0372e38Jeff Brown * @hide 26180e7b80fa607e13d31d7dab68ddfd4d9f0372e38Jeff Brown */ 26280e7b80fa607e13d31d7dab68ddfd4d9f0372e38Jeff Brown public static void cursorFillWindow(final Cursor cursor, 26380e7b80fa607e13d31d7dab68ddfd4d9f0372e38Jeff Brown int position, final CursorWindow window) { 26480e7b80fa607e13d31d7dab68ddfd4d9f0372e38Jeff Brown if (position < 0 || position >= cursor.getCount()) { 26580e7b80fa607e13d31d7dab68ddfd4d9f0372e38Jeff Brown return; 26680e7b80fa607e13d31d7dab68ddfd4d9f0372e38Jeff Brown } 26703bd302aebbb77f4f95789a269c8a5463ac5a840Jeff Brown final int oldPos = cursor.getPosition(); 26803bd302aebbb77f4f95789a269c8a5463ac5a840Jeff Brown final int numColumns = cursor.getColumnCount(); 26903bd302aebbb77f4f95789a269c8a5463ac5a840Jeff Brown window.clear(); 27003bd302aebbb77f4f95789a269c8a5463ac5a840Jeff Brown window.setStartPosition(position); 27103bd302aebbb77f4f95789a269c8a5463ac5a840Jeff Brown window.setNumColumns(numColumns); 27203bd302aebbb77f4f95789a269c8a5463ac5a840Jeff Brown if (cursor.moveToPosition(position)) { 273bb8c841e909a2fb967db2ad3b9f8b058f9b849e8Jeff Brown rowloop: do { 27403bd302aebbb77f4f95789a269c8a5463ac5a840Jeff Brown if (!window.allocRow()) { 27503bd302aebbb77f4f95789a269c8a5463ac5a840Jeff Brown break; 27603bd302aebbb77f4f95789a269c8a5463ac5a840Jeff Brown } 27703bd302aebbb77f4f95789a269c8a5463ac5a840Jeff Brown for (int i = 0; i < numColumns; i++) { 27803bd302aebbb77f4f95789a269c8a5463ac5a840Jeff Brown final int type = cursor.getType(i); 27903bd302aebbb77f4f95789a269c8a5463ac5a840Jeff Brown final boolean success; 28003bd302aebbb77f4f95789a269c8a5463ac5a840Jeff Brown switch (type) { 28103bd302aebbb77f4f95789a269c8a5463ac5a840Jeff Brown case Cursor.FIELD_TYPE_NULL: 28203bd302aebbb77f4f95789a269c8a5463ac5a840Jeff Brown success = window.putNull(position, i); 28303bd302aebbb77f4f95789a269c8a5463ac5a840Jeff Brown break; 28480e7b80fa607e13d31d7dab68ddfd4d9f0372e38Jeff Brown 28503bd302aebbb77f4f95789a269c8a5463ac5a840Jeff Brown case Cursor.FIELD_TYPE_INTEGER: 28603bd302aebbb77f4f95789a269c8a5463ac5a840Jeff Brown success = window.putLong(cursor.getLong(i), position, i); 28703bd302aebbb77f4f95789a269c8a5463ac5a840Jeff Brown break; 28880e7b80fa607e13d31d7dab68ddfd4d9f0372e38Jeff Brown 28903bd302aebbb77f4f95789a269c8a5463ac5a840Jeff Brown case Cursor.FIELD_TYPE_FLOAT: 29003bd302aebbb77f4f95789a269c8a5463ac5a840Jeff Brown success = window.putDouble(cursor.getDouble(i), position, i); 29103bd302aebbb77f4f95789a269c8a5463ac5a840Jeff Brown break; 29280e7b80fa607e13d31d7dab68ddfd4d9f0372e38Jeff Brown 29303bd302aebbb77f4f95789a269c8a5463ac5a840Jeff Brown case Cursor.FIELD_TYPE_BLOB: { 29403bd302aebbb77f4f95789a269c8a5463ac5a840Jeff Brown final byte[] value = cursor.getBlob(i); 29503bd302aebbb77f4f95789a269c8a5463ac5a840Jeff Brown success = value != null ? window.putBlob(value, position, i) 29603bd302aebbb77f4f95789a269c8a5463ac5a840Jeff Brown : window.putNull(position, i); 29703bd302aebbb77f4f95789a269c8a5463ac5a840Jeff Brown break; 29880e7b80fa607e13d31d7dab68ddfd4d9f0372e38Jeff Brown } 29903bd302aebbb77f4f95789a269c8a5463ac5a840Jeff Brown 30003bd302aebbb77f4f95789a269c8a5463ac5a840Jeff Brown default: // assume value is convertible to String 30103bd302aebbb77f4f95789a269c8a5463ac5a840Jeff Brown case Cursor.FIELD_TYPE_STRING: { 30203bd302aebbb77f4f95789a269c8a5463ac5a840Jeff Brown final String value = cursor.getString(i); 30303bd302aebbb77f4f95789a269c8a5463ac5a840Jeff Brown success = value != null ? window.putString(value, position, i) 30403bd302aebbb77f4f95789a269c8a5463ac5a840Jeff Brown : window.putNull(position, i); 30580e7b80fa607e13d31d7dab68ddfd4d9f0372e38Jeff Brown break; 30680e7b80fa607e13d31d7dab68ddfd4d9f0372e38Jeff Brown } 30780e7b80fa607e13d31d7dab68ddfd4d9f0372e38Jeff Brown } 30803bd302aebbb77f4f95789a269c8a5463ac5a840Jeff Brown if (!success) { 30903bd302aebbb77f4f95789a269c8a5463ac5a840Jeff Brown window.freeLastRow(); 310bb8c841e909a2fb967db2ad3b9f8b058f9b849e8Jeff Brown break rowloop; 31103bd302aebbb77f4f95789a269c8a5463ac5a840Jeff Brown } 31203bd302aebbb77f4f95789a269c8a5463ac5a840Jeff Brown } 31303bd302aebbb77f4f95789a269c8a5463ac5a840Jeff Brown position += 1; 31403bd302aebbb77f4f95789a269c8a5463ac5a840Jeff Brown } while (cursor.moveToNext()); 31580e7b80fa607e13d31d7dab68ddfd4d9f0372e38Jeff Brown } 31603bd302aebbb77f4f95789a269c8a5463ac5a840Jeff Brown cursor.moveToPosition(oldPos); 31780e7b80fa607e13d31d7dab68ddfd4d9f0372e38Jeff Brown } 31880e7b80fa607e13d31d7dab68ddfd4d9f0372e38Jeff Brown 31980e7b80fa607e13d31d7dab68ddfd4d9f0372e38Jeff Brown /** 3209066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Appends an SQL string to the given StringBuilder, including the opening 3219066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * and closing single quotes. Any single quotes internal to sqlString will 3229066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * be escaped. 3239066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 3249066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * This method is deprecated because we want to encourage everyone 3259066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * to use the "?" binding form. However, when implementing a 3269066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * ContentProvider, one may want to add WHERE clauses that were 3279066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * not provided by the caller. Since "?" is a positional form, 3289066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * using it in this case could break the caller because the 3299066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * indexes would be shifted to accomodate the ContentProvider's 3309066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * internal bindings. In that case, it may be necessary to 3319066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * construct a WHERE clause manually. This method is useful for 3329066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * those cases. 3339066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 3349066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param sb the StringBuilder that the SQL string will be appended to 3359066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param sqlString the raw string to be appended, which may contain single 3369066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * quotes 3379066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 3389066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static void appendEscapedSQLString(StringBuilder sb, String sqlString) { 3399066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sb.append('\''); 3409066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (sqlString.indexOf('\'') != -1) { 3419066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project int length = sqlString.length(); 3429066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project for (int i = 0; i < length; i++) { 3439066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project char c = sqlString.charAt(i); 3449066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (c == '\'') { 3459066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sb.append('\''); 3469066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 3479066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sb.append(c); 3489066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 3499066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else 3509066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sb.append(sqlString); 3519066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sb.append('\''); 3529066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 35322f711423e66750cd44a64e75372ea66304fb9a1Fred Quintana 3549066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 3559066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * SQL-escape a string. 3569066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 3579066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static String sqlEscapeString(String value) { 3589066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project StringBuilder escaper = new StringBuilder(); 3599066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 3609066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project DatabaseUtils.appendEscapedSQLString(escaper, value); 3619066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 3629066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return escaper.toString(); 3639066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 3649066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 3659066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 3669066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Appends an Object to an SQL string with the proper escaping, etc. 3679066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 3689066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static final void appendValueToSql(StringBuilder sql, Object value) { 3699066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (value == null) { 3709066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sql.append("NULL"); 3719066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else if (value instanceof Boolean) { 3729066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project Boolean bool = (Boolean)value; 3739066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (bool) { 3749066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sql.append('1'); 3759066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else { 3769066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sql.append('0'); 3779066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 3789066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else { 3799066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project appendEscapedSQLString(sql, value.toString()); 3809066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 3819066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 38222f711423e66750cd44a64e75372ea66304fb9a1Fred Quintana 3839066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 3849066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Concatenates two SQL WHERE clauses, handling empty or null values. 3859066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 3869066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static String concatenateWhere(String a, String b) { 3879066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (TextUtils.isEmpty(a)) { 3889066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return b; 3899066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 3909066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (TextUtils.isEmpty(b)) { 3919066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return a; 3929066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 39322f711423e66750cd44a64e75372ea66304fb9a1Fred Quintana 3949066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return "(" + a + ") AND (" + b + ")"; 3959066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 39622f711423e66750cd44a64e75372ea66304fb9a1Fred Quintana 3979066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 39822f711423e66750cd44a64e75372ea66304fb9a1Fred Quintana * return the collation key 3999066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param name 4009066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @return the collation key 4019066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 4029066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static String getCollationKey(String name) { 4039066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project byte [] arr = getCollationKeyInBytes(name); 4049066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project try { 4059066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return new String(arr, 0, getKeyLen(arr), "ISO8859_1"); 4069066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } catch (Exception ex) { 4079066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return ""; 4089066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 4099066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 41022f711423e66750cd44a64e75372ea66304fb9a1Fred Quintana 4119066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 4129066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * return the collation key in hex format 4139066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param name 4149066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @return the collation key in hex format 4159066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 4169066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static String getHexCollationKey(String name) { 4173bdd327f8532a79b83f575cc62e8eb09a1f93f3dNarayan Kamath byte[] arr = getCollationKeyInBytes(name); 4183bdd327f8532a79b83f575cc62e8eb09a1f93f3dNarayan Kamath char[] keys = encodeHex(arr); 4199066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return new String(keys, 0, getKeyLen(arr) * 2); 4209066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 42122f711423e66750cd44a64e75372ea66304fb9a1Fred Quintana 4223bdd327f8532a79b83f575cc62e8eb09a1f93f3dNarayan Kamath 4233bdd327f8532a79b83f575cc62e8eb09a1f93f3dNarayan Kamath /** 4243bdd327f8532a79b83f575cc62e8eb09a1f93f3dNarayan Kamath * Used building output as Hex 4253bdd327f8532a79b83f575cc62e8eb09a1f93f3dNarayan Kamath */ 4263bdd327f8532a79b83f575cc62e8eb09a1f93f3dNarayan Kamath private static final char[] DIGITS = { 4273bdd327f8532a79b83f575cc62e8eb09a1f93f3dNarayan Kamath '0', '1', '2', '3', '4', '5', '6', '7', 4283bdd327f8532a79b83f575cc62e8eb09a1f93f3dNarayan Kamath '8', '9', 'a', 'b', 'c', 'd', 'e', 'f' 4293bdd327f8532a79b83f575cc62e8eb09a1f93f3dNarayan Kamath }; 4303bdd327f8532a79b83f575cc62e8eb09a1f93f3dNarayan Kamath 4313bdd327f8532a79b83f575cc62e8eb09a1f93f3dNarayan Kamath private static char[] encodeHex(byte[] input) { 4323bdd327f8532a79b83f575cc62e8eb09a1f93f3dNarayan Kamath int l = input.length; 4333bdd327f8532a79b83f575cc62e8eb09a1f93f3dNarayan Kamath char[] out = new char[l << 1]; 4343bdd327f8532a79b83f575cc62e8eb09a1f93f3dNarayan Kamath 4353bdd327f8532a79b83f575cc62e8eb09a1f93f3dNarayan Kamath // two characters form the hex value. 4363bdd327f8532a79b83f575cc62e8eb09a1f93f3dNarayan Kamath for (int i = 0, j = 0; i < l; i++) { 4373bdd327f8532a79b83f575cc62e8eb09a1f93f3dNarayan Kamath out[j++] = DIGITS[(0xF0 & input[i]) >>> 4 ]; 4383bdd327f8532a79b83f575cc62e8eb09a1f93f3dNarayan Kamath out[j++] = DIGITS[ 0x0F & input[i] ]; 4393bdd327f8532a79b83f575cc62e8eb09a1f93f3dNarayan Kamath } 4403bdd327f8532a79b83f575cc62e8eb09a1f93f3dNarayan Kamath 4413bdd327f8532a79b83f575cc62e8eb09a1f93f3dNarayan Kamath return out; 4423bdd327f8532a79b83f575cc62e8eb09a1f93f3dNarayan Kamath } 4433bdd327f8532a79b83f575cc62e8eb09a1f93f3dNarayan Kamath 4449066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private static int getKeyLen(byte[] arr) { 4459066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (arr[arr.length - 1] != 0) { 4469066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return arr.length; 4479066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else { 4489066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // remove zero "termination" 4499066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return arr.length-1; 4509066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 4519066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 45222f711423e66750cd44a64e75372ea66304fb9a1Fred Quintana 4539066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private static byte[] getCollationKeyInBytes(String name) { 4549066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (mColl == null) { 4559066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mColl = Collator.getInstance(); 4569066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mColl.setStrength(Collator.PRIMARY); 4579066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 45822f711423e66750cd44a64e75372ea66304fb9a1Fred Quintana return mColl.getCollationKey(name).toByteArray(); 4599066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 46022f711423e66750cd44a64e75372ea66304fb9a1Fred Quintana 46122f711423e66750cd44a64e75372ea66304fb9a1Fred Quintana private static Collator mColl = null; 4629066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 4639066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Prints the contents of a Cursor to System.out. The position is restored 4649066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * after printing. 4659066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 4669066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param cursor the cursor to print 4679066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 4689066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static void dumpCursor(Cursor cursor) { 4699066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project dumpCursor(cursor, System.out); 4709066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 4719066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 4729066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 4739066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Prints the contents of a Cursor to a PrintSteam. The position is restored 4749066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * after printing. 4759066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 4769066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param cursor the cursor to print 4779066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param stream the stream to print to 4789066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 4799066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static void dumpCursor(Cursor cursor, PrintStream stream) { 4809066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project stream.println(">>>>> Dumping cursor " + cursor); 4819066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (cursor != null) { 4829066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project int startPos = cursor.getPosition(); 4839066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 4849066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project cursor.moveToPosition(-1); 4859066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project while (cursor.moveToNext()) { 4869066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project dumpCurrentRow(cursor, stream); 4879066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 4889066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project cursor.moveToPosition(startPos); 4899066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 4909066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project stream.println("<<<<<"); 4919066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 4929066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 4939066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 4949066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Prints the contents of a Cursor to a StringBuilder. The position 4959066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * is restored after printing. 4969066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 4979066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param cursor the cursor to print 4989066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param sb the StringBuilder to print to 4999066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 5009066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static void dumpCursor(Cursor cursor, StringBuilder sb) { 5019066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sb.append(">>>>> Dumping cursor " + cursor + "\n"); 5029066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (cursor != null) { 5039066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project int startPos = cursor.getPosition(); 5049066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 5059066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project cursor.moveToPosition(-1); 5069066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project while (cursor.moveToNext()) { 5079066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project dumpCurrentRow(cursor, sb); 5089066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 5099066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project cursor.moveToPosition(startPos); 5109066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 5119066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sb.append("<<<<<\n"); 5129066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 5139066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 5149066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 5159066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Prints the contents of a Cursor to a String. The position is restored 5169066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * after printing. 5179066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 5189066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param cursor the cursor to print 5199066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @return a String that contains the dumped cursor 5209066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 5219066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static String dumpCursorToString(Cursor cursor) { 5229066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project StringBuilder sb = new StringBuilder(); 5239066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project dumpCursor(cursor, sb); 5249066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return sb.toString(); 5259066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 5269066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 5279066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 5289066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Prints the contents of a Cursor's current row to System.out. 5299066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 5309066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param cursor the cursor to print from 5319066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 5329066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static void dumpCurrentRow(Cursor cursor) { 5339066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project dumpCurrentRow(cursor, System.out); 5349066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 5359066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 5369066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 5379066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Prints the contents of a Cursor's current row to a PrintSteam. 5389066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 5399066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param cursor the cursor to print 5409066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param stream the stream to print to 5419066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 5429066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static void dumpCurrentRow(Cursor cursor, PrintStream stream) { 5439066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project String[] cols = cursor.getColumnNames(); 5449066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project stream.println("" + cursor.getPosition() + " {"); 5459066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project int length = cols.length; 5469066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project for (int i = 0; i< length; i++) { 5479066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project String value; 5489066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project try { 5499066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project value = cursor.getString(i); 5509066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } catch (SQLiteException e) { 5519066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // assume that if the getString threw this exception then the column is not 5529066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // representable by a string, e.g. it is a BLOB. 5539066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project value = "<unprintable>"; 5549066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 5559066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project stream.println(" " + cols[i] + '=' + value); 5569066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 5579066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project stream.println("}"); 5589066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 5599066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 5609066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 5619066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Prints the contents of a Cursor's current row to a StringBuilder. 5629066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 5639066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param cursor the cursor to print 5649066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param sb the StringBuilder to print to 5659066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 5669066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static void dumpCurrentRow(Cursor cursor, StringBuilder sb) { 5679066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project String[] cols = cursor.getColumnNames(); 5689066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sb.append("" + cursor.getPosition() + " {\n"); 5699066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project int length = cols.length; 5709066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project for (int i = 0; i < length; i++) { 5719066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project String value; 5729066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project try { 5739066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project value = cursor.getString(i); 5749066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } catch (SQLiteException e) { 5759066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // assume that if the getString threw this exception then the column is not 5769066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // representable by a string, e.g. it is a BLOB. 5779066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project value = "<unprintable>"; 5789066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 5799066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sb.append(" " + cols[i] + '=' + value + "\n"); 5809066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 5819066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sb.append("}\n"); 5829066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 5839066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 5849066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 5859066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Dump the contents of a Cursor's current row to a String. 5869066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 5879066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param cursor the cursor to print 5889066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @return a String that contains the dumped cursor row 5899066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 5909066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static String dumpCurrentRowToString(Cursor cursor) { 5919066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project StringBuilder sb = new StringBuilder(); 5929066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project dumpCurrentRow(cursor, sb); 5939066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return sb.toString(); 5949066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 5959066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 5969066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 5979066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Reads a String out of a field in a Cursor and writes it to a Map. 5989066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 5999066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param cursor The cursor to read from 6009066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param field The TEXT field to read 6019066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param values The {@link ContentValues} to put the value into, with the field as the key 6029066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 6039066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static void cursorStringToContentValues(Cursor cursor, String field, 6049066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project ContentValues values) { 6059066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project cursorStringToContentValues(cursor, field, values, field); 6069066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 6079066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 6089066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 6099066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Reads a String out of a field in a Cursor and writes it to an InsertHelper. 6109066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 6119066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param cursor The cursor to read from 6129066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param field The TEXT field to read 6139066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param inserter The InsertHelper to bind into 6149066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param index the index of the bind entry in the InsertHelper 6159066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 6169066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static void cursorStringToInsertHelper(Cursor cursor, String field, 6179066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project InsertHelper inserter, int index) { 6189066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project inserter.bind(index, cursor.getString(cursor.getColumnIndexOrThrow(field))); 6199066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 6209066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 6219066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 6229066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Reads a String out of a field in a Cursor and writes it to a Map. 6239066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 6249066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param cursor The cursor to read from 6259066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param field The TEXT field to read 6269066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param values The {@link ContentValues} to put the value into, with the field as the key 6279066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param key The key to store the value with in the map 6289066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 6299066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static void cursorStringToContentValues(Cursor cursor, String field, 6309066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project ContentValues values, String key) { 6319066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project values.put(key, cursor.getString(cursor.getColumnIndexOrThrow(field))); 6329066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 6339066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 6349066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 6359066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Reads an Integer out of a field in a Cursor and writes it to a Map. 6369066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 6379066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param cursor The cursor to read from 6389066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param field The INTEGER field to read 6399066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param values The {@link ContentValues} to put the value into, with the field as the key 6409066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 6419066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static void cursorIntToContentValues(Cursor cursor, String field, ContentValues values) { 6429066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project cursorIntToContentValues(cursor, field, values, field); 6439066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 6449066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 6459066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 6469066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Reads a Integer out of a field in a Cursor and writes it to a Map. 6479066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 6489066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param cursor The cursor to read from 6499066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param field The INTEGER field to read 6509066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param values The {@link ContentValues} to put the value into, with the field as the key 6519066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param key The key to store the value with in the map 6529066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 6539066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static void cursorIntToContentValues(Cursor cursor, String field, ContentValues values, 6549066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project String key) { 6559066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project int colIndex = cursor.getColumnIndex(field); 6569066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (!cursor.isNull(colIndex)) { 6579066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project values.put(key, cursor.getInt(colIndex)); 6589066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else { 6599066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project values.put(key, (Integer) null); 6609066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 6619066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 6629066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 6639066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 6649066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Reads a Long out of a field in a Cursor and writes it to a Map. 6659066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 6669066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param cursor The cursor to read from 6679066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param field The INTEGER field to read 6689066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param values The {@link ContentValues} to put the value into, with the field as the key 6699066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 6709066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static void cursorLongToContentValues(Cursor cursor, String field, ContentValues values) 6719066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project { 6729066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project cursorLongToContentValues(cursor, field, values, field); 6739066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 6749066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 6759066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 6769066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Reads a Long out of a field in a Cursor and writes it to a Map. 6779066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 6789066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param cursor The cursor to read from 6799066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param field The INTEGER field to read 6809066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param values The {@link ContentValues} to put the value into 6819066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param key The key to store the value with in the map 6829066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 6839066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static void cursorLongToContentValues(Cursor cursor, String field, ContentValues values, 6849066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project String key) { 6859066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project int colIndex = cursor.getColumnIndex(field); 6869066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (!cursor.isNull(colIndex)) { 6879066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project Long value = Long.valueOf(cursor.getLong(colIndex)); 6889066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project values.put(key, value); 6899066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else { 6909066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project values.put(key, (Long) null); 6919066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 6929066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 6939066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 6949066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 6959066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Reads a Double out of a field in a Cursor and writes it to a Map. 6969066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 6979066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param cursor The cursor to read from 6989066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param field The REAL field to read 6999066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param values The {@link ContentValues} to put the value into 7009066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 7019066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static void cursorDoubleToCursorValues(Cursor cursor, String field, ContentValues values) 7029066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project { 7039066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project cursorDoubleToContentValues(cursor, field, values, field); 7049066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 7059066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 7069066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 7079066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Reads a Double out of a field in a Cursor and writes it to a Map. 7089066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 7099066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param cursor The cursor to read from 7109066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param field The REAL field to read 7119066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param values The {@link ContentValues} to put the value into 7129066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param key The key to store the value with in the map 7139066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 7149066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static void cursorDoubleToContentValues(Cursor cursor, String field, 7159066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project ContentValues values, String key) { 7169066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project int colIndex = cursor.getColumnIndex(field); 7179066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (!cursor.isNull(colIndex)) { 7189066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project values.put(key, cursor.getDouble(colIndex)); 7199066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else { 7209066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project values.put(key, (Double) null); 7219066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 7229066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 7239066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 7249066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 7259066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Read the entire contents of a cursor row and store them in a ContentValues. 7269066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 7279066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param cursor the cursor to read from. 7289066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param values the {@link ContentValues} to put the row into. 7299066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 7309066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static void cursorRowToContentValues(Cursor cursor, ContentValues values) { 7319066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project AbstractWindowedCursor awc = 7329066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project (cursor instanceof AbstractWindowedCursor) ? (AbstractWindowedCursor) cursor : null; 7339066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 7349066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project String[] columns = cursor.getColumnNames(); 7359066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project int length = columns.length; 7369066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project for (int i = 0; i < length; i++) { 7379066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (awc != null && awc.isBlob(i)) { 7389066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project values.put(columns[i], cursor.getBlob(i)); 7399066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else { 7409066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project values.put(columns[i], cursor.getString(i)); 7419066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 7429066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 7439066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 7449066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 7459066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 746650de3dcfcbc7635da3c070410ef1dc4027ae464Jeff Brown * Picks a start position for {@link Cursor#fillWindow} such that the 747650de3dcfcbc7635da3c070410ef1dc4027ae464Jeff Brown * window will contain the requested row and a useful range of rows 748650de3dcfcbc7635da3c070410ef1dc4027ae464Jeff Brown * around it. 749650de3dcfcbc7635da3c070410ef1dc4027ae464Jeff Brown * 750650de3dcfcbc7635da3c070410ef1dc4027ae464Jeff Brown * When the data set is too large to fit in a cursor window, seeking the 751650de3dcfcbc7635da3c070410ef1dc4027ae464Jeff Brown * cursor can become a very expensive operation since we have to run the 752650de3dcfcbc7635da3c070410ef1dc4027ae464Jeff Brown * query again when we move outside the bounds of the current window. 753650de3dcfcbc7635da3c070410ef1dc4027ae464Jeff Brown * 754650de3dcfcbc7635da3c070410ef1dc4027ae464Jeff Brown * We try to choose a start position for the cursor window such that 755650de3dcfcbc7635da3c070410ef1dc4027ae464Jeff Brown * 1/3 of the window's capacity is used to hold rows before the requested 756650de3dcfcbc7635da3c070410ef1dc4027ae464Jeff Brown * position and 2/3 of the window's capacity is used to hold rows after the 757650de3dcfcbc7635da3c070410ef1dc4027ae464Jeff Brown * requested position. 758650de3dcfcbc7635da3c070410ef1dc4027ae464Jeff Brown * 759650de3dcfcbc7635da3c070410ef1dc4027ae464Jeff Brown * @param cursorPosition The row index of the row we want to get. 760650de3dcfcbc7635da3c070410ef1dc4027ae464Jeff Brown * @param cursorWindowCapacity The estimated number of rows that can fit in 761650de3dcfcbc7635da3c070410ef1dc4027ae464Jeff Brown * a cursor window, or 0 if unknown. 762650de3dcfcbc7635da3c070410ef1dc4027ae464Jeff Brown * @return The recommended start position, always less than or equal to 763650de3dcfcbc7635da3c070410ef1dc4027ae464Jeff Brown * the requested row. 764650de3dcfcbc7635da3c070410ef1dc4027ae464Jeff Brown * @hide 765650de3dcfcbc7635da3c070410ef1dc4027ae464Jeff Brown */ 766650de3dcfcbc7635da3c070410ef1dc4027ae464Jeff Brown public static int cursorPickFillWindowStartPosition( 767650de3dcfcbc7635da3c070410ef1dc4027ae464Jeff Brown int cursorPosition, int cursorWindowCapacity) { 768650de3dcfcbc7635da3c070410ef1dc4027ae464Jeff Brown return Math.max(cursorPosition - cursorWindowCapacity / 3, 0); 769650de3dcfcbc7635da3c070410ef1dc4027ae464Jeff Brown } 770650de3dcfcbc7635da3c070410ef1dc4027ae464Jeff Brown 771650de3dcfcbc7635da3c070410ef1dc4027ae464Jeff Brown /** 7729066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Query the table for the number of rows in the table. 7739066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param db the database the table is in 7749066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param table the name of the table to query 7759066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @return the number of rows in the table 7769066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 7779066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static long queryNumEntries(SQLiteDatabase db, String table) { 778e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer return queryNumEntries(db, table, null, null); 779e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer } 780e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer 781e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer /** 782e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer * Query the table for the number of rows in the table. 783e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer * @param db the database the table is in 784e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer * @param table the name of the table to query 785e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer * @param selection A filter declaring which rows to return, 786e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer * formatted as an SQL WHERE clause (excluding the WHERE itself). 787e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer * Passing null will count all rows for the given table 788e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer * @return the number of rows in the table filtered by the selection 789e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer */ 790e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer public static long queryNumEntries(SQLiteDatabase db, String table, String selection) { 791e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer return queryNumEntries(db, table, selection, null); 792e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer } 793e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer 794e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer /** 795e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer * Query the table for the number of rows in the table. 796e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer * @param db the database the table is in 797e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer * @param table the name of the table to query 798e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer * @param selection A filter declaring which rows to return, 799e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer * formatted as an SQL WHERE clause (excluding the WHERE itself). 800e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer * Passing null will count all rows for the given table 801e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer * @param selectionArgs You may include ?s in selection, 802e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer * which will be replaced by the values from selectionArgs, 803e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer * in order that they appear in the selection. 804e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer * The values will be bound as Strings. 805e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer * @return the number of rows in the table filtered by the selection 806e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer */ 807e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer public static long queryNumEntries(SQLiteDatabase db, String table, String selection, 808e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer String[] selectionArgs) { 809e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer String s = (!TextUtils.isEmpty(selection)) ? " where " + selection : ""; 810e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer return longForQuery(db, "select count(*) from " + table + s, 811e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer selectionArgs); 8129066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 8139066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 8149066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 815ac4daee248b4bb0cb658c83437e4a9d93c6dce2dHyoseong Kim * Query the table to check whether a table is empty or not 816ac4daee248b4bb0cb658c83437e4a9d93c6dce2dHyoseong Kim * @param db the database the table is in 817ac4daee248b4bb0cb658c83437e4a9d93c6dce2dHyoseong Kim * @param table the name of the table to query 818ac4daee248b4bb0cb658c83437e4a9d93c6dce2dHyoseong Kim * @return True if the table is empty 819ac4daee248b4bb0cb658c83437e4a9d93c6dce2dHyoseong Kim * @hide 820ac4daee248b4bb0cb658c83437e4a9d93c6dce2dHyoseong Kim */ 821ac4daee248b4bb0cb658c83437e4a9d93c6dce2dHyoseong Kim public static boolean queryIsEmpty(SQLiteDatabase db, String table) { 822ac4daee248b4bb0cb658c83437e4a9d93c6dce2dHyoseong Kim long isEmpty = longForQuery(db, "select exists(select 1 from " + table + ")", null); 823ac4daee248b4bb0cb658c83437e4a9d93c6dce2dHyoseong Kim return isEmpty == 0; 824ac4daee248b4bb0cb658c83437e4a9d93c6dce2dHyoseong Kim } 825ac4daee248b4bb0cb658c83437e4a9d93c6dce2dHyoseong Kim 826ac4daee248b4bb0cb658c83437e4a9d93c6dce2dHyoseong Kim /** 8279066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Utility method to run the query on the db and return the value in the 8289066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * first column of the first row. 8299066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 8309066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static long longForQuery(SQLiteDatabase db, String query, String[] selectionArgs) { 8319066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project SQLiteStatement prog = db.compileStatement(query); 8329066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project try { 8339066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return longForQuery(prog, selectionArgs); 8349066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } finally { 8359066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project prog.close(); 8369066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 8379066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 8389066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 8399066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 8409066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Utility method to run the pre-compiled query and return the value in the 8419066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * first column of the first row. 8429066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 8439066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static long longForQuery(SQLiteStatement prog, String[] selectionArgs) { 8440732f7912ccec9a1cc379b535ac0b56ae50972b3Vasu Nori prog.bindAllArgsAsStrings(selectionArgs); 8450732f7912ccec9a1cc379b535ac0b56ae50972b3Vasu Nori return prog.simpleQueryForLong(); 8469066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 8479066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 8489066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 8499066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Utility method to run the query on the db and return the value in the 8509066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * first column of the first row. 8519066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 8529066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static String stringForQuery(SQLiteDatabase db, String query, String[] selectionArgs) { 8539066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project SQLiteStatement prog = db.compileStatement(query); 8549066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project try { 8559066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return stringForQuery(prog, selectionArgs); 8569066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } finally { 8579066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project prog.close(); 8589066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 8599066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 8609066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 8619066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 8629066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Utility method to run the pre-compiled query and return the value in the 8639066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * first column of the first row. 8649066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 8659066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static String stringForQuery(SQLiteStatement prog, String[] selectionArgs) { 8660732f7912ccec9a1cc379b535ac0b56ae50972b3Vasu Nori prog.bindAllArgsAsStrings(selectionArgs); 8670732f7912ccec9a1cc379b535ac0b56ae50972b3Vasu Nori return prog.simpleQueryForString(); 8689066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 8699066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 8709066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 871a006b47298539d89dc7a06b54c070cb3e986352aBjorn Bringert * Utility method to run the query on the db and return the blob value in the 872a006b47298539d89dc7a06b54c070cb3e986352aBjorn Bringert * first column of the first row. 873a006b47298539d89dc7a06b54c070cb3e986352aBjorn Bringert * 874a006b47298539d89dc7a06b54c070cb3e986352aBjorn Bringert * @return A read-only file descriptor for a copy of the blob value. 875a006b47298539d89dc7a06b54c070cb3e986352aBjorn Bringert */ 876a006b47298539d89dc7a06b54c070cb3e986352aBjorn Bringert public static ParcelFileDescriptor blobFileDescriptorForQuery(SQLiteDatabase db, 877a006b47298539d89dc7a06b54c070cb3e986352aBjorn Bringert String query, String[] selectionArgs) { 878a006b47298539d89dc7a06b54c070cb3e986352aBjorn Bringert SQLiteStatement prog = db.compileStatement(query); 879a006b47298539d89dc7a06b54c070cb3e986352aBjorn Bringert try { 880a006b47298539d89dc7a06b54c070cb3e986352aBjorn Bringert return blobFileDescriptorForQuery(prog, selectionArgs); 881a006b47298539d89dc7a06b54c070cb3e986352aBjorn Bringert } finally { 882a006b47298539d89dc7a06b54c070cb3e986352aBjorn Bringert prog.close(); 883a006b47298539d89dc7a06b54c070cb3e986352aBjorn Bringert } 884a006b47298539d89dc7a06b54c070cb3e986352aBjorn Bringert } 885a006b47298539d89dc7a06b54c070cb3e986352aBjorn Bringert 886a006b47298539d89dc7a06b54c070cb3e986352aBjorn Bringert /** 887a006b47298539d89dc7a06b54c070cb3e986352aBjorn Bringert * Utility method to run the pre-compiled query and return the blob value in the 888a006b47298539d89dc7a06b54c070cb3e986352aBjorn Bringert * first column of the first row. 889a006b47298539d89dc7a06b54c070cb3e986352aBjorn Bringert * 890a006b47298539d89dc7a06b54c070cb3e986352aBjorn Bringert * @return A read-only file descriptor for a copy of the blob value. 891a006b47298539d89dc7a06b54c070cb3e986352aBjorn Bringert */ 892a006b47298539d89dc7a06b54c070cb3e986352aBjorn Bringert public static ParcelFileDescriptor blobFileDescriptorForQuery(SQLiteStatement prog, 893a006b47298539d89dc7a06b54c070cb3e986352aBjorn Bringert String[] selectionArgs) { 894a006b47298539d89dc7a06b54c070cb3e986352aBjorn Bringert prog.bindAllArgsAsStrings(selectionArgs); 895a006b47298539d89dc7a06b54c070cb3e986352aBjorn Bringert return prog.simpleQueryForBlobFileDescriptor(); 896a006b47298539d89dc7a06b54c070cb3e986352aBjorn Bringert } 897a006b47298539d89dc7a06b54c070cb3e986352aBjorn Bringert 898a006b47298539d89dc7a06b54c070cb3e986352aBjorn Bringert /** 8992ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * Reads a String out of a column in a Cursor and writes it to a ContentValues. 9002ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * Adds nothing to the ContentValues if the column isn't present or if its value is null. 9012ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * 9022ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * @param cursor The cursor to read from 9032ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * @param column The column to read 9042ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * @param values The {@link ContentValues} to put the value into 9052ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana */ 9062ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana public static void cursorStringToContentValuesIfPresent(Cursor cursor, ContentValues values, 9072ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana String column) { 9089a9ce6067f36d85b9224ab50cae76c0b0a676442Dmitri Plotnikov final int index = cursor.getColumnIndex(column); 9099a9ce6067f36d85b9224ab50cae76c0b0a676442Dmitri Plotnikov if (index != -1 && !cursor.isNull(index)) { 9102ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana values.put(column, cursor.getString(index)); 9112ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana } 9122ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana } 9132ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana 9142ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana /** 9152ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * Reads a Long out of a column in a Cursor and writes it to a ContentValues. 9162ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * Adds nothing to the ContentValues if the column isn't present or if its value is null. 9172ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * 9182ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * @param cursor The cursor to read from 9192ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * @param column The column to read 9202ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * @param values The {@link ContentValues} to put the value into 9212ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana */ 9222ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana public static void cursorLongToContentValuesIfPresent(Cursor cursor, ContentValues values, 9232ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana String column) { 9249a9ce6067f36d85b9224ab50cae76c0b0a676442Dmitri Plotnikov final int index = cursor.getColumnIndex(column); 9259a9ce6067f36d85b9224ab50cae76c0b0a676442Dmitri Plotnikov if (index != -1 && !cursor.isNull(index)) { 9262ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana values.put(column, cursor.getLong(index)); 9272ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana } 9282ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana } 9292ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana 9302ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana /** 9312ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * Reads a Short out of a column in a Cursor and writes it to a ContentValues. 9322ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * Adds nothing to the ContentValues if the column isn't present or if its value is null. 9332ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * 9342ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * @param cursor The cursor to read from 9352ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * @param column The column to read 9362ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * @param values The {@link ContentValues} to put the value into 9372ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana */ 9382ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana public static void cursorShortToContentValuesIfPresent(Cursor cursor, ContentValues values, 9392ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana String column) { 9409a9ce6067f36d85b9224ab50cae76c0b0a676442Dmitri Plotnikov final int index = cursor.getColumnIndex(column); 9419a9ce6067f36d85b9224ab50cae76c0b0a676442Dmitri Plotnikov if (index != -1 && !cursor.isNull(index)) { 9422ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana values.put(column, cursor.getShort(index)); 9432ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana } 9442ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana } 9452ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana 9462ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana /** 9472ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * Reads a Integer out of a column in a Cursor and writes it to a ContentValues. 9482ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * Adds nothing to the ContentValues if the column isn't present or if its value is null. 9492ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * 9502ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * @param cursor The cursor to read from 9512ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * @param column The column to read 9522ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * @param values The {@link ContentValues} to put the value into 9532ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana */ 9542ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana public static void cursorIntToContentValuesIfPresent(Cursor cursor, ContentValues values, 9552ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana String column) { 9569a9ce6067f36d85b9224ab50cae76c0b0a676442Dmitri Plotnikov final int index = cursor.getColumnIndex(column); 9579a9ce6067f36d85b9224ab50cae76c0b0a676442Dmitri Plotnikov if (index != -1 && !cursor.isNull(index)) { 9582ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana values.put(column, cursor.getInt(index)); 9592ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana } 9602ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana } 9612ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana 9622ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana /** 9632ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * Reads a Float out of a column in a Cursor and writes it to a ContentValues. 9642ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * Adds nothing to the ContentValues if the column isn't present or if its value is null. 9652ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * 9662ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * @param cursor The cursor to read from 9672ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * @param column The column to read 9682ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * @param values The {@link ContentValues} to put the value into 9692ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana */ 9702ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana public static void cursorFloatToContentValuesIfPresent(Cursor cursor, ContentValues values, 9712ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana String column) { 9729a9ce6067f36d85b9224ab50cae76c0b0a676442Dmitri Plotnikov final int index = cursor.getColumnIndex(column); 9739a9ce6067f36d85b9224ab50cae76c0b0a676442Dmitri Plotnikov if (index != -1 && !cursor.isNull(index)) { 9742ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana values.put(column, cursor.getFloat(index)); 9752ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana } 9762ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana } 9772ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana 9782ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana /** 9792ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * Reads a Double out of a column in a Cursor and writes it to a ContentValues. 9802ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * Adds nothing to the ContentValues if the column isn't present or if its value is null. 9812ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * 9822ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * @param cursor The cursor to read from 9832ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * @param column The column to read 9842ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * @param values The {@link ContentValues} to put the value into 9852ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana */ 9862ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana public static void cursorDoubleToContentValuesIfPresent(Cursor cursor, ContentValues values, 9872ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana String column) { 9889a9ce6067f36d85b9224ab50cae76c0b0a676442Dmitri Plotnikov final int index = cursor.getColumnIndex(column); 9899a9ce6067f36d85b9224ab50cae76c0b0a676442Dmitri Plotnikov if (index != -1 && !cursor.isNull(index)) { 9902ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana values.put(column, cursor.getDouble(index)); 9912ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana } 9922ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana } 9932ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana 9942ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana /** 995b33eb4e32a25e28677524c68be02ca7034351bf0Jeff Brown * This class allows users to do multiple inserts into a table using 996b33eb4e32a25e28677524c68be02ca7034351bf0Jeff Brown * the same statement. 997b33eb4e32a25e28677524c68be02ca7034351bf0Jeff Brown * <p> 998b33eb4e32a25e28677524c68be02ca7034351bf0Jeff Brown * This class is not thread-safe. 999b33eb4e32a25e28677524c68be02ca7034351bf0Jeff Brown * </p> 1000b33eb4e32a25e28677524c68be02ca7034351bf0Jeff Brown * 1001b33eb4e32a25e28677524c68be02ca7034351bf0Jeff Brown * @deprecated Use {@link SQLiteStatement} instead. 10029066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 1003b33eb4e32a25e28677524c68be02ca7034351bf0Jeff Brown @Deprecated 10049066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static class InsertHelper { 10059066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private final SQLiteDatabase mDb; 10069066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private final String mTableName; 10079066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private HashMap<String, Integer> mColumns; 10089066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private String mInsertSQL = null; 10099066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private SQLiteStatement mInsertStatement = null; 10109066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private SQLiteStatement mReplaceStatement = null; 10119066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private SQLiteStatement mPreparedStatement = null; 10129066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 10139066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 10149066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * {@hide} 10159066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 10169066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * These are the columns returned by sqlite's "PRAGMA 10179066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * table_info(...)" command that we depend on. 10189066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 10199066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static final int TABLE_INFO_PRAGMA_COLUMNNAME_INDEX = 1; 1020b33eb4e32a25e28677524c68be02ca7034351bf0Jeff Brown 1021b33eb4e32a25e28677524c68be02ca7034351bf0Jeff Brown /** 1022b33eb4e32a25e28677524c68be02ca7034351bf0Jeff Brown * This field was accidentally exposed in earlier versions of the platform 1023b33eb4e32a25e28677524c68be02ca7034351bf0Jeff Brown * so we can hide it but we can't remove it. 1024b33eb4e32a25e28677524c68be02ca7034351bf0Jeff Brown * 1025b33eb4e32a25e28677524c68be02ca7034351bf0Jeff Brown * @hide 1026b33eb4e32a25e28677524c68be02ca7034351bf0Jeff Brown */ 10279066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static final int TABLE_INFO_PRAGMA_DEFAULT_INDEX = 4; 10289066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 10299066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 10309066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param db the SQLiteDatabase to insert into 10319066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param tableName the name of the table to insert into 10329066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 10339066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public InsertHelper(SQLiteDatabase db, String tableName) { 10349066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mDb = db; 10359066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mTableName = tableName; 10369066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 10379066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 10389066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private void buildSQL() throws SQLException { 10399066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project StringBuilder sb = new StringBuilder(128); 10409066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sb.append("INSERT INTO "); 10419066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sb.append(mTableName); 10429066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sb.append(" ("); 10439066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 10449066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project StringBuilder sbv = new StringBuilder(128); 10459066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sbv.append("VALUES ("); 10469066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 10479066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project int i = 1; 10489066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project Cursor cur = null; 10499066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project try { 10509066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project cur = mDb.rawQuery("PRAGMA table_info(" + mTableName + ")", null); 10519066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mColumns = new HashMap<String, Integer>(cur.getCount()); 10529066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project while (cur.moveToNext()) { 10539066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project String columnName = cur.getString(TABLE_INFO_PRAGMA_COLUMNNAME_INDEX); 10549066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project String defaultValue = cur.getString(TABLE_INFO_PRAGMA_DEFAULT_INDEX); 10559066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 10569066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mColumns.put(columnName, i); 10579066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sb.append("'"); 10589066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sb.append(columnName); 10599066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sb.append("'"); 10609066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 10619066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (defaultValue == null) { 10629066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sbv.append("?"); 10639066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else { 10649066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sbv.append("COALESCE(?, "); 10659066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sbv.append(defaultValue); 10669066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sbv.append(")"); 10679066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 10689066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 10699066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sb.append(i == cur.getCount() ? ") " : ", "); 10709066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sbv.append(i == cur.getCount() ? ");" : ", "); 10719066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project ++i; 10729066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 10739066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } finally { 10749066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (cur != null) cur.close(); 10759066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 10769066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 10779066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sb.append(sbv); 10789066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 10799066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mInsertSQL = sb.toString(); 1080b33eb4e32a25e28677524c68be02ca7034351bf0Jeff Brown if (DEBUG) Log.v(TAG, "insert statement is " + mInsertSQL); 10819066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 10829066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 10839066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private SQLiteStatement getStatement(boolean allowReplace) throws SQLException { 10849066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (allowReplace) { 10859066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (mReplaceStatement == null) { 10869066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (mInsertSQL == null) buildSQL(); 10879066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // chop "INSERT" off the front and prepend "INSERT OR REPLACE" instead. 10889066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project String replaceSQL = "INSERT OR REPLACE" + mInsertSQL.substring(6); 10899066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mReplaceStatement = mDb.compileStatement(replaceSQL); 10909066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 10919066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return mReplaceStatement; 10929066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else { 10939066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (mInsertStatement == null) { 10949066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (mInsertSQL == null) buildSQL(); 10959066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mInsertStatement = mDb.compileStatement(mInsertSQL); 10969066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 10979066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return mInsertStatement; 10989066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 10999066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 11009066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 11019066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 11029066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Performs an insert, adding a new row with the given values. 11039066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 11049066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param values the set of values with which to populate the 11059066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * new row 11069066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param allowReplace if true, the statement does "INSERT OR 11079066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * REPLACE" instead of "INSERT", silently deleting any 11089066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * previously existing rows that would cause a conflict 11099066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 11109066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @return the row ID of the newly inserted row, or -1 if an 11119066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * error occurred 11129066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 1113b33eb4e32a25e28677524c68be02ca7034351bf0Jeff Brown private long insertInternal(ContentValues values, boolean allowReplace) { 1114b33eb4e32a25e28677524c68be02ca7034351bf0Jeff Brown // Start a transaction even though we don't really need one. 1115b33eb4e32a25e28677524c68be02ca7034351bf0Jeff Brown // This is to help maintain compatibility with applications that 1116b33eb4e32a25e28677524c68be02ca7034351bf0Jeff Brown // access InsertHelper from multiple threads even though they never should have. 1117b33eb4e32a25e28677524c68be02ca7034351bf0Jeff Brown // The original code used to lock the InsertHelper itself which was prone 1118b33eb4e32a25e28677524c68be02ca7034351bf0Jeff Brown // to deadlocks. Starting a transaction achieves the same mutual exclusion 1119b33eb4e32a25e28677524c68be02ca7034351bf0Jeff Brown // effect as grabbing a lock but without the potential for deadlocks. 1120b33eb4e32a25e28677524c68be02ca7034351bf0Jeff Brown mDb.beginTransactionNonExclusive(); 11219066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project try { 11229066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project SQLiteStatement stmt = getStatement(allowReplace); 11239066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project stmt.clearBindings(); 1124b33eb4e32a25e28677524c68be02ca7034351bf0Jeff Brown if (DEBUG) Log.v(TAG, "--- inserting in table " + mTableName); 11259066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project for (Map.Entry<String, Object> e: values.valueSet()) { 11269066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project final String key = e.getKey(); 11279066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project int i = getColumnIndex(key); 11289066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project DatabaseUtils.bindObjectToProgram(stmt, i, e.getValue()); 1129b33eb4e32a25e28677524c68be02ca7034351bf0Jeff Brown if (DEBUG) { 11309066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project Log.v(TAG, "binding " + e.getValue() + " to column " + 11319066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project i + " (" + key + ")"); 11329066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 11339066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1134b33eb4e32a25e28677524c68be02ca7034351bf0Jeff Brown long result = stmt.executeInsert(); 1135b33eb4e32a25e28677524c68be02ca7034351bf0Jeff Brown mDb.setTransactionSuccessful(); 1136b33eb4e32a25e28677524c68be02ca7034351bf0Jeff Brown return result; 11379066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } catch (SQLException e) { 11389066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project Log.e(TAG, "Error inserting " + values + " into table " + mTableName, e); 11399066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return -1; 1140b33eb4e32a25e28677524c68be02ca7034351bf0Jeff Brown } finally { 1141b33eb4e32a25e28677524c68be02ca7034351bf0Jeff Brown mDb.endTransaction(); 11429066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 11439066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 11449066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 11459066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 11469066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Returns the index of the specified column. This is index is suitagble for use 11479066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * in calls to bind(). 11489066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param key the column name 11499066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @return the index of the column 11509066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 11519066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public int getColumnIndex(String key) { 11529066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project getStatement(false); 11539066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project final Integer index = mColumns.get(key); 11549066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (index == null) { 11559066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project throw new IllegalArgumentException("column '" + key + "' is invalid"); 11569066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 11579066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return index; 11589066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 11599066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 11609066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 11619066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Bind the value to an index. A prepareForInsert() or prepareForReplace() 11629066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * without a matching execute() must have already have been called. 11639066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param index the index of the slot to which to bind 11649066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param value the value to bind 11659066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 11669066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public void bind(int index, double value) { 11679066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mPreparedStatement.bindDouble(index, value); 11689066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 11699066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 11709066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 11719066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Bind the value to an index. A prepareForInsert() or prepareForReplace() 11729066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * without a matching execute() must have already have been called. 11739066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param index the index of the slot to which to bind 11749066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param value the value to bind 11759066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 11769066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public void bind(int index, float value) { 11779066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mPreparedStatement.bindDouble(index, value); 11789066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 11799066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 11809066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 11819066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Bind the value to an index. A prepareForInsert() or prepareForReplace() 11829066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * without a matching execute() must have already have been called. 11839066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param index the index of the slot to which to bind 11849066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param value the value to bind 11859066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 11869066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public void bind(int index, long value) { 11879066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mPreparedStatement.bindLong(index, value); 11889066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 11899066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 11909066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 11919066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Bind the value to an index. A prepareForInsert() or prepareForReplace() 11929066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * without a matching execute() must have already have been called. 11939066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param index the index of the slot to which to bind 11949066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param value the value to bind 11959066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 11969066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public void bind(int index, int value) { 11979066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mPreparedStatement.bindLong(index, value); 11989066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 11999066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 12009066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 12019066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Bind the value to an index. A prepareForInsert() or prepareForReplace() 12029066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * without a matching execute() must have already have been called. 12039066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param index the index of the slot to which to bind 12049066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param value the value to bind 12059066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 12069066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public void bind(int index, boolean value) { 12079066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mPreparedStatement.bindLong(index, value ? 1 : 0); 12089066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 12099066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 12109066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 12119066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Bind null to an index. A prepareForInsert() or prepareForReplace() 12129066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * without a matching execute() must have already have been called. 12139066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param index the index of the slot to which to bind 12149066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 12159066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public void bindNull(int index) { 12169066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mPreparedStatement.bindNull(index); 12179066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 12189066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 12199066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 12209066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Bind the value to an index. A prepareForInsert() or prepareForReplace() 12219066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * without a matching execute() must have already have been called. 12229066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param index the index of the slot to which to bind 12239066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param value the value to bind 12249066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 12259066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public void bind(int index, byte[] value) { 12269066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (value == null) { 12279066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mPreparedStatement.bindNull(index); 12289066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else { 12299066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mPreparedStatement.bindBlob(index, value); 12309066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 12319066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 12329066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 12339066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 12349066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Bind the value to an index. A prepareForInsert() or prepareForReplace() 12359066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * without a matching execute() must have already have been called. 12369066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param index the index of the slot to which to bind 12379066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param value the value to bind 12389066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 12399066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public void bind(int index, String value) { 12409066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (value == null) { 12419066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mPreparedStatement.bindNull(index); 12429066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else { 12439066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mPreparedStatement.bindString(index, value); 12449066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 12459066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 12469066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 12479066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 12489066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Performs an insert, adding a new row with the given values. 12499066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * If the table contains conflicting rows, an error is 12509066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * returned. 12519066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 12529066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param values the set of values with which to populate the 12539066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * new row 12549066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 12559066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @return the row ID of the newly inserted row, or -1 if an 12569066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * error occurred 12579066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 12589066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public long insert(ContentValues values) { 12599066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return insertInternal(values, false); 12609066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 12619066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 12629066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 12639066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Execute the previously prepared insert or replace using the bound values 12649066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * since the last call to prepareForInsert or prepareForReplace. 12659066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 12669066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * <p>Note that calling bind() and then execute() is not thread-safe. The only thread-safe 12679066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * way to use this class is to call insert() or replace(). 12689066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 12699066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @return the row ID of the newly inserted row, or -1 if an 12709066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * error occurred 12719066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 12729066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public long execute() { 12739066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (mPreparedStatement == null) { 12749066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project throw new IllegalStateException("you must prepare this inserter before calling " 12759066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project + "execute"); 12769066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 12779066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project try { 1278b33eb4e32a25e28677524c68be02ca7034351bf0Jeff Brown if (DEBUG) Log.v(TAG, "--- doing insert or replace in table " + mTableName); 12799066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return mPreparedStatement.executeInsert(); 12809066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } catch (SQLException e) { 12819066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project Log.e(TAG, "Error executing InsertHelper with table " + mTableName, e); 12829066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return -1; 12839066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } finally { 12849066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // you can only call this once per prepare 12859066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mPreparedStatement = null; 12869066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 12879066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 12889066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 12899066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 12909066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Prepare the InsertHelper for an insert. The pattern for this is: 12919066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * <ul> 12929066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * <li>prepareForInsert() 12939066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * <li>bind(index, value); 12949066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * <li>bind(index, value); 12959066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * <li>... 12969066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * <li>bind(index, value); 12979066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * <li>execute(); 12989066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * </ul> 12999066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 13009066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public void prepareForInsert() { 13019066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mPreparedStatement = getStatement(false); 13029066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mPreparedStatement.clearBindings(); 13039066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 13049066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 13059066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 13069066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Prepare the InsertHelper for a replace. The pattern for this is: 13079066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * <ul> 13089066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * <li>prepareForReplace() 13099066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * <li>bind(index, value); 13109066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * <li>bind(index, value); 13119066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * <li>... 13129066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * <li>bind(index, value); 13139066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * <li>execute(); 13149066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * </ul> 13159066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 13169066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public void prepareForReplace() { 13179066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mPreparedStatement = getStatement(true); 13189066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mPreparedStatement.clearBindings(); 13199066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 13209066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 13219066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 13229066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Performs an insert, adding a new row with the given values. 13239066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * If the table contains conflicting rows, they are deleted 13249066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * and replaced with the new row. 13259066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 13269066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param values the set of values with which to populate the 13279066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * new row 13289066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 13299066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @return the row ID of the newly inserted row, or -1 if an 13309066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * error occurred 13319066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 13329066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public long replace(ContentValues values) { 13339066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return insertInternal(values, true); 13349066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 13359066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 13369066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 13379066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Close this object and release any resources associated with 13389066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * it. The behavior of calling <code>insert()</code> after 13399066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * calling this method is undefined. 13409066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 13419066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public void close() { 13429066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (mInsertStatement != null) { 13439066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mInsertStatement.close(); 13449066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mInsertStatement = null; 13459066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 13469066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (mReplaceStatement != null) { 13479066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mReplaceStatement.close(); 13489066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mReplaceStatement = null; 13499066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 13509066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mInsertSQL = null; 13519066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mColumns = null; 13529066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 13539066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 13549066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 13559066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 13569066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Creates a db and populates it with the sql statements in sqlStatements. 13579066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 13589066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param context the context to use to create the db 13599066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param dbName the name of the db to create 13609066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param dbVersion the version to set on the db 13619066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param sqlStatements the statements to use to populate the db. This should be a single string 13629066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * of the form returned by sqlite3's <tt>.dump</tt> command (statements separated by 13639066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * semicolons) 13649066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 13659066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project static public void createDbFromSqlStatements( 13669066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project Context context, String dbName, int dbVersion, String sqlStatements) { 13679066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project SQLiteDatabase db = context.openOrCreateDatabase(dbName, 0, null); 13689066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // TODO: this is not quite safe since it assumes that all semicolons at the end of a line 13699066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // terminate statements. It is possible that a text field contains ;\n. We will have to fix 13709066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // this if that turns out to be a problem. 13719066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project String[] statements = TextUtils.split(sqlStatements, ";\n"); 13729066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project for (String statement : statements) { 13739066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (TextUtils.isEmpty(statement)) continue; 13749066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project db.execSQL(statement); 13759066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 13769066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project db.setVersion(dbVersion); 13779066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project db.close(); 13789066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1379ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori 1380ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori /** 1381ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori * Returns one of the following which represent the type of the given SQL statement. 1382ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori * <ol> 1383ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori * <li>{@link #STATEMENT_SELECT}</li> 1384ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori * <li>{@link #STATEMENT_UPDATE}</li> 1385ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori * <li>{@link #STATEMENT_ATTACH}</li> 1386ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori * <li>{@link #STATEMENT_BEGIN}</li> 1387ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori * <li>{@link #STATEMENT_COMMIT}</li> 1388ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori * <li>{@link #STATEMENT_ABORT}</li> 1389ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori * <li>{@link #STATEMENT_OTHER}</li> 1390ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori * </ol> 1391ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori * @param sql the SQL statement whose type is returned by this method 1392ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori * @return one of the values listed above 1393ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori */ 1394ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori public static int getSqlStatementType(String sql) { 1395ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori sql = sql.trim(); 1396ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori if (sql.length() < 3) { 1397ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori return STATEMENT_OTHER; 1398ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori } 1399cb64d430627b71221c588ef5f23599dd34a89ee9Elliott Hughes String prefixSql = sql.substring(0, 3).toUpperCase(Locale.ROOT); 1400ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori if (prefixSql.equals("SEL")) { 1401ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori return STATEMENT_SELECT; 1402ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori } else if (prefixSql.equals("INS") || 1403ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori prefixSql.equals("UPD") || 1404ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori prefixSql.equals("REP") || 1405ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori prefixSql.equals("DEL")) { 1406ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori return STATEMENT_UPDATE; 1407ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori } else if (prefixSql.equals("ATT")) { 1408ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori return STATEMENT_ATTACH; 1409ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori } else if (prefixSql.equals("COM")) { 1410ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori return STATEMENT_COMMIT; 1411ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori } else if (prefixSql.equals("END")) { 1412ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori return STATEMENT_COMMIT; 1413ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori } else if (prefixSql.equals("ROL")) { 1414ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori return STATEMENT_ABORT; 1415ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori } else if (prefixSql.equals("BEG")) { 1416ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori return STATEMENT_BEGIN; 14174e874edf69ce9900eb847629dc4d3616972a3468Vasu Nori } else if (prefixSql.equals("PRA")) { 14184e874edf69ce9900eb847629dc4d3616972a3468Vasu Nori return STATEMENT_PRAGMA; 14194e874edf69ce9900eb847629dc4d3616972a3468Vasu Nori } else if (prefixSql.equals("CRE") || prefixSql.equals("DRO") || 14204e874edf69ce9900eb847629dc4d3616972a3468Vasu Nori prefixSql.equals("ALT")) { 14214e874edf69ce9900eb847629dc4d3616972a3468Vasu Nori return STATEMENT_DDL; 14224e874edf69ce9900eb847629dc4d3616972a3468Vasu Nori } else if (prefixSql.equals("ANA") || prefixSql.equals("DET")) { 14234e874edf69ce9900eb847629dc4d3616972a3468Vasu Nori return STATEMENT_UNPREPARED; 1424ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori } 1425ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori return STATEMENT_OTHER; 1426ce38b98feb1e7c9c1799eb270c40798d833aa9aeVasu Nori } 1427f0cfe3438aea77b5193d94fb9fa0c8d37972b194Jeff Hamilton 1428f0cfe3438aea77b5193d94fb9fa0c8d37972b194Jeff Hamilton /** 1429f0cfe3438aea77b5193d94fb9fa0c8d37972b194Jeff Hamilton * Appends one set of selection args to another. This is useful when adding a selection 1430f0cfe3438aea77b5193d94fb9fa0c8d37972b194Jeff Hamilton * argument to a user provided set. 1431f0cfe3438aea77b5193d94fb9fa0c8d37972b194Jeff Hamilton */ 1432f0cfe3438aea77b5193d94fb9fa0c8d37972b194Jeff Hamilton public static String[] appendSelectionArgs(String[] originalValues, String[] newValues) { 1433f0cfe3438aea77b5193d94fb9fa0c8d37972b194Jeff Hamilton if (originalValues == null || originalValues.length == 0) { 1434f0cfe3438aea77b5193d94fb9fa0c8d37972b194Jeff Hamilton return newValues; 1435f0cfe3438aea77b5193d94fb9fa0c8d37972b194Jeff Hamilton } 1436f0cfe3438aea77b5193d94fb9fa0c8d37972b194Jeff Hamilton String[] result = new String[originalValues.length + newValues.length ]; 1437f0cfe3438aea77b5193d94fb9fa0c8d37972b194Jeff Hamilton System.arraycopy(originalValues, 0, result, 0, originalValues.length); 1438f0cfe3438aea77b5193d94fb9fa0c8d37972b194Jeff Hamilton System.arraycopy(newValues, 0, result, originalValues.length, newValues.length); 1439f0cfe3438aea77b5193d94fb9fa0c8d37972b194Jeff Hamilton return result; 1440f0cfe3438aea77b5193d94fb9fa0c8d37972b194Jeff Hamilton } 1441fb5a4964b8d402b39754f406dd2255035ff2148dJeff Brown 1442fb5a4964b8d402b39754f406dd2255035ff2148dJeff Brown /** 1443fb5a4964b8d402b39754f406dd2255035ff2148dJeff Brown * Returns column index of "_id" column, or -1 if not found. 1444fb5a4964b8d402b39754f406dd2255035ff2148dJeff Brown * @hide 1445fb5a4964b8d402b39754f406dd2255035ff2148dJeff Brown */ 1446fb5a4964b8d402b39754f406dd2255035ff2148dJeff Brown public static int findRowIdColumnIndex(String[] columnNames) { 1447fb5a4964b8d402b39754f406dd2255035ff2148dJeff Brown int length = columnNames.length; 1448fb5a4964b8d402b39754f406dd2255035ff2148dJeff Brown for (int i = 0; i < length; i++) { 1449fb5a4964b8d402b39754f406dd2255035ff2148dJeff Brown if (columnNames[i].equals("_id")) { 1450fb5a4964b8d402b39754f406dd2255035ff2148dJeff Brown return i; 1451fb5a4964b8d402b39754f406dd2255035ff2148dJeff Brown } 1452fb5a4964b8d402b39754f406dd2255035ff2148dJeff Brown } 1453fb5a4964b8d402b39754f406dd2255035ff2148dJeff Brown return -1; 1454fb5a4964b8d402b39754f406dd2255035ff2148dJeff Brown } 14559066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project} 1456