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 #include "filepathmodel.h"
23 FilePathModel::FilePathModel(QObject *parent) :
24 EmuFrontQueryModel(parent)
29 void FilePathModel::refresh()
31 setQuery(constructSelect());
32 setHeaderData(FilePath_Id, Qt::Horizontal, tr("Id"));
33 setHeaderData(FilePath_Name, Qt::Horizontal, tr("Name"));
34 setHeaderData(FilePath_LastScanned, Qt::Horizontal, tr("Last scanned"));
35 setHeaderData(FilePath_SetupId, Qt::Horizontal, tr("Set up id"));
36 setHeaderData(FilePath_SetupName, Qt::Horizontal, tr("Set up"));
39 QString FilePathModel::constructSelect(QString where) const
41 return QString("SELECT "
42 "filepath.id AS FilePathId, "
43 "filepath.name AS Name, "
44 "datetime(filepath.lastscanned, 'unixepoch') AS LastScanned, "
45 "setup.id AS SetupId, "
46 "platform.name || ' ' || mediatype.name AS SetupName, "
47 "filepath.filetypeid "
49 "INNER JOIN setup ON filepath.setupid=setup.id "
50 "INNER JOIN platform ON setup.platformid=platform.id "
51 "INNER JOIN mediatype ON setup.mediatypeid=mediatype.id "
53 "ORDER BY SetupName").arg(where);
56 Qt::ItemFlags FilePathModel::flags(const QModelIndex &index) const
58 Qt::ItemFlags flags = QSqlQueryModel::flags(index);
63 bool FilePathModel::setData(const QModelIndex &index, const QVariant &value, int role)
69 bool FilePathModel::insertRows(int row, int count, const QModelIndex &parent)
75 bool FilePathModel::removeRows(int row, int count, const QModelIndex &parent)