| 199 | } |
| 200 | |
| 201 | bool CDatabaseUrl::UpdateUrl(const QString &url, const QString &title, const QIcon &icon) |
| 202 | { |
| 203 | if (url.isEmpty()) return false; |
| 204 | if(title.isEmpty() && icon.isNull()) return false; |
| 205 | |
| 206 | QString szSql; |
| 207 | szSql += "visit_time=\"" + QDateTime::currentDateTime().toString(Qt::ISODate) + "\" "; |
| 208 | if(!title.isEmpty()) |
| 209 | szSql += ", title=\"" + title + "\" "; |
| 210 | if(!icon.isNull()) { |
| 211 | szSql += ", icon=" + QString::number(m_iconDB.GetIcon(icon)) + " "; |
| 212 | } |
| 213 | |
| 214 | szSql = "UPDATE " + m_szTableName + " SET " + szSql; |
| 215 | szSql += " WHERE url=\"" + url + "\""; |
| 216 | |
| 217 | QSqlQuery query(GetDatabase()); |
| 218 | bool success = query.exec(szSql); |
| 219 | if (!success) { |
| 220 | SetError("Failed to update url: " + query.lastError().text() + "; Sql: " + szSql); |
| 221 | qCritical(log) << GetError(); |
| 222 | } |
| 223 | |
| 224 | return success; |
| 225 | } |
| 226 | |
| 227 | bool CDatabaseUrl::UpdateUrl(int id, const QString &title, const QIcon &icon) |
| 228 | { |
no test coverage detected