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