Changeset 47eda2b in confclerk_git for src/sql

Timestamp:

07/08/11 16:52:32 (12 years ago)

Author:

gregor herrmann <gregoa@…>

Branches:

master, qt5

Children:

e388cda

Parents:

66698a6

Message:

Split search keyword string on whitespace.

File:

• src/sql/sqlengine.cpp (modified) (2 diffs)

src/sql/sqlengine.cpp

@@ -314 +314 @@
     sql += QString("WHERE EVENT.xid_conference = %1 AND (").arg( aConferenceId );
 
+    QStringList searchKeywords = aKeyword.split(QRegExp("\\s+"));
     foreach (QString table, aColumns.uniqueKeys()){
         foreach (QString column, aColumns.values(table)){
-            sql += QString("%1.%2 LIKE '\%' || :%1%2 || '\%' OR ").arg( table, column );
+            for (int i=0; i < searchKeywords.count(); i++){
+                 sql += QString("%1.%2 LIKE '\%' || :%1%2 || '\%' OR ").arg( table, column );
+            }
         }
     }
@@ -326 +329 @@
     foreach (QString table, aColumns.uniqueKeys()){
         foreach (QString column, aColumns.values(table)){
-            query.bindValue(QString(":%1%2").arg(table, column), aKeyword );
+            foreach (QString keyword, searchKeywords){
+                query.bindValue(QString(":%1%2").arg(table, column), keyword );
+            }
         }
     }