Differential D29726 Diff 82946 runners/bookmarks/faviconfromblob.cpp

Changeset View

Standalone View

View Options

runners/bookmarks/faviconfromblob.cpp

Show All 34 Lines
35#include <QSqlError> 35​#include <QSqlError>
36#include <QSqlRecord> 36​#include <QSqlRecord>
37 37​
38FaviconFromBlob *FaviconFromBlob::chrome(const QString &profileDirectory, QObject *parent) 38​FaviconFromBlob *FaviconFromBlob::chrome(const QString &profileDirectory, QObject *parent)
39{ 39​{
40 QString profileName = QFileInfo(profileDirectory).fileName(); 40​ QString profileName = QFileInfo(profileDirectory).fileName();
41 QString faviconCache = QStringLiteral("%1/KRunner-Chrome-Favicons-%2.sqlite") 41​ QString faviconCache = QStringLiteral("%1/KRunner-Chrome-Favicons-%2.sqlite")
42 .arg(QStandardPaths::writableLocation(QStandardPaths::CacheLocation), profileName); 42​ .arg(QStandardPaths::writableLocation(QStandardPaths::CacheLocation), profileName);
43 FetchSqlite *fetchSqlite = new FetchSqlite(profileDirectory + QStringLiteral("/Favicons"), faviconCache, parent); 43​ FetchSqlite *fetchSqlite = new FetchSqlite(faviconCache, parent);
44 44​
45 QString faviconQuery; 45​ QString faviconQuery;
46 if(fetchSqlite->tables().contains(QLatin1String("favicon_bitmaps"))) { 46​ if(fetchSqlite->tables().contains(QLatin1String("favicon_bitmaps"))) {
47 faviconQuery = QLatin1String("SELECT * FROM favicons " \ 47​ faviconQuery = QLatin1String("SELECT * FROM favicons " \
48 "inner join icon_mapping on icon_mapping.icon_id = favicons.id " \ 48​ "inner join icon_mapping on icon_mapping.icon_id = favicons.id " \
49 "inner join favicon_bitmaps on icon_mapping.icon_id = favicon_bitmaps.icon_id " \ 49​ "inner join favicon_bitmaps on icon_mapping.icon_id = favicon_bitmaps.icon_id " \
50 "WHERE page_url = :url ORDER BY height desc LIMIT 1;"); 50​ "WHERE page_url = :url ORDER BY height desc LIMIT 1;");
51 } else { 51​ } else {
▲ Show 20 Lines • Show All 74 Lines • Show Last 20 Lines