bookmarksengine/browsercontentdll/src/browsercontentdll.cpp
changeset 12 d26902edeef5
parent 9 1d51612454b5
child 15 5ea3798f1248
equal deleted inserted replaced
11:6078840978b1 12:d26902edeef5
   782         return true;
   782         return true;
   783     }
   783     }
   784     return false;  
   784     return false;  
   785    
   785    
   786 }
   786 }
       
   787 
       
   788 QMap<QString, QString> BrowserContent::findSimilarHistoryItems(QString atitle)
       
   789 {
       
   790     BOOKMARKSCLIENT_PRIVATEPTR(BrowserContent);
       
   791     QSqlDatabase db = QSqlDatabase::database(priv->m_connectionName);
       
   792     
       
   793     QMap<QString, QString> map;
       
   794     
       
   795     if (db.isOpen()){
       
   796         QSqlQuery query(db);
       
   797         
       
   798         QString queryStatement = "SELECT url, pageTitle FROM HistoryTable WHERE pageTitle LIKE '%"+atitle+"%' OR url LIKE '%" + atitle + "%'";          
       
   799         query.prepare(queryStatement);
       
   800         if(query.exec()) {    
       
   801             while (query.next()){
       
   802                  QString HistoryUrl = query.value(0).toString();
       
   803                  QString HistoryTitle =   query.value(1).toString();
       
   804                  map.insert( HistoryUrl, HistoryTitle );
       
   805              }
       
   806         } else {
       
   807             QSqlError error = query.lastError();
       
   808         }
       
   809     }
       
   810     return map;
       
   811 }