#include <DlgDbExplorer.h>

Inheritance diagram for DlgDbExplorer:

Public Member Functions
	DlgDbExplorer (QWidget *parent=0)

	~DlgDbExplorer () override

Public Member Functions inherited from KoDialog
QPushButton *	button (ButtonCode id) const

QIcon	buttonIcon (ButtonCode id) const

QString	buttonText (ButtonCode id) const

QString	buttonToolTip (ButtonCode id) const

QString	buttonWhatsThis (ButtonCode id) const

ButtonCode	defaultButton () const

QString	helpLinkText () const

void	incrementInitialSize (const QSize &size)

bool	isButtonEnabled (ButtonCode id) const

	KoDialog (QWidget *parent=0, Qt::WindowFlags f=Qt::WindowFlags())

QWidget *	mainWidget ()

QSize	minimumSizeHint () const override

void	setButtonFocus (ButtonCode id)

void	setButtonGuiItem (ButtonCode id, const KGuiItem &item)

void	setButtonIcon (ButtonCode id, const QIcon &icon)

void	setButtons (ButtonCodes buttonMask)

void	setButtonsOrientation (Qt::Orientation orientation)

void	setButtonText (ButtonCode id, const QString &text)

void	setButtonToolTip (ButtonCode id, const QString &text)

void	setButtonWhatsThis (ButtonCode id, const QString &text)

void	setDefaultButton (ButtonCode id)

void	setEscapeButton (ButtonCode id)

void	setInitialSize (const QSize &size)

void	setMainWidget (QWidget *widget)

void	showButton (ButtonCode id, bool state)

void	showButtonSeparator (bool state)

QSize	sizeHint () const override

	~KoDialog () override

Private Slots
void	slotRvResourceTypeSelected (int index)

void	slotRvTagSelected (int index)

void	slotTbResourceItemSelected ()

void	slotTbResourceTypeSelected (int index)

void	slotTbTagSelected (const QModelIndex &index)

Private Member Functions
void	updateTagModel (const QString &resourceType)

Private Attributes
KisTagFilterResourceProxyModel *	m_filterProxyModel {0}

WdgDbExplorer *	m_page {0}

KisResourceTypeModel *	m_resourceTypeModel {0}

KisTagModel *	m_tagModel {0}

Additional Inherited Members
Public Types inherited from KoDialog
enum	ButtonCode { None = 0x00000000 , Help = 0x00000001 , Default = 0x00000002 , Ok = 0x00000004 , Apply = 0x00000008 , Try = 0x00000010 , Cancel = 0x00000020 , Close = 0x00000040 , No = 0x00000080 , Yes = 0x00000100 , Reset = 0x00000200 , Details = 0x00000400 , User1 = 0x00001000 , User2 = 0x00002000 , User3 = 0x00004000 , NoDefault = 0x00008000 }

enum	ButtonPopupMode { InstantPopup = 0 , DelayedPopup = 1 }

enum	CaptionFlag { NoCaptionFlags = 0 , AppNameCaption = 1 , ModifiedCaption = 2 , HIGCompliantCaption = AppNameCaption }

Public Slots inherited from KoDialog
void	delayedDestruct ()

void	enableButton (ButtonCode id, bool state)

void	enableButtonApply (bool state)

void	enableButtonCancel (bool state)

void	enableButtonOk (bool state)

void	enableLinkedHelp (bool state)

bool	isDetailsWidgetVisible () const

virtual void	setCaption (const QString &caption)

virtual void	setCaption (const QString &caption, bool modified)

void	setDetailsWidget (QWidget *detailsWidget)

void	setDetailsWidgetVisible (bool visible)

void	setHelp (const QString &anchor, const QString &appname=QString())

void	setHelpLinkText (const QString &text)

virtual void	setPlainCaption (const QString &caption)

Signals inherited from KoDialog
void	aboutToShowDetails ()

void	applyClicked ()

void	buttonClicked (KoDialog::ButtonCode button)

void	cancelClicked ()

void	closeClicked ()

void	defaultClicked ()

void	finished ()

void	helpClicked ()

void	hidden ()

void	layoutHintChanged ()

void	noClicked ()

void	okClicked ()

void	resetClicked ()

void	tryClicked ()

void	user1Clicked ()

void	user2Clicked ()

void	user3Clicked ()

void	yesClicked ()

Static Public Member Functions inherited from KoDialog
static int	groupSpacingHint ()

static QString	makeStandardCaption (const QString &userCaption, QWidget *window=0, CaptionFlags flags=HIGCompliantCaption)

static int	marginHint ()

static void	resizeLayout (QLayout *lay, int margin, int spacing)

static void	resizeLayout (QWidget *widget, int margin, int spacing)

static int	spacingHint ()

Protected Slots inherited from KoDialog
virtual void	slotButtonClicked (int button)

Protected Member Functions inherited from KoDialog
void	closeEvent (QCloseEvent *e) override

void	hideEvent (QHideEvent *) override

void	keyPressEvent (QKeyEvent *) override

void	showEvent (QShowEvent *e) override

Detailed Description

Definition at line 31 of file DlgDbExplorer.h.

Constructor & Destructor Documentation

◆ DlgDbExplorer()

DlgDbExplorer::DlgDbExplorer ( QWidget * parent = 0 )

Definition at line 32 of file DlgDbExplorer.cpp.

    : KoDialog(parent)
{
    setCaption(i18n("Resources Cache Database Explorer"));
 
    setButtons(Ok);
 
    m_page = new WdgDbExplorer(this);
    Q_CHECK_PTR(m_page);
 
    setMainWidget(m_page);
 
    m_resourceTypeModel = new KisResourceTypeModel(this);
    m_tagModel = new KisTagModel("", this);
 
    {
        KisStorageModel *model = new KisStorageModel(this);
        TableDelegate *delegate = new TableDelegate(m_page->tableResources);
        m_page->tableStorages->setModel(model);
        delegate->addDateTimeColumn(3); // creation date
        delegate->addBooleanColumn(4); // preinstalled
        delegate->addBooleanColumn(5); // active
        m_page->tableStorages->setItemDelegate(delegate);
        m_page->tableStorages->hideColumn(0);
        m_page->tableStorages->setSelectionMode(QAbstractItemView::SingleSelection);
        m_page->tableStorages->resizeColumnsToContents();
    }
 
    {
        KisResourceModel *resourcesModel = new KisResourceModel(ResourceType::Brushes, this);
        TableDelegate *resourcesDelegate = new TableDelegate(m_page->tableResources);
        resourcesDelegate->addBooleanColumn(6); // Status
        resourcesDelegate->addBooleanColumn(12); // Dirty
        resourcesDelegate->addBooleanColumn(14); // Active
        m_page->tableResources->setModel(resourcesModel);
        m_page->tableResources->setItemDelegate(resourcesDelegate);
        m_page->tableResources->hideColumn(0);
        m_page->tableResources->setSelectionMode(QAbstractItemView::SingleSelection);
 
        m_page->cmbResourceTypes->setModel(m_resourceTypeModel);
        m_page->cmbResourceTypes->setModelColumn(KisResourceTypeModel::Name);
 
        connect(m_page->cmbResourceTypes, SIGNAL(activated(int)), SLOT(slotTbResourceTypeSelected(int)));
        connect(m_page->tableResources, SIGNAL(clicked(QModelIndex)), SLOT(slotTbResourceItemSelected()));
    }
 
    {
        TableModel *resourceVersionsModel = new TableModel(this, QSqlDatabase::database());
        TableDelegate *versionsDelegate = new TableDelegate(m_page->tableVersions);
        resourceVersionsModel->setTable("versioned_resources");
        resourceVersionsModel->setHeaderData(0, Qt::Horizontal, i18n("Id"));
        resourceVersionsModel->setHeaderData(1, Qt::Horizontal, i18n("Resource ID"));
        resourceVersionsModel->setHeaderData(2, Qt::Horizontal, i18n("Storage ID"));
        resourceVersionsModel->setHeaderData(3, Qt::Horizontal, i18n("Version"));
        resourceVersionsModel->setHeaderData(4, Qt::Horizontal, i18n("File name"));
        resourceVersionsModel->setHeaderData(5, Qt::Horizontal, i18n("md5sum"));
        resourceVersionsModel->setHeaderData(6, Qt::Horizontal, i18n("Creation Date"));
        resourceVersionsModel->addDateTimeColumn(6);
        versionsDelegate->addDateTimeColumn(6);
        resourceVersionsModel->select();
 
        m_page->tableVersions->setModel(resourceVersionsModel);
        m_page->tableVersions->hideColumn(0);
        m_page->tableVersions->setItemDelegate(versionsDelegate);
        m_page->tableVersions->setSelectionMode(QAbstractItemView::NoSelection);
        m_page->tableVersions->resizeColumnsToContents();
    }
 
    {
        TableModel *tagsModel = new TableModel(this, QSqlDatabase::database());
        TableDelegate *tagsDelegate = new TableDelegate(m_page->tableStorages);
        tagsModel->setTable("tags");
        tagsModel->setHeaderData(0, Qt::Horizontal, i18n("Id"));
        tagsModel->setHeaderData(1, Qt::Horizontal, i18n("Type"));
        tagsModel->setRelation(1, QSqlRelation("resource_types", "id", "name"));
        tagsModel->setHeaderData(2, Qt::Horizontal, i18n("Tag"));
        tagsModel->setHeaderData(3, Qt::Horizontal, i18n("Name"));
        tagsModel->setHeaderData(4, Qt::Horizontal, i18n("Comment"));
        tagsModel->setHeaderData(5, Qt::Horizontal, i18n("File name"));
        tagsModel->setHeaderData(6, Qt::Horizontal, i18n("Active"));
        tagsModel->setHeaderData(7, Qt::Horizontal, i18n("Thumbnail"));
        tagsModel->setHeaderData(8, Qt::Horizontal, i18n("Display Name"));
        tagsModel->addBooleanColumn(6);
        tagsDelegate->addBooleanColumn(6);
        tagsModel->select();
 
        m_page->tableTags->setModel(tagsModel);
        m_page->tableTags->hideColumn(0);
        m_page->tableTags->setItemDelegate(tagsDelegate);
        m_page->tableTags->setSelectionMode(QAbstractItemView::SingleSelection);
        m_page->tableTags->resizeColumnsToContents();
 
        connect(m_page->tableTags, &QTableView::clicked, this, &DlgDbExplorer::slotTbTagSelected);
    }
 
    {
        KisTagResourceModel *model = new KisTagResourceModel(ResourceType::Brushes, this);
        TableDelegate *delegate = new TableDelegate(m_page->tableTaggedResources);
        delegate->addBooleanColumn(6); // status
        delegate->addBooleanColumn(12); // dirty
        delegate->addBooleanColumn(14); // resource active
        delegate->addBooleanColumn(15); // storage active
        delegate->addBooleanColumn(20); // resource active
        delegate->addBooleanColumn(21); // tag active
        delegate->addBooleanColumn(22); // storage active
 
        m_page->tableTaggedResources->setModel(model);
        m_page->tableTaggedResources->setItemDelegate(delegate);
        m_page->tableTaggedResources->setSelectionMode(QAbstractItemView::NoSelection);
        m_page->tableTaggedResources->resizeColumnsToContents();
    }
 
    {
        TableModel *versionModel = new TableModel(this, QSqlDatabase::database());
        TableDelegate *delegate = new TableDelegate(m_page->tableSchema);
        versionModel->setTable("version_information");
        versionModel->setHeaderData(0, Qt::Horizontal, i18n("Id"));
        versionModel->setHeaderData(1, Qt::Horizontal, i18n("Database version"));
        versionModel->setHeaderData(2, Qt::Horizontal, i18n("Krita version"));
        versionModel->setHeaderData(3, Qt::Horizontal, i18n("Upgrade date"));
        versionModel->addDateTimeColumn(3);
        delegate->addDateTimeColumn(3);
        versionModel->select();
 
        const QSqlRecord r = versionModel->record(0);
        m_page->lblDatabaseVersion->setText(r.value(1).toString());
        m_page->lblKritaVersion->setText(r.value(2).toString());
        m_page->lblCreationDate->setText(QDateTime::fromSecsSinceEpoch(r.value(3).value<int>()).toString());
 
        m_page->tableSchema->setModel(versionModel);
        m_page->tableSchema->hideColumn(0);
        m_page->tableSchema->setItemDelegate(delegate);
        m_page->tableSchema->setSelectionMode(QAbstractItemView::NoSelection);
        m_page->tableSchema->resizeColumnsToContents();
    }
 
 
    {
        m_page->cmbRvResourceTypes->setModel(m_resourceTypeModel);
        m_page->cmbRvResourceTypes->setModelColumn(KisResourceTypeModel::Name);
        connect(m_page->cmbRvResourceTypes, SIGNAL(activated(int)), SLOT(slotRvResourceTypeSelected(int)));
 
        m_page->cmbRvTags->setModelColumn(KisAllTagsModel::Name);
        m_page->cmbRvTags->setModel(m_tagModel);
        connect(m_page->cmbRvTags, SIGNAL(activated(int)), SLOT(slotRvTagSelected(int)));
 
        m_page->cmbRvResourceTypes->setCurrentIndex(0);
        slotRvResourceTypeSelected(0);
 
        m_page->resourceItemView->setItemDelegate(new KisResourceItemDelegate(this));
        m_page->resourceItemView->setSelectionMode(QAbstractItemView::SingleSelection);
    }
 
}

References TableDelegate::addBooleanColumn(), TableModel::addBooleanColumn(), TableDelegate::addDateTimeColumn(), TableModel::addDateTimeColumn(), ResourceType::Brushes, connect(), m_page, m_resourceTypeModel, m_tagModel, KisResourceTypeModel::Name, KisAllTagsModel::Name, KoDialog::Ok, KoDialog::setButtons(), KoDialog::setCaption(), KoDialog::setMainWidget(), slotRvResourceTypeSelected(), slotRvTagSelected(), slotTbResourceItemSelected(), slotTbResourceTypeSelected(), and slotTbTagSelected().

◆ ~DlgDbExplorer()

DlgDbExplorer::~DlgDbExplorer ( )

override

Definition at line 187 of file DlgDbExplorer.cpp.

188{

189}

Member Function Documentation

◆ slotRvResourceTypeSelected

void DlgDbExplorer::slotRvResourceTypeSelected ( int index )

privateslot

Definition at line 200 of file DlgDbExplorer.cpp.

{
    QModelIndex idx = m_page->cmbResourceTypes->model()->index(index, KisResourceTypeModel::ResourceType);
    QString resourceType = idx.data(Qt::DisplayRole).toString();
 
    updateTagModel(resourceType);
 
    KisTagFilterResourceProxyModel *tagFilterModel = new KisTagFilterResourceProxyModel(resourceType, this);
 
    m_filterProxyModel = tagFilterModel;
 
    m_page->resourceItemView->setModel(tagFilterModel);
}

References m_filterProxyModel, m_page, KisResourceTypeModel::ResourceType, and updateTagModel().

◆ slotRvTagSelected

void DlgDbExplorer::slotRvTagSelected ( int index )

privateslot

Definition at line 271 of file DlgDbExplorer.cpp.

{
    qDebug() << "selected tag" << index;
    QModelIndex idx = m_tagModel->index(index, 0);
    KisTagSP tag = m_tagModel->tagForIndex(idx);
 
    if (m_filterProxyModel && !tag.isNull() && tag->valid()) {
        m_filterProxyModel->setTagFilter(tag);
        m_page->tableTaggedResources->resizeColumnsToContents();
    }
}

References m_filterProxyModel, m_page, m_tagModel, KisTagFilterResourceProxyModel::setTagFilter(), and KisTagModel::tagForIndex().

◆ slotTbResourceItemSelected

void DlgDbExplorer::slotTbResourceItemSelected ( )

privateslot

Definition at line 228 of file DlgDbExplorer.cpp.

{
    if (m_page->tableResources->selectionModel()->selectedIndexes().isEmpty()) return;
 
    QModelIndex idx = m_page->tableResources->selectionModel()->selectedIndexes().first();
 
    QImage thumb = idx.data(Qt::UserRole + KisAbstractResourceModel::Thumbnail).value<QImage>();
    Qt::TransformationMode mode = Qt::SmoothTransformation;
    if (thumb.size().width() < 100 && thumb.size().height() < 100) {
        mode = Qt::FastTransformation;
    }
 
    if (!thumb.isNull()) {
        m_page->lblThumbnail->setPixmap(QPixmap::fromImage(thumb.scaled(100, 100, Qt::KeepAspectRatio, mode)));
    } else {
        m_page->lblThumbnail->setPixmap(QPixmap());
    }
 
    TableModel *model = dynamic_cast<TableModel *>(m_page->tableVersions->model());
 
    if (model) {
        const QString md5 = idx.data(Qt::UserRole + KisAbstractResourceModel::MD5).value<QString>();
        model->setFilter(QString("md5sum='%1'").arg(md5));
        m_page->tableVersions->resizeColumnsToContents();
    }
}

References m_page, KisAbstractResourceModel::MD5, and KisAbstractResourceModel::Thumbnail.

◆ slotTbResourceTypeSelected

void DlgDbExplorer::slotTbResourceTypeSelected ( int index )

privateslot

Definition at line 214 of file DlgDbExplorer.cpp.

{
    QModelIndex idx = m_page->cmbRvResourceTypes->model()->index(index, KisResourceTypeModel::ResourceType);
    QString resourceType = idx.data(Qt::DisplayRole).toString();
 
    m_tagModel = new KisTagModel(resourceType, this);
 
    KisResourceModel *resourceModel = new KisResourceModel(resourceType, this);
    m_page->tableResources->setModel(resourceModel);
    m_page->tableResources->setCurrentIndex(m_page->tableResources->model()->index(0, 0));
    slotTbResourceItemSelected();
    m_page->tableResources->resizeColumnsToContents();
}

References m_page, m_tagModel, KisResourceTypeModel::ResourceType, and slotTbResourceItemSelected().

◆ slotTbTagSelected

void DlgDbExplorer::slotTbTagSelected ( const QModelIndex & index )

privateslot

Definition at line 255 of file DlgDbExplorer.cpp.

{
    // 0 == tag ID
    const QModelIndex idx = m_page->tableTags->model()->index(index.row(), 0);
    // get tag's resource type
    const QModelIndex idx2 = m_page->tableTags->model()->index(index.row(), 1);
 
    KisTagResourceModel *newModel = new KisTagResourceModel(idx2.data().value<QString>(), this);
    newModel->setResourceFilter(KisTagResourceModel::ShowAllResources);
    newModel->setTagsFilter(QVector<int>{idx.data().value<int>()});
    QAbstractItemModel *oldModel = m_page->tableTaggedResources->model();
    m_page->tableTaggedResources->setModel(newModel);
    m_page->tableTaggedResources->resizeColumnsToContents();
    oldModel->deleteLater();
}

References m_page, KisTagResourceModel::setResourceFilter(), KisTagResourceModel::setTagsFilter(), and KisAbstractResourceFilterInterface::ShowAllResources.

◆ updateTagModel()

void DlgDbExplorer::updateTagModel ( const QString & resourceType )

private

Definition at line 191 of file DlgDbExplorer.cpp.

{
    m_tagModel = new KisTagModel(resourceType, this);
    m_page->cmbRvTags->setModelColumn(KisAllTagsModel::Name);
    m_page->cmbRvTags->setModel(m_tagModel);
    m_page->cmbRvTags->update();
    qDebug() << "number of tags in " << resourceType << " tag model: " << m_tagModel->rowCount();
}

References m_page, m_tagModel, and KisAllTagsModel::Name.

Member Data Documentation

◆ m_filterProxyModel

KisTagFilterResourceProxyModel* DlgDbExplorer::m_filterProxyModel {0}

private

Definition at line 55 of file DlgDbExplorer.h.

55{0};

◆ m_page

WdgDbExplorer* DlgDbExplorer::m_page {0}

private

Definition at line 51 of file DlgDbExplorer.h.

51{0};

◆ m_resourceTypeModel

KisResourceTypeModel* DlgDbExplorer::m_resourceTypeModel {0}

private

Definition at line 54 of file DlgDbExplorer.h.

54{0};

◆ m_tagModel

KisTagModel* DlgDbExplorer::m_tagModel {0}

private

Definition at line 53 of file DlgDbExplorer.h.

53{0};

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

plugins/extensions/dbexplorer/DlgDbExplorer.h
plugins/extensions/dbexplorer/DlgDbExplorer.cpp

Public Member Functions

Private Slots

Private Member Functions

Private Attributes

Additional Inherited Members

Detailed Description

Constructor & Destructor Documentation

◆ DlgDbExplorer()

◆ ~DlgDbExplorer()

Member Function Documentation

◆ slotRvResourceTypeSelected

◆ slotRvTagSelected

◆ slotTbResourceItemSelected

◆ slotTbResourceTypeSelected

◆ slotTbTagSelected

◆ updateTagModel()

Member Data Documentation

◆ m_filterProxyModel

◆ m_page

◆ m_resourceTypeModel

◆ m_tagModel