Differential D15305 Diff 41124 runners/bookmarks/browsers/firefox.cpp

Changeset View

Standalone View

View Options

runners/bookmarks/browsers/firefox.cpp

Show First 20 Lines • Show All 81 Lines • ▼ Show 20 Line(s)80{
82 if (!m_fetchsqlite) { 82​ if (!m_fetchsqlite) {
83 return matches; 83​ return matches;
84 } 84​ }
85 //qDebug() << "Firefox bookmark: match " << term; 85​ //qDebug() << "Firefox bookmark: match " << term;
86 86​
87 QString tmpTerm = term; 87​ QString tmpTerm = term;
88 QString query; 88​ QString query;
89 if (addEverything) { 89​ if (addEverything) {
90 query = QStringLiteral("SELECT moz_bookmarks.fk, moz_bookmarks.title, moz_places.url," \ 90​ query = QStringLiteral("SELECT moz_bookmarks.fk, moz_bookmarks.title, moz_places.url " \
91 "moz_places.favicon_id FROM moz_bookmarks, moz_places WHERE " \ 91​ "FROM moz_bookmarks, moz_places WHERE " \
92 "moz_bookmarks.type = 1 AND moz_bookmarks.fk = moz_places.id"); 92​ "moz_bookmarks.type = 1 AND moz_bookmarks.fk = moz_places.id");
93 } else { 93​ } else {
94 const QString escapedTerm = tmpTerm.replace('\'', QLatin1String("\\'")); 94​ const QString escapedTerm = tmpTerm.replace('\'', QLatin1String("\\'"));
95 query = QString("SELECT moz_bookmarks.fk, moz_bookmarks.title, moz_places.url," \ 95​ query = QString("SELECT moz_bookmarks.fk, moz_bookmarks.title, moz_places.url " \
96 "moz_places.favicon_id FROM moz_bookmarks, moz_places WHERE " \ 96​ "FROM moz_bookmarks, moz_places WHERE " \
97 "moz_bookmarks.type = 1 AND moz_bookmarks.fk = moz_places.id AND " \ 97​ "moz_bookmarks.type = 1 AND moz_bookmarks.fk = moz_places.id AND " \
98 "(moz_bookmarks.title LIKE '%" + escapedTerm + "%' or moz_places.url LIKE '%" 98​ "(moz_bookmarks.title LIKE '%" + escapedTerm + "%' or moz_places.url LIKE '%"
99 + escapedTerm + "%')"); 99​ + escapedTerm + "%')");
100 } 100​ }
101 QList<QVariantMap> results = m_fetchsqlite->query(query, QMap<QString, QVariant>()); 101​ QList<QVariantMap> results = m_fetchsqlite->query(query, QMap<QString, QVariant>());
102 foreach(QVariantMap result, results) { 102​ foreach(QVariantMap result, results) {
103 const QString title = result.value(QStringLiteral("title")).toString(); 103​ const QString title = result.value(QStringLiteral("title")).toString();
104 const QUrl url = result.value(QStringLiteral("url")).toUrl(); 104​ const QUrl url = result.value(QStringLiteral("url")).toUrl();
▲ Show 20 Lines • Show All 73 Lines • Show Last 20 Lines