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   if ( DbAccess::database().isOpen() )
  33     ui.tableBox->addItems( DbAccess::database().tables(QSql::AllTables) );
  34
  35   ui.refreshButton->setIcon( KIcon( "view-refresh" ) );
  36   connect( ui.refreshButton, SIGNAL(clicked()), SLOT(refreshClicked()) );
  37 }
  38
  39 void DbBrowser::refreshClicked()
  40 {
  41   const QString table = ui.tableBox->currentText();
  42   if ( table.isEmpty() )
  43     return;
  44   delete mTableModel;
  45   mTableModel = new QSqlTableModel( this, DbAccess::database() );
  46   mTableModel->setTable( table );
  47   mTableModel->setEditStrategy( QSqlTableModel::OnRowChange );
  48   mTableModel->select();
  49   ui.tableView->setModel( mTableModel );
  50 }
  51
  52 #include "dbbrowser.moc"