Krita Source Code Documentation
Loading...
Searching...
No Matches
Static Public Member Functions | Static Private Member Functions | List of all members
KisResourceQueryMapper Class Reference

#include <KisResourceQueryMapper.h>

Static Public Member Functions

static QVariant variantFromResourceQuery (const QSqlQuery &query, int column, int role, bool useResourcePrefix)
 variantFromResourceQuery returns a QVariant for the given column and or role
 

Static Private Member Functions

static QImage getThumbnailFromQuery (const QSqlQuery &query, bool useResourcePrefix)
 

Detailed Description

Definition at line 13 of file KisResourceQueryMapper.h.

Member Function Documentation

◆ getThumbnailFromQuery()

QImage KisResourceQueryMapper::getThumbnailFromQuery ( const QSqlQuery & query,
bool useResourcePrefix )
staticprivate

Definition at line 30 of file KisResourceQueryMapper.cpp.

31{
32 const QString storageLocation =
33 KisResourceLocator::instance()->makeStorageLocationAbsolute(query.value("location").toString());
34 const QString resourceType = query.value("resource_type").toString();
35 const QString filename = query.value(useResourcePrefix ? "resource_filename" : "filename").toString();
36
37 // NOTE: Only use the private methods of KisResourceThumbnailCache here to prevent any chances of
38 // recursion.
39 QImage img =
40 KisResourceThumbnailCache::instance()->originalImage(storageLocation, resourceType, filename);
41 if (!img.isNull()) {
42 return img;
43 } else {
44 const int resourceId = query.value(useResourcePrefix ? "resource_id" : "id").toInt();
45 KIS_SAFE_ASSERT_RECOVER_RETURN_VALUE(resourceId >= 0, img);
46
47 bool result = false;
48 QSqlQuery thumbQuery;
49 result = thumbQuery.prepare("SELECT thumbnail FROM resources WHERE resources.id = :resource_id");
50 if (!result) {
51 qWarning() << "Failed to prepare query for thumbnail of" << resourceId << thumbQuery.lastError();
52 return img;
53 }
54
55 thumbQuery.bindValue(":resource_id", resourceId);
56
57 result = thumbQuery.exec();
58
59 if (!result) {
60 qWarning() << "Failed to execute query for thumbnail of" << resourceId << thumbQuery.lastError();
61 return img;
62 }
63
64 if (!thumbQuery.next()) {
65 qWarning() << "Failed to find thumbnail of" << resourceId;
66 return img;
67 }
68
69 QByteArray ba = thumbQuery.value("thumbnail").toByteArray();
70 QBuffer buf(&ba);
71 buf.open(QBuffer::ReadOnly);
72 img.load(&buf, "PNG");
73
74 KisResourceThumbnailCache::instance()->insert(storageLocation, resourceType, filename, img);
75 return img;
76 }
77}
KisResourceLocator::makeStorageLocationAbsolute
QString makeStorageLocationAbsolute(QString storageLocation) const
Definition KisResourceLocator.cpp:1145
KisResourceLocator::instance
static KisResourceLocator * instance()
Definition KisResourceLocator.cpp:63
KisResourceThumbnailCache::insert
void insert(const QString &storageLocation, const QString &resourceType, const QString &filename, const QImage &image)
Definition KisResourceThumbnailCache.cpp:129
KisResourceThumbnailCache::instance
static KisResourceThumbnailCache * instance()
Definition KisResourceThumbnailCache.cpp:107
KisResourceThumbnailCache::originalImage
QImage originalImage(const QString &storageLocation, const QString &resourceType, const QString &filename) const
Definition KisResourceThumbnailCache.cpp:121
KIS_SAFE_ASSERT_RECOVER_RETURN_VALUE
#define KIS_SAFE_ASSERT_RECOVER_RETURN_VALUE(cond, val)
Definition kis_assert.h:129
KisDomUtils::toInt
int toInt(const QString &str, bool *ok=nullptr)
Definition kis_dom_utils.h:59
KisDomUtils::toString
QString toString(const QString &value)
Definition kis_dom_utils.h:30

References KisResourceThumbnailCache::insert(), KisResourceLocator::instance(), KisResourceThumbnailCache::instance(), KIS_SAFE_ASSERT_RECOVER_RETURN_VALUE, KisResourceLocator::makeStorageLocationAbsolute(), and KisResourceThumbnailCache::originalImage().

◆ variantFromResourceQuery()

QVariant KisResourceQueryMapper::variantFromResourceQuery ( const QSqlQuery & query,
int column,
int role,
bool useResourcePrefix )
static

variantFromResourceQuery returns a QVariant for the given column and or role

Parameters
querythe query: it supposed to be in the right position already

Definition at line 79 of file KisResourceQueryMapper.cpp.

80{
81 const QString resourceType = query.value("resource_type").toString();
82
83 switch(role) {
84 case Qt::FontRole:
85 return QFont();
86 case Qt::DisplayRole:
87 {
88 switch(column) {
89 case KisAbstractResourceModel::Id:
90 return query.value(useResourcePrefix ? "resource_id" : "id");
91 case KisAbstractResourceModel::StorageId:
92 return query.value("storage_id");
93 case KisAbstractResourceModel::Name:
94 return query.value(useResourcePrefix ? "resource_name" : "name");
95 case KisAbstractResourceModel::Filename:
96 return query.value(useResourcePrefix ? "resource_filename" : "filename");
97 case KisAbstractResourceModel::Tooltip:
98 return query.value(useResourcePrefix ? "resource_tooltip" : "tooltip");
99 case KisAbstractResourceModel::Thumbnail:
100 {
101 return QVariant::fromValue<QImage>(getThumbnailFromQuery(query, useResourcePrefix));
102 }
103 case KisAbstractResourceModel::Status:
104 return query.value(useResourcePrefix ? "resource_active" : "status");
105 case KisAbstractResourceModel::Location:
106 return query.value("location");
107 case KisAbstractResourceModel::ResourceType:
108 return query.value("resource_type");
109 case KisAbstractResourceModel::Dirty:
110 {
111 QString storageLocation = query.value("location").toString();
112 QString filename = query.value(useResourcePrefix ? "resource_filename" : "filename").toString();
113
114 // An uncached resource has not been loaded, so it cannot be dirty
115 if (!KisResourceLocator::instance()->resourceCached(storageLocation, resourceType, filename)) {
116 return false;
117 }
118 else {
119 // Now we have to check the resource, but that's cheap since it's been loaded in any case
120 KoResourceSP resource = KisResourceLocator::instance()->resourceForId(query.value(useResourcePrefix ? "resource_id" : "id").toInt());
121 return resource->isDirty();
122 }
123 }
124 case KisAbstractResourceModel::ResourceActive:
125 return query.value("resource_active");
126 case KisAbstractResourceModel::StorageActive:
127 return query.value(useResourcePrefix ? "resource_storage_active" : "storage_active");
128 default:
129 ;
130 };
131 Q_FALLTHROUGH();
132 }
133 case Qt::DecorationRole:
134 {
135 if (column == KisAbstractResourceModel::Thumbnail) {
136 return QVariant::fromValue<QImage>(getThumbnailFromQuery(query, useResourcePrefix));
137 }
138 return QVariant();
139 }
140 case Qt::CheckStateRole: {
141 switch (column) {
142 case KisAbstractResourceModel::Status:
143 if (query.value(useResourcePrefix ? "resource_active" : "status").toInt() == 0) {
144 return Qt::Unchecked;
145 } else {
146 return Qt::Checked;
147 }
148 case KisAbstractResourceModel::Dirty: {
149 const QString storageLocation = query.value("location").toString();
150 const QString filename = query.value(useResourcePrefix ? "resource_filename" : "filename").toString();
151
152 // An uncached resource has not been loaded, so it cannot be dirty
153 if (!KisResourceLocator::instance()->resourceCached(storageLocation, resourceType, filename)) {
154 return Qt::Unchecked;
155 } else {
156 // Now we have to check the resource, but that's cheap since it's been loaded in any case
157 KoResourceSP resource = KisResourceLocator::instance()->resourceForId(
158 query.value(useResourcePrefix ? "resource_id" : "id").toInt());
159 return resource->isDirty() ? Qt::Checked : Qt::Unchecked;
160 }
161 }
162 case KisAbstractResourceModel::ResourceActive:
163 if (query.value("resource_active").toInt() == 0) {
164 return Qt::Unchecked;
165 } else {
166 return Qt::Checked;
167 }
168 case KisAbstractResourceModel::StorageActive:
169 if (query.value(useResourcePrefix ? "resource_storage_active" : "storage_active").toInt() == 0) {
170 return Qt::Unchecked;
171 } else {
172 return Qt::Checked;
173 }
174 default:
175 return {};
176 };
177 }
178 case Qt::StatusTipRole:
179 return QVariant();
180 case Qt::ToolTipRole:
181 Q_FALLTHROUGH();
182 case Qt::WhatsThisRole:
183 return query.value(useResourcePrefix ? "resource_tooltip" : "tooltip");
184 case Qt::UserRole + KisAbstractResourceModel::Id:
185 return query.value(useResourcePrefix ? "resource_id" : "id");
186 case Qt::UserRole + KisAbstractResourceModel::StorageId:
187 return query.value("storage_id");
188 case Qt::UserRole + KisAbstractResourceModel::Name:
189 return query.value(useResourcePrefix ? "resource_name" : "name");
190 case Qt::UserRole + KisAbstractResourceModel::Filename:
191 return query.value(useResourcePrefix ? "resource_filename" : "filename");
192 case Qt::UserRole + KisAbstractResourceModel::Tooltip:
193 return query.value(useResourcePrefix ? "resource_tooltip" : "tooltip");
194 case Qt::UserRole + KisAbstractResourceModel::MD5:
195 return query.value(useResourcePrefix ? "resource_md5sum" : "md5sum");
196 case Qt::UserRole + KisAbstractResourceModel::Thumbnail:
197 {
198 return QVariant::fromValue<QImage>(getThumbnailFromQuery(query, useResourcePrefix));
199 }
200 case Qt::UserRole + KisAbstractResourceModel::Status:
201 return query.value(useResourcePrefix ? "resource_active" : "status");
202 case Qt::UserRole + KisAbstractResourceModel::Location:
203 return query.value("location");
204 case Qt::UserRole + KisAbstractResourceModel::ResourceType:
205 return query.value("resource_type");
206 case Qt::UserRole + KisAbstractResourceModel::Tags:
207 {
208 KisAllResourcesModel *resourceModel = KisResourceModelProvider::resourceModel(resourceType);
209 QStringList tagNames;
210 Q_FOREACH(const KisTagSP tag, resourceModel->tagsForResource(query.value(useResourcePrefix ? "resource_id" : "id").toInt())) {
211 tagNames << tag->name();
212 }
213 return tagNames;
214 }
215 case Qt::UserRole + KisAbstractResourceModel::Dirty:
216 {
217 QString storageLocation = query.value("location").toString();
218 QString filename = query.value(useResourcePrefix ? "resource_filename" : "filename").toString();
219
220 // An uncached resource has not been loaded, so it cannot be dirty
221 if (!KisResourceLocator::instance()->resourceCached(storageLocation, resourceType, filename)) {
222 return false;
223 }
224 else {
225 // Now we have to check the resource, but that's cheap since it's been loaded in any case
226 KoResourceSP resource = KisResourceLocator::instance()->resourceForId(query.value(useResourcePrefix ? "resource_id" : "id").toInt());
227 return resource->isDirty();
228 }
229 }
230 case Qt::UserRole + KisAbstractResourceModel::MetaData:
231 {
232 QMap<QString, QVariant> r = KisResourceLocator::instance()->metaDataForResource(query.value(useResourcePrefix ? "resource_id" : "id").toInt());
233 return r;
234 }
235 case Qt::UserRole + KisAbstractResourceModel::ResourceActive:
236 {
237 return query.value("resource_active");
238 }
239 case Qt::UserRole + KisAbstractResourceModel::StorageActive:
240 {
241 return query.value(useResourcePrefix ? "resource_storage_active" : "storage_active");
242 }
243 case Qt::UserRole + KisAbstractResourceModel::BrokenStatus:
244 {
245 if (resourceType == ResourceType::PaintOpPresets) {
246 KisResourceMetaDataModel *metaDataModel = KisResourceModelProvider::resourceMetadataModel();
247 const int id = query.value(useResourcePrefix ? "resource_id" : "id").toInt();
248 const QStringList requiredBrushes =
249 metaDataModel->metaDataValue(id, "dependent_resources_filenames").toStringList();
250 if (!requiredBrushes.isEmpty()) {
251 KisAllResourcesModel *model = KisResourceModelProvider::resourceModel(ResourceType::Brushes);
252 Q_FOREACH (const QString brushFile, requiredBrushes) {
253 if (!model->resourceExists("", brushFile, "")) {
254 qWarning() << "dependent resource" << brushFile << "misses.";
255 return true;
256 }
257 }
258 }
259 }
260
261 return false;
262 }
263 case Qt::UserRole + KisAbstractResourceModel::BrokenStatusMessage:
264 {
265 if (resourceType == ResourceType::PaintOpPresets) {
266 KisResourceMetaDataModel *metaDataModel = KisResourceModelProvider::resourceMetadataModel();
267 const int id = query.value(useResourcePrefix ? "resource_id" : "id").toInt();
268 const QStringList requiredBrushes =
269 metaDataModel->metaDataValue(id, "dependent_resources_filenames").toStringList();
270 QStringList missingResources;
271 if (!requiredBrushes.isEmpty()) {
272 KisAllResourcesModel *model = KisResourceModelProvider::resourceModel(ResourceType::Brushes);
273 Q_FOREACH (const QString brushFile, requiredBrushes) {
274 if (!model->resourceExists("", brushFile, "")) {
275 missingResources << brushFile;
276 break;
277 }
278 }
279 if (!missingResources.isEmpty()) {
280 QString resourcesList;
281 Q_FOREACH (const QString &resource, missingResources) {
282 resourcesList += "<li>" + resource + "</li>";
283 }
284
285 return QString(
286 "%1</br>"
287 "<ul style=\"list-style-type: disc; margin: 0px;\">%2</ul>")
288 .arg(i18n("Some resources are missing:"), resourcesList);
289 }
290 }
291 }
292 return QVariant();
293 }
294 default:
295 ;
296 }
297
298 return QVariant();
299}
KisAbstractResourceModel::Status
@ Status
Whether the resource is active. Duplicate of ResourceActive.
Definition KisResourceModel.h:40
KisAbstractResourceModel::ResourceActive
@ ResourceActive
Whether the current resource is active.
Definition KisResourceModel.h:52
KisAbstractResourceModel::Dirty
@ Dirty
A dirty resource is one that has been modified locally but not saved.
Definition KisResourceModel.h:48
KisAbstractResourceModel::MetaData
@ MetaData
MetaData is a map of key, value pairs that is associated with this resource.
Definition KisResourceModel.h:50
KisAbstractResourceModel::BrokenStatus
@ BrokenStatus
Whether the resource is broken (bool)
Definition KisResourceModel.h:56
KisAbstractResourceModel::StorageActive
@ StorageActive
Whether the current resource's storage is active.
Definition KisResourceModel.h:54
KisAllResourcesModel
The KisAllresourcesModel class provides access to the cache database for a particular resource type....
Definition KisResourceModel.h:237
KisAllResourcesModel::resourceExists
bool resourceExists(const QString &md5, const QString &filename, const QString &name)
resourceExists checks whether there is a resource with, in order, the given md5, the filename or the ...
Definition KisResourceModel.cpp:205
KisAllResourcesModel::tagsForResource
QVector< KisTagSP > tagsForResource(int resourceId) const
Definition KisResourceModel.cpp:610
KisResourceLocator::metaDataForResource
QMap< QString, QVariant > metaDataForResource(int id) const
metaDataForResource
Definition KisResourceLocator.cpp:738
KisResourceLocator::resourceForId
KoResourceSP resourceForId(int resourceId)
resourceForId returns the resource with the given id, or 0 if no such resource exists....
Definition KisResourceLocator.cpp:408
KisResourceMetaDataModel::metaDataValue
QVariant metaDataValue(int resourceId, const QString &key)
Definition KisResourceMetaDataModel.cpp:42
KisResourceModelProvider::resourceModel
static KisAllResourcesModel * resourceModel(const QString &resourceType)
Definition KisResourceModelProvider.cpp:43
KisResourceModelProvider::resourceMetadataModel
static KisResourceMetaDataModel * resourceMetadataModel()
Definition KisResourceModelProvider.cpp:104
KisResourceQueryMapper::getThumbnailFromQuery
static QImage getThumbnailFromQuery(const QSqlQuery &query, bool useResourcePrefix)
Definition KisResourceQueryMapper.cpp:30
ResourceType::Brushes
const QString Brushes
Definition KisResourceTypes.cpp:15
ResourceType::PaintOpPresets
const QString PaintOpPresets
Definition KisResourceTypes.cpp:14
resize_to_all_layers.r
r
Definition resize_to_all_layers.py:22

References KisAbstractResourceModel::BrokenStatus, KisAbstractResourceModel::BrokenStatusMessage, ResourceType::Brushes, KisAbstractResourceModel::Dirty, KisAbstractResourceModel::Filename, getThumbnailFromQuery(), KisAbstractResourceModel::Id, KisResourceLocator::instance(), KisAbstractResourceModel::Location, KisAbstractResourceModel::MD5, KisAbstractResourceModel::MetaData, KisResourceLocator::metaDataForResource(), KisResourceMetaDataModel::metaDataValue(), KisAbstractResourceModel::Name, ResourceType::PaintOpPresets, KisAbstractResourceModel::ResourceActive, KisResourceLocator::resourceCached(), KisAllResourcesModel::resourceExists(), KisResourceLocator::resourceForId(), KisResourceModelProvider::resourceMetadataModel(), KisResourceModelProvider::resourceModel(), KisAbstractResourceModel::ResourceType, KisAbstractResourceModel::Status, KisAbstractResourceModel::StorageActive, KisAbstractResourceModel::StorageId, KisAbstractResourceModel::Tags, KisAllResourcesModel::tagsForResource(), KisAbstractResourceModel::Thumbnail, and KisAbstractResourceModel::Tooltip.

The documentation for this class was generated from the following files: