| 316 | } |
| 317 | |
| 318 | QList<int> CDatabaseUrl::GetDomain(const QString &szDomain) |
| 319 | { |
| 320 | QList<int> ret; |
| 321 | QSqlQuery query(GetDatabase()); |
| 322 | query.prepare("SELECT id FROM " + m_szTableName + " WHERE url LIKE :url"); |
| 323 | query.bindValue(":url", QString("%%://%%%1%%").arg(szDomain)); |
| 324 | bool bRet = query.exec(); |
| 325 | if (bRet) { |
| 326 | while(query.next()) { |
| 327 | ret << query.value(0).toInt(); |
| 328 | } |
| 329 | } else { |
| 330 | qCritical(log) << "Failed to get domain:" |
| 331 | << query.lastError().text() |
| 332 | << query.executedQuery(); |
| 333 | } |
| 334 | return ret; |
| 335 | } |
| 336 | |
| 337 | QList<CDatabaseUrl::UrlItem> CDatabaseUrl::Search(const QString &keyword) |
| 338 | { |