2 // Copyright 2010 Mikko Keinänen
4 // This file is part of EmuFront.
7 // EmuFront is free software: you can redistribute it and/or modify
8 // it under the terms of the GNU General Public License version 2 as published by
9 // the Free Software Foundation and appearing in the file gpl.txt included in the
10 // packaging of this file.
12 // EmuFront is distributed in the hope that it will be useful,
13 // but WITHOUT ANY WARRANTY; without even the implied warranty of
14 // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 // GNU General Public License for more details.
17 // You should have received a copy of the GNU General Public License
18 // along with EmuFront. If not, see <http://www.gnu.org/licenses/>.
21 #include <QSqlTableModel>
22 #include "dbobjectdialog.h"
23 #include "../db/databasemanager.h"
25 DbObjectDialog::DbObjectDialog(QWidget *parent)
26 : EmuFrontDialog(parent)
31 editButton = new QPushButton(tr("&Edit"));
32 editButton->setEnabled(false);
33 addButton = new QPushButton(tr("&Add"));
34 deleteButton = new QPushButton(tr("&Delete"));
35 deleteButton->setEnabled(false);
36 objectList = new QTableView(this);
37 buttonBox = new QDialogButtonBox(QDialogButtonBox::Ok, Qt::Vertical);
38 buttonBox->addButton(editButton, QDialogButtonBox::ActionRole);
39 buttonBox->addButton(addButton, QDialogButtonBox::ActionRole);
40 buttonBox->addButton(deleteButton, QDialogButtonBox::ActionRole);
41 // this be called from the implementing classes:
46 DbObjectDialog::~DbObjectDialog()
48 // no need to explicitly delete widgets within a parented layout
49 // they are automatically parented and will be deleted
50 // dbManager is also parented and will be implicitly deleted
51 // this must be deleted in an implementing class
53 // hiddenColumn QList will be deleted implicitly, since it
54 // implements implicit data sharing
57 void DbObjectDialog::connectSignals()
59 connect(buttonBox, SIGNAL(accepted()), this, SLOT(close()));
60 connect(objectList, SIGNAL(clicked(const QModelIndex &)),
61 this, SLOT(listObjectClicked(const QModelIndex &)));
62 connect(editButton, SIGNAL(clicked()), this, SLOT(editButtonClicked()));
63 connect(addButton, SIGNAL(clicked()), this, SLOT(addButtonClicked()));
64 connect(deleteButton, SIGNAL(clicked()), this, SLOT(deleteButtonClicked()));
65 connect(nameDialog, SIGNAL(dataObjectUpdated()), this, SLOT(updateData()));
66 connect(nameDialog, SIGNAL(updateRejected()), this, SLOT(updateReject()));
67 connect(nameDialog, SIGNAL(test()), this, SLOT(testSlot()));
70 void DbObjectDialog::testSlot()
72 qDebug() << "TEST SIGNAL RECEIVED!";
75 void DbObjectDialog::insertDb(const EmuFrontObject *ob) const
77 if (!dbManager->insertDataObjectToModel(ob))
78 errorMessage->showMessage(tr("Inserting data object %1 failed.").arg(ob->getName()));
81 void DbObjectDialog::addObject()
83 if (!nameDialog) initEditDialog();
84 deleteCurrentObject();
85 dbObject = createObject();
86 nameDialog->setDataObject(dbObject);
90 void DbObjectDialog::editObject()
92 QModelIndex index = objectList->currentIndex();
95 if (!nameDialog) initEditDialog();
96 deleteCurrentObject();
97 dbObject = dbManager->getDataObjectFromModel(&index);
99 nameDialog->setDataObject(dbObject);
102 bool DbObjectDialog::deleteItem()
104 qDebug() << "deleteItem called";
105 QModelIndex index = objectList->currentIndex();
106 if (!index.isValid()) return false;
109 EmuFrontObject *ob = dbManager->getDataObjectFromModel(&index);
111 qDebug() << "Trying to delete " << ob->getName();
115 errorMessage->showMessage(tr("Couldn't find the selected data object from data model!"));
119 int numBindings = dbManager->countDataObjectRefs(ob->getId());
121 if (numBindings > 0 && !confirmDelete(ob->getName(), numBindings))
123 deleteCurrentObject();
125 bool delOk = dbManager->deleteDataObject(ob->getId());
128 errorMessage->showMessage(tr("Deleting data object %1 failed!").arg(ob->getName()));
132 objectList->setFocus();
134 catch(EmuFrontException e)
136 errorMessage->showMessage(e.what());
141 void DbObjectDialog::updateDb(const EmuFrontObject *ob) const
144 if ( !dbManager->updateDataObjectToModel(ob) )
145 { errorMessage->showMessage("Database update failed!"); }
148 void DbObjectDialog::updateList() const
150 if (!dbManager) return;
151 dbManager->resetModel();
154 void DbObjectDialog::addButtonClicked()
160 void DbObjectDialog::editButtonClicked()
166 void DbObjectDialog::deleteButtonClicked()
168 QItemSelectionModel *selModel = objectList->selectionModel();
169 if (!selModel->hasSelection()) return;
171 QAbstractItemModel *tblModel = objectList->model();
172 QModelIndex index = selModel->currentIndex();
173 QVariant vName = tblModel->data(index);
174 QString name = vName.toString();
177 QString msg = tr("Do you want to delete") + name + "?";
178 int yn = QMessageBox::question(this, "Confirm", msg, QMessageBox::Yes | QMessageBox::No, QMessageBox::No);
179 if (yn == QMessageBox::Yes)
185 void DbObjectDialog::layout()
187 QHBoxLayout *mainLayout = new QHBoxLayout;
188 mainLayout->addWidget(objectList);
189 mainLayout->addWidget(buttonBox);
190 setLayout(mainLayout);
193 void DbObjectDialog::listObjectClicked(const QModelIndex &index)
195 const QModelIndex *x;
197 qDebug() << "Row " << x->row() << ", column " << x->column() << " clicked.";
198 setButtonsEnabled(index.isValid());
203 void DbObjectDialog::setButtonsEnabled(bool enabled)
205 editButton->setEnabled(enabled);
206 deleteButton->setEnabled(enabled);
209 void DbObjectDialog::disableSelection()
211 setButtonsEnabled(false);
214 void DbObjectDialog::activateNameDialog(bool updateData)
216 if (!nameDialog) return;
220 nameDialog->updateData();
221 nameDialog->activateWindow();
224 void DbObjectDialog::initDataTable()
226 objectList->setModel(dbManager->getDataModel());
227 objectList->setSelectionMode(QAbstractItemView::SingleSelection);
228 objectList->resizeColumnsToContents();
231 void DbObjectDialog::updateReject()
233 // we don't want to keep this in memory
234 deleteCurrentObject();
237 void DbObjectDialog::updateData()
239 qDebug() << "DbObjectDialog::updateData()";
241 if (!dbObject) return;
244 // if data object id > -1 we are updating the data otherwise we are inserting new data
245 if (dbObject->getId() > -1) updateDb(dbObject);
246 else insertDb(dbObject);
248 // we don't need dbObject anymore
249 deleteCurrentObject();
254 void DbObjectDialog::deleteCurrentObject()
259 bool DbObjectDialog::confirmDelete(QString name, int numRefs)
261 int r = QMessageBox::warning(this, tr("Confirm delete"),
262 QString("Do you really want to delete %1 with %2 data bindings?")
263 .arg(name).arg(numRefs),
264 QMessageBox::Yes | QMessageBox::No);
265 if ( r == QMessageBox::No )
270 void DbObjectDialog::refreshDataModel()
272 dbManager->resetModel();
275 void DbObjectDialog::hideColumns()
277 foreach(int c, hiddenColumns)
278 objectList->hideColumn(c);