summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorArno <arno@disconnect.de>2016-12-19 02:07:54 +0100
committerArno <arno@disconnect.de>2016-12-19 02:07:54 +0100
commit6786163a0c81b71435cf6070db90e0c4d4b59757 (patch)
tree4caaffa3cceb1adc295b10dfaafdd39e4593f668
parentab8a4b0f744c4132f39c6749842a5507408291f4 (diff)
downloadShemovCleaner-6786163a0c81b71435cf6070db90e0c4d4b59757.tar.gz
ShemovCleaner-6786163a0c81b71435cf6070db90e0c4d4b59757.tar.bz2
ShemovCleaner-6786163a0c81b71435cf6070db90e0c4d4b59757.zip
Replace RE match in OriginDialog with LIKE
Unfortunately there is no Postgres equivalent for \Q \E, so the query didn't work with filenames containing e.g. () or []. Use LIKE instead and see when that comes back to haunt me :)
-rw-r--r--origindialog.cpp6
1 files changed, 4 insertions, 2 deletions
diff --git a/origindialog.cpp b/origindialog.cpp
index 3e8bd3a..f885132 100644
--- a/origindialog.cpp
+++ b/origindialog.cpp
@@ -107,8 +107,10 @@ void OriginDialog::setDstData(const QString &absolutefn){
QFileInfo fi(absolutefn);
QSqlDatabase db = QSqlDatabase::database("shemovdb");
QSqlQuery dstQ(db);
- dstQ.prepare("SELECT tfilename, iduration, bisize, cmd5sum, ifiles_id FROM files WHERE tfilename ~ :fnb");
- dstQ.bindValue(":fnb", fi.completeBaseName());
+ dstQ.prepare("SELECT tfilename, iduration, bisize, cmd5sum, ifiles_id FROM files WHERE tfilename LIKE :fnb");
+ QString fn = fi.completeBaseName();
+ fn.append('%');
+ dstQ.bindValue(":fnb", fn);
dstQ.exec();
while(dstQ.next()){
mDstName->setText(dstQ.value(0).toString());