equal
deleted
inserted
replaced
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 } |