SearchRecentSuggestionsProvider.java revision b4569fb17fada4fdc43e4f4dbfbc79bb097a1f74
19066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project/* 29066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Copyright (C) 2008 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 android.content; 189066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 199066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.app.SearchManager; 209066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.database.Cursor; 219066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.database.sqlite.SQLiteDatabase; 229066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.database.sqlite.SQLiteOpenHelper; 239066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.net.Uri; 249066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.text.TextUtils; 259066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectimport android.util.Log; 269066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 279066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project/** 289066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * This superclass can be used to create a simple search suggestions provider for your application. 299066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * It creates suggestions (as the user types) based on recent queries and/or recent views. 309066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 319066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * <p>In order to use this class, you must do the following. 329066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 339066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * <ul> 349066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * <li>Implement and test query search, as described in {@link android.app.SearchManager}. (This 359066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * provider will send any suggested queries via the standard 369066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * {@link android.content.Intent#ACTION_SEARCH ACTION_SEARCH} Intent, which you'll already 379066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * support once you have implemented and tested basic searchability.)</li> 389066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * <li>Create a Content Provider within your application by extending 399066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * {@link android.content.SearchRecentSuggestionsProvider}. The class you create will be 409066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * very simple - typically, it will have only a constructor. But the constructor has a very 419066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * important responsibility: When it calls {@link #setupSuggestions(String, int)}, it 429066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * <i>configures</i> the provider to match the requirements of your searchable activity.</li> 439066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * <li>Create a manifest entry describing your provider. Typically this would be as simple 449066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * as adding the following lines: 459066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * <pre class="prettyprint"> 469066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * <!-- Content provider for search suggestions --> 479066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * <provider android:name="YourSuggestionProviderClass" 489066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * android:authorities="your.suggestion.authority" /></pre> 499066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * </li> 509066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * <li>Please note that you <i>do not</i> instantiate this content provider directly from within 519066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * your code. This is done automatically by the system Content Resolver, when the search dialog 529066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * looks for suggestions.</li> 539066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * <li>In order for the Content Resolver to do this, you must update your searchable activity's 549066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * XML configuration file with information about your content provider. The following additions 559066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * are usually sufficient: 569066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * <pre class="prettyprint"> 579066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * android:searchSuggestAuthority="your.suggestion.authority" 589066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * android:searchSuggestSelection=" ? "</pre> 599066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * </li> 609066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * <li>In your searchable activities, capture any user-generated queries and record them 619066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * for future searches by calling {@link android.provider.SearchRecentSuggestions#saveRecentQuery 629066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * SearchRecentSuggestions.saveRecentQuery()}.</li> 639066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * </ul> 649066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 659066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @see android.provider.SearchRecentSuggestions 669066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 679066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Projectpublic class SearchRecentSuggestionsProvider extends ContentProvider { 689066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // debugging support 699066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private static final String TAG = "SuggestionsProvider"; 709066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 719066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // client-provided configuration values 729066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private String mAuthority; 739066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private int mMode; 749066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private boolean mTwoLineDisplay; 759066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 769066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // general database configuration and tables 779066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private SQLiteOpenHelper mOpenHelper; 789066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private static final String sDatabaseName = "suggestions.db"; 799066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private static final String sSuggestions = "suggestions"; 809066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private static final String ORDER_BY = "date DESC"; 819066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private static final String NULL_COLUMN = "query"; 829066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 839066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // Table of database versions. Don't forget to update! 849066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // NOTE: These version values are shifted left 8 bits (x 256) in order to create space for 859066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // a small set of mode bitflags in the version int. 869066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // 879066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // 1 original implementation with queries, and 1 or 2 display columns 889066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // 1->2 added UNIQUE constraint to display1 column 899066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private static final int DATABASE_VERSION = 2 * 256; 909066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 919066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 929066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * This mode bit configures the database to record recent queries. <i>required</i> 939066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 949066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @see #setupSuggestions(String, int) 959066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 969066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static final int DATABASE_MODE_QUERIES = 1; 979066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 989066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * This mode bit configures the database to include a 2nd annotation line with each entry. 999066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * <i>optional</i> 1009066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 1019066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @see #setupSuggestions(String, int) 1029066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 1039066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public static final int DATABASE_MODE_2LINES = 2; 1049066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1059066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // Uri and query support 1069066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private static final int URI_MATCH_SUGGEST = 1; 1079066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1089066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private Uri mSuggestionsUri; 1099066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private UriMatcher mUriMatcher; 1109066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1119066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private String mSuggestSuggestionClause; 1129066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private String[] mSuggestionProjection; 1139066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1149066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 1159066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * Builds the database. This version has extra support for using the version field 1169066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * as a mode flags field, and configures the database columns depending on the mode bits 1179066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * (features) requested by the extending class. 1189066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 1199066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @hide 1209066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 1219066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private static class DatabaseHelper extends SQLiteOpenHelper { 1229066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1239066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project private int mNewVersion; 1249066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1259066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public DatabaseHelper(Context context, int newVersion) { 1269066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project super(context, sDatabaseName, null, newVersion); 1279066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mNewVersion = newVersion; 1289066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1299066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1309066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project @Override 1319066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public void onCreate(SQLiteDatabase db) { 1329066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project StringBuilder builder = new StringBuilder(); 1339066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project builder.append("CREATE TABLE suggestions (" + 1349066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project "_id INTEGER PRIMARY KEY" + 1359066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project ",display1 TEXT UNIQUE ON CONFLICT REPLACE"); 1369066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (0 != (mNewVersion & DATABASE_MODE_2LINES)) { 1379066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project builder.append(",display2 TEXT"); 1389066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1399066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project builder.append(",query TEXT" + 1409066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project ",date LONG" + 1419066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project ");"); 1429066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project db.execSQL(builder.toString()); 1439066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1449066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1459066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project @Override 1469066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { 1479066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project Log.w(TAG, "Upgrading database from version " + oldVersion + " to " 1489066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project + newVersion + ", which will destroy all old data"); 1499066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project db.execSQL("DROP TABLE IF EXISTS suggestions"); 1509066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project onCreate(db); 1519066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1529066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1539066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1549066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 1559066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * In order to use this class, you must extend it, and call this setup function from your 1569066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * constructor. In your application or activities, you must provide the same values when 1579066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * you create the {@link android.provider.SearchRecentSuggestions} helper. 1589066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 1599066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param authority This must match the authority that you've declared in your manifest. 1609066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @param mode You can use mode flags here to determine certain functional aspects of your 1619066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * database. Note, this value should not change from run to run, because when it does change, 1629066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * your suggestions database may be wiped. 1639066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * 1649066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @see #DATABASE_MODE_QUERIES 1659066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * @see #DATABASE_MODE_2LINES 1669066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 1679066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project protected void setupSuggestions(String authority, int mode) { 1689066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (TextUtils.isEmpty(authority) || 1699066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project ((mode & DATABASE_MODE_QUERIES) == 0)) { 1709066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project throw new IllegalArgumentException(); 1719066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 1729066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // unpack mode flags 1739066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mTwoLineDisplay = (0 != (mode & DATABASE_MODE_2LINES)); 1749066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1759066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // saved values 1769066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mAuthority = new String(authority); 1779066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mMode = mode; 1789066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1799066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // derived values 1809066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mSuggestionsUri = Uri.parse("content://" + mAuthority + "/suggestions"); 1819066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mUriMatcher = new UriMatcher(UriMatcher.NO_MATCH); 1829066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mUriMatcher.addURI(mAuthority, SearchManager.SUGGEST_URI_PATH_QUERY, URI_MATCH_SUGGEST); 1839066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1849066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (mTwoLineDisplay) { 1859066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mSuggestSuggestionClause = "display1 LIKE ? OR display2 LIKE ?"; 1869066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 1879066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mSuggestionProjection = new String [] { 1889066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project "0 AS " + SearchManager.SUGGEST_COLUMN_FORMAT, 189b4569fb17fada4fdc43e4f4dbfbc79bb097a1f74Amith Yamasani "'android.resource://system/" 190b4569fb17fada4fdc43e4f4dbfbc79bb097a1f74Amith Yamasani + com.android.internal.R.drawable.ic_menu_recent_history + "' AS " 191b4569fb17fada4fdc43e4f4dbfbc79bb097a1f74Amith Yamasani + SearchManager.SUGGEST_COLUMN_ICON_1, 1929066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project "display1 AS " + SearchManager.SUGGEST_COLUMN_TEXT_1, 1939066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project "display2 AS " + SearchManager.SUGGEST_COLUMN_TEXT_2, 1949066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project "query AS " + SearchManager.SUGGEST_COLUMN_QUERY, 1959066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project "_id" 1969066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project }; 1979066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else { 1989066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mSuggestSuggestionClause = "display1 LIKE ?"; 1999066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 2009066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mSuggestionProjection = new String [] { 2019066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project "0 AS " + SearchManager.SUGGEST_COLUMN_FORMAT, 202b4569fb17fada4fdc43e4f4dbfbc79bb097a1f74Amith Yamasani "'android.resource://system/" 203b4569fb17fada4fdc43e4f4dbfbc79bb097a1f74Amith Yamasani + com.android.internal.R.drawable.ic_menu_recent_history + "' AS " 204b4569fb17fada4fdc43e4f4dbfbc79bb097a1f74Amith Yamasani + SearchManager.SUGGEST_COLUMN_ICON_1, 2059066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project "display1 AS " + SearchManager.SUGGEST_COLUMN_TEXT_1, 2069066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project "query AS " + SearchManager.SUGGEST_COLUMN_QUERY, 2079066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project "_id" 2089066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project }; 2099066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 2109066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 2119066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 2129066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 2139066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 2149066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 2159066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * This method is provided for use by the ContentResolver. Do not override, or directly 2169066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * call from your own code. 2179066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 2189066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project @Override 2199066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public int delete(Uri uri, String selection, String[] selectionArgs) { 2209066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project SQLiteDatabase db = mOpenHelper.getWritableDatabase(); 2219066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 2229066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project final int length = uri.getPathSegments().size(); 2239066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (length != 1) { 2249066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project throw new IllegalArgumentException("Unknown Uri"); 2259066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 2269066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 2279066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project final String base = uri.getPathSegments().get(0); 2289066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project int count = 0; 2299066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (base.equals(sSuggestions)) { 2309066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project count = db.delete(sSuggestions, selection, selectionArgs); 2319066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else { 2329066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project throw new IllegalArgumentException("Unknown Uri"); 2339066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 2349066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project getContext().getContentResolver().notifyChange(uri, null); 2359066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return count; 2369066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 2379066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 2389066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 2399066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * This method is provided for use by the ContentResolver. Do not override, or directly 2409066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * call from your own code. 2419066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 2429066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project @Override 2439066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public String getType(Uri uri) { 2449066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (mUriMatcher.match(uri) == URI_MATCH_SUGGEST) { 2459066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return SearchManager.SUGGEST_MIME_TYPE; 2469066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 2479066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project int length = uri.getPathSegments().size(); 2489066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (length >= 1) { 2499066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project String base = uri.getPathSegments().get(0); 2509066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (base.equals(sSuggestions)) { 2519066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (length == 1) { 2529066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return "vnd.android.cursor.dir/suggestion"; 2539066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else if (length == 2) { 2549066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return "vnd.android.cursor.item/suggestion"; 2559066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 2569066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 2579066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 2589066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project throw new IllegalArgumentException("Unknown Uri"); 2599066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 2609066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 2619066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 2629066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * This method is provided for use by the ContentResolver. Do not override, or directly 2639066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * call from your own code. 2649066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 2659066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project @Override 2669066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public Uri insert(Uri uri, ContentValues values) { 2679066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project SQLiteDatabase db = mOpenHelper.getWritableDatabase(); 2689066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 2699066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project int length = uri.getPathSegments().size(); 2709066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (length < 1) { 2719066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project throw new IllegalArgumentException("Unknown Uri"); 2729066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 2739066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // Note: This table has on-conflict-replace semantics, so insert() may actually replace() 2749066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project long rowID = -1; 2759066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project String base = uri.getPathSegments().get(0); 2769066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project Uri newUri = null; 2779066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (base.equals(sSuggestions)) { 2789066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (length == 1) { 2799066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project rowID = db.insert(sSuggestions, NULL_COLUMN, values); 2809066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (rowID > 0) { 2819066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project newUri = Uri.withAppendedPath(mSuggestionsUri, String.valueOf(rowID)); 2829066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 2839066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 2849066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 2859066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (rowID < 0) { 2869066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project throw new IllegalArgumentException("Unknown Uri"); 2879066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 2889066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project getContext().getContentResolver().notifyChange(newUri, null); 2899066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return newUri; 2909066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 2919066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 2929066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 2939066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * This method is provided for use by the ContentResolver. Do not override, or directly 2949066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * call from your own code. 2959066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 2969066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project @Override 2979066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public boolean onCreate() { 2989066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (mAuthority == null || mMode == 0) { 2999066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project throw new IllegalArgumentException("Provider not configured"); 3009066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 3019066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project int mWorkingDbVersion = DATABASE_VERSION + mMode; 3029066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project mOpenHelper = new DatabaseHelper(getContext(), mWorkingDbVersion); 3039066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 3049066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return true; 3059066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 3069066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 3079066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 3089066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * This method is provided for use by the ContentResolver. Do not override, or directly 3099066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * call from your own code. 3109066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 3119066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // TODO: Confirm no injection attacks here, or rewrite. 3129066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project @Override 3139066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public Cursor query(Uri uri, String[] projection, String selection, String[] selectionArgs, 3149066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project String sortOrder) { 3159066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project SQLiteDatabase db = mOpenHelper.getReadableDatabase(); 3169066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 3179066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // special case for actual suggestions (from search manager) 3189066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (mUriMatcher.match(uri) == URI_MATCH_SUGGEST) { 3199066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project String suggestSelection; 3209066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project String[] myArgs; 3219066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (TextUtils.isEmpty(selectionArgs[0])) { 3229066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project suggestSelection = null; 3239066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project myArgs = null; 3249066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else { 3259066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project String like = "%" + selectionArgs[0] + "%"; 3269066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (mTwoLineDisplay) { 3279066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project myArgs = new String [] { like, like }; 3289066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } else { 3299066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project myArgs = new String [] { like }; 3309066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 3319066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project suggestSelection = mSuggestSuggestionClause; 3329066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 3339066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // Suggestions are always performed with the default sort order 3349066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project Cursor c = db.query(sSuggestions, mSuggestionProjection, 3359066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project suggestSelection, myArgs, null, null, ORDER_BY, null); 3369066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project c.setNotificationUri(getContext().getContentResolver(), uri); 3379066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return c; 3389066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 3399066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 3409066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // otherwise process arguments and perform a standard query 3419066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project int length = uri.getPathSegments().size(); 3429066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (length != 1 && length != 2) { 3439066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project throw new IllegalArgumentException("Unknown Uri"); 3449066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 3459066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 3469066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project String base = uri.getPathSegments().get(0); 3479066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (!base.equals(sSuggestions)) { 3489066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project throw new IllegalArgumentException("Unknown Uri"); 3499066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 3509066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 3519066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project String[] useProjection = null; 3529066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (projection != null && projection.length > 0) { 3539066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project useProjection = new String[projection.length + 1]; 3549066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project System.arraycopy(projection, 0, useProjection, 0, projection.length); 3559066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project useProjection[projection.length] = "_id AS _id"; 3569066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 3579066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 3589066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project StringBuilder whereClause = new StringBuilder(256); 3599066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (length == 2) { 3609066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project whereClause.append("(_id = ").append(uri.getPathSegments().get(1)).append(")"); 3619066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 3629066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 3639066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // Tack on the user's selection, if present 3649066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (selection != null && selection.length() > 0) { 3659066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project if (whereClause.length() > 0) { 3669066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project whereClause.append(" AND "); 3679066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 3689066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 3699066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project whereClause.append('('); 3709066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project whereClause.append(selection); 3719066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project whereClause.append(')'); 3729066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 3739066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 3749066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project // And perform the generic query as requested 3759066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project Cursor c = db.query(base, useProjection, whereClause.toString(), 3769066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project selectionArgs, null, null, sortOrder, 3779066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project null); 3789066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project c.setNotificationUri(getContext().getContentResolver(), uri); 3799066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project return c; 3809066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 3819066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 3829066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project /** 3839066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * This method is provided for use by the ContentResolver. Do not override, or directly 3849066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project * call from your own code. 3859066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project */ 3869066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project @Override 3879066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project public int update(Uri uri, ContentValues values, String selection, String[] selectionArgs) { 3889066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project throw new UnsupportedOperationException("Not implemented"); 3899066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project } 3909066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project 3919066cfe9886ac131c34d59ed0e2d287b0e3c0087The Android Open Source Project} 392