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/>.
20 #ifndef DATABASEMANAGER_H
21 #define DATABASEMANAGER_H
24 #include <QSqlDatabase>
25 #include "../exceptions/emufrontexception.h"
33 class DatabaseManager : public QObject
36 DatabaseManager(QObject *parent = 0);
39 QSqlQueryModel* getDataModel(bool update = false);
40 EmuFrontObject* getDataObjectFromModel(QModelIndex*);
41 EmuFrontObject* getDataObject(int id);
42 EmuFrontObject* getDataObject(QString filter);
43 virtual bool updateDataObjectToModel(const EmuFrontObject*) = 0;
44 virtual int insertDataObjectToModel(const EmuFrontObject*) = 0;
45 virtual bool deleteDataObjectFromModel(QModelIndex*) = 0;
46 virtual bool deleteDataObject(int id) const = 0;
47 int countDataObjectRefs(int id) const;
48 static int getCurrentTimeStamp();
52 Filetype_MediaImageContainer = 0,
53 Filetype_Screenshot = 1,
54 Filetype_PlatformIcon = 2,
55 Filetype_MediaTypeIcon = 3 };
58 QSqlQueryModel* sqlTableModel;
59 virtual EmuFrontObject* recordToDataObject(const QSqlRecord* ) = 0;
60 virtual void filterById(int id) = 0;
61 virtual void filterDataObjects(QList<QString> filter) = 0;
62 virtual void clearFilters() = 0;
63 int countRows(QString tableName, QString columnName, int id) const;
64 static const QString DB_TABLE_NAME_FILE;
65 static const QString DB_TABLE_NAME_FILEPATH;
66 static const QString DB_TABLE_NAME_MEDIATYPE;
67 static const QString DB_TABLE_NAME_PLATFORM;
68 static const QString DB_TABLE_NAME_SETUP;
69 static const QString DB_TABLE_MEDIAIMAGECONTAINER;
70 static const QString DB_TABLE_MEDIAIMAGECONTAINER_MEDIAIMAGE;
71 static const QString DB_TABLE_EXECUTABLE;
74 static const QString DB_FILENAME;
75 static const QString DATABASE;
76 virtual QSqlQueryModel* getData() = 0;
77 static QString getDbPath();
78 EmuFrontObject* getFilteredDataObject();
79 virtual QString getCountRefsSelect(int) const = 0;