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 as published by
9 // the Free Software Foundation, either version 3 of the License, or
10 // (at your option) any later version.
12 // Foobar 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 Foobar. 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 explicitically delete widgets within a parented layout
49 // they are automatically parented and will be deleted
50 // dbManager is also parented and will be implicitically deleted
51 // this must be deleted in an implementing class
55 void DbObjectDialog::connectSignals()
57 qDebug() << "DbObjectDialog connecting signals";
58 connect(buttonBox, SIGNAL(accepted()), this, SLOT(close()));
59 connect(objectList, SIGNAL(clicked(const QModelIndex &)),
60 this, SLOT(listObjectClicked(const QModelIndex &)));
61 connect(editButton, SIGNAL(clicked()), this, SLOT(editButtonClicked()));
62 connect(addButton, SIGNAL(clicked()), this, SLOT(addButtonClicked()));
63 connect(deleteButton, SIGNAL(clicked()), this, SLOT(deleteButtonClicked()));
64 connect(nameDialog, SIGNAL(dataObjectUpdated()), this, SLOT(updateData()));
65 connect(nameDialog, SIGNAL(updateRejected()), this, SLOT(updateReject()));
66 connect(nameDialog, SIGNAL(test()), this, SLOT(testSlot()));
69 void DbObjectDialog::testSlot()
71 qDebug() << "TEST SIGNAL RECEIVED!";
74 void DbObjectDialog::insertDb(const EmuFrontObject *ob) const
76 if ( dbManager->insertDataObjectToModel(ob) )
77 qDebug() << "Db insert ok";
78 else qDebug() << "Db insert failed";
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);
98 nameDialog->setDataObject(dbObject);
102 bool DbObjectDialog::deleteItem()
104 QModelIndex index = objectList->currentIndex();
105 if (!index.isValid()) return false;
108 EmuFrontObject *ob = dbManager->getDataObjectFromModel(&index);
112 errorMessage->showMessage(tr("Couldn't find the selected data object from data model!"));
116 int numBindings = dbManager->countDataObjectRefs(ob->getId());
118 if (numBindings > 0 && !confirmDelete(ob->getName(), numBindings))
120 deleteCurrentObject();
122 bool delOk = dbManager->deleteDataObjectFromModel(&index);
125 errorMessage->showMessage(tr("Deleting data object %1 failed!").arg(ob->getName()));
129 objectList->setFocus();
131 catch(EmuFrontException e)
133 errorMessage->showMessage(e.what());
138 void DbObjectDialog::updateDb(const EmuFrontObject *ob) const
141 if ( !dbManager->updateDataObjectToModel(ob) )
142 { errorMessage->showMessage("Database update failed!"); }
145 void DbObjectDialog::updateList() const
147 if (!dbManager) return;
148 dbManager->resetModel();
151 void DbObjectDialog::addButtonClicked()
157 void DbObjectDialog::editButtonClicked()
163 void DbObjectDialog::deleteButtonClicked()
165 QItemSelectionModel *selModel = objectList->selectionModel();
166 if (!selModel->hasSelection()) return;
168 QAbstractItemModel *tblModel = objectList->model();
169 QModelIndex index = selModel->currentIndex();
170 QVariant vName = tblModel->data(index);
171 QString name = vName.toString();
174 QString msg = tr("Do you want to delete") + name + "?";
175 int yn = QMessageBox::question(this, "Confirm", msg, QMessageBox::Yes | QMessageBox::No, QMessageBox::No);
176 if (yn == QMessageBox::Yes)
182 void DbObjectDialog::layout()
184 QHBoxLayout *mainLayout = new QHBoxLayout;
185 mainLayout->addWidget(objectList);
186 mainLayout->addWidget(buttonBox);
187 setLayout(mainLayout);
190 void DbObjectDialog::listObjectClicked(const QModelIndex &index)
192 const QModelIndex *x;
194 qDebug() << "Row " << x->row() << ", column " << x->column() << " clicked.";
195 setButtonsEnabled(index.isValid());
200 void DbObjectDialog::setButtonsEnabled(bool enabled)
202 editButton->setEnabled(enabled);
203 deleteButton->setEnabled(enabled);
206 void DbObjectDialog::disableSelection()
208 setButtonsEnabled(false);
211 void DbObjectDialog::activateNameDialog()
213 if (!nameDialog) return;
216 nameDialog->activateWindow();
219 void DbObjectDialog::initDataTable()
221 objectList->setModel(dbManager->getDataModel());
222 objectList->setSelectionMode(QAbstractItemView::SingleSelection);
223 objectList->resizeColumnsToContents();
226 void DbObjectDialog::updateReject()
228 qDebug() << "Update rejected ... going to delete current object.";
229 // we don't want to keep this in memory
230 deleteCurrentObject();
233 void DbObjectDialog::updateData()
235 qDebug() << "Update accepted.";
237 if (!dbObject) return;
239 qDebug() << "dbObject is not 0";
241 qDebug() << "We have a " + dbObject->getName();
243 qDebug() << "Data will be inserted/updated...";
245 // if data object id > -1 we are updating the data otherwise we are inserting new data
246 if (dbObject->getId() > -1) updateDb(dbObject);
247 else insertDb(dbObject);
249 // we don't need dbObject anymore
250 deleteCurrentObject();
255 void DbObjectDialog::deleteCurrentObject()
260 bool DbObjectDialog::confirmDelete(QString name, int numRefs)
262 int r = QMessageBox::warning(this, tr("Confirm delete"),
263 QString("Do you really want to delete %1 with %2 data bindings?")
264 .arg(name).arg(numRefs),
265 QMessageBox::Yes | QMessageBox::No);
266 if ( r == QMessageBox::No )