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()
35 QString FilePathModel::constructSelect(QString where) const
37 return QString("SELECT "
38 "filepath.id AS FilePathId, "
39 "filepath.name AS Name, "
40 "datetime(filepath.lastscanned, 'unixepoch') AS LastScanned, "
41 "setup.id AS SetupId, "
42 "platform.name || ' ' || mediatype.name AS SetupName, "
43 "filepath.filetypeid "
45 "INNER JOIN setup ON filepath.setupid=setup.id "
46 "INNER JOIN platform ON setup.platformid=platform.id "
47 "INNER JOIN mediatype ON setup.mediatypeid=mediatype.id "
49 "ORDER BY SetupName").arg(where);
52 Qt::ItemFlags FilePathModel::flags(const QModelIndex &index) const
54 Qt::ItemFlags flags = QSqlQueryModel::flags(index);
59 bool FilePathModel::setData(const QModelIndex &index, const QVariant &value, int role)
65 bool FilePathModel::insertRows(int row, int count, const QModelIndex &parent)
71 bool FilePathModel::removeRows(int row, int count, const QModelIndex &parent)