akonadiconsole/dbbrowser.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 "dbbrowser.h"
  21 #include "dbaccess.h"
  22
  23 #include <QSqlDatabase>
  24 #include <QSqlTableModel>
  25
  26 DbBrowser::DbBrowser(QWidget* parent) :
  27   QWidget( parent ),
  28   mTableModel( 0 )
  29 {
  30   ui.setupUi( this );
  31
  32   ui.tableBox->addItems( DbAccess::database().tables(QSql::AllTables) );
  33
  34   ui.refreshButton->setIcon( KIcon( "view-refresh" ) );
  35   connect( ui.refreshButton, SIGNAL(clicked()), SLOT(refreshClicked()) );
  36 }
  37
  38 void DbBrowser::refreshClicked()
  39 {
  40   const QString table = ui.tableBox->currentText();
  41   if ( table.isEmpty() )
  42     return;
  43   delete mTableModel;
  44   mTableModel = new QSqlTableModel( this, DbAccess::database() );
  45   mTableModel->setTable( table );
  46   mTableModel->setEditStrategy( QSqlTableModel::OnRowChange );
  47   mTableModel->select();
  48   ui.tableView->setModel( mTableModel );
  49 }
  50
  51 #include "dbbrowser.moc"