Mercurial > hg > syntilista
diff src/main.cpp @ 255:55581d90c55d
Change API for slCheckAndReportSQLError().
author | Matti Hamalainen <ccr@tnsp.org> |
---|---|
date | Wed, 10 Oct 2018 13:21:51 +0300 |
parents | eadffc38ab43 |
children | df3f902588af |
line wrap: on
line diff
--- a/src/main.cpp Thu May 10 01:16:30 2018 +0300 +++ b/src/main.cpp Wed Oct 10 13:21:51 2018 +0300 @@ -673,7 +673,7 @@ query.prepare(QStringLiteral("SELECT id,value,added FROM transactions WHERE person=? ORDER BY added DESC LIMIT 5")); query.addBindValue(id); query.exec(); - slCheckAndReportSQLError("SELECT transactions for tableview_Latest", query.lastError()); + slCheckAndReportSQLError(query, "SELECT transactions for tableview_Latest"); model_Latest->setQuery(query); @@ -934,9 +934,9 @@ } // Execute the query and update model - slCheckAndReportSQLError("updatePersonList() before exec", query.lastError()); + slCheckAndReportSQLError(query, "updatePersonList() before exec"); query.exec(); - slCheckAndReportSQLError("updatePersonList() after exec", query.lastError()); + slCheckAndReportSQLError(query, "updatePersonList() after exec"); model_People->setQuery(query); @@ -959,7 +959,7 @@ QSqlQuery query; query.prepare(QStringLiteral("SELECT TOTAL(value) FROM transactions AS balance")); query.exec(); - if (slCheckAndReportSQLError("updateMiscValues() get total balance query", query.lastError()) && + if (slCheckAndReportSQLError(query, "updateMiscValues() get total balance query") && query.next()) { totalBalance = query.value(0).toDouble();; @@ -971,7 +971,7 @@ query.finish(); query.prepare(QStringLiteral("SELECT COUNT(*) FROM people")); query.exec(); - if (slCheckAndReportSQLError("updateMiscValues() get people count", query.lastError()) && + if (slCheckAndReportSQLError(query, "updateMiscValues() get people count") && query.next()) { totalPeople = query.value(0).toInt(); @@ -1008,7 +1008,7 @@ query.addBindValue(value); query.addBindValue(QDateTime::currentDateTimeUtc()); query.exec(); - if (!slCheckAndReportSQLError(QStringLiteral("addTransaction(%1, %2)").arg(id).arg(value), query.lastError(), true)) + if (!slCheckAndReportSQLError(query, QStringLiteral("addTransaction(%1, %2)").arg(id).arg(value), true)) { QSqlDatabase::database().rollback(); return -2; @@ -1019,7 +1019,7 @@ query.addBindValue(QDateTime::currentDateTimeUtc()); query.addBindValue(id); query.exec(); - if (!slCheckAndReportSQLError("addTransaction update timestamp", query.lastError(), true)) + if (!slCheckAndReportSQLError(query, "addTransaction update timestamp", true)) { QSqlDatabase::database().rollback(); return -3;