query.bindValue(":street", result.street);
query.bindValue(":city", result.city);
+ qDebug() << result.number << result.name << result.street << result.city;
+
if(!query.exec())
{
+ qDebug() << "Unable to add item to cache";
ret = false;
}
QSqlQuery query;
- query.prepare("INSERT INTO log(number, name, street, city, time, missed) VALUES(:number, :name, :street, :city, :time, :missed)");
+ query.prepare("INSERT INTO log(number, name, street, city, country, time, missed) VALUES(:number, :name, :street, :city, :country, :time, :missed)");
query.bindValue(":number", result.number);
query.bindValue(":name", result.name);
query.bindValue(":street", result.street);
query.bindValue(":city", result.city);
+ query.bindValue(":country", result.country);
query.bindValue(":time", time);
int misVal = missed ? 1 : 0;
DB::connect();
}
- QSqlQuery query("SELECT number, name, street, city, time, missed FROM log ORDER BY time DESC LIMIT " + QString::number(limit));
+ QSqlQuery query("SELECT number, name, street, city, country, time, missed FROM log ORDER BY time DESC LIMIT " + QString::number(limit));
while(query.next())
{
details.result.name = query.value(1).toString();
details.result.street = query.value(2).toString();
details.result.city = query.value(3).toString();
- details.time = query.value(4).toInt();
+ details.result.country = query.value(4).toString();
+ details.time = query.value(5).toInt();
- int missed = query.value(5).toInt();
+ int missed = query.value(6).toInt();
details.missed = missed ? true : false;