2 * Copyright (C) 2006 The Android Open Source Project
4 * Licensed under the Apache License, Version 2.0 (the "License");
5 * you may not use this file except in compliance with the License.
6 * You may obtain a copy of the License at
8 * http://www.apache.org/licenses/LICENSE-2.0
10 * Unless required by applicable law or agreed to in writing, software
11 * distributed under the License is distributed on an "AS IS" BASIS,
12 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
13 * See the License for the specific language governing permissions and
14 * limitations under the License.
17 package com.android.browser;
19 import android.app.SearchManager;
20 import android.app.SearchableInfo;
21 import android.backup.BackupManager;
22 import android.content.ComponentName;
23 import android.content.ContentProvider;
24 import android.content.ContentResolver;
25 import android.content.ContentUris;
26 import android.content.ContentValues;
27 import android.content.Context;
28 import android.content.Intent;
29 import android.content.SharedPreferences;
30 import android.content.UriMatcher;
31 import android.content.SharedPreferences.Editor;
32 import android.content.pm.PackageManager;
33 import android.content.pm.ResolveInfo;
34 import android.database.AbstractCursor;
35 import android.database.ContentObserver;
36 import android.database.Cursor;
37 import android.database.sqlite.SQLiteDatabase;
38 import android.database.sqlite.SQLiteOpenHelper;
39 import android.net.Uri;
40 import android.os.AsyncTask;
41 import android.os.Handler;
42 import android.preference.PreferenceManager;
43 import android.provider.Browser;
44 import android.provider.Settings;
45 import android.provider.Browser.BookmarkColumns;
46 import android.speech.RecognizerResultsIntent;
47 import android.text.TextUtils;
48 import android.util.Log;
49 import android.util.TypedValue;
50 import android.webkit.GeolocationPermissions;
52 import com.android.common.Patterns;
54 import com.google.android.gsf.GoogleSettingsContract.Partner;
57 import java.io.FilenameFilter;
58 import java.util.ArrayList;
59 import java.util.Date;
60 import java.util.regex.Matcher;
61 import java.util.regex.Pattern;
64 public class BrowserProvider extends ContentProvider {
66 private SQLiteOpenHelper mOpenHelper;
67 private BackupManager mBackupManager;
68 private static final String sDatabaseName = "browser.db";
69 private static final String TAG = "BrowserProvider";
70 private static final String ORDER_BY = "visits DESC, date DESC";
72 private static final String PICASA_URL = "http://picasaweb.google.com/m/" +
73 "viewer?source=androidclient";
75 private static final String[] TABLE_NAMES = new String[] {
76 "bookmarks", "searches", "geolocation"
78 private static final String[] SUGGEST_PROJECTION = new String[] {
79 "_id", "url", "title", "bookmark", "user_entered"
81 private static final String SUGGEST_SELECTION =
82 "(url LIKE ? OR url LIKE ? OR url LIKE ? OR url LIKE ?"
83 + " OR title LIKE ?) AND (bookmark = 1 OR user_entered = 1)";
84 private String[] SUGGEST_ARGS = new String[5];
86 // shared suggestion array index, make sure to match COLUMNS
87 private static final int SUGGEST_COLUMN_INTENT_ACTION_ID = 1;
88 private static final int SUGGEST_COLUMN_INTENT_DATA_ID = 2;
89 private static final int SUGGEST_COLUMN_TEXT_1_ID = 3;
90 private static final int SUGGEST_COLUMN_TEXT_2_ID = 4;
91 private static final int SUGGEST_COLUMN_ICON_1_ID = 5;
92 private static final int SUGGEST_COLUMN_ICON_2_ID = 6;
93 private static final int SUGGEST_COLUMN_QUERY_ID = 7;
94 private static final int SUGGEST_COLUMN_FORMAT = 8;
95 private static final int SUGGEST_COLUMN_INTENT_EXTRA_DATA = 9;
97 // shared suggestion columns
98 private static final String[] COLUMNS = new String[] {
100 SearchManager.SUGGEST_COLUMN_INTENT_ACTION,
101 SearchManager.SUGGEST_COLUMN_INTENT_DATA,
102 SearchManager.SUGGEST_COLUMN_TEXT_1,
103 SearchManager.SUGGEST_COLUMN_TEXT_2,
104 SearchManager.SUGGEST_COLUMN_ICON_1,
105 SearchManager.SUGGEST_COLUMN_ICON_2,
106 SearchManager.SUGGEST_COLUMN_QUERY,
107 SearchManager.SUGGEST_COLUMN_FORMAT,
108 SearchManager.SUGGEST_COLUMN_INTENT_EXTRA_DATA};
110 private static final int MAX_SUGGESTION_SHORT_ENTRIES = 3;
111 private static final int MAX_SUGGESTION_LONG_ENTRIES = 6;
112 private static final String MAX_SUGGESTION_LONG_ENTRIES_STRING =
113 Integer.valueOf(MAX_SUGGESTION_LONG_ENTRIES).toString();
115 // make sure that these match the index of TABLE_NAMES
116 private static final int URI_MATCH_BOOKMARKS = 0;
117 private static final int URI_MATCH_SEARCHES = 1;
118 private static final int URI_MATCH_GEOLOCATION = 2;
119 // (id % 10) should match the table name index
120 private static final int URI_MATCH_BOOKMARKS_ID = 10;
121 private static final int URI_MATCH_SEARCHES_ID = 11;
123 private static final int URI_MATCH_SUGGEST = 20;
124 private static final int URI_MATCH_BOOKMARKS_SUGGEST = 21;
126 private static final UriMatcher URI_MATCHER;
129 URI_MATCHER = new UriMatcher(UriMatcher.NO_MATCH);
130 URI_MATCHER.addURI("browser", TABLE_NAMES[URI_MATCH_BOOKMARKS],
131 URI_MATCH_BOOKMARKS);
132 URI_MATCHER.addURI("browser", TABLE_NAMES[URI_MATCH_BOOKMARKS] + "/#",
133 URI_MATCH_BOOKMARKS_ID);
134 URI_MATCHER.addURI("browser", TABLE_NAMES[URI_MATCH_SEARCHES],
136 URI_MATCHER.addURI("browser", TABLE_NAMES[URI_MATCH_SEARCHES] + "/#",
137 URI_MATCH_SEARCHES_ID);
138 URI_MATCHER.addURI("browser", SearchManager.SUGGEST_URI_PATH_QUERY,
140 URI_MATCHER.addURI("browser",
141 TABLE_NAMES[URI_MATCH_BOOKMARKS] + "/" + SearchManager.SUGGEST_URI_PATH_QUERY,
142 URI_MATCH_BOOKMARKS_SUGGEST);
143 URI_MATCHER.addURI("browser", TABLE_NAMES[URI_MATCH_GEOLOCATION],
144 URI_MATCH_GEOLOCATION);
147 // 1 -> 2 add cache table
148 // 2 -> 3 update history table
149 // 3 -> 4 add passwords table
150 // 4 -> 5 add settings table
153 // 7 -> 8 drop proxy table
154 // 8 -> 9 drop settings table
155 // 9 -> 10 add form_urls and form_data
156 // 10 -> 11 add searches table
157 // 11 -> 12 modify cache table
158 // 12 -> 13 modify cache table
159 // 13 -> 14 correspond with Google Bookmarks schema
160 // 14 -> 15 move couple of tables to either browser private database or webview database
161 // 15 -> 17 Set it up for the SearchManager
162 // 17 -> 18 Added favicon in bookmarks table for Home shortcuts
163 // 18 -> 19 Remove labels table
164 // 19 -> 20 Added thumbnail
165 // 20 -> 21 Added touch_icon
166 // 21 -> 22 Remove "clientid"
167 // 22 -> 23 Added user_entered
168 private static final int DATABASE_VERSION = 23;
170 // Regular expression which matches http://, followed by some stuff, followed by
171 // optionally a trailing slash, all matched as separate groups.
172 private static final Pattern STRIP_URL_PATTERN = Pattern.compile("^(http://)(.*?)(/$)?");
174 private SearchManager mSearchManager;
176 // The ID of the ColorStateList to be applied to urls of website suggestions, as derived from
177 // the current theme. This is not set until/unless beautifyUrl is called, at which point
178 // this variable caches the color value.
179 private static String mSearchUrlColorId;
181 public BrowserProvider() {
185 private static CharSequence replaceSystemPropertyInString(Context context, CharSequence srcString) {
186 StringBuffer sb = new StringBuffer();
189 final String client_id = Partner.getString(context.getContentResolver(),
190 Partner.CLIENT_ID, "android-google");
192 for (int i = 0; i < srcString.length(); ++i) {
193 char c = srcString.charAt(i);
195 sb.append(srcString.subSequence(lastCharLoc, i));
198 for (int j = i; j < srcString.length(); ++j) {
199 char k = srcString.charAt(j);
201 String propertyKeyValue = srcString.subSequence(i + 1, j).toString();
202 if (propertyKeyValue.equals("CLIENT_ID")) {
203 sb.append(client_id);
205 sb.append("unknown");
214 if (srcString.length() - lastCharLoc > 0) {
215 // Put on the tail, if there is one
216 sb.append(srcString.subSequence(lastCharLoc, srcString.length()));
221 private static class DatabaseHelper extends SQLiteOpenHelper {
222 private Context mContext;
224 public DatabaseHelper(Context context) {
225 super(context, sDatabaseName, null, DATABASE_VERSION);
230 public void onCreate(SQLiteDatabase db) {
231 db.execSQL("CREATE TABLE bookmarks (" +
232 "_id INTEGER PRIMARY KEY," +
238 "description TEXT," +
239 "bookmark INTEGER," +
240 "favicon BLOB DEFAULT NULL," +
241 "thumbnail BLOB DEFAULT NULL," +
242 "touch_icon BLOB DEFAULT NULL," +
243 "user_entered INTEGER" +
246 final CharSequence[] bookmarks = mContext.getResources()
247 .getTextArray(R.array.bookmarks);
248 int size = bookmarks.length;
250 for (int i = 0; i < size; i = i + 2) {
251 CharSequence bookmarkDestination = replaceSystemPropertyInString(mContext, bookmarks[i + 1]);
252 db.execSQL("INSERT INTO bookmarks (title, url, visits, " +
253 "date, created, bookmark)" + " VALUES('" +
254 bookmarks[i] + "', '" + bookmarkDestination +
257 } catch (ArrayIndexOutOfBoundsException e) {
260 db.execSQL("CREATE TABLE searches (" +
261 "_id INTEGER PRIMARY KEY," +
268 public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
269 Log.w(TAG, "Upgrading database from version " + oldVersion + " to "
271 if (oldVersion == 18) {
272 db.execSQL("DROP TABLE IF EXISTS labels");
274 if (oldVersion <= 19) {
275 db.execSQL("ALTER TABLE bookmarks ADD COLUMN thumbnail BLOB DEFAULT NULL;");
277 if (oldVersion < 21) {
278 db.execSQL("ALTER TABLE bookmarks ADD COLUMN touch_icon BLOB DEFAULT NULL;");
280 if (oldVersion < 22) {
281 db.execSQL("DELETE FROM bookmarks WHERE (bookmark = 0 AND url LIKE \"%.google.%client=ms-%\")");
284 if (oldVersion < 23) {
285 db.execSQL("ALTER TABLE bookmarks ADD COLUMN user_entered INTEGER;");
287 db.execSQL("DROP TABLE IF EXISTS bookmarks");
288 db.execSQL("DROP TABLE IF EXISTS searches");
293 private void removeGears() {
294 AsyncTask<Void, Void, Void> task = new AsyncTask<Void, Void, Void>() {
295 public Void doInBackground(Void... unused) {
296 String browserDataDirString = mContext.getApplicationInfo().dataDir;
297 final String appPluginsDirString = "app_plugins";
298 final String gearsPrefix = "gears";
299 File appPluginsDir = new File(browserDataDirString + File.separator
300 + appPluginsDirString);
301 if (!appPluginsDir.exists()) {
304 // Delete the Gears plugin files
305 File[] gearsFiles = appPluginsDir.listFiles(new FilenameFilter() {
306 public boolean accept(File dir, String filename) {
307 return filename.startsWith(gearsPrefix);
310 for (int i = 0; i < gearsFiles.length; ++i) {
311 if (gearsFiles[i].isDirectory()) {
312 deleteDirectory(gearsFiles[i]);
314 gearsFiles[i].delete();
317 // Delete the Gears data files
318 File gearsDataDir = new File(browserDataDirString + File.separator
320 if (!gearsDataDir.exists()) {
323 deleteDirectory(gearsDataDir);
327 private void deleteDirectory(File currentDir) {
328 File[] files = currentDir.listFiles();
329 for (int i = 0; i < files.length; ++i) {
330 if (files[i].isDirectory()) {
331 deleteDirectory(files[i]);
344 public boolean onCreate() {
345 final Context context = getContext();
346 mOpenHelper = new DatabaseHelper(context);
347 mBackupManager = new BackupManager(context);
348 // we added "picasa web album" into default bookmarks for version 19.
349 // To avoid erasing the bookmark table, we added it explicitly for
350 // version 18 and 19 as in the other cases, we will erase the table.
351 if (DATABASE_VERSION == 18 || DATABASE_VERSION == 19) {
352 SharedPreferences p = PreferenceManager
353 .getDefaultSharedPreferences(context);
354 boolean fix = p.getBoolean("fix_picasa", true);
357 Editor ed = p.edit();
358 ed.putBoolean("fix_picasa", false);
362 mSearchManager = (SearchManager) context.getSystemService(Context.SEARCH_SERVICE);
363 mShowWebSuggestionsSettingChangeObserver
364 = new ShowWebSuggestionsSettingChangeObserver();
365 context.getContentResolver().registerContentObserver(
366 Settings.System.getUriFor(
367 Settings.System.SHOW_WEB_SUGGESTIONS),
368 true, mShowWebSuggestionsSettingChangeObserver);
369 updateShowWebSuggestions();
374 * This Observer will ensure that if the user changes the system
375 * setting of whether to display web suggestions, we will
376 * change accordingly.
378 /* package */ class ShowWebSuggestionsSettingChangeObserver
379 extends ContentObserver {
380 public ShowWebSuggestionsSettingChangeObserver() {
381 super(new Handler());
385 public void onChange(boolean selfChange) {
386 updateShowWebSuggestions();
390 private ShowWebSuggestionsSettingChangeObserver
391 mShowWebSuggestionsSettingChangeObserver;
393 // If non-null, then the system is set to show web suggestions,
394 // and this is the SearchableInfo to use to get them.
395 private SearchableInfo mSearchableInfo;
398 * Check the system settings to see whether web suggestions are
399 * allowed. If so, store the SearchableInfo to grab suggestions
400 * while the user is typing.
402 private void updateShowWebSuggestions() {
403 mSearchableInfo = null;
404 Context context = getContext();
405 if (Settings.System.getInt(context.getContentResolver(),
406 Settings.System.SHOW_WEB_SUGGESTIONS,
407 1 /* default on */) == 1) {
408 Intent intent = new Intent(Intent.ACTION_WEB_SEARCH);
409 intent.addCategory(Intent.CATEGORY_DEFAULT);
410 ResolveInfo info = context.getPackageManager().resolveActivity(
411 intent, PackageManager.MATCH_DEFAULT_ONLY);
413 ComponentName googleSearchComponent =
414 new ComponentName(info.activityInfo.packageName,
415 info.activityInfo.name);
416 mSearchableInfo = mSearchManager.getSearchableInfo(
417 googleSearchComponent, false);
422 private void fixPicasaBookmark() {
423 SQLiteDatabase db = mOpenHelper.getWritableDatabase();
424 Cursor cursor = db.rawQuery("SELECT _id FROM bookmarks WHERE " +
425 "bookmark = 1 AND url = ?", new String[] { PICASA_URL });
427 if (!cursor.moveToFirst()) {
428 // set "created" so that it will be on the top of the list
429 db.execSQL("INSERT INTO bookmarks (title, url, visits, " +
430 "date, created, bookmark)" + " VALUES('" +
431 getContext().getString(R.string.picasa) + "', '"
432 + PICASA_URL + "', 0, 0, " + new Date().getTime()
436 if (cursor != null) {
443 * Subclass AbstractCursor so we can combine multiple Cursors and add
445 * Here are the rules.
446 * 1. We only have MAX_SUGGESTION_LONG_ENTRIES in the list plus
448 * 2. If bookmark/history entries are less than
449 * (MAX_SUGGESTION_SHORT_ENTRIES -1), we include Google suggest.
451 private class MySuggestionCursor extends AbstractCursor {
452 private Cursor mHistoryCursor;
453 private Cursor mSuggestCursor;
454 private int mHistoryCount;
455 private int mSuggestionCount;
456 private boolean mIncludeWebSearch;
457 private String mString;
458 private int mSuggestText1Id;
459 private int mSuggestText2Id;
460 private int mSuggestQueryId;
461 private int mSuggestIntentExtraDataId;
463 public MySuggestionCursor(Cursor hc, Cursor sc, String string) {
466 mHistoryCount = hc.getCount();
467 mSuggestionCount = sc != null ? sc.getCount() : 0;
468 if (mSuggestionCount > (MAX_SUGGESTION_LONG_ENTRIES - mHistoryCount)) {
469 mSuggestionCount = MAX_SUGGESTION_LONG_ENTRIES - mHistoryCount;
472 mIncludeWebSearch = string.length() > 0;
474 // Some web suggest providers only give suggestions and have no description string for
475 // items. The order of the result columns may be different as well. So retrieve the
476 // column indices for the fields we need now and check before using below.
477 if (mSuggestCursor == null) {
478 mSuggestText1Id = -1;
479 mSuggestText2Id = -1;
480 mSuggestQueryId = -1;
481 mSuggestIntentExtraDataId = -1;
483 mSuggestText1Id = mSuggestCursor.getColumnIndex(
484 SearchManager.SUGGEST_COLUMN_TEXT_1);
485 mSuggestText2Id = mSuggestCursor.getColumnIndex(
486 SearchManager.SUGGEST_COLUMN_TEXT_2);
487 mSuggestQueryId = mSuggestCursor.getColumnIndex(
488 SearchManager.SUGGEST_COLUMN_QUERY);
489 mSuggestIntentExtraDataId = mSuggestCursor.getColumnIndex(
490 SearchManager.SUGGEST_COLUMN_INTENT_EXTRA_DATA);
495 public boolean onMove(int oldPosition, int newPosition) {
496 if (mHistoryCursor == null) {
499 if (mIncludeWebSearch) {
500 if (newPosition == 0) {
506 if (mHistoryCount > newPosition) {
507 mHistoryCursor.moveToPosition(newPosition);
509 mSuggestCursor.moveToPosition(newPosition - mHistoryCount);
515 public int getCount() {
516 if (mIncludeWebSearch) {
517 return mHistoryCount + mSuggestionCount + 1;
519 return mHistoryCount + mSuggestionCount;
524 public String[] getColumnNames() {
529 public String getString(int columnIndex) {
530 if ((mPos != -1 && mHistoryCursor != null)) {
531 int position = mIncludeWebSearch ? mPos - 1 : mPos;
532 switch(columnIndex) {
533 case SUGGEST_COLUMN_INTENT_ACTION_ID:
534 if (position >= 0 && position < mHistoryCount) {
535 return Intent.ACTION_VIEW;
537 return Intent.ACTION_SEARCH;
540 case SUGGEST_COLUMN_INTENT_DATA_ID:
541 if (position >= 0 && position < mHistoryCount) {
542 return mHistoryCursor.getString(1);
547 case SUGGEST_COLUMN_TEXT_1_ID:
550 } else if (mHistoryCount > position) {
551 return getHistoryTitle();
553 if (mSuggestText1Id == -1) return null;
554 return mSuggestCursor.getString(mSuggestText1Id);
557 case SUGGEST_COLUMN_TEXT_2_ID:
559 return getContext().getString(R.string.search_the_web);
560 } else if (mHistoryCount > position) {
561 return getHistorySubtitle();
563 if (mSuggestText2Id == -1) return null;
564 return mSuggestCursor.getString(mSuggestText2Id);
567 case SUGGEST_COLUMN_ICON_1_ID:
568 if (position >= 0 && position < mHistoryCount) {
569 if (mHistoryCursor.getInt(3) == 1) {
570 return Integer.valueOf(
571 R.drawable.ic_search_category_bookmark)
574 return Integer.valueOf(
575 R.drawable.ic_search_category_history)
579 return Integer.valueOf(
580 R.drawable.ic_search_category_suggest)
584 case SUGGEST_COLUMN_ICON_2_ID:
587 case SUGGEST_COLUMN_QUERY_ID:
590 } else if (mHistoryCount > position) {
591 // Return the url in the intent query column. This is ignored
592 // within the browser because our searchable is set to
593 // android:searchMode="queryRewriteFromData", but it is used by
594 // global search for query rewriting.
595 return mHistoryCursor.getString(1);
597 if (mSuggestQueryId == -1) return null;
598 return mSuggestCursor.getString(mSuggestQueryId);
601 case SUGGEST_COLUMN_FORMAT:
604 case SUGGEST_COLUMN_INTENT_EXTRA_DATA:
607 } else if (mHistoryCount > position) {
610 if (mSuggestIntentExtraDataId == -1) return null;
611 return mSuggestCursor.getString(mSuggestIntentExtraDataId);
619 public double getDouble(int column) {
620 throw new UnsupportedOperationException();
624 public float getFloat(int column) {
625 throw new UnsupportedOperationException();
629 public int getInt(int column) {
630 throw new UnsupportedOperationException();
634 public long getLong(int column) {
635 if ((mPos != -1) && column == 0) {
636 return mPos; // use row# as the _Id
638 throw new UnsupportedOperationException();
642 public short getShort(int column) {
643 throw new UnsupportedOperationException();
647 public boolean isNull(int column) {
648 throw new UnsupportedOperationException();
651 // TODO Temporary change, finalize after jq's changes go in
652 public void deactivate() {
653 if (mHistoryCursor != null) {
654 mHistoryCursor.deactivate();
656 if (mSuggestCursor != null) {
657 mSuggestCursor.deactivate();
662 public boolean requery() {
663 return (mHistoryCursor != null ? mHistoryCursor.requery() : false) |
664 (mSuggestCursor != null ? mSuggestCursor.requery() : false);
667 // TODO Temporary change, finalize after jq's changes go in
668 public void close() {
670 if (mHistoryCursor != null) {
671 mHistoryCursor.close();
672 mHistoryCursor = null;
674 if (mSuggestCursor != null) {
675 mSuggestCursor.close();
676 mSuggestCursor = null;
681 * Provides the title (text line 1) for a browser suggestion, which should be the
682 * webpage title. If the webpage title is empty, returns the stripped url instead.
684 * @return the title string to use
686 private String getHistoryTitle() {
687 String title = mHistoryCursor.getString(2 /* webpage title */);
688 if (TextUtils.isEmpty(title) || TextUtils.getTrimmedLength(title) == 0) {
689 title = beautifyUrl(mHistoryCursor.getString(1 /* url */));
695 * Provides the subtitle (text line 2) for a browser suggestion, which should be the
696 * webpage url. If the webpage title is empty, then the url should go in the title
697 * instead, and the subtitle should be empty, so this would return null.
699 * @return the subtitle string to use, or null if none
701 private String getHistorySubtitle() {
702 String title = mHistoryCursor.getString(2 /* webpage title */);
703 if (TextUtils.isEmpty(title) || TextUtils.getTrimmedLength(title) == 0) {
706 return beautifyUrl(mHistoryCursor.getString(1 /* url */));
711 * Strips "http://" from the beginning of a url and "/" from the end,
712 * and adds html formatting to make it green.
714 private String beautifyUrl(String url) {
715 if (mSearchUrlColorId == null) {
716 // Get the color used for this purpose from the current theme.
717 TypedValue colorValue = new TypedValue();
718 getContext().getTheme().resolveAttribute(
719 com.android.internal.R.attr.textColorSearchUrl, colorValue, true);
720 mSearchUrlColorId = Integer.toString(colorValue.resourceId);
723 return "<font color=\"@" + mSearchUrlColorId + "\">" + stripUrl(url) + "</font>";
727 private static class ResultsCursor extends AbstractCursor {
728 // Array indices for RESULTS_COLUMNS
729 private static final int RESULT_ACTION_ID = 1;
730 private static final int RESULT_DATA_ID = 2;
731 private static final int RESULT_TEXT_ID = 3;
732 private static final int RESULT_ICON_ID = 4;
733 private static final int RESULT_EXTRA_ID = 5;
735 private static final String[] RESULTS_COLUMNS = new String[] {
737 SearchManager.SUGGEST_COLUMN_INTENT_ACTION,
738 SearchManager.SUGGEST_COLUMN_INTENT_DATA,
739 SearchManager.SUGGEST_COLUMN_TEXT_1,
740 SearchManager.SUGGEST_COLUMN_ICON_1,
741 SearchManager.SUGGEST_COLUMN_INTENT_EXTRA_DATA
743 private final ArrayList<String> mResults;
744 public ResultsCursor(ArrayList<String> results) {
747 public int getCount() { return mResults.size(); }
749 public String[] getColumnNames() {
750 return RESULTS_COLUMNS;
753 public String getString(int column) {
755 case RESULT_ACTION_ID:
756 return RecognizerResultsIntent.ACTION_VOICE_SEARCH_RESULTS;
758 // The data is used when the phone is in landscape mode. We
759 // still want to show the result string.
761 return mResults.get(mPos);
762 case RESULT_EXTRA_ID:
763 // The Intent's extra data will store the index into
764 // mResults so the BrowserActivity will know which result to
766 return Integer.toString(mPos);
768 return Integer.valueOf(R.drawable.magnifying_glass)
774 public short getShort(int column) {
775 throw new UnsupportedOperationException();
777 public int getInt(int column) {
778 throw new UnsupportedOperationException();
780 public long getLong(int column) {
781 if ((mPos != -1) && column == 0) {
782 return mPos; // use row# as the _id
784 throw new UnsupportedOperationException();
786 public float getFloat(int column) {
787 throw new UnsupportedOperationException();
789 public double getDouble(int column) {
790 throw new UnsupportedOperationException();
792 public boolean isNull(int column) {
793 throw new UnsupportedOperationException();
797 private ResultsCursor mResultsCursor;
800 * Provide a set of results to be returned to query, intended to be used
801 * by the SearchDialog when the BrowserActivity is in voice search mode.
802 * @param results Strings to display in the dropdown from the SearchDialog
804 /* package */ void setQueryResults(ArrayList<String> results) {
805 if (results == null) {
806 mResultsCursor = null;
808 mResultsCursor = new ResultsCursor(results);
813 public Cursor query(Uri url, String[] projectionIn, String selection,
814 String[] selectionArgs, String sortOrder)
815 throws IllegalStateException {
816 int match = URI_MATCHER.match(url);
818 throw new IllegalArgumentException("Unknown URL");
820 if (match == URI_MATCH_GEOLOCATION) {
821 throw new UnsupportedOperationException("query() not supported for geolocation");
823 if (match == URI_MATCH_SUGGEST && mResultsCursor != null) {
824 Cursor results = mResultsCursor;
825 mResultsCursor = null;
828 SQLiteDatabase db = mOpenHelper.getReadableDatabase();
830 if (match == URI_MATCH_SUGGEST || match == URI_MATCH_BOOKMARKS_SUGGEST) {
831 String suggestSelection;
833 if (selectionArgs[0] == null || selectionArgs[0].equals("")) {
834 suggestSelection = null;
837 String like = selectionArgs[0] + "%";
838 if (selectionArgs[0].startsWith("http")
839 || selectionArgs[0].startsWith("file")) {
840 myArgs = new String[1];
842 suggestSelection = selection;
844 SUGGEST_ARGS[0] = "http://" + like;
845 SUGGEST_ARGS[1] = "http://www." + like;
846 SUGGEST_ARGS[2] = "https://" + like;
847 SUGGEST_ARGS[3] = "https://www." + like;
848 // To match against titles.
849 SUGGEST_ARGS[4] = like;
850 myArgs = SUGGEST_ARGS;
851 suggestSelection = SUGGEST_SELECTION;
855 Cursor c = db.query(TABLE_NAMES[URI_MATCH_BOOKMARKS],
856 SUGGEST_PROJECTION, suggestSelection, myArgs, null, null,
857 ORDER_BY, MAX_SUGGESTION_LONG_ENTRIES_STRING);
859 if (match == URI_MATCH_BOOKMARKS_SUGGEST
860 || Patterns.WEB_URL.matcher(selectionArgs[0]).matches()) {
861 return new MySuggestionCursor(c, null, "");
863 // get Google suggest if there is still space in the list
864 if (myArgs != null && myArgs.length > 1
865 && mSearchableInfo != null
866 && c.getCount() < (MAX_SUGGESTION_SHORT_ENTRIES - 1)) {
867 Cursor sc = mSearchManager.getSuggestions(mSearchableInfo, selectionArgs[0]);
868 return new MySuggestionCursor(c, sc, selectionArgs[0]);
870 return new MySuggestionCursor(c, null, selectionArgs[0]);
874 String[] projection = null;
875 if (projectionIn != null && projectionIn.length > 0) {
876 projection = new String[projectionIn.length + 1];
877 System.arraycopy(projectionIn, 0, projection, 0, projectionIn.length);
878 projection[projectionIn.length] = "_id AS _id";
881 StringBuilder whereClause = new StringBuilder(256);
882 if (match == URI_MATCH_BOOKMARKS_ID || match == URI_MATCH_SEARCHES_ID) {
883 whereClause.append("(_id = ").append(url.getPathSegments().get(1))
887 // Tack on the user's selection, if present
888 if (selection != null && selection.length() > 0) {
889 if (whereClause.length() > 0) {
890 whereClause.append(" AND ");
893 whereClause.append('(');
894 whereClause.append(selection);
895 whereClause.append(')');
897 Cursor c = db.query(TABLE_NAMES[match % 10], projection,
898 whereClause.toString(), selectionArgs, null, null, sortOrder,
900 c.setNotificationUri(getContext().getContentResolver(), url);
905 public String getType(Uri url) {
906 int match = URI_MATCHER.match(url);
908 case URI_MATCH_BOOKMARKS:
909 return "vnd.android.cursor.dir/bookmark";
911 case URI_MATCH_BOOKMARKS_ID:
912 return "vnd.android.cursor.item/bookmark";
914 case URI_MATCH_SEARCHES:
915 return "vnd.android.cursor.dir/searches";
917 case URI_MATCH_SEARCHES_ID:
918 return "vnd.android.cursor.item/searches";
920 case URI_MATCH_SUGGEST:
921 return SearchManager.SUGGEST_MIME_TYPE;
923 case URI_MATCH_GEOLOCATION:
924 return "vnd.android.cursor.dir/geolocation";
927 throw new IllegalArgumentException("Unknown URL");
932 public Uri insert(Uri url, ContentValues initialValues) {
933 boolean isBookmarkTable = false;
934 SQLiteDatabase db = mOpenHelper.getWritableDatabase();
936 int match = URI_MATCHER.match(url);
939 case URI_MATCH_BOOKMARKS: {
940 // Insert into the bookmarks table
941 long rowID = db.insert(TABLE_NAMES[URI_MATCH_BOOKMARKS], "url",
944 uri = ContentUris.withAppendedId(Browser.BOOKMARKS_URI,
947 isBookmarkTable = true;
951 case URI_MATCH_SEARCHES: {
952 // Insert into the searches table
953 long rowID = db.insert(TABLE_NAMES[URI_MATCH_SEARCHES], "url",
956 uri = ContentUris.withAppendedId(Browser.SEARCHES_URI,
962 case URI_MATCH_GEOLOCATION:
963 String origin = initialValues.getAsString(Browser.GeolocationColumns.ORIGIN);
964 if (TextUtils.isEmpty(origin)) {
965 throw new IllegalArgumentException("Empty origin");
967 GeolocationPermissions.getInstance().allow(origin);
968 // TODO: Should we have one URI per permission?
969 uri = Browser.GEOLOCATION_URI;
973 throw new IllegalArgumentException("Unknown URL");
977 throw new IllegalArgumentException("Unknown URL");
979 getContext().getContentResolver().notifyChange(uri, null);
981 // Back up the new bookmark set if we just inserted one.
982 // A row created when bookmarks are added from scratch will have
983 // bookmark=1 in the initial value set.
985 && initialValues.containsKey(BookmarkColumns.BOOKMARK)
986 && initialValues.getAsInteger(BookmarkColumns.BOOKMARK) != 0) {
987 mBackupManager.dataChanged();
993 public int delete(Uri url, String where, String[] whereArgs) {
994 SQLiteDatabase db = mOpenHelper.getWritableDatabase();
996 int match = URI_MATCHER.match(url);
997 if (match == -1 || match == URI_MATCH_SUGGEST) {
998 throw new IllegalArgumentException("Unknown URL");
1001 if (match == URI_MATCH_GEOLOCATION) {
1002 return deleteGeolocation(url, where, whereArgs);
1005 // need to know whether it's the bookmarks table for a couple of reasons
1006 boolean isBookmarkTable = (match == URI_MATCH_BOOKMARKS_ID);
1009 if (isBookmarkTable || match == URI_MATCH_SEARCHES_ID) {
1010 StringBuilder sb = new StringBuilder();
1011 if (where != null && where.length() > 0) {
1014 sb.append(" ) AND ");
1016 id = url.getPathSegments().get(1);
1017 sb.append("_id = ");
1019 where = sb.toString();
1022 ContentResolver cr = getContext().getContentResolver();
1024 // we'lll need to back up the bookmark set if we are about to delete one
1025 if (isBookmarkTable) {
1026 Cursor cursor = cr.query(Browser.BOOKMARKS_URI,
1027 new String[] { BookmarkColumns.BOOKMARK },
1028 "_id = " + id, null, null);
1029 if (cursor.moveToNext()) {
1030 if (cursor.getInt(0) != 0) {
1031 // yep, this record is a bookmark
1032 mBackupManager.dataChanged();
1038 int count = db.delete(TABLE_NAMES[match % 10], where, whereArgs);
1039 cr.notifyChange(url, null);
1043 private int deleteGeolocation(Uri uri, String where, String[] whereArgs) {
1044 if (whereArgs.length != 1) {
1045 throw new IllegalArgumentException("Bad where arguments");
1047 String origin = whereArgs[0];
1048 if (TextUtils.isEmpty(origin)) {
1049 throw new IllegalArgumentException("Empty origin");
1051 GeolocationPermissions.getInstance().clear(origin);
1052 getContext().getContentResolver().notifyChange(Browser.GEOLOCATION_URI, null);
1053 return 1; // We always return 1, to avoid having to check whether anything was actually removed
1057 public int update(Uri url, ContentValues values, String where,
1058 String[] whereArgs) {
1059 SQLiteDatabase db = mOpenHelper.getWritableDatabase();
1061 int match = URI_MATCHER.match(url);
1062 if (match == -1 || match == URI_MATCH_SUGGEST) {
1063 throw new IllegalArgumentException("Unknown URL");
1067 boolean isBookmarkTable = (match == URI_MATCH_BOOKMARKS_ID);
1068 boolean changingBookmarks = false;
1070 if (isBookmarkTable || match == URI_MATCH_SEARCHES_ID) {
1071 StringBuilder sb = new StringBuilder();
1072 if (where != null && where.length() > 0) {
1075 sb.append(" ) AND ");
1077 id = url.getPathSegments().get(1);
1078 sb.append("_id = ");
1080 where = sb.toString();
1083 ContentResolver cr = getContext().getContentResolver();
1085 // Not all bookmark-table updates should be backed up. Look to see
1086 // whether we changed the title, url, or "is a bookmark" state, and
1087 // request a backup if so.
1088 if (isBookmarkTable) {
1089 // Alterations to the bookmark field inherently change the bookmark
1090 // set, so we don't need to query the record; we know a priori that
1091 // we will need to back up this change.
1092 if (values.containsKey(BookmarkColumns.BOOKMARK)) {
1093 changingBookmarks = true;
1095 // changing the title or URL of a bookmark record requires a backup,
1096 // but we don't know wether such an update is on a bookmark without
1097 // querying the record
1098 if (!changingBookmarks &&
1099 (values.containsKey(BookmarkColumns.TITLE)
1100 || values.containsKey(BookmarkColumns.URL))) {
1101 // when isBookmarkTable is true, the 'id' var was assigned above
1102 Cursor cursor = cr.query(Browser.BOOKMARKS_URI,
1103 new String[] { BookmarkColumns.BOOKMARK },
1104 "_id = " + id, null, null);
1105 if (cursor.moveToNext()) {
1106 changingBookmarks = (cursor.getInt(0) != 0);
1111 // if this *is* a bookmark row we're altering, we need to back it up.
1112 if (changingBookmarks) {
1113 mBackupManager.dataChanged();
1117 int ret = db.update(TABLE_NAMES[match % 10], values, where, whereArgs);
1118 cr.notifyChange(url, null);
1123 * Strips the provided url of preceding "http://" and any trailing "/". Does not
1124 * strip "https://". If the provided string cannot be stripped, the original string
1127 * TODO: Put this in TextUtils to be used by other packages doing something similar.
1129 * @param url a url to strip, like "http://www.google.com/"
1130 * @return a stripped url like "www.google.com", or the original string if it could
1133 private static String stripUrl(String url) {
1134 if (url == null) return null;
1135 Matcher m = STRIP_URL_PATTERN.matcher(url);
1136 if (m.matches() && m.groupCount() == 3) {