int id = rec->value(FilePath_Id).toInt();
QString fpath = rec->value(FilePath_Name).toString();
int setupId = rec->value(FilePath_SetupId).toInt();
- //int fileType = rec->value(FilePath_FileTypeId).toInt();
+ int fileType = rec->value(FilePath_FileTypeId).toInt();
Setup *sup = dynamic_cast<Setup*>(dbSetup->getDataObject(setupId));
// TODO
//int lastScanned = 0;
- return new FilePathObject(id, fpath, /* TODO */ 0, sup);
+ return new FilePathObject(id, fpath, fileType, sup);
}
bool DbFilePath::updateDataObjectToModel(const EmuFrontObject *ob)
QString DbFilePath::constructSelect(QString where) const
{
- /*QString where = whereClause.isEmpty()
- ? "" : QString("WHERE ").append(whereClause);*/
-
return QString("SELECT filepath.id AS FilePathId, "
"filepath.name AS Name, "
"filepath.lastscanned AS LastScanned, "
"setup.id AS SetupId, "
- "platform.name || ' ' || mediatype.name AS SetupName "
+ "platform.name || ' ' || mediatype.name AS SetupName, "
+ "filepath.filetypeid "
"FROM filepath "
"INNER JOIN setup ON filepath.setupid=setup.id "
"INNER JOIN platform ON setup.platformid=platform.id "
QSqlQueryModel* DbFilePath::getData()
{
- QSqlQueryModel *model = new QSqlQueryModel;
+ QSqlQueryModel *model = new QSqlQueryModel(this);
model->setQuery(constructSelect());
model->setHeaderData(FilePath_Id, Qt::Horizontal, tr("Id"));
model->setHeaderData(FilePath_Name, Qt::Horizontal, tr("Name"));