Mercurial > hg > syntilista

changeset 107:8ceaafde9b52

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Use total() instead of sum() in the SQL queries for better accuracy.
author Matti Hamalainen <ccr@tnsp.org>
date Mon, 03 Jul 2017 11:53:43 +0300
parents c7320f522b59
children bb17f6714fa4
files src/main.cpp
diffstat 1 files changed, 2 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- a/src/main.cpp	Thu Jun 29 11:31:37 2017 +0300
+++ b/src/main.cpp	Mon Jul 03 11:53:43 2017 +0300
@@ -142,7 +142,7 @@
     QSqlQuery query;
     query.prepare(
         "SELECT id,first_name,last_name,extra_info,added,updated, "
-        "(SELECT SUM(value) FROM transactions WHERE transactions.person=people.id) AS balance "
+        "(SELECT TOTAL(value) FROM transactions WHERE transactions.person=people.id) AS balance "
         "FROM people WHERE id=?");
 
     query.addBindValue(id);
@@ -636,7 +636,7 @@
 {
     static QString queryBase =
         "SELECT id,last_name,first_name,"
-        "(SELECT SUM(value) FROM transactions WHERE transactions.person=people.id) AS balance,"
+        "(SELECT TOTAL(value) FROM transactions WHERE transactions.person=people.id) AS balance,"
         "updated FROM people";
 
     QSqlQuery query;