Search database during FSWidget::gatherData

First, look for md5 in files and files_origin. Then look for the complete
filename in files, and finally for the filename without suffix in files_origin.
If we have a match, note it in the new column "Presence". Matches from
files are displayed green, matches from files_orgin blue.

This implementation tries to execute as few QSqlQueries as possible by
using goto for performance. We only want to know if the file is somewhere
present, so skip the remaining queries once we have a match.

1 files changed, 2 insertions, 0 deletions

diff --git a/fswidget.h b/fswidget.h
index e711b09..0683602 100644
--- a/fswidget.h
+++ b/fswidget.h
@@ -2,6 +2,7 @@
 #define FSWIDGET_H
 
 #include <QWidget>
+#include <QSqlQuery>
 
 class QComboBox;
 class QTreeView;
@@ -22,6 +23,7 @@ class FSWidget : public QWidget {
         void insertItem(QComboBox *cb, const QString &text);
         void removeItem(QComboBox *cb);
         void gatherData(const QString &curDir);
+        int queryCount(QSqlQuery &q, const QString &arg) const;
 
     private:
         void setupWidget();