From 62d3ca1482b202d2883eeb5e17e72300e8612477 Mon Sep 17 00:00:00 2001
From: Arno <arno@disconnect.de>
Date: Fri, 28 May 2021 07:57:05 +0200
Subject: Make Origin MD5sums searchable

First, add a QAction to copy the MD5sum from FSWidget to Clipboard. Then
enhance the SearchDialog to support MD5sums from files_origin *only*.
---
 searchdialog.cpp | 17 +++++++++++++++++
 1 file changed, 17 insertions(+)

(limited to 'searchdialog.cpp')

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();
 }
-- 
cgit v1.2.3-70-g09d2