diff options
Diffstat (limited to 'searchdialog.cpp')
-rw-r--r-- | searchdialog.cpp | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/searchdialog.cpp b/searchdialog.cpp index 5c155b9..788c468 100644 --- a/searchdialog.cpp +++ b/searchdialog.cpp @@ -122,6 +122,23 @@ void FilenamesAndMetadata::search(){ if(ctr == 0){ appendEmpty(filenameItem); } + + //search md5sums + QSqlQuery md5sumQ(db); + md5sumQ.prepare("SELECT tfilename, iseriespart_id, series.tseries_name, seriesparts.tsubtitle FROM files, files_origin, seriesparts, series WHERE files_origin.cmd5sum = :md5 AND files_origin.ifiles_id = files.ifiles_id AND files.iseriespart_id = seriesparts.iseriesparts_id AND seriesparts.iseries_id = series.iseries_id"); + md5sumQ.bindValue(":md5", mSearch->text()); + SmTreeItem *md5Item = new SmTreeItem(QVariantList() << tr("MD5 Sums") << QVariant() << QVariant(), root); + root->appendChild(md5Item); + ctr = 0; + md5sumQ.exec(); + while(md5sumQ.next()){ + ++ctr; + appendChild(md5sumQ.value(1), md5sumQ.value(0), md5sumQ.value(2), md5sumQ.value(3), md5Item); + } + if(ctr == 0){ + appendEmpty(md5Item); + } + mModel->setRoot(root); mResult->expandAll(); } |