19066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project/*
29066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Copyright (C) 2007 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
171a44d5dcabc18cd5ef111f732ccff91683a1a093Neal Nguyenpackage android.app.activity;
189066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project
199066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.content.UriMatcher;
209066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.content.*;
219066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.database.Cursor;
229066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.database.sqlite.SQLiteDatabase;
239066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.database.sqlite.SQLiteOpenHelper;
249066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.database.sqlite.SQLiteQueryBuilder;
259066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.net.Uri;
269066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.util.Log;
279066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project
289066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project/** Simple test provider that runs in the local process. */
299066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectpublic class LocalProvider extends ContentProvider {
309066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project    private static final String TAG = "LocalProvider";
319066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project
329066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project    private SQLiteOpenHelper mOpenHelper;
339066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project
349066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project    private static final int DATA = 1;
359066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project    private static final int DATA_ID = 2;
369066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project    private static final UriMatcher sURLMatcher = new UriMatcher(
379066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project            UriMatcher.NO_MATCH);
389066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project
399066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project    static {
409066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project        sURLMatcher.addURI("*", "data", DATA);
419066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project        sURLMatcher.addURI("*", "data/#", DATA_ID);
429066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project    }
439066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project
449066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project    private static class DatabaseHelper extends SQLiteOpenHelper {
459066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project        private static final String DATABASE_NAME = "local.db";
469066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project        private static final int DATABASE_VERSION = 1;
479066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project
489066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project        public DatabaseHelper(Context context) {
499066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project            super(context, DATABASE_NAME, null, DATABASE_VERSION);
509066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project        }
519066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project
529066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project        @Override
539066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project        public void onCreate(SQLiteDatabase db) {
549066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project            db.execSQL("CREATE TABLE data (" +
559066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project                       "_id INTEGER PRIMARY KEY," +
569066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project                       "text TEXT, " +
579066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project                       "integer INTEGER);");
589066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project
599066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project            // insert alarms
609066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project            db.execSQL("INSERT INTO data (text, integer) VALUES ('first data', 100);");
619066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project        }
629066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project
639066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project        @Override
649066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project        public void onUpgrade(SQLiteDatabase db, int oldVersion, int currentVersion) {
659066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project            Log.w(TAG, "Upgrading test database from version " +
669066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project                  oldVersion + " to " + currentVersion +
679066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project                  ", which will destroy all old data");
689066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project            db.execSQL("DROP TABLE IF EXISTS data");
699066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project            onCreate(db);
709066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project        }
719066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project    }
729066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project
739066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project
749066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project    public LocalProvider() {
759066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project    }
769066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project
779066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project    @Override
789066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project    public boolean onCreate() {
799066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project        mOpenHelper = new DatabaseHelper(getContext());
809066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project        return true;
819066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project    }
829066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project
839066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project    @Override
849066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project    public Cursor query(Uri url, String[] projectionIn, String selection,
859066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project            String[] selectionArgs, String sort) {
869066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project        SQLiteQueryBuilder qb = new SQLiteQueryBuilder();
879066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project
889066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project        // Generate the body of the query
899066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project        int match = sURLMatcher.match(url);
909066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project        switch (match) {
919066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project            case DATA:
929066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project                qb.setTables("data");
939066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project                break;
949066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project            case DATA_ID:
959066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project                qb.setTables("data");
969066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project                qb.appendWhere("_id=");
979066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project                qb.appendWhere(url.getPathSegments().get(1));
989066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project                break;
999066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project            default:
1009066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project                throw new IllegalArgumentException("Unknown URL " + url);
1019066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project        }
1029066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project
1039066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project        SQLiteDatabase db = mOpenHelper.getReadableDatabase();
1049066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project        Cursor ret = qb.query(db, projectionIn, selection, selectionArgs,
1059066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project                              null, null, sort);
1069066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project
1079066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project        if (ret == null) {
10843a17654cf4bfe7f1ec22bd8b7b32daccdf27c09Joe Onorato            if (false) Log.d(TAG, "Alarms.query: failed");
1099066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project        } else {
1109066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project            ret.setNotificationUri(getContext().getContentResolver(), url);
1119066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project        }
1129066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project
1139066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project        return ret;
1149066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project    }
1159066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project
1169066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project    @Override
1179066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project    public String getType(Uri url) {
1189066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project        int match = sURLMatcher.match(url);
1199066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project        switch (match) {
1209066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project            case DATA:
1219066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project                return "vnd.android.cursor.dir/vnd.google.unit_tests.local";
1229066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project            case DATA_ID:
1239066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project                return "vnd.android.cursor.item/vnd.google.unit_tests.local";
1249066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project            default:
1259066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project                throw new IllegalArgumentException("Unknown URL");
1269066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project        }
1279066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project    }
1289066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project
1299066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project    @Override
1309066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project    public int update(Uri url, ContentValues values, String where, String[] whereArgs) {
1319066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project        int count;
1329066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project        long rowId = 0;
1339066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project        int match = sURLMatcher.match(url);
1349066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project        SQLiteDatabase db = mOpenHelper.getWritableDatabase();
1359066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project        switch (match) {
1369066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project            case DATA_ID: {
1379066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project                String segment = url.getPathSegments().get(1);
1389066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project                rowId = Long.parseLong(segment);
1399066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project                count = db.update("data", values, "_id=" + rowId, null);
1409066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project                break;
1419066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project            }
1429066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project            default: {
1439066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project                throw new UnsupportedOperationException(
1449066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project                        "Cannot update URL: " + url);
1459066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project            }
1469066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project        }
14743a17654cf4bfe7f1ec22bd8b7b32daccdf27c09Joe Onorato        if (false) Log.d(TAG, "*** notifyChange() rowId: " + rowId);
1489066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project        getContext().getContentResolver().notifyChange(url, null);
1499066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project        return count;
1509066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project    }
1519066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project
1529066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project
1539066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project    @Override
1549066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project    public Uri insert(Uri url, ContentValues initialValues) {
1559066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project        return null;
1569066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project    }
1579066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project
1589066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project    @Override
1599066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project    public int delete(Uri url, String where, String[] whereArgs) {
1609066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project        throw new UnsupportedOperationException("delete not supported");
1619066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project    }
1629066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project}
163