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