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/>.
20 #include "databasemanager.h"
22 #include <QSqlDatabase>
23 #include <QSqlTableModel>
31 const QString DatabaseManager::DB_FILENAME = QString("my.db.sqlite");
32 const QString DatabaseManager::DATABASE = QString("QSQLITE");
33 const QString DatabaseManager::DB_TABLE_NAME_MEDIATYPE = QString("mediatype");
34 const QString DatabaseManager::DB_TABLE_NAME_PLATFORM = QString("platform");
35 const QString DatabaseManager::DB_TABLE_NAME_FILEPATH = QString("filepath");
37 DatabaseManager::DatabaseManager(QObject *parent)
41 DatabaseManager::~DatabaseManager()
43 // no need to explicitily destroy sqlTableModel
44 // because it is parented QObject and will
45 // be destroyed when parent is destroyed
48 bool DatabaseManager::openDB()
50 QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
51 db.setDatabaseName(DatabaseManager::getDbPath());
55 QString DatabaseManager::getDbPath()
59 path.append(QDir::home().path());
60 path.append(QDir::separator()).append(DB_FILENAME);
62 path.append(DB_FILENAME);
67 void DatabaseManager::resetModel() const
69 if (!sqlTableModel) return;
70 sqlTableModel->setFilter("");
71 sqlTableModel->select();
74 // sql must return a count(*) value
75 int DatabaseManager::countRows(QString tableName, QString columnName, int id) const
77 QString sql = QString("SELECT COUNT(*) FROM %1 WHERE %2 = %3")
78 .arg(tableName).arg(columnName).arg(id);
82 numEntries = query.value(0).toInt();
86 EmuFrontObject* DatabaseManager::getDataObject(int id) const
88 sqlTableModel->setFilter(QString("id = %1").arg(id));
89 sqlTableModel->select();
90 EmuFrontObject *plf = 0;
91 if (sqlTableModel->rowCount() == 1)
93 QSqlRecord record = sqlTableModel->record(0);
94 plf = recordToDataObject(&record);
99 EmuFrontObject* DatabaseManager::getDataObjectFromModel(QModelIndex *index)
101 QSqlRecord record = sqlTableModel->record(index->row());
102 return recordToDataObject(&record);