From 58f0265365114a8241260d137833437cee3d400b Mon Sep 17 00:00:00 2001 From: Arno Date: Sat, 3 Nov 2018 10:48:38 +0100 Subject: Move fuzzyCheck to Helper namespace --- movieinfopage.cpp | 12 +----------- 1 file changed, 1 insertion(+), 11 deletions(-) (limited to 'movieinfopage.cpp') diff --git a/movieinfopage.cpp b/movieinfopage.cpp index 55a5075..425a252 100644 --- a/movieinfopage.cpp +++ b/movieinfopage.cpp @@ -321,17 +321,7 @@ void MovieInfoPage::toLower(){ } void MovieInfoPage::fuzzyCheck(){ - QString subtitle = mSubtitle->text(); - QStringList res; - 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()){ - res << fuzzyQ.value(0).toString(); - } + QStringList res = Helper::fuzzyCheck(mSubtitle->text()); if(!res.isEmpty()){ QString msg = QString(tr("Already have: