Modified the license text comment type.

[emufront] / src / db / dbmediatype.cpp

diff --git a/src/db/dbmediatype.cpp b/src/db/dbmediatype.cpp
index 6268853..10501df 100644 (file)
--- a/src/db/dbmediatype.cpp
+++ b/src/db/dbmediatype.cpp
@@ -1,117 +1,36 @@
-// EmuFront
-// Copyright 2010 Mikko Keinänen
-//
-// This file is part of EmuFront.
-//
-//
-// EmuFront is free software: you can redistribute it and/or modify
-// it under the terms of the GNU General Public License as published by
-// the Free Software Foundation, either version 3 of the License, or
-// (at your option) any later version.
-//
-// Foobar is distributed in the hope that it will be useful,
-// but WITHOUT ANY WARRANTY; without even the implied warranty of
-// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
-// GNU General Public License for more details.
-//
-// You should have received a copy of the GNU General Public License
-// along with Foobar.  If not, see <http://www.gnu.org/licenses/>.
-
-#include <QSqlRecord>
-#include <QSqlQuery>
-#include <QSqlTableModel>
-#include <QDebug>
+/*
+** EmuFront
+** Copyright 2010 Mikko Keinänen
+**
+** This file is part of EmuFront.
+**
+**
+** EmuFront is free software: you can redistribute it and/or modify
+** it under the terms of the GNU General Public License version 2 as published by
+** the Free Software Foundation and appearing in the file gpl.txt included in the
+** packaging of this file.
+**
+** EmuFront is distributed in the hope that it will be useful,
+** but WITHOUT ANY WARRANTY; without even the implied warranty of
+** MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+** GNU General Public License for more details.
+**
+** You should have received a copy of the GNU General Public License
+** along with EmuFront.  If not, see <http://www.gnu.org/licenses/>.
+*/
 #include "dbmediatype.h"
-#include "../dataobjects/mediatype.h"
-
-const QString DbMediaType::DB_TABLE_NAME_MEDIATYPE = QString("mediatype");
-
-
-DbMediaType::DbMediaType(QObject *parent) : DatabaseManager(parent)
-{
-    sqlTableModel = getData();
-}
-
-QSqlTableModel* DbMediaType::getDataModel()
-{
-    return sqlTableModel;
-}
-
-EmuFrontObject* DbMediaType::getDataObjectFromModel(QModelIndex *index)
-{
-    QSqlRecord record = sqlTableModel->record(index->row());
-    int id = record.value(MediaType_Id).toInt();
-    QString name = record.value(MediaType_Name).toString();
-    QString fileName = record.value(MediaType_Filename).toString();
-    //qDebug() << "Got platform Name " << name << " id " << id;
-    return new MediaType(id, name, fileName);
-}
-
-bool DbMediaType::updateDataObjectToModel(const EmuFrontObject *ob)
-{
-    const MediaType *plf = dynamic_cast<const MediaType*>(ob);
-    bool ret = false;
-    sqlTableModel->setFilter(QString("id = %1").arg(plf->getId()));
-    sqlTableModel->select();
-    if (sqlTableModel->rowCount() == 1)
-    {
-        QSqlRecord record = sqlTableModel->record(0);
-        record.setValue("name", plf->getName());
-        record.setValue("filename", plf->getFilename());
-        sqlTableModel->setRecord(0, record);
-        ret = sqlTableModel->submitAll();
-    }
-    resetModel();
-    return ret;
-}
 
-bool DbMediaType::insertDataObjectToModel(const EmuFrontObject *ob)
+DbMediaType::DbMediaType(QObject *parent) : DbEmuFrontFileObject(parent)
 {
-    const MediaType *plf = dynamic_cast<const MediaType*>(ob);
-    int row = 0;
-    sqlTableModel->insertRows(row, 1);
-    // the null value for index will be set implicitily
-    // when we don't assign any value to cell 0 in the sql table model
-    //sqlTableModel->setData(sqlTableModel->index(row, 0), NULL);
-    sqlTableModel->setData(sqlTableModel->index(row, 1), plf->getName());
-    sqlTableModel->setData(sqlTableModel->index(row, 2), plf->getFilename());
-    return sqlTableModel->submitAll();
+    tableName = DbMediaType::DB_TABLE_NAME_MEDIATYPE;
 }
 
-int DbMediaType::countDataObjectRefs(int id) const
-{
-    return countRows("imagecontainer", "mediatypeid", id);
-}
-
-// WARNING: this will delete also all the databindings to selected platform
-bool DbMediaType::deleteDataObjectFromModel(QModelIndex *index)
-{
-    QSqlDatabase::database().transaction();
-    QSqlRecord record = sqlTableModel->record(index->row());
-    int id = record.value(MediaType_Id).toInt();
-    qDebug() << "Deleting mediatype " << id;
-    int count = countDataObjectRefs(id);
-    if (count > 0)
-    {
-        QSqlQuery query;
-        if (!query.exec(QString("DELETE FROM imagecontainer WHERE mediatypeid = %1").arg(id)))
-        {
-            qDebug() << "Deleting data bindings failed!";
-            QSqlDatabase::database().rollback();
-            return false;
-        }
-    }
-    sqlTableModel->removeRow(index->row());
-    sqlTableModel->submitAll();
-    return QSqlDatabase::database().commit();
-}
+EmuFrontObject* DbMediaType::createEmuFrontFileObject(int id, QString name, EmuFrontFile *f)
+{   return new MediaType(id, name, f); }
 
-QSqlTableModel* DbMediaType::getData()
+QString DbMediaType::getCountRefsSelect(int id) const
 {
-    QSqlTableModel *model = new QSqlTableModel(this);
-    model->setTable(DB_TABLE_NAME_MEDIATYPE);
-    model->setSort(MediaType_Name, Qt::AscendingOrder);
-    model->setHeaderData(MediaType_Name, Qt::Horizontal, tr("Name"));
-    model->select();
-    return model;
+    return QString("SELECT count(*) FROM mediatype "
+                   "INNER JOIN setup ON mediatype.id=setup.mediatypeid "
+                   "WHERE mediatype.id=%1").arg(id);
 }