DatabaseUtils.java revision e7731f0a7f824add1fffa391965cbfeaf7cb2cf2
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 org.apache.commons.codec.binary.Hex; 209066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 219066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.content.ContentValues; 229066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.content.Context; 238943737692169f564cd34a9c8d471f3a5d438712Fred Quintanaimport android.content.OperationApplicationException; 249066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.database.sqlite.SQLiteAbortException; 259066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.database.sqlite.SQLiteConstraintException; 269066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.database.sqlite.SQLiteDatabase; 279066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.database.sqlite.SQLiteDatabaseCorruptException; 289066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.database.sqlite.SQLiteDiskIOException; 299066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.database.sqlite.SQLiteException; 309066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.database.sqlite.SQLiteFullException; 319066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.database.sqlite.SQLiteProgram; 329066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.database.sqlite.SQLiteStatement; 339066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.os.Parcel; 349066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.text.TextUtils; 359066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.util.Config; 369066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.util.Log; 379066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 389066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport java.io.FileNotFoundException; 399066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport java.io.PrintStream; 409066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport java.text.Collator; 419066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport java.util.HashMap; 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 private static final boolean LOCAL_LOGV = DEBUG ? Config.LOGD : Config.LOGV; 529066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 539066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 549066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Special function for writing an exception result at the header of 559066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * a parcel, to be used when returning an exception from a transaction. 569066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * exception will be re-thrown by the function in another process 579066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param reply Parcel to write to 589066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param e The Exception to be written. 599066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @see Parcel#writeNoException 609066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @see Parcel#writeException 619066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 629066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static final void writeExceptionToParcel(Parcel reply, Exception e) { 639066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project int code = 0; 649066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project boolean logException = true; 659066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (e instanceof FileNotFoundException) { 669066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project code = 1; 679066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project logException = false; 689066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else if (e instanceof IllegalArgumentException) { 699066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project code = 2; 709066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else if (e instanceof UnsupportedOperationException) { 719066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project code = 3; 729066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else if (e instanceof SQLiteAbortException) { 739066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project code = 4; 749066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else if (e instanceof SQLiteConstraintException) { 759066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project code = 5; 769066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else if (e instanceof SQLiteDatabaseCorruptException) { 779066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project code = 6; 789066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else if (e instanceof SQLiteFullException) { 799066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project code = 7; 809066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else if (e instanceof SQLiteDiskIOException) { 819066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project code = 8; 829066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else if (e instanceof SQLiteException) { 839066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project code = 9; 848943737692169f564cd34a9c8d471f3a5d438712Fred Quintana } else if (e instanceof OperationApplicationException) { 858943737692169f564cd34a9c8d471f3a5d438712Fred Quintana code = 10; 869066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else { 879066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project reply.writeException(e); 889066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project Log.e(TAG, "Writing exception to parcel", e); 899066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return; 909066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 919066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project reply.writeInt(code); 929066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project reply.writeString(e.getMessage()); 939066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 949066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (logException) { 959066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project Log.e(TAG, "Writing exception to parcel", e); 969066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 979066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 989066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 999066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 1009066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Special function for reading an exception result from the header of 1019066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * a parcel, to be used after receiving the result of a transaction. This 1029066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * will throw the exception for you if it had been written to the Parcel, 1039066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * otherwise return and let you read the normal result data from the Parcel. 1049066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param reply Parcel to read from 1059066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @see Parcel#writeNoException 1069066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @see Parcel#readException 1079066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 1089066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static final void readExceptionFromParcel(Parcel reply) { 1099066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project int code = reply.readInt(); 1109066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (code == 0) return; 1119066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project String msg = reply.readString(); 1129066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project DatabaseUtils.readExceptionFromParcel(reply, msg, code); 1139066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1149066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1159066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static void readExceptionWithFileNotFoundExceptionFromParcel( 1169066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project Parcel reply) throws FileNotFoundException { 1179066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project int code = reply.readInt(); 1189066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (code == 0) return; 1199066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project String msg = reply.readString(); 1209066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (code == 1) { 1219066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project throw new FileNotFoundException(msg); 1229066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else { 1239066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project DatabaseUtils.readExceptionFromParcel(reply, msg, code); 1249066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1259066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1269066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1278943737692169f564cd34a9c8d471f3a5d438712Fred Quintana public static void readExceptionWithOperationApplicationExceptionFromParcel( 1288943737692169f564cd34a9c8d471f3a5d438712Fred Quintana Parcel reply) throws OperationApplicationException { 1298943737692169f564cd34a9c8d471f3a5d438712Fred Quintana int code = reply.readInt(); 1308943737692169f564cd34a9c8d471f3a5d438712Fred Quintana if (code == 0) return; 1318943737692169f564cd34a9c8d471f3a5d438712Fred Quintana String msg = reply.readString(); 1328943737692169f564cd34a9c8d471f3a5d438712Fred Quintana if (code == 10) { 1338943737692169f564cd34a9c8d471f3a5d438712Fred Quintana throw new OperationApplicationException(msg); 1348943737692169f564cd34a9c8d471f3a5d438712Fred Quintana } else { 1358943737692169f564cd34a9c8d471f3a5d438712Fred Quintana DatabaseUtils.readExceptionFromParcel(reply, msg, code); 1368943737692169f564cd34a9c8d471f3a5d438712Fred Quintana } 1378943737692169f564cd34a9c8d471f3a5d438712Fred Quintana } 1388943737692169f564cd34a9c8d471f3a5d438712Fred Quintana 1399066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private static final void readExceptionFromParcel(Parcel reply, String msg, int code) { 1409066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project switch (code) { 1419066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project case 2: 1429066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project throw new IllegalArgumentException(msg); 1439066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project case 3: 1449066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project throw new UnsupportedOperationException(msg); 1459066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project case 4: 1469066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project throw new SQLiteAbortException(msg); 1479066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project case 5: 1489066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project throw new SQLiteConstraintException(msg); 1499066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project case 6: 1509066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project throw new SQLiteDatabaseCorruptException(msg); 1519066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project case 7: 1529066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project throw new SQLiteFullException(msg); 1539066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project case 8: 1549066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project throw new SQLiteDiskIOException(msg); 1559066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project case 9: 1569066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project throw new SQLiteException(msg); 1579066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project default: 1589066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project reply.readException(code, msg); 1599066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1609066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1619066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1629066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 1639066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Binds the given Object to the given SQLiteProgram using the proper 1649066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * typing. For example, bind numbers as longs/doubles, and everything else 1659066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * as a string by call toString() on it. 1669066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 1679066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param prog the program to bind the object to 1689066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param index the 1-based index to bind at 1699066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param value the value to bind 1709066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 1719066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static void bindObjectToProgram(SQLiteProgram prog, int index, 1729066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project Object value) { 1739066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (value == null) { 1749066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project prog.bindNull(index); 1759066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else if (value instanceof Double || value instanceof Float) { 1769066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project prog.bindDouble(index, ((Number)value).doubleValue()); 1779066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else if (value instanceof Number) { 1789066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project prog.bindLong(index, ((Number)value).longValue()); 1799066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else if (value instanceof Boolean) { 1809066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project Boolean bool = (Boolean)value; 1819066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (bool) { 1829066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project prog.bindLong(index, 1); 1839066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else { 1849066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project prog.bindLong(index, 0); 1859066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1869066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else if (value instanceof byte[]){ 1879066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project prog.bindBlob(index, (byte[]) value); 1889066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else { 1899066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project prog.bindString(index, value.toString()); 1909066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1919066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1929066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1939066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 1949066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Appends an SQL string to the given StringBuilder, including the opening 1959066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * and closing single quotes. Any single quotes internal to sqlString will 1969066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * be escaped. 1979066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 1989066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * This method is deprecated because we want to encourage everyone 1999066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * to use the "?" binding form. However, when implementing a 2009066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * ContentProvider, one may want to add WHERE clauses that were 2019066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * not provided by the caller. Since "?" is a positional form, 2029066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * using it in this case could break the caller because the 2039066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * indexes would be shifted to accomodate the ContentProvider's 2049066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * internal bindings. In that case, it may be necessary to 2059066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * construct a WHERE clause manually. This method is useful for 2069066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * those cases. 2079066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 2089066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param sb the StringBuilder that the SQL string will be appended to 2099066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param sqlString the raw string to be appended, which may contain single 2109066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * quotes 2119066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 2129066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static void appendEscapedSQLString(StringBuilder sb, String sqlString) { 2139066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sb.append('\''); 2149066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (sqlString.indexOf('\'') != -1) { 2159066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project int length = sqlString.length(); 2169066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project for (int i = 0; i < length; i++) { 2179066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project char c = sqlString.charAt(i); 2189066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (c == '\'') { 2199066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sb.append('\''); 2209066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 2219066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sb.append(c); 2229066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 2239066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else 2249066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sb.append(sqlString); 2259066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sb.append('\''); 2269066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 22722f711423e66750cd44a64e75372ea66304fb9a1Fred Quintana 2289066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 2299066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * SQL-escape a string. 2309066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 2319066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static String sqlEscapeString(String value) { 2329066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project StringBuilder escaper = new StringBuilder(); 2339066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 2349066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project DatabaseUtils.appendEscapedSQLString(escaper, value); 2359066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 2369066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return escaper.toString(); 2379066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 2389066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 2399066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 2409066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Appends an Object to an SQL string with the proper escaping, etc. 2419066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 2429066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static final void appendValueToSql(StringBuilder sql, Object value) { 2439066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (value == null) { 2449066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sql.append("NULL"); 2459066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else if (value instanceof Boolean) { 2469066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project Boolean bool = (Boolean)value; 2479066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (bool) { 2489066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sql.append('1'); 2499066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else { 2509066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sql.append('0'); 2519066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 2529066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else { 2539066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project appendEscapedSQLString(sql, value.toString()); 2549066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 2559066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 25622f711423e66750cd44a64e75372ea66304fb9a1Fred Quintana 2579066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 2589066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Concatenates two SQL WHERE clauses, handling empty or null values. 2599066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @hide 2609066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 2619066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static String concatenateWhere(String a, String b) { 2629066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (TextUtils.isEmpty(a)) { 2639066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return b; 2649066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 2659066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (TextUtils.isEmpty(b)) { 2669066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return a; 2679066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 26822f711423e66750cd44a64e75372ea66304fb9a1Fred Quintana 2699066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return "(" + a + ") AND (" + b + ")"; 2709066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 27122f711423e66750cd44a64e75372ea66304fb9a1Fred Quintana 2729066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 27322f711423e66750cd44a64e75372ea66304fb9a1Fred Quintana * return the collation key 2749066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param name 2759066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @return the collation key 2769066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 2779066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static String getCollationKey(String name) { 2789066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project byte [] arr = getCollationKeyInBytes(name); 2799066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project try { 2809066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return new String(arr, 0, getKeyLen(arr), "ISO8859_1"); 2819066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } catch (Exception ex) { 2829066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return ""; 2839066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 2849066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 28522f711423e66750cd44a64e75372ea66304fb9a1Fred Quintana 2869066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 2879066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * return the collation key in hex format 2889066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param name 2899066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @return the collation key in hex format 2909066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 2919066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static String getHexCollationKey(String name) { 2929066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project byte [] arr = getCollationKeyInBytes(name); 2939066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project char[] keys = Hex.encodeHex(arr); 2949066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return new String(keys, 0, getKeyLen(arr) * 2); 2959066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 29622f711423e66750cd44a64e75372ea66304fb9a1Fred Quintana 2979066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private static int getKeyLen(byte[] arr) { 2989066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (arr[arr.length - 1] != 0) { 2999066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return arr.length; 3009066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else { 3019066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // remove zero "termination" 3029066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return arr.length-1; 3039066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 3049066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 30522f711423e66750cd44a64e75372ea66304fb9a1Fred Quintana 3069066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private static byte[] getCollationKeyInBytes(String name) { 3079066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (mColl == null) { 3089066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mColl = Collator.getInstance(); 3099066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mColl.setStrength(Collator.PRIMARY); 3109066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 31122f711423e66750cd44a64e75372ea66304fb9a1Fred Quintana return mColl.getCollationKey(name).toByteArray(); 3129066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 31322f711423e66750cd44a64e75372ea66304fb9a1Fred Quintana 31422f711423e66750cd44a64e75372ea66304fb9a1Fred Quintana private static Collator mColl = null; 3159066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 3169066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Prints the contents of a Cursor to System.out. The position is restored 3179066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * after printing. 3189066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 3199066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param cursor the cursor to print 3209066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 3219066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static void dumpCursor(Cursor cursor) { 3229066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project dumpCursor(cursor, System.out); 3239066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 3249066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 3259066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 3269066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Prints the contents of a Cursor to a PrintSteam. The position is restored 3279066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * after printing. 3289066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 3299066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param cursor the cursor to print 3309066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param stream the stream to print to 3319066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 3329066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static void dumpCursor(Cursor cursor, PrintStream stream) { 3339066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project stream.println(">>>>> Dumping cursor " + cursor); 3349066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (cursor != null) { 3359066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project int startPos = cursor.getPosition(); 3369066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 3379066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project cursor.moveToPosition(-1); 3389066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project while (cursor.moveToNext()) { 3399066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project dumpCurrentRow(cursor, stream); 3409066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 3419066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project cursor.moveToPosition(startPos); 3429066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 3439066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project stream.println("<<<<<"); 3449066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 3459066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 3469066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 3479066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Prints the contents of a Cursor to a StringBuilder. The position 3489066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * is restored after printing. 3499066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 3509066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param cursor the cursor to print 3519066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param sb the StringBuilder to print to 3529066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 3539066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static void dumpCursor(Cursor cursor, StringBuilder sb) { 3549066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sb.append(">>>>> Dumping cursor " + cursor + "\n"); 3559066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (cursor != null) { 3569066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project int startPos = cursor.getPosition(); 3579066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 3589066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project cursor.moveToPosition(-1); 3599066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project while (cursor.moveToNext()) { 3609066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project dumpCurrentRow(cursor, sb); 3619066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 3629066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project cursor.moveToPosition(startPos); 3639066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 3649066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sb.append("<<<<<\n"); 3659066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 3669066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 3679066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 3689066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Prints the contents of a Cursor to a String. The position is restored 3699066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * after printing. 3709066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 3719066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param cursor the cursor to print 3729066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @return a String that contains the dumped cursor 3739066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 3749066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static String dumpCursorToString(Cursor cursor) { 3759066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project StringBuilder sb = new StringBuilder(); 3769066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project dumpCursor(cursor, sb); 3779066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return sb.toString(); 3789066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 3799066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 3809066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 3819066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Prints the contents of a Cursor's current row to System.out. 3829066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 3839066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param cursor the cursor to print from 3849066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 3859066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static void dumpCurrentRow(Cursor cursor) { 3869066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project dumpCurrentRow(cursor, System.out); 3879066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 3889066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 3899066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 3909066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Prints the contents of a Cursor's current row to a PrintSteam. 3919066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 3929066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param cursor the cursor to print 3939066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param stream the stream to print to 3949066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 3959066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static void dumpCurrentRow(Cursor cursor, PrintStream stream) { 3969066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project String[] cols = cursor.getColumnNames(); 3979066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project stream.println("" + cursor.getPosition() + " {"); 3989066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project int length = cols.length; 3999066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project for (int i = 0; i< length; i++) { 4009066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project String value; 4019066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project try { 4029066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project value = cursor.getString(i); 4039066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } catch (SQLiteException e) { 4049066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // assume that if the getString threw this exception then the column is not 4059066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // representable by a string, e.g. it is a BLOB. 4069066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project value = "<unprintable>"; 4079066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 4089066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project stream.println(" " + cols[i] + '=' + value); 4099066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 4109066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project stream.println("}"); 4119066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 4129066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 4139066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 4149066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Prints the contents of a Cursor's current row to a StringBuilder. 4159066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 4169066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param cursor the cursor to print 4179066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param sb the StringBuilder to print to 4189066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 4199066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static void dumpCurrentRow(Cursor cursor, StringBuilder sb) { 4209066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project String[] cols = cursor.getColumnNames(); 4219066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sb.append("" + cursor.getPosition() + " {\n"); 4229066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project int length = cols.length; 4239066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project for (int i = 0; i < length; i++) { 4249066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project String value; 4259066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project try { 4269066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project value = cursor.getString(i); 4279066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } catch (SQLiteException e) { 4289066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // assume that if the getString threw this exception then the column is not 4299066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // representable by a string, e.g. it is a BLOB. 4309066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project value = "<unprintable>"; 4319066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 4329066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sb.append(" " + cols[i] + '=' + value + "\n"); 4339066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 4349066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sb.append("}\n"); 4359066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 4369066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 4379066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 4389066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Dump the contents of a Cursor's current row to a String. 4399066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 4409066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param cursor the cursor to print 4419066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @return a String that contains the dumped cursor row 4429066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 4439066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static String dumpCurrentRowToString(Cursor cursor) { 4449066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project StringBuilder sb = new StringBuilder(); 4459066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project dumpCurrentRow(cursor, sb); 4469066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return sb.toString(); 4479066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 4489066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 4499066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 4509066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Reads a String out of a field in a Cursor and writes it to a Map. 4519066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 4529066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param cursor The cursor to read from 4539066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param field The TEXT field to read 4549066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param values The {@link ContentValues} to put the value into, with the field as the key 4559066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 4569066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static void cursorStringToContentValues(Cursor cursor, String field, 4579066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project ContentValues values) { 4589066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project cursorStringToContentValues(cursor, field, values, field); 4599066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 4609066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 4619066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 4629066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Reads a String out of a field in a Cursor and writes it to an InsertHelper. 4639066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 4649066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param cursor The cursor to read from 4659066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param field The TEXT field to read 4669066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param inserter The InsertHelper to bind into 4679066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param index the index of the bind entry in the InsertHelper 4689066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 4699066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static void cursorStringToInsertHelper(Cursor cursor, String field, 4709066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project InsertHelper inserter, int index) { 4719066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project inserter.bind(index, cursor.getString(cursor.getColumnIndexOrThrow(field))); 4729066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 4739066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 4749066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 4759066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Reads a String out of a field in a Cursor and writes it to a Map. 4769066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 4779066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param cursor The cursor to read from 4789066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param field The TEXT field to read 4799066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param values The {@link ContentValues} to put the value into, with the field as the key 4809066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param key The key to store the value with in the map 4819066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 4829066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static void cursorStringToContentValues(Cursor cursor, String field, 4839066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project ContentValues values, String key) { 4849066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project values.put(key, cursor.getString(cursor.getColumnIndexOrThrow(field))); 4859066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 4869066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 4879066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 4889066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Reads an Integer out of a field in a Cursor and writes it to a Map. 4899066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 4909066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param cursor The cursor to read from 4919066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param field The INTEGER field to read 4929066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param values The {@link ContentValues} to put the value into, with the field as the key 4939066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 4949066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static void cursorIntToContentValues(Cursor cursor, String field, ContentValues values) { 4959066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project cursorIntToContentValues(cursor, field, values, field); 4969066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 4979066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 4989066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 4999066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Reads a Integer out of a field in a Cursor and writes it to a Map. 5009066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 5019066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param cursor The cursor to read from 5029066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param field The INTEGER field to read 5039066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param values The {@link ContentValues} to put the value into, with the field as the key 5049066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param key The key to store the value with in the map 5059066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 5069066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static void cursorIntToContentValues(Cursor cursor, String field, ContentValues values, 5079066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project String key) { 5089066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project int colIndex = cursor.getColumnIndex(field); 5099066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (!cursor.isNull(colIndex)) { 5109066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project values.put(key, cursor.getInt(colIndex)); 5119066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else { 5129066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project values.put(key, (Integer) null); 5139066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 5149066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 5159066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 5169066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 5179066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Reads a Long out of a field in a Cursor and writes it to a Map. 5189066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 5199066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param cursor The cursor to read from 5209066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param field The INTEGER field to read 5219066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param values The {@link ContentValues} to put the value into, with the field as the key 5229066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 5239066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static void cursorLongToContentValues(Cursor cursor, String field, ContentValues values) 5249066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project { 5259066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project cursorLongToContentValues(cursor, field, values, field); 5269066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 5279066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 5289066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 5299066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Reads a Long out of a field in a Cursor and writes it to a Map. 5309066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 5319066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param cursor The cursor to read from 5329066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param field The INTEGER field to read 5339066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param values The {@link ContentValues} to put the value into 5349066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param key The key to store the value with in the map 5359066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 5369066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static void cursorLongToContentValues(Cursor cursor, String field, ContentValues values, 5379066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project String key) { 5389066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project int colIndex = cursor.getColumnIndex(field); 5399066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (!cursor.isNull(colIndex)) { 5409066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project Long value = Long.valueOf(cursor.getLong(colIndex)); 5419066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project values.put(key, value); 5429066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else { 5439066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project values.put(key, (Long) null); 5449066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 5459066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 5469066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 5479066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 5489066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Reads a Double out of a field in a Cursor and writes it to a Map. 5499066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 5509066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param cursor The cursor to read from 5519066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param field The REAL field to read 5529066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param values The {@link ContentValues} to put the value into 5539066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 5549066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static void cursorDoubleToCursorValues(Cursor cursor, String field, ContentValues values) 5559066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project { 5569066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project cursorDoubleToContentValues(cursor, field, values, field); 5579066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 5589066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 5599066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 5609066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Reads a Double out of a field in a Cursor and writes it to a Map. 5619066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 5629066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param cursor The cursor to read from 5639066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param field The REAL field to read 5649066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param values The {@link ContentValues} to put the value into 5659066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param key The key to store the value with in the map 5669066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 5679066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static void cursorDoubleToContentValues(Cursor cursor, String field, 5689066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project ContentValues values, String key) { 5699066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project int colIndex = cursor.getColumnIndex(field); 5709066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (!cursor.isNull(colIndex)) { 5719066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project values.put(key, cursor.getDouble(colIndex)); 5729066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else { 5739066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project values.put(key, (Double) null); 5749066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 5759066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 5769066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 5779066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 5789066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Read the entire contents of a cursor row and store them in a ContentValues. 5799066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 5809066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param cursor the cursor to read from. 5819066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param values the {@link ContentValues} to put the row into. 5829066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 5839066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static void cursorRowToContentValues(Cursor cursor, ContentValues values) { 5849066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project AbstractWindowedCursor awc = 5859066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project (cursor instanceof AbstractWindowedCursor) ? (AbstractWindowedCursor) cursor : null; 5869066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 5879066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project String[] columns = cursor.getColumnNames(); 5889066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project int length = columns.length; 5899066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project for (int i = 0; i < length; i++) { 5909066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (awc != null && awc.isBlob(i)) { 5919066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project values.put(columns[i], cursor.getBlob(i)); 5929066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else { 5939066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project values.put(columns[i], cursor.getString(i)); 5949066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 5959066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 5969066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 5979066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 5989066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 5999066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Query the table for the number of rows in the table. 6009066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param db the database the table is in 6019066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param table the name of the table to query 6029066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @return the number of rows in the table 6039066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 6049066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static long queryNumEntries(SQLiteDatabase db, String table) { 605e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer return queryNumEntries(db, table, null, null); 606e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer } 607e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer 608e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer /** 609e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer * Query the table for the number of rows in the table. 610e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer * @param db the database the table is in 611e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer * @param table the name of the table to query 612e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer * @param selection A filter declaring which rows to return, 613e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer * formatted as an SQL WHERE clause (excluding the WHERE itself). 614e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer * Passing null will count all rows for the given table 615e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer * @return the number of rows in the table filtered by the selection 616e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer */ 617e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer public static long queryNumEntries(SQLiteDatabase db, String table, String selection) { 618e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer return queryNumEntries(db, table, selection, null); 619e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer } 620e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer 621e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer /** 622e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer * Query the table for the number of rows in the table. 623e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer * @param db the database the table is in 624e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer * @param table the name of the table to query 625e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer * @param selection A filter declaring which rows to return, 626e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer * formatted as an SQL WHERE clause (excluding the WHERE itself). 627e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer * Passing null will count all rows for the given table 628e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer * @param selectionArgs You may include ?s in selection, 629e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer * which will be replaced by the values from selectionArgs, 630e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer * in order that they appear in the selection. 631e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer * The values will be bound as Strings. 632e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer * @return the number of rows in the table filtered by the selection 633e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer */ 634e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer public static long queryNumEntries(SQLiteDatabase db, String table, String selection, 635e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer String[] selectionArgs) { 636e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer String s = (!TextUtils.isEmpty(selection)) ? " where " + selection : ""; 637e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer return longForQuery(db, "select count(*) from " + table + s, 638e7731f0a7f824add1fffa391965cbfeaf7cb2cf2Christian Mehlmauer selectionArgs); 6399066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 6409066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 6419066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 6429066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Utility method to run the query on the db and return the value in the 6439066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * first column of the first row. 6449066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 6459066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static long longForQuery(SQLiteDatabase db, String query, String[] selectionArgs) { 6469066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project SQLiteStatement prog = db.compileStatement(query); 6479066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project try { 6489066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return longForQuery(prog, selectionArgs); 6499066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } finally { 6509066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project prog.close(); 6519066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 6529066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 6539066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 6549066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 6559066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Utility method to run the pre-compiled query and return the value in the 6569066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * first column of the first row. 6579066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 6589066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static long longForQuery(SQLiteStatement prog, String[] selectionArgs) { 6599066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (selectionArgs != null) { 6609066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project int size = selectionArgs.length; 6619066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project for (int i = 0; i < size; i++) { 6629066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project bindObjectToProgram(prog, i + 1, selectionArgs[i]); 6639066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 6649066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 6659066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project long value = prog.simpleQueryForLong(); 6669066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return value; 6679066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 6689066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 6699066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 6709066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Utility method to run the query on the db and return the value in the 6719066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * first column of the first row. 6729066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 6739066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static String stringForQuery(SQLiteDatabase db, String query, String[] selectionArgs) { 6749066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project SQLiteStatement prog = db.compileStatement(query); 6759066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project try { 6769066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return stringForQuery(prog, selectionArgs); 6779066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } finally { 6789066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project prog.close(); 6799066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 6809066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 6819066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 6829066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 6839066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Utility method to run the pre-compiled query and return the value in the 6849066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * first column of the first row. 6859066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 6869066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static String stringForQuery(SQLiteStatement prog, String[] selectionArgs) { 6879066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (selectionArgs != null) { 6889066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project int size = selectionArgs.length; 6899066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project for (int i = 0; i < size; i++) { 6909066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project bindObjectToProgram(prog, i + 1, selectionArgs[i]); 6919066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 6929066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 6939066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project String value = prog.simpleQueryForString(); 6949066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return value; 6959066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 6969066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 6979066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 6982ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * Reads a String out of a column in a Cursor and writes it to a ContentValues. 6992ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * Adds nothing to the ContentValues if the column isn't present or if its value is null. 7002ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * 7012ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * @param cursor The cursor to read from 7022ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * @param column The column to read 7032ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * @param values The {@link ContentValues} to put the value into 7042ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana */ 7052ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana public static void cursorStringToContentValuesIfPresent(Cursor cursor, ContentValues values, 7062ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana String column) { 7072ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana final int index = cursor.getColumnIndexOrThrow(column); 7082ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana if (!cursor.isNull(index)) { 7092ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana values.put(column, cursor.getString(index)); 7102ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana } 7112ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana } 7122ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana 7132ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana /** 7142ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * Reads a Long out of a column in a Cursor and writes it to a ContentValues. 7152ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * Adds nothing to the ContentValues if the column isn't present or if its value is null. 7162ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * 7172ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * @param cursor The cursor to read from 7182ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * @param column The column to read 7192ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * @param values The {@link ContentValues} to put the value into 7202ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana */ 7212ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana public static void cursorLongToContentValuesIfPresent(Cursor cursor, ContentValues values, 7222ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana String column) { 7232ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana final int index = cursor.getColumnIndexOrThrow(column); 7242ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana if (!cursor.isNull(index)) { 7252ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana values.put(column, cursor.getLong(index)); 7262ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana } 7272ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana } 7282ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana 7292ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana /** 7302ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * Reads a Short out of a column in a Cursor and writes it to a ContentValues. 7312ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * Adds nothing to the ContentValues if the column isn't present or if its value is null. 7322ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * 7332ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * @param cursor The cursor to read from 7342ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * @param column The column to read 7352ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * @param values The {@link ContentValues} to put the value into 7362ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana */ 7372ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana public static void cursorShortToContentValuesIfPresent(Cursor cursor, ContentValues values, 7382ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana String column) { 7392ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana final int index = cursor.getColumnIndexOrThrow(column); 7402ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana if (!cursor.isNull(index)) { 7412ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana values.put(column, cursor.getShort(index)); 7422ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana } 7432ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana } 7442ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana 7452ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana /** 7462ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * Reads a Integer out of a column in a Cursor and writes it to a ContentValues. 7472ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * Adds nothing to the ContentValues if the column isn't present or if its value is null. 7482ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * 7492ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * @param cursor The cursor to read from 7502ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * @param column The column to read 7512ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * @param values The {@link ContentValues} to put the value into 7522ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana */ 7532ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana public static void cursorIntToContentValuesIfPresent(Cursor cursor, ContentValues values, 7542ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana String column) { 7552ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana final int index = cursor.getColumnIndexOrThrow(column); 7562ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana if (!cursor.isNull(index)) { 7572ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana values.put(column, cursor.getInt(index)); 7582ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana } 7592ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana } 7602ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana 7612ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana /** 7622ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * Reads a Float out of a column in a Cursor and writes it to a ContentValues. 7632ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * Adds nothing to the ContentValues if the column isn't present or if its value is null. 7642ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * 7652ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * @param cursor The cursor to read from 7662ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * @param column The column to read 7672ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * @param values The {@link ContentValues} to put the value into 7682ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana */ 7692ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana public static void cursorFloatToContentValuesIfPresent(Cursor cursor, ContentValues values, 7702ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana String column) { 7712ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana final int index = cursor.getColumnIndexOrThrow(column); 7722ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana if (!cursor.isNull(index)) { 7732ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana values.put(column, cursor.getFloat(index)); 7742ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana } 7752ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana } 7762ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana 7772ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana /** 7782ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * Reads a Double out of a column in a Cursor and writes it to a ContentValues. 7792ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * Adds nothing to the ContentValues if the column isn't present or if its value is null. 7802ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * 7812ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * @param cursor The cursor to read from 7822ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * @param column The column to read 7832ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana * @param values The {@link ContentValues} to put the value into 7842ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana */ 7852ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana public static void cursorDoubleToContentValuesIfPresent(Cursor cursor, ContentValues values, 7862ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana String column) { 7872ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana final int index = cursor.getColumnIndexOrThrow(column); 7882ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana if (!cursor.isNull(index)) { 7892ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana values.put(column, cursor.getDouble(index)); 7902ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana } 7912ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana } 7922ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana 7932ec6c5699181316e5a5c2cd293c006ac4a8bb101Fred Quintana /** 7949066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * This class allows users to do multiple inserts into a table but 7959066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * compile the SQL insert statement only once, which may increase 7969066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * performance. 7979066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 7989066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static class InsertHelper { 7999066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private final SQLiteDatabase mDb; 8009066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private final String mTableName; 8019066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private HashMap<String, Integer> mColumns; 8029066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private String mInsertSQL = null; 8039066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private SQLiteStatement mInsertStatement = null; 8049066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private SQLiteStatement mReplaceStatement = null; 8059066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private SQLiteStatement mPreparedStatement = null; 8069066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 8079066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 8089066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * {@hide} 8099066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 8109066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * These are the columns returned by sqlite's "PRAGMA 8119066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * table_info(...)" command that we depend on. 8129066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 8139066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static final int TABLE_INFO_PRAGMA_COLUMNNAME_INDEX = 1; 8149066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static final int TABLE_INFO_PRAGMA_DEFAULT_INDEX = 4; 8159066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 8169066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 8179066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param db the SQLiteDatabase to insert into 8189066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param tableName the name of the table to insert into 8199066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 8209066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public InsertHelper(SQLiteDatabase db, String tableName) { 8219066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mDb = db; 8229066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mTableName = tableName; 8239066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 8249066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 8259066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private void buildSQL() throws SQLException { 8269066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project StringBuilder sb = new StringBuilder(128); 8279066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sb.append("INSERT INTO "); 8289066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sb.append(mTableName); 8299066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sb.append(" ("); 8309066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 8319066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project StringBuilder sbv = new StringBuilder(128); 8329066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sbv.append("VALUES ("); 8339066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 8349066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project int i = 1; 8359066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project Cursor cur = null; 8369066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project try { 8379066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project cur = mDb.rawQuery("PRAGMA table_info(" + mTableName + ")", null); 8389066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mColumns = new HashMap<String, Integer>(cur.getCount()); 8399066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project while (cur.moveToNext()) { 8409066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project String columnName = cur.getString(TABLE_INFO_PRAGMA_COLUMNNAME_INDEX); 8419066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project String defaultValue = cur.getString(TABLE_INFO_PRAGMA_DEFAULT_INDEX); 8429066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 8439066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mColumns.put(columnName, i); 8449066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sb.append("'"); 8459066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sb.append(columnName); 8469066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sb.append("'"); 8479066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 8489066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (defaultValue == null) { 8499066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sbv.append("?"); 8509066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else { 8519066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sbv.append("COALESCE(?, "); 8529066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sbv.append(defaultValue); 8539066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sbv.append(")"); 8549066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 8559066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 8569066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sb.append(i == cur.getCount() ? ") " : ", "); 8579066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sbv.append(i == cur.getCount() ? ");" : ", "); 8589066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project ++i; 8599066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 8609066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } finally { 8619066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (cur != null) cur.close(); 8629066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 8639066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 8649066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project sb.append(sbv); 8659066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 8669066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mInsertSQL = sb.toString(); 8679066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (LOCAL_LOGV) Log.v(TAG, "insert statement is " + mInsertSQL); 8689066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 8699066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 8709066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private SQLiteStatement getStatement(boolean allowReplace) throws SQLException { 8719066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (allowReplace) { 8729066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (mReplaceStatement == null) { 8739066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (mInsertSQL == null) buildSQL(); 8749066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // chop "INSERT" off the front and prepend "INSERT OR REPLACE" instead. 8759066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project String replaceSQL = "INSERT OR REPLACE" + mInsertSQL.substring(6); 8769066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mReplaceStatement = mDb.compileStatement(replaceSQL); 8779066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 8789066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return mReplaceStatement; 8799066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else { 8809066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (mInsertStatement == null) { 8819066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (mInsertSQL == null) buildSQL(); 8829066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mInsertStatement = mDb.compileStatement(mInsertSQL); 8839066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 8849066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return mInsertStatement; 8859066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 8869066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 8879066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 8889066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 8899066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Performs an insert, adding a new row with the given values. 8909066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 8919066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param values the set of values with which to populate the 8929066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * new row 8939066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param allowReplace if true, the statement does "INSERT OR 8949066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * REPLACE" instead of "INSERT", silently deleting any 8959066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * previously existing rows that would cause a conflict 8969066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 8979066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @return the row ID of the newly inserted row, or -1 if an 8989066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * error occurred 8999066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 9009066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private synchronized long insertInternal(ContentValues values, boolean allowReplace) { 9019066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project try { 9029066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project SQLiteStatement stmt = getStatement(allowReplace); 9039066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project stmt.clearBindings(); 9049066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (LOCAL_LOGV) Log.v(TAG, "--- inserting in table " + mTableName); 9059066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project for (Map.Entry<String, Object> e: values.valueSet()) { 9069066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project final String key = e.getKey(); 9079066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project int i = getColumnIndex(key); 9089066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project DatabaseUtils.bindObjectToProgram(stmt, i, e.getValue()); 9099066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (LOCAL_LOGV) { 9109066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project Log.v(TAG, "binding " + e.getValue() + " to column " + 9119066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project i + " (" + key + ")"); 9129066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 9139066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 9149066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return stmt.executeInsert(); 9159066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } catch (SQLException e) { 9169066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project Log.e(TAG, "Error inserting " + values + " into table " + mTableName, e); 9179066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return -1; 9189066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 9199066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 9209066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 9219066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 9229066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Returns the index of the specified column. This is index is suitagble for use 9239066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * in calls to bind(). 9249066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param key the column name 9259066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @return the index of the column 9269066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 9279066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public int getColumnIndex(String key) { 9289066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project getStatement(false); 9299066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project final Integer index = mColumns.get(key); 9309066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (index == null) { 9319066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project throw new IllegalArgumentException("column '" + key + "' is invalid"); 9329066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 9339066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return index; 9349066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 9359066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 9369066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 9379066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Bind the value to an index. A prepareForInsert() or prepareForReplace() 9389066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * without a matching execute() must have already have been called. 9399066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param index the index of the slot to which to bind 9409066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param value the value to bind 9419066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 9429066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public void bind(int index, double value) { 9439066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mPreparedStatement.bindDouble(index, value); 9449066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 9459066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 9469066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 9479066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Bind the value to an index. A prepareForInsert() or prepareForReplace() 9489066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * without a matching execute() must have already have been called. 9499066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param index the index of the slot to which to bind 9509066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param value the value to bind 9519066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 9529066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public void bind(int index, float value) { 9539066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mPreparedStatement.bindDouble(index, value); 9549066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 9559066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 9569066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 9579066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Bind the value to an index. A prepareForInsert() or prepareForReplace() 9589066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * without a matching execute() must have already have been called. 9599066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param index the index of the slot to which to bind 9609066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param value the value to bind 9619066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 9629066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public void bind(int index, long value) { 9639066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mPreparedStatement.bindLong(index, value); 9649066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 9659066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 9669066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 9679066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Bind the value to an index. A prepareForInsert() or prepareForReplace() 9689066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * without a matching execute() must have already have been called. 9699066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param index the index of the slot to which to bind 9709066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param value the value to bind 9719066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 9729066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public void bind(int index, int value) { 9739066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mPreparedStatement.bindLong(index, value); 9749066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 9759066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 9769066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 9779066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Bind the value to an index. A prepareForInsert() or prepareForReplace() 9789066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * without a matching execute() must have already have been called. 9799066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param index the index of the slot to which to bind 9809066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param value the value to bind 9819066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 9829066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public void bind(int index, boolean value) { 9839066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mPreparedStatement.bindLong(index, value ? 1 : 0); 9849066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 9859066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 9869066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 9879066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Bind null to an index. A prepareForInsert() or prepareForReplace() 9889066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * without a matching execute() must have already have been called. 9899066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param index the index of the slot to which to bind 9909066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 9919066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public void bindNull(int index) { 9929066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mPreparedStatement.bindNull(index); 9939066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 9949066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 9959066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 9969066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Bind the value to an index. A prepareForInsert() or prepareForReplace() 9979066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * without a matching execute() must have already have been called. 9989066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param index the index of the slot to which to bind 9999066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param value the value to bind 10009066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 10019066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public void bind(int index, byte[] value) { 10029066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (value == null) { 10039066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mPreparedStatement.bindNull(index); 10049066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else { 10059066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mPreparedStatement.bindBlob(index, value); 10069066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 10079066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 10089066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 10099066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 10109066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Bind the value to an index. A prepareForInsert() or prepareForReplace() 10119066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * without a matching execute() must have already have been called. 10129066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param index the index of the slot to which to bind 10139066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param value the value to bind 10149066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 10159066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public void bind(int index, String value) { 10169066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (value == null) { 10179066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mPreparedStatement.bindNull(index); 10189066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else { 10199066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mPreparedStatement.bindString(index, value); 10209066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 10219066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 10229066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 10239066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 10249066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Performs an insert, adding a new row with the given values. 10259066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * If the table contains conflicting rows, an error is 10269066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * returned. 10279066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 10289066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param values the set of values with which to populate the 10299066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * new row 10309066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 10319066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @return the row ID of the newly inserted row, or -1 if an 10329066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * error occurred 10339066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 10349066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public long insert(ContentValues values) { 10359066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return insertInternal(values, false); 10369066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 10379066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 10389066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 10399066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Execute the previously prepared insert or replace using the bound values 10409066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * since the last call to prepareForInsert or prepareForReplace. 10419066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 10429066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * <p>Note that calling bind() and then execute() is not thread-safe. The only thread-safe 10439066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * way to use this class is to call insert() or replace(). 10449066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 10459066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @return the row ID of the newly inserted row, or -1 if an 10469066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * error occurred 10479066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 10489066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public long execute() { 10499066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (mPreparedStatement == null) { 10509066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project throw new IllegalStateException("you must prepare this inserter before calling " 10519066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project + "execute"); 10529066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 10539066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project try { 10549066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (LOCAL_LOGV) Log.v(TAG, "--- doing insert or replace in table " + mTableName); 10559066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return mPreparedStatement.executeInsert(); 10569066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } catch (SQLException e) { 10579066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project Log.e(TAG, "Error executing InsertHelper with table " + mTableName, e); 10589066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return -1; 10599066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } finally { 10609066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // you can only call this once per prepare 10619066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mPreparedStatement = null; 10629066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 10639066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 10649066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 10659066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 10669066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Prepare the InsertHelper for an insert. The pattern for this is: 10679066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * <ul> 10689066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * <li>prepareForInsert() 10699066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * <li>bind(index, value); 10709066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * <li>bind(index, value); 10719066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * <li>... 10729066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * <li>bind(index, value); 10739066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * <li>execute(); 10749066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * </ul> 10759066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 10769066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public void prepareForInsert() { 10779066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mPreparedStatement = getStatement(false); 10789066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mPreparedStatement.clearBindings(); 10799066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 10809066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 10819066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 10829066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Prepare the InsertHelper for a replace. The pattern for this is: 10839066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * <ul> 10849066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * <li>prepareForReplace() 10859066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * <li>bind(index, value); 10869066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * <li>bind(index, value); 10879066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * <li>... 10889066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * <li>bind(index, value); 10899066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * <li>execute(); 10909066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * </ul> 10919066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 10929066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public void prepareForReplace() { 10939066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mPreparedStatement = getStatement(true); 10949066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mPreparedStatement.clearBindings(); 10959066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 10969066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 10979066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 10989066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Performs an insert, adding a new row with the given values. 10999066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * If the table contains conflicting rows, they are deleted 11009066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * and replaced with the new row. 11019066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 11029066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param values the set of values with which to populate the 11039066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * new row 11049066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 11059066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @return the row ID of the newly inserted row, or -1 if an 11069066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * error occurred 11079066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 11089066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public long replace(ContentValues values) { 11099066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return insertInternal(values, true); 11109066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 11119066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 11129066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 11139066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Close this object and release any resources associated with 11149066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * it. The behavior of calling <code>insert()</code> after 11159066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * calling this method is undefined. 11169066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 11179066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public void close() { 11189066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (mInsertStatement != null) { 11199066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mInsertStatement.close(); 11209066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mInsertStatement = null; 11219066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 11229066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (mReplaceStatement != null) { 11239066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mReplaceStatement.close(); 11249066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mReplaceStatement = null; 11259066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 11269066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mInsertSQL = null; 11279066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mColumns = null; 11289066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 11299066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 11309066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 11319066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 11329066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Creates a db and populates it with the sql statements in sqlStatements. 11339066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 11349066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param context the context to use to create the db 11359066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param dbName the name of the db to create 11369066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param dbVersion the version to set on the db 11379066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param sqlStatements the statements to use to populate the db. This should be a single string 11389066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * of the form returned by sqlite3's <tt>.dump</tt> command (statements separated by 11399066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * semicolons) 11409066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 11419066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project static public void createDbFromSqlStatements( 11429066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project Context context, String dbName, int dbVersion, String sqlStatements) { 11439066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project SQLiteDatabase db = context.openOrCreateDatabase(dbName, 0, null); 11449066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // TODO: this is not quite safe since it assumes that all semicolons at the end of a line 11459066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // terminate statements. It is possible that a text field contains ;\n. We will have to fix 11469066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // this if that turns out to be a problem. 11479066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project String[] statements = TextUtils.split(sqlStatements, ";\n"); 11489066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project for (String statement : statements) { 11499066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (TextUtils.isEmpty(statement)) continue; 11509066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project db.execSQL(statement); 11519066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 11529066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project db.setVersion(dbVersion); 11539066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project db.close(); 11549066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 11559066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project} 1156