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