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 : DbQueryModelManager(parent)
26 dbMediaImage = new DbMediaImage(parent);
29 bool DbMediaImageContainer::updateDataObjectToModel(const EmuFrontObject *efo)
35 int DbMediaImageContainer::insertDataObjectToModel(const EmuFrontObject *efo)
41 bool DbMediaImageContainer::deleteDataObjectFromModel(QModelIndex *i)
47 int DbMediaImageContainer::countDataObjectRefs(int id) const
53 QString DbMediaImageContainer::constructSelect(QString whereClause) const
59 QString DbMediaImageContainer::constructFilterById(int id) const
65 QString DbMediaImageContainer::constructSelectById(int id) const
71 EmuFrontObject* DbMediaImageContainer::recordToDataObject(const QSqlRecord *)
77 QSqlQueryModel* DbMediaImageContainer::getData()
83 int DbMediaImageContainer::getMediaImageContainer(QString checksum) const
91 * Stores media image containers, including the media images included
94 void DbMediaImageContainer::storeContainers(QList<MediaImageContainer *> lst)
96 qDebug() << "Storing media image containers to database.";
97 foreach(MediaImageContainer *mic, lst)
99 qDebug() << "Media image container " << mic->getName();
100 QList<MediaImage*> images = mic->getMediaImages();
102 /* If media image container is already in the db, continue */
103 if (getMediaImageContainer(mic->getCheckSum()) >= 0)
106 // this is a new media image container, lets build a list
107 // of media image id's for this container
108 QList<int> ids = dbMediaImage->storeMediaImages(images);
112 // store media image to db
113 int micId = insertDataObjectToModel(mic);
116 // need to remove the media images without media image container in list 'ids'
117 dbMediaImage->removeOrphanedMediaImages(ids);
118 // because the previous insert failed, the next is most likely going to fail, throw exception
119 qDebug() << QString(tr("Failed inserting media image container '%1' to database!")).arg(mic->getName());
122 // link all the media image ids in list to media image container id
123 linkMediaImagesWithContainer(micId, ids);
128 void DbMediaImageContainer::linkMediaImagesWithContainer(int micId, QList<int> miIds)