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;