KisAllTagResourceModel Class Reference

#include <KisTagResourceModel.h>

Inheritance diagram for KisAllTagResourceModel:

Classes
struct	Private

Public Types
enum	Columns {   TagId = KisAbstractResourceModel::BrokenStatusMessage + 1 , ResourceId , Tag , Resource ,   ResourceActive , TagActive , ResourceStorageActive , ResourceName ,   TagName }

Public Member Functions
int	columnCount (const QModelIndex &parent=QModelIndex()) const override
QVariant	data (const QModelIndex &index, int role) const override
	Note: only role is significant, column is not.
QVariant	headerData (int section, Qt::Orientation orientation, int role=Qt::DisplayRole) const override
int	isResourceTagged (const KisTagSP tag, const int resourceId) override
	isResourceTagged
int	rowCount (const QModelIndex &parent=QModelIndex()) const override
bool	tagResources (const KisTagSP tag, const QVector< int > &resourceIds) override
bool	untagResources (const KisTagSP tag, const QVector< int > &resourceId) override
	~KisAllTagResourceModel () override
Public Member Functions inherited from KisAbstractTagResourceModel
virtual	~KisAbstractTagResourceModel ()

Private Slots
void	addStorage (const QString &location)
void	removeStorage (const QString &location)
void	slotResourceActiveStateChanged (const QString &resourceType, int resourceId)

Private Member Functions
void	closeQuery ()
QString	createQuery (bool onlyAchieve=true, bool returnADbIndexToo=false)
	KisAllTagResourceModel (const QString &resourceType, QObject *parent=0)
bool	resetQuery ()

Private Attributes
Private *const	d

Friends
class	KisResourceModelProvider
class	KisTagResourceModel
class	TestTagResourceModel

Detailed Description

Definition at line 37 of file KisTagResourceModel.h.

Member Enumeration Documentation

Columns

enum KisAllTagResourceModel::Columns

Enumerator
TagId
ResourceId
Tag
Resource
ResourceActive
TagActive
ResourceStorageActive
ResourceName
TagName

Definition at line 55 of file KisTagResourceModel.h.

                 {
        TagId = KisAbstractResourceModel::BrokenStatusMessage + 1,
        ResourceId,
        Tag,
        Resource,
        ResourceActive,
        TagActive,
        ResourceStorageActive,
        ResourceName,
        TagName
    };

Constructor & Destructor Documentation

KisAllTagResourceModel()

KisAllTagResourceModel::KisAllTagResourceModel ( const QString & resourceType, QObject * parent = 0 )

private

TODO: connect to beginExternalResourceImport() and beginExternalResourceRemove as well. It seems to work without them somehow, but I guess it is just a coincidence or UB

Definition at line 30 of file KisTagResourceModel.cpp.

    : QAbstractTableModel(parent)
    , d(new Private())
{
    d->resourceType = resourceType;
    resetQuery();
 
    connect(KisResourceLocator::instance(), SIGNAL(storageAdded(const QString&)), this, SLOT(addStorage(const QString&)));
    connect(KisResourceLocator::instance(), SIGNAL(storageRemoved(const QString&)), this, SLOT(removeStorage(const QString&)));
    connect(KisStorageModel::instance(), SIGNAL(storageEnabled(const QString&)), this, SLOT(addStorage(const QString&)));
    connect(KisStorageModel::instance(), SIGNAL(storageDisabled(const QString&)), this, SLOT(removeStorage(const QString&)));
    connect(KisResourceLocator::instance(), SIGNAL(resourceActiveStateChanged(const QString&, int)), this, SLOT(slotResourceActiveStateChanged(const QString&, int)));
 
}

References addStorage(), connect(), d, KisResourceLocator::instance(), KisStorageModel::instance(), removeStorage(), resetQuery(), KisAllTagResourceModel::Private::resourceType, and slotResourceActiveStateChanged().

~KisAllTagResourceModel()

KisAllTagResourceModel::~KisAllTagResourceModel ( )

override

Definition at line 50 of file KisTagResourceModel.cpp.

{
    delete d;
}

References d.

Member Function Documentation

addStorage

void KisAllTagResourceModel::addStorage ( const QString & location )

privateslot

Definition at line 517 of file KisTagResourceModel.cpp.

{
    Q_UNUSED(location);
    beginInsertRows(QModelIndex(), rowCount(), rowCount());
    resetQuery();
    endInsertRows();
}

References resetQuery(), and rowCount().

closeQuery()

void KisAllTagResourceModel::closeQuery ( )

private

Definition at line 691 of file KisTagResourceModel.cpp.

{
    d->query.clear();
}

References d, and KisAllTagResourceModel::Private::query.

columnCount()

int KisAllTagResourceModel::columnCount ( const QModelIndex & parent = QModelIndex() ) const

override

Definition at line 91 of file KisTagResourceModel.cpp.

{
    if (parent.isValid()) {
        return 0;
    }
 
    return d->columnCount;
}

References KisAllTagResourceModel::Private::columnCount, and d.

createQuery()

QString KisAllTagResourceModel::createQuery ( bool onlyAchieve = true, bool returnADbIndexToo = false )

private

Definition at line 558 of file KisTagResourceModel.cpp.

{
    QString query = QString("WITH initial_selection AS (\n"
                            "    SELECT   tags.id\n"
                            "    ,        resources.name\n"
                            "    ,        resources.filename\n"
                            "    ,        resources.md5sum\n"
                            "    ,        resource_types.id            as    resource_type_id\n"
                            "    ,        resource_types.name          as    resource_type_name\n"
                            "    ,        min(resources.id)            as    resource_id\n"
                            ) + (returnADbIndexToo ? QString(", resource_tags.id   as   resource_tags_row_id\n") : QString("")) + QString( // include r_t row id
                            ) + (onlyActive ? QString("") : QString(", resource_tags.active   as   resource_tags_pair_active\n")) + QString( // include r_t row active info
                            "    FROM     resource_types\n"
                            "    JOIN     resource_tags\n   ON       resource_tags.resource_id    = resources.id\n"
                            ) + (onlyActive ? QString("    AND       resource_tags.active         = 1\n") : QString("")) + QString( // make sure only active tags are used
                            "    JOIN     resources         ON       resources.resource_type_id   = resource_types.id\n"
                            "    JOIN     tags              ON       tags.id                      = resource_tags.tag_id\n"
                            "                              AND       tags.resource_type_id        = resource_types.id\n"
                            "    WHERE    resource_types.name          = :resource_type\n"
                            "    GROUP BY tags.id\n"
                            "    ,        resources.name\n"
                            "    ,        resources.filename\n"
                            "    ,        resources.md5sum\n"
                            "    ,        resource_types.id\n"
                            "    ORDER BY resource_tags.id\n"
                            ")\n"
                            "SELECT \n"
                            "       initial_selection.id           as tag_id\n"
                            ",      initial_selection.name         as resource_name\n"
                            ",      initial_selection.filename     as resource_filename\n"
                            ",      initial_selection.md5sum       as resource_md5sum\n"
                            ",      initial_selection.resource_id  as resource_id\n"
                            ",      tags.url                       as tag_url"
                            ",      tags.active                    as tag_active"
                            ",      tags.name                      as tag_name"
                            ",      tags.comment                   as tag_comment"
                            ",      resources.status               as resource_active\n"
                            ",      resources.tooltip              as resource_tooltip\n"
                            ",      resources.status               as resource_active\n"
                            ",      resources.storage_id           as storage_id\n"
                            ",      storages.active                as resource_storage_active\n"
                            ",      storages.location              as location\n"
                            ",      tag_translations.name          as translated_name\n"
                            ",      tag_translations.comment       as translated_comment\n"
                            ",      initial_selection.resource_type_name as resource_type\n"
                            ) + (returnADbIndexToo ? QString(", initial_selection.resource_tags_row_id   as   resource_tags_row_id\n") : QString("")) + QString(
                            ) + (onlyActive ? QString("") : QString(", initial_selection.resource_tags_pair_active   as   resource_tags_pair_active\n")) + QString(
                            "FROM      initial_selection\n"
                            "JOIN      tags               ON   tags.id                     = initial_selection.id\n"
                            "                            AND   tags.resource_type_id       = initial_selection.resource_type_id\n"
                            "JOIN      resources          ON   resources.id                = resource_id\n"
                            "JOIN      storages           ON   storages.id                 = resources.storage_id\n"
                            "LEFT JOIN tag_translations   ON   tag_translations.tag_id     = initial_selection.id\n"
                            "                            AND   tag_translations.language   = :language\n");
 
    return query;
}

data()

QVariant KisAllTagResourceModel::data ( const QModelIndex & index, int role ) const

override

Note: only role is significant, column is not.

Definition at line 100 of file KisTagResourceModel.cpp.

{
    QVariant v;
 
    if (!index.isValid()) { return v; }
    if (index.row() > rowCount()) { return v; }
    if (index.column() > d->columnCount) { return v;}
 
    bool pos = const_cast<KisAllTagResourceModel*>(this)->d->query.seek(index.row());
    if (!pos) {return v;}
 
    if (role < Qt::UserRole + TagId && index.column() < TagId) {
        return KisResourceQueryMapper::variantFromResourceQuery(d->query, index.column(), role, true);
    }
 
    if (role == Qt::FontRole) {
        return QFont();
    }
 
    if (index.column() >= TagId) {
        // trick to get the correct value without writing everything again
        // this is used for example in case of sorting
        role = Qt::UserRole + index.column();
    }
 
    // These are not shown, but needed for the filter
    switch(role) {
    case Qt::UserRole + TagId:
    {
        v = d->query.value("tag_id");
        break;
    }
    case Qt::UserRole + ResourceId:
    {
        v = d->query.value("resource_id");
        break;
    }
    case Qt::UserRole + Tag:
    {
        KisTagSP tag = KisResourceLocator::instance()->tagForUrl(d->query.value("tag_url").toString(), d->resourceType);
        v = QVariant::fromValue(tag);
        break;
    }
    case Qt::UserRole + Resource:
    {
        v = QVariant::fromValue(KisResourceLocator::instance()->resourceForId(d->query.value("resource_id").toInt()));
        break;
    }
    case Qt::UserRole + ResourceActive:
    {
        v = d->query.value("resource_active");
        break;
    }
    case Qt::UserRole + TagActive:
    {
        v = d->query.value("tag_active");
        break;
    }
    case Qt::UserRole + ResourceStorageActive:
    {
        v = d->query.value("resource_storage_active");
        break;
    }
    case Qt::UserRole + ResourceName:
    {
        v = d->query.value("resource_name");
        break;
    }
    case Qt::UserRole + TagName:
    {
        v = d->query.value("translated_name");
        if (v.isNull()) {
            v = d->query.value("tag_name");
        }
        break;
    }
 
    default:
        ;
    }
    return v;
}

References KisAllTagResourceModel::Private::columnCount, d, KisResourceLocator::instance(), KisAllTagResourceModel::Private::query, Resource, ResourceActive, ResourceId, ResourceName, ResourceStorageActive, KisAllTagResourceModel::Private::resourceType, rowCount(), Tag, TagActive, KisResourceLocator::tagForUrl(), TagId, TagName, v, and KisResourceQueryMapper::variantFromResourceQuery().

headerData()

QVariant KisAllTagResourceModel::headerData ( int section, Qt::Orientation orientation, int role = Qt::DisplayRole ) const

override

Definition at line 618 of file KisTagResourceModel.cpp.

{
    if (orientation != Qt::Horizontal) {
        return {};
    }
    if (role != Qt::DisplayRole) {
        return {};
    }
 
    switch (section) {
    case KisAbstractResourceModel::Id:
        return i18n("Id");
    case KisAbstractResourceModel::StorageId:
        return i18n("Storage ID");
    case KisAbstractResourceModel::Name:
        return i18n("Name");
    case KisAbstractResourceModel::Filename:
        return i18n("File Name");
    case KisAbstractResourceModel::Tooltip:
        return i18n("Tooltip");
    case KisAbstractResourceModel::Thumbnail:
        return i18n("Image");
    case KisAbstractResourceModel::Status:
        return i18n("Status");
    case KisAbstractResourceModel::Location:
        return i18n("Location");
    case KisAbstractResourceModel::ResourceType:
        return i18n("Resource Type");
    case KisAbstractResourceModel::ResourceActive:
        return i18n("Active");
    case KisAbstractResourceModel::StorageActive:
        return i18n("Storage Active");
    case KisAbstractResourceModel::MD5:
        return i18n("md5sum");
    case KisAbstractResourceModel::Tags:
        return i18n("Tags");
    case KisAbstractResourceModel::LargeThumbnail:
        return i18n("Large Thumbnail");
    case KisAbstractResourceModel::Dirty:
        return i18n("Dirty");
    case KisAbstractResourceModel::MetaData:
        return i18n("Metadata");
    default:
        role = Qt::UserRole + section;
        break;
    }
 
    switch (role) {
    case Qt::UserRole + KisAllTagResourceModel::TagId:
        return i18n("Tag ID");
    case Qt::UserRole + KisAllTagResourceModel::ResourceId:
        return i18n("Resource ID");
    case Qt::UserRole + KisAllTagResourceModel::Tag:
        return i18n("Tag Url");
    case Qt::UserRole + KisAllTagResourceModel::Resource:
        return i18n("Resource");
    case Qt::UserRole + ResourceActive:
        return i18n("Resource Active");
    case Qt::UserRole + TagActive:
        return i18n("Tag Active");
    case Qt::UserRole + ResourceStorageActive:
        return i18n("Storage Active");
    case Qt::UserRole + ResourceName:
        return i18n("Resource Name");
    case Qt::UserRole + TagName:
        return i18n("Tag File Name");
    default:
        break;
    }
 
    return {};
}

References KisAbstractResourceModel::Dirty, KisAbstractResourceModel::Filename, KisAbstractResourceModel::Id, KisAbstractResourceModel::LargeThumbnail, KisAbstractResourceModel::Location, KisAbstractResourceModel::MD5, KisAbstractResourceModel::MetaData, KisAbstractResourceModel::Name, Resource, KisAbstractResourceModel::ResourceActive, ResourceActive, ResourceId, ResourceName, ResourceStorageActive, KisAbstractResourceModel::ResourceType, KisAbstractResourceModel::Status, KisAbstractResourceModel::StorageActive, KisAbstractResourceModel::StorageId, Tag, TagActive, TagId, TagName, KisAbstractResourceModel::Tags, KisAbstractResourceModel::Thumbnail, and KisAbstractResourceModel::Tooltip.

isResourceTagged()

int KisAllTagResourceModel::isResourceTagged ( const KisTagSP tag, const int resourceId )

overridevirtual

isResourceTagged

Parameters

tag	the tag to check
resourceId	the id of the resource to check

Returns

-1 if the resource was never tagged before, 0 if the resource was tagged, but then untagged, 1 if the resource is already tagged

Implements KisAbstractTagResourceModel.

Definition at line 487 of file KisTagResourceModel.cpp.

{
    QSqlQuery query;
    bool r = query.prepare("SELECT resource_tags.active\n"
                           "FROM   resource_tags\n"
                           "WHERE  resource_tags.resource_id = :resource_id\n"
                           "AND    resource_tags.tag_id = :tag_id\n");
 
    if (!r) {
        qWarning() << "Could not prepare bool KisAllTagResourceModel::checkResourceTaggedState query" << query.lastError();
        return false;
    }
 
    query.bindValue(":resource_id", resourceId);
    query.bindValue(":tag_id", tag->id());
 
    if (!query.exec()) {
        qWarning() << "Could not execute is resource tagged with a specific tag query" << query.boundValues() << query.lastError();
        return false;
    }
 
    r = query.first();
    if (!r) {
        // Resource was not tagged
        return -1;
    }
 
    return query.value(0).toInt() > 0;
}

removeStorage

void KisAllTagResourceModel::removeStorage ( const QString & location )

privateslot

Definition at line 525 of file KisTagResourceModel.cpp.

{
    Q_UNUSED(location);
    beginRemoveRows(QModelIndex(), rowCount(), rowCount());
    resetQuery();
    endRemoveRows();
}

References resetQuery(), and rowCount().

resetQuery()

bool KisAllTagResourceModel::resetQuery ( )

private

Definition at line 696 of file KisTagResourceModel.cpp.

{
    bool r = d->query.prepare(createQuery(true));
 
    if (!r) {
        qWarning() << "Could not prepare KisAllTagResourcesModel query" << d->query.lastError();
    }
 
    d->query.bindValue(":resource_type", d->resourceType);
    d->query.bindValue(":language", KisTag::currentLocale());
 
    r = d->query.exec();
 
    if (!r) {
        qWarning() << "Could not execute KisAllTagResourcesModel query" << d->query.lastError();
    }
 
    d->cachedRowCount = -1;
 
    return r;
}

References KisAllTagResourceModel::Private::cachedRowCount, createQuery(), KisTag::currentLocale(), d, KisAllTagResourceModel::Private::query, and KisAllTagResourceModel::Private::resourceType.

rowCount()

int KisAllTagResourceModel::rowCount ( const QModelIndex & parent = QModelIndex() ) const

override

Definition at line 55 of file KisTagResourceModel.cpp.

{
    if (parent.isValid()) {
        return 0;
    }
 
    if (d->cachedRowCount < 0) {
        QSqlQuery q;
        const bool r = q.prepare("SELECT COUNT(DISTINCT resource_tags.tag_id || resources.name || resources.filename || resources.md5sum)\n"
                  "FROM   resource_tags\n"
                  ",      resources\n"
                  ",      resource_types\n"
                  "WHERE  resource_tags.resource_id = resources.id\n"
                  "AND    resources.resource_type_id = resource_types.id\n"
                  "AND    resource_types.name = :resource_type\n"
                  "AND    resource_tags.active = 1\n");
 
        if (!r) {
            qWarning() << "Could not execute resource/tags rowcount query" << q.lastError();
            return 0;
        }
 
        q.bindValue(":resource_type", d->resourceType);
 
        if (!q.exec()) {
            qWarning() << "Could not execute resource/tags rowcount query" << q.lastError();
            return 0;
        }
 
        q.first();
 
        const_cast<KisAllTagResourceModel*>(this)->d->cachedRowCount = q.value(0).toInt();
    }
    return d->cachedRowCount;
}

References KisAllTagResourceModel::Private::cachedRowCount, d, and KisAllTagResourceModel::Private::resourceType.

slotResourceActiveStateChanged

void KisAllTagResourceModel::slotResourceActiveStateChanged ( const QString & resourceType, int resourceId )

privateslot

The model has multiple rows for every resource, one row per tag, so we need to notify about the changes in all the tags

Definition at line 533 of file KisTagResourceModel.cpp.

{
    if (resourceType != d->resourceType) return;
    if (resourceId < 0) return;
 
    resetQuery();
 
    QVector<QModelIndex> indexes;
 
    for (int i = 0; i < rowCount(); ++i)  {
        const QModelIndex idx = this->index(i, 0);
        KIS_ASSERT_RECOVER(idx.isValid()) { continue; }
 
        if (idx.data(Qt::UserRole + KisAllTagResourceModel::ResourceId).toInt() == resourceId) {
            indexes << idx;
        }
    }
 
    Q_FOREACH(const QModelIndex &index, indexes) {
        Q_EMIT dataChanged(index, index, {Qt::CheckStateRole, Qt::UserRole + KisAllTagResourceModel::ResourceActive});
    }
}

References d, KIS_ASSERT_RECOVER, resetQuery(), ResourceActive, ResourceId, KisAllTagResourceModel::Private::resourceType, and rowCount().

tagResources()

bool KisAllTagResourceModel::tagResources ( const KisTagSP tag, const QVector< int > & resourceIds )

overridevirtual

Implements KisAbstractTagResourceModel.

Definition at line 183 of file KisTagResourceModel.cpp.

{
    KIS_SAFE_ASSERT_RECOVER_RETURN_VALUE(tag && tag->valid() && tag->id() >= 0, false);
 
    // notes for performance:
    // the only two costly parts are:
    // - executing the query constructed by createQuery()
    // - running endInsertRows() (because it updates all the views and filter proxies etc...)
 
    QVector<int> resourceIdsToAdd;
    QVector<int> resourceIdsToUpdate;
 
    // looks expensive but actually isn't
    for (int i = 0; i < resourceIds.count(); i++) {
        KIS_SAFE_ASSERT_RECOVER_RETURN_VALUE(resourceIds[i] >= 0, false);
        int taggedState = isResourceTagged(tag, resourceIds[i]);
        switch (taggedState) {
        case -1:
            // never tagged
            resourceIdsToAdd.append(resourceIds[i]);
            break;
        case 0:
            // tagged but then untagged
            resourceIdsToUpdate.append(resourceIds[i]);
            break;
        case 1:
            // it means the resource is already tagged; do nothing
            break;
        }
    }
 
    if (resourceIdsToAdd.isEmpty() && resourceIdsToUpdate.isEmpty()) {
        // Is already tagged, let's do nothing
        return true;
    }
 
    int howManyTimesBeginInsertedCalled = 0;
 
    if (resourceIdsToUpdate.count() > 0) {
 
        QSqlQuery allIndices;
        if (!allIndices.prepare(createQuery(false, true))) {
            qWarning() << "Could not prepare tagResource-allIndices query" << allIndices.lastError();
        }
 
        allIndices.bindValue(":resource_type", d->resourceType);
        allIndices.bindValue(":language", KisTag::currentLocale());
 
        if (!allIndices.exec()) {
            qWarning() << "Could not execute tagResource-allIndices query" << allIndices.lastError();
        }
 
        int activesRowId = -1;
        int lastActiveRowId = -1;
 
        // needed for beginInsertRows calculations
        QMap<int, int> resourcesCountForLastActiveRowId;
 
        int idd = 0;
 
        while (allIndices.next()) {
            idd++;
            bool isActive = allIndices.value("resource_tags_pair_active").toBool();
            if (isActive) {
                activesRowId++;
                lastActiveRowId = activesRowId;
            } else {
                bool variantSuccess = true;
                int rowTagId = allIndices.value("tag_id").toInt(&variantSuccess);
                KIS_SAFE_ASSERT_RECOVER(variantSuccess) { rowTagId = -1; }
                int rowResourceId = allIndices.value("resource_id").toInt(&variantSuccess);
                KIS_SAFE_ASSERT_RECOVER(variantSuccess) { rowResourceId = -1; }
                if (rowTagId == tag->id() && resourceIdsToUpdate.contains(rowResourceId)) {
                    if (!resourcesCountForLastActiveRowId.contains(lastActiveRowId)) {
                        resourcesCountForLastActiveRowId[lastActiveRowId] = 1;
                    } else {
                        resourcesCountForLastActiveRowId[lastActiveRowId] = resourcesCountForLastActiveRowId[lastActiveRowId] + 1;
                    }
                }
            }
         }
 
        Q_FOREACH(const int key, resourcesCountForLastActiveRowId.keys()) {
            // when having multiple beginInsertRows:
            // let's say you have this model:
            // 0  A
            // 1  A
            // 2  A
            //  <- put 2 Bs here
            // 3  A
            //  <- put one B here
            // 4  A
            // and you want to add the two Bs and then add another B
            // then the signals should be:
            // beginRemoveRows(3, 4) <- new indices of the two Bs
            // beginRemoveRows(4, 4) <- new index of the one B ignoring the action before
 
 
            beginInsertRows(QModelIndex(), key + 1, key + resourcesCountForLastActiveRowId[key]);
            howManyTimesBeginInsertedCalled++;
        }
 
        // Resource was tagged, then untagged. Tag again;
        QSqlQuery q;
 
        if (!q.prepare("UPDATE resource_tags\n"
                       "SET    active = 1\n"
                       "WHERE  resource_id = :resource_id\n"
                       "AND    tag_id      = :tag_id")) {
 
 
            qWarning() << "Could not prepare update resource_tags to active statement" << q.lastError();
 
            return false;
        }
 
        QVariantList resourceIdsVariants;
        QVariantList tagIdVariants;
 
        for (int i = 0; i < resourceIdsToUpdate.count(); i++) {
            resourceIdsVariants << QVariant(resourceIdsToUpdate[i]);
            tagIdVariants << QVariant(tag->id());
        }
 
        q.bindValue(":resource_id", resourceIdsVariants);
        q.bindValue(":tag_id", tagIdVariants);
 
        if (!q.execBatch()) {
            qWarning() << "Could not execute update resource_tags to active statement" << q.lastError();
            for (int i = 0; i < howManyTimesBeginInsertedCalled; i++) {
                endInsertRows();
            }
            return false;
        }
 
    }
 
    if (resourceIdsToAdd.count() > 0) {
 
        beginInsertRows(QModelIndex(), rowCount(), rowCount() + resourceIdsToAdd.count() - 1);
        howManyTimesBeginInsertedCalled++;
 
        // Resource was never tagged before, insert it. The active column is DEFAULT 1
        QSqlQuery q;
 
 
        QString values;
        for (int i = 0; i < resourceIdsToAdd.count(); i++) {
            if (i > 0) {
                values.append(", ");
            }
            values.append("(?, ?, ?)");
        }
 
        if (!q.prepare(QString("INSERT INTO resource_tags\n"
                       "(resource_id, tag_id, active)\n"
                       "VALUES ") + values + QString(";\n"))) {
            qWarning() << "Could not prepare insert into resource tags statement" << q.lastError();
            for (int i = 0; i < howManyTimesBeginInsertedCalled; i++) {
                endInsertRows();
            }
            return false;
        }
 
        for (int i = 0; i < resourceIdsToAdd.count(); i++) {
            q.addBindValue(resourceIdsToAdd[i]);
            q.addBindValue(tag->id());
            q.addBindValue(true);
 
        }
 
        if (!q.exec()) {
            qWarning() << "Could not execute insert into resource tags statement" << q.boundValues() << q.lastError();
            for (int i = 0; i < howManyTimesBeginInsertedCalled; i++) {
                endInsertRows();
            }
            return false;
        }
    }
 
    resetQuery();
 
    for (int i = 0; i < howManyTimesBeginInsertedCalled; i++) {
        endInsertRows();
    }
 
    return true;
}

References createQuery(), KisTag::currentLocale(), d, isResourceTagged(), KIS_SAFE_ASSERT_RECOVER, KIS_SAFE_ASSERT_RECOVER_RETURN_VALUE, resetQuery(), KisAllTagResourceModel::Private::resourceType, and rowCount().

untagResources()

bool KisAllTagResourceModel::untagResources ( const KisTagSP tag, const QVector< int > & resourceId )

overridevirtual

Implements KisAbstractTagResourceModel.

Definition at line 372 of file KisTagResourceModel.cpp.

{
    if (!tag || !tag->valid()) return false;
    if (!d->query.isSelect()) return false;
    if (rowCount() < 1) return false;
 
    int beginRemoveRowsCount = 0;
 
    QSqlQuery q;
 
    if (!q.prepare("UPDATE resource_tags\n"
                   "SET    active      = 0\n"
                   "WHERE  tag_id      = :tag_id\n"
                   "AND    resource_id = :resource_id")) {
        qWarning() << "Could not prepare untagResource-update query" << q.lastError();
        return false;
    }
 
    QSqlQuery allIndices;
    if (!allIndices.prepare(createQuery(true, true))) {
        qWarning() << "Could not prepare untagResource-allIndices query " << allIndices.lastError();
    }
 
    allIndices.bindValue(":resource_type", d->resourceType);
    allIndices.bindValue(":language", KisTag::currentLocale());
 
    if (!allIndices.exec()) {
        qCritical() << "Could not exec untagResource-allIndices query " << allIndices.lastError();
    }
 
    int activesRowId = -1;
    int lastActiveRowId = -1;
 
    // needed for beginInsertRows indices calculations
    QMap<int, int> resourcesCountForLastActiveRowId;
 
    int idd = 0;
 
    while (allIndices.next()) {
        idd++;
        bool variantSuccess = true;
 
        bool isActive = true; // all of them are active!
        KIS_SAFE_ASSERT_RECOVER(variantSuccess) { isActive = false; }
 
        int rowTagId = allIndices.value("tag_id").toInt(&variantSuccess);
        KIS_SAFE_ASSERT_RECOVER(variantSuccess) { rowTagId = -1; }
        int rowResourceId = allIndices.value("resource_id").toInt(&variantSuccess);
        KIS_SAFE_ASSERT_RECOVER(variantSuccess) { rowResourceId = -1; }
 
        bool willStayActive = isActive && (rowTagId != tag->id() || !resourceIds.contains(rowResourceId));
        activesRowId++;
        if (willStayActive) {
            lastActiveRowId = activesRowId;
        } else if (isActive) {
            // means we're removing it
            if (!resourcesCountForLastActiveRowId.contains(lastActiveRowId)) {
                resourcesCountForLastActiveRowId[lastActiveRowId] = 0;
            }
            resourcesCountForLastActiveRowId[lastActiveRowId]++;
        }
    }
 
    Q_FOREACH(const int key, resourcesCountForLastActiveRowId.keys()) {
        // when having multiple beginRemoveRows:
        // let's say you have this model:
        // 0  A
        // 1  A
        // 2  A
        // 3  *B*
        // 4  *B*
        // 5  A
        // 6  *B*
        // 7  A
        // and you want to remove all Bs
        // then the signals should be:
        // beginRemoveRows(3, 4) <- first two indices in the obvious way
        // beginRemoveRows(4, 4) <- next index as if the first action was already done
        //  (so `5  A` already became `3  A`, so the *B* is `4  B`, not `6  B`)
 
        beginRemoveRows(QModelIndex(), key + 1, key + resourcesCountForLastActiveRowId[key]);
        beginRemoveRowsCount++;
    }
 
    QSqlDatabase::database().transaction();
    for (int i = 0; i < resourceIds.count(); i++) {
        int resourceId = resourceIds[i];
 
        if (resourceId < 0) continue;
        if (isResourceTagged(tag, resourceId) < 1) continue;
 
        q.bindValue(":tag_id", tag->id());
        q.bindValue(":resource_id", resourceId);
 
        if (!q.exec()) {
            qWarning() << "Could not execute untagResource-update query" << q.lastError() << q.boundValues();
            for (int i = 0; i < beginRemoveRowsCount; i++) {
                endRemoveRows();
            }
            QSqlDatabase::database().rollback();
            return false;
        }
    }
    QSqlDatabase::database().commit();
 
    if (beginRemoveRowsCount > 0) {
        resetQuery();
        for (int i = 0; i < beginRemoveRowsCount; i++) {
            endRemoveRows();
        }
    }
 
    return true;
}

References createQuery(), KisTag::currentLocale(), d, isResourceTagged(), KIS_SAFE_ASSERT_RECOVER, KisAllTagResourceModel::Private::query, resetQuery(), KisAllTagResourceModel::Private::resourceType, and rowCount().

Friends And Related Symbol Documentation

KisResourceModelProvider

friend class KisResourceModelProvider

friend

Definition at line 44 of file KisTagResourceModel.h.

KisTagResourceModel

friend class KisTagResourceModel

friend

Definition at line 46 of file KisTagResourceModel.h.

TestTagResourceModel

friend class TestTagResourceModel

friend

Definition at line 45 of file KisTagResourceModel.h.

Member Data Documentation

d

Private* const KisAllTagResourceModel::d

private

Definition at line 96 of file KisTagResourceModel.h.

---

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

• libs/resources/KisTagResourceModel.h
• libs/resources/KisTagResourceModel.cpp