Move fuzzyCheck to Helper namespace

1 files changed, 14 insertions, 0 deletions

diff --git a/helper.cpp b/helper.cpp
index 88b243d..b1f277b 100644
--- a/helper.cpp
+++ b/helper.cpp
@@ -384,6 +384,20 @@ namespace Helper {
         return PicData();
     }
 
+    QStringList fuzzyCheck(const QString &subtitle){
+        QStringList retval;
+        QSqlDatabase db = QSqlDatabase::database("treedb");
+        db.open();
+        QSqlQuery fuzzyQ(db);
+        fuzzyQ.prepare("SELECT tsubtitle FROM seriesparts WHERE regexp_replace(tsubtitle, '[ .,''!-]', '', 'g') = lower(regexp_replace(:st, '[ .,''!-]', '', 'g'))");
+        fuzzyQ.bindValue(":st", subtitle);
+        fuzzyQ.exec();
+        while(fuzzyQ.next()){
+            retval << fuzzyQ.value(0).toString();
+        }
+        return retval;
+    }
+
     Duration::Duration() : mHours(0), mMinutes(0), mSeconds(0) {}
 
     Duration::Duration(qint64 seconds){