mirror of
https://bitbucket.org/smil3y/kde-playground.git
synced 2025-02-23 10:22:50 +00:00
83 lines
2.5 KiB
C++
83 lines
2.5 KiB
C++
/*
|
|
Copyright (c) 2009 Volker Krause <vkrause@kde.org>
|
|
|
|
This library is free software; you can redistribute it and/or modify it
|
|
under the terms of the GNU Library General Public License as published by
|
|
the Free Software Foundation; either version 2 of the License, or (at your
|
|
option) any later version.
|
|
|
|
This library is distributed in the hope that it will be useful, but WITHOUT
|
|
ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
|
|
FITNESS FOR A PARTICULAR PURPOSE. See the GNU Library General Public
|
|
License for more details.
|
|
|
|
You should have received a copy of the GNU Library General Public License
|
|
along with this library; see the file COPYING.LIB. If not, write to the
|
|
Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
|
|
02110-1301, USA.
|
|
*/
|
|
|
|
#include "dbconsole.h"
|
|
#include "dbaccess.h"
|
|
|
|
#include <KAction>
|
|
#include <KDebug>
|
|
#include <KGlobalSettings>
|
|
#include <KStandardAction>
|
|
#include <KConfigGroup>
|
|
|
|
#include <QApplication>
|
|
#include <QClipboard>
|
|
#include <QSqlQueryModel>
|
|
#include <QSqlError>
|
|
|
|
DbConsole::DbConsole(QWidget* parent) :
|
|
QWidget( parent ),
|
|
mQueryModel( 0 )
|
|
{
|
|
ui.setupUi( this );
|
|
|
|
KAction *copyAction = KStandardAction::copy( this, SLOT(copyCell()), this );
|
|
ui.resultView->addAction( copyAction );
|
|
|
|
ui.execButton->setIcon( KIcon( "application-x-executable" ) );
|
|
ui.execButton->setShortcut( Qt::CTRL + Qt::Key_Return );
|
|
connect( ui.execButton, SIGNAL(clicked()), SLOT(execClicked()) );
|
|
|
|
ui.queryEdit->setFont( KGlobalSettings::fixedFont() );
|
|
ui.errorView->setFont( KGlobalSettings::fixedFont() );
|
|
|
|
ui.queryEdit->setPlainText( KGlobal::config()->group( "DBConsole" ).readEntry( "queryText" ) );
|
|
}
|
|
|
|
void DbConsole::execClicked()
|
|
{
|
|
const QString query = ui.queryEdit->toPlainText();
|
|
if ( query.isEmpty() )
|
|
return;
|
|
delete mQueryModel;
|
|
mQueryModel = new QSqlQueryModel( this );
|
|
mQueryModel->setQuery( query, DbAccess::database() );
|
|
ui.resultView->setModel( mQueryModel );
|
|
|
|
if ( mQueryModel->lastError().isValid() ) {
|
|
ui.errorView->appendPlainText( mQueryModel->lastError().text() );
|
|
ui.resultStack->setCurrentWidget( ui.errorViewPage );
|
|
} else {
|
|
ui.errorView->clear();
|
|
ui.resultStack->setCurrentWidget( ui.resultViewPage );
|
|
}
|
|
|
|
KGlobal::config()->group( "DBConsole" ).writeEntry( "queryText", query );
|
|
}
|
|
|
|
void DbConsole::copyCell()
|
|
{
|
|
QModelIndex index = ui.resultView->currentIndex();
|
|
if ( !index.isValid() ) {
|
|
return;
|
|
}
|
|
QString text = index.data( Qt::DisplayRole ).toString();
|
|
QApplication::clipboard()->setText( text );
|
|
}
|
|
|