Changeset View
Changeset View
Standalone View
Standalone View
runners/bookmarks/faviconfromblob.cpp
Show All 34 Lines | |||||
35 | #include <QSqlError> | 35 | #include <QSqlError> | ||
36 | #include <QSqlRecord> | 36 | #include <QSqlRecord> | ||
37 | 37 | | |||
38 | FaviconFromBlob *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 |