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 // 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 "dbmediaimagecontainer.h"
23 DbMediaImageContainer::DbMediaImageContainer(QObject *parent)
24 : DbFile(parent) // DbQueryModelManager(parent)
26 dbMediaImage = new DbMediaImage(parent);
27 //dbFile = new DbFile(parent);
30 bool DbMediaImageContainer::updateDataObjectToModel(const EmuFrontObject *efo)
36 int DbMediaImageContainer::insertDataObjectToModel(const EmuFrontObject *efo)
42 bool DbMediaImageContainer::deleteDataObjectFromModel(QModelIndex *i)
48 int DbMediaImageContainer::countDataObjectRefs(int id) const
54 QString DbMediaImageContainer::constructSelect(QString whereClause) const
60 QString DbMediaImageContainer::constructFilterById(int id) const
66 QString DbMediaImageContainer::constructSelectById(int id) const
72 EmuFrontObject* DbMediaImageContainer::recordToDataObject(const QSqlRecord *)
78 QSqlQueryModel* DbMediaImageContainer::getData()
84 int DbMediaImageContainer::getMediaImageContainer(QString checksum) const
92 * Stores media image containers, including the media images included
95 void DbMediaImageContainer::storeContainers(QList<MediaImageContainer *> lst, FilePathObject *fpo)
97 qDebug() << "Storing media image containers to database.";
98 foreach(MediaImageContainer *mic, lst)
100 qDebug() << "Media image container " << mic->getName();
101 QList<MediaImage*> images = mic->getMediaImages();
103 /* If media image container is already in the db, continue */
104 if (getMediaImageContainer(mic->getCheckSum()) >= 0)
107 // this is a new media image container, lets build a list
108 // of media image id's for this container
109 QList<int> ids = dbMediaImage->storeMediaImages(images);
114 // mediaimagecontainer table: id, fileid, filepathid, updatetime
116 // insert the media image container file to file table
117 int micFileId = DbFile::insertDataObjectToModel(mic);
119 throw new EmuFrontException(QString(tr("Inserting media image container %1 to file database failed")).arg(mic->getName()));
121 int fpId = fpo->getId();
122 // store media image to db
123 int micId = insertDataObjectToModel(mic);
125 // because the previous insert failed, the next is most likely going to fail, throw exception
126 throw new EmuFrontException(QString(tr("Failed inserting media image container '%1' to database!")).arg(mic->getName()));
129 // link all the media image ids in list to media image container id
130 linkMediaImagesWithContainer(micId, ids);
131 } catch (EmuFrontException e) {
132 // need to remove the media images without media image container in list 'ids'
133 dbMediaImage->removeOrphanedMediaImages(ids);
139 void DbMediaImageContainer::linkMediaImagesWithContainer(int micId, QList<int> miIds)