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 #ifndef DATABASEMANAGER_H
21 #define DATABASEMANAGER_H
24 #include <QSqlDatabase>
32 class DatabaseManager : public QObject
35 DatabaseManager(QObject *parent = 0);
38 virtual QSqlTableModel* getDataModel() = 0;
39 virtual EmuFrontObject* getDataObjectFromModel(QModelIndex*) = 0;
40 virtual bool updateDataObjectToModel(const EmuFrontObject*) = 0;
41 virtual bool insertDataObjectToModel(const EmuFrontObject*) = 0;
42 virtual bool deleteDataObjectFromModel(QModelIndex*) = 0;
43 virtual int countDataObjectRefs(int id) const = 0;
45 void resetModel() const;
47 Filetype_MediaImageContainer = 0,
48 Filetype_Screenshot = 1,
49 Filetype_PlatformIcon = 2,
50 Filetype_MediaTypeIcon = 3 };
53 QSqlTableModel* sqlTableModel;
54 //virtual QSqlTableModel* getDataModel() = 0;
55 int countRows(QString tableName, QString columnName, int id) const;
56 static const QString DB_TABLE_NAME_FILEPATH;
57 static const QString DB_TABLE_NAME_MEDIATYPE;
58 static const QString DB_TABLE_NAME_PLATFORM;
61 static const QString DB_FILENAME;
62 static const QString DATABASE;
63 virtual QSqlTableModel* getData() = 0;
64 static QString getDbPath();