19066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project/* 29066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Copyright (C) 2008 Esmertec AG. 39066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Copyright (C) 2008 The Android Open Source Project 49066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 59066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Licensed under the Apache License, Version 2.0 (the "License"); 69066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * you may not use this file except in compliance with the License. 79066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * You may obtain a copy of the License at 89066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 99066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * http://www.apache.org/licenses/LICENSE-2.0 109066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 119066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Unless required by applicable law or agreed to in writing, software 129066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * distributed under the License is distributed on an "AS IS" BASIS, 139066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. 149066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * See the License for the specific language governing permissions and 159066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * limitations under the License. 169066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 179066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 185e342fa3260044353705c946d3ae62c89df52ee6Tom Taylorpackage android.database.sqlite; 199066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 209066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.content.ContentResolver; 219066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.content.ContentValues; 229066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.content.Context; 239066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.database.Cursor; 249066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.database.sqlite.SQLiteException; 259066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.net.Uri; 269066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.util.Log; 279066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.widget.Toast; 289066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 295e342fa3260044353705c946d3ae62c89df52ee6Tom Taylor/** 305e342fa3260044353705c946d3ae62c89df52ee6Tom Taylor * @hide 315e342fa3260044353705c946d3ae62c89df52ee6Tom Taylor */ 325e342fa3260044353705c946d3ae62c89df52ee6Tom Taylor 339066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectpublic final class SqliteWrapper { 349066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private static final String TAG = "SqliteWrapper"; 359066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private static final String SQLITE_EXCEPTION_DETAIL_MESSAGE 369066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project = "unable to open database file"; 379066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 389066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private SqliteWrapper() { 399066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // Forbidden being instantiated. 409066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 419066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 429066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // FIXME: need to optimize this method. 439066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private static boolean isLowMemory(SQLiteException e) { 449066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return e.getMessage().equals(SQLITE_EXCEPTION_DETAIL_MESSAGE); 459066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 469066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 479066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static void checkSQLiteException(Context context, SQLiteException e) { 489066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (isLowMemory(e)) { 499066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project Toast.makeText(context, com.android.internal.R.string.low_memory, 509066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project Toast.LENGTH_SHORT).show(); 519066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else { 529066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project throw e; 539066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 549066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 559066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 569066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static Cursor query(Context context, ContentResolver resolver, Uri uri, 579066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project String[] projection, String selection, String[] selectionArgs, String sortOrder) { 589066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project try { 599066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return resolver.query(uri, projection, selection, selectionArgs, sortOrder); 609066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } catch (SQLiteException e) { 619066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project Log.e(TAG, "Catch a SQLiteException when query: ", e); 629066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project checkSQLiteException(context, e); 639066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return null; 649066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 659066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 669066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 679066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static boolean requery(Context context, Cursor cursor) { 689066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project try { 699066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return cursor.requery(); 709066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } catch (SQLiteException e) { 719066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project Log.e(TAG, "Catch a SQLiteException when requery: ", e); 729066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project checkSQLiteException(context, e); 739066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return false; 749066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 759066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 769066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static int update(Context context, ContentResolver resolver, Uri uri, 779066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project ContentValues values, String where, String[] selectionArgs) { 789066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project try { 799066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return resolver.update(uri, values, where, selectionArgs); 809066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } catch (SQLiteException e) { 819066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project Log.e(TAG, "Catch a SQLiteException when update: ", e); 829066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project checkSQLiteException(context, e); 839066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return -1; 849066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 859066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 869066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 879066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static int delete(Context context, ContentResolver resolver, Uri uri, 889066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project String where, String[] selectionArgs) { 899066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project try { 909066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return resolver.delete(uri, where, selectionArgs); 919066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } catch (SQLiteException e) { 929066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project Log.e(TAG, "Catch a SQLiteException when delete: ", e); 939066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project checkSQLiteException(context, e); 949066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return -1; 959066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 969066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 979066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 989066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static Uri insert(Context context, ContentResolver resolver, 999066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project Uri uri, ContentValues values) { 1009066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project try { 1019066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return resolver.insert(uri, values); 1029066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } catch (SQLiteException e) { 1039066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project Log.e(TAG, "Catch a SQLiteException when insert: ", e); 1049066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project checkSQLiteException(context, e); 1059066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return null; 1069066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1079066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1089066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project} 109