Lines Matching defs:shortcuts
59 "SELECT " + Shortcuts.intent_key.fullName + " FROM " + Shortcuts.TABLE_NAME;
64 Shortcuts.shortcut_id.name() + "=? AND " + Shortcuts.source.name() + "=?";
109 String tables = ClickLog.TABLE_NAME + " INNER JOIN " + Shortcuts.TABLE_NAME
110 + " ON " + ClickLog.intent_key.fullName + " = " + Shortcuts.intent_key.fullName;
112 Shortcuts.intent_key.fullName,
113 Shortcuts.source.fullName,
114 Shortcuts.source_version_code.fullName,
115 Shortcuts.format.fullName + " AS " + SearchManager.SUGGEST_COLUMN_FORMAT,
116 Shortcuts.title + " AS " + SearchManager.SUGGEST_COLUMN_TEXT_1,
117 Shortcuts.description + " AS " + SearchManager.SUGGEST_COLUMN_TEXT_2,
118 Shortcuts.description_url + " AS " + SearchManager.SUGGEST_COLUMN_TEXT_2_URL,
119 Shortcuts.icon1 + " AS " + SearchManager.SUGGEST_COLUMN_ICON_1,
120 Shortcuts.icon2 + " AS " + SearchManager.SUGGEST_COLUMN_ICON_2,
121 Shortcuts.intent_action + " AS " + SearchManager.SUGGEST_COLUMN_INTENT_ACTION,
122 Shortcuts.intent_data + " AS " + SearchManager.SUGGEST_COLUMN_INTENT_DATA,
123 Shortcuts.intent_query + " AS " + SearchManager.SUGGEST_COLUMN_QUERY,
124 Shortcuts.intent_extradata + " AS " + SearchManager.SUGGEST_COLUMN_INTENT_EXTRA_DATA,
125 Shortcuts.shortcut_id + " AS " + SearchManager.SUGGEST_COLUMN_SHORTCUT_ID,
126 Shortcuts.spinner_while_refreshing + " AS " + SearchManager.SUGGEST_COLUMN_SPINNER_WHILE_REFRESHING,
127 Shortcuts.log_type + " AS " + CursorBackedSuggestionCursor.SUGGEST_COLUMN_LOG_TYPE,
205 db.delete(Shortcuts.TABLE_NAME, null, null);
228 ShortcutCursor shortcuts = getShortcutsForQuery(query, allowedCorpora, maxShortcuts,
230 if (shortcuts != null) {
231 startRefresh(shortcuts);
233 return shortcuts;
271 private void startRefresh(final ShortcutCursor shortcuts) {
272 mRefresher.refresh(shortcuts, new ShortcutRefresher.Listener() {
278 shortcuts.refresh(source, shortcutId, refreshed);
304 db.delete(Shortcuts.TABLE_NAME, SHORTCUT_BY_ID_WHERE, whereArgs);
307 db.updateWithOnConflict(Shortcuts.TABLE_NAME, shortcut,
328 String srcStr = mCursor.getString(Shortcuts.source.ordinal());
337 int versionCode = mCursor.getInt(Shortcuts.source_version_code.ordinal());
362 return "shortcuts[" + getUserQuery() + "]";
455 cv.put(Shortcuts.intent_key.name(), intentKey);
456 cv.put(Shortcuts.source.name(), sourceName);
457 cv.put(Shortcuts.source_version_code.name(), source.getVersionCode());
458 cv.put(Shortcuts.format.name(), suggestion.getSuggestionFormat());
459 cv.put(Shortcuts.title.name(), suggestion.getSuggestionText1());
460 cv.put(Shortcuts.description.name(), suggestion.getSuggestionText2());
461 cv.put(Shortcuts.description_url.name(), suggestion.getSuggestionText2Url());
462 cv.put(Shortcuts.icon1.name(), icon1Uri);
463 cv.put(Shortcuts.icon2.name(), icon2Uri);
464 cv.put(Shortcuts.intent_action.name(), intentAction);
465 cv.put(Shortcuts.intent_data.name(), intentData);
466 cv.put(Shortcuts.intent_query.name(), intentQuery);
467 cv.put(Shortcuts.intent_extradata.name(), intentExtraData);
468 cv.put(Shortcuts.shortcut_id.name(), suggestion.getShortcutId());
470 cv.put(Shortcuts.spinner_while_refreshing.name(), "true");
472 cv.put(Shortcuts.log_type.name(), suggestion.getSuggestionLogType());
520 String intentKey = shortcut.getAsString(Shortcuts.intent_key.name());
533 db.replaceOrThrow(Shortcuts.TABLE_NAME, null, shortcut);
543 * shortcuts table
545 enum Shortcuts {
563 static final String TABLE_NAME = "shortcuts";
567 Shortcuts() {
638 = Shortcuts.TABLE_NAME + "_" + Shortcuts.shortcut_id.name();
646 = Shortcuts.TABLE_NAME + "_delete";
648 = Shortcuts.TABLE_NAME + "_update_intent_key";
661 // The shortcuts info is not all that important, so we just drop the tables
663 Log.i(TAG, "Upgrading shortcuts DB from version " +
664 + oldVersion + " to " + newVersion + ". This deletes all shortcuts.");
677 db.execSQL("DROP TABLE IF EXISTS " + Shortcuts.TABLE_NAME);
703 db.execSQL("CREATE TABLE " + Shortcuts.TABLE_NAME + " (" +
706 Shortcuts.intent_key.name() + " TEXT NOT NULL COLLATE UNICODE PRIMARY KEY, " +
707 Shortcuts.source.name() + " TEXT NOT NULL, " +
708 Shortcuts.source_version_code.name() + " INTEGER NOT NULL, " +
709 Shortcuts.format.name() + " TEXT, " +
710 Shortcuts.title.name() + " TEXT, " +
711 Shortcuts.description.name() + " TEXT, " +
712 Shortcuts.description_url.name() + " TEXT, " +
713 Shortcuts.icon1.name() + " TEXT, " +
714 Shortcuts.icon2.name() + " TEXT, " +
715 Shortcuts.intent_action.name() + " TEXT, " +
716 Shortcuts.intent_data.name() + " TEXT, " +
717 Shortcuts.intent_query.name() + " TEXT, " +
718 Shortcuts.intent_extradata.name() + " TEXT, " +
719 Shortcuts.shortcut_id.name() + " TEXT, " +
720 Shortcuts.spinner_while_refreshing.name() + " TEXT, " +
721 Shortcuts.log_type.name() + " TEXT" +
724 // index for fast lookup of shortcuts by shortcut_id
726 + " ON " + Shortcuts.TABLE_NAME
727 + "(" + Shortcuts.shortcut_id.name() + ", " + Shortcuts.source.name() + ")");
731 // type must match Shortcuts.intent_key
733 + Shortcuts.TABLE_NAME + "(" + Shortcuts.intent_key + "), " +
766 + Shortcuts.TABLE_NAME
770 + " = OLD." + Shortcuts.intent_key.name() + ";"
775 + " AFTER UPDATE ON " + Shortcuts.TABLE_NAME
776 + " WHEN NEW." + Shortcuts.intent_key.name()
777 + " != OLD." + Shortcuts.intent_key.name()
780 + ClickLog.intent_key.name() + " = NEW." + Shortcuts.intent_key.name()
782 + ClickLog.intent_key.name() + " = OLD." + Shortcuts.intent_key.name()
