akonadiconsole/dbconsole.cpp

   1 /*
   2     Copyright (c) 2009 Volker Krause <vkrause@kde.org>
   3
   4     This library is free software; you can redistribute it and/or modify it
   5     under the terms of the GNU Library General Public License as published by
   6     the Free Software Foundation; either version 2 of the License, or (at your
   7     option) any later version.
   8
   9     This library is distributed in the hope that it will be useful, but WITHOUT
  10     ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
  11     FITNESS FOR A PARTICULAR PURPOSE.  See the GNU Library General Public
  12     License for more details.
  13
  14     You should have received a copy of the GNU Library General Public License
  15     along with this library; see the file COPYING.LIB.  If not, write to the
  16     Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
  17     02110-1301, USA.
  18 */
  19
  20 #include "dbconsole.h"
  21 #include "dbaccess.h"
  22
  23 #include <QAction>
  24
  25 #include <KStandardAction>
  26 #include <KSharedConfig>
  27 #include <KConfigGroup>
  28 #include <QIcon>
  29
  30 #include <QApplication>
  31 #include <QClipboard>
  32 #include <QSqlQueryModel>
  33 #include <QSqlError>
  34 #include <QFontDatabase>
  35
  36 DbConsole::DbConsole(QWidget *parent) :
  37     QWidget(parent),
  38     mQueryModel(Q_NULLPTR)
  39 {
  40     ui.setupUi(this);
  41
  42     QAction *copyAction = KStandardAction::copy(this, SLOT(copyCell()), this);
  43     ui.resultView->addAction(copyAction);
  44
  45     ui.execButton->setIcon(QIcon::fromTheme(QStringLiteral("application-x-executable")));
  46     ui.execButton->setShortcut(Qt::CTRL + Qt::Key_Return);
  47     connect(ui.execButton, &QPushButton::clicked, this, &DbConsole::execClicked);
  48
  49     ui.queryEdit->setFont(QFontDatabase::systemFont(QFontDatabase::FixedFont));
  50     ui.errorView->setFont(QFontDatabase::systemFont(QFontDatabase::FixedFont));
  51
  52     ui.queryEdit->setPlainText(KSharedConfig::openConfig()->group("DBConsole").readEntry("queryText"));
  53 }
  54
  55 void DbConsole::execClicked()
  56 {
  57     const QString query = ui.queryEdit->toPlainText();
  58     if (query.isEmpty()) {
  59         return;
  60     }
  61     delete mQueryModel;
  62     mQueryModel = new QSqlQueryModel(this);
  63     mQueryModel->setQuery(query, DbAccess::database());
  64     ui.resultView->setModel(mQueryModel);
  65
  66     if (mQueryModel->lastError().isValid()) {
  67         ui.errorView->appendPlainText(mQueryModel->lastError().text());
  68         ui.resultStack->setCurrentWidget(ui.errorViewPage);
  69     } else {
  70         ui.errorView->clear();
  71         ui.resultStack->setCurrentWidget(ui.resultViewPage);
  72     }
  73
  74     KSharedConfig::openConfig()->group("DBConsole").writeEntry("queryText", query);
  75 }
  76
  77 void DbConsole::copyCell()
  78 {
  79     QModelIndex index = ui.resultView->currentIndex();
  80     if (!index.isValid()) {
  81         return;
  82     }
  83     QString text = index.data(Qt::DisplayRole).toString();
  84     QApplication::clipboard()->setText(text);
  85 }
  86