diff options
author | Arno <arno@disconnect.de> | 2016-12-19 02:07:54 +0100 |
---|---|---|
committer | Arno <arno@disconnect.de> | 2016-12-19 02:07:54 +0100 |
commit | 6786163a0c81b71435cf6070db90e0c4d4b59757 (patch) | |
tree | 4caaffa3cceb1adc295b10dfaafdd39e4593f668 | |
parent | ab8a4b0f744c4132f39c6749842a5507408291f4 (diff) | |
download | ShemovCleaner-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.cpp | 6 |
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()); |