# HG changeset patch
# User Matti Hamalainen <ccr@tnsp.org>
# Date 1499072023 -10800
# Node ID 8ceaafde9b528ac4555533cc4938b0e019647b6c
# Parent  c7320f522b59d53e1179d58364485fec231d9f77
Use total() instead of sum() in the SQL queries for better accuracy.

diff -r c7320f522b59 -r 8ceaafde9b52 src/main.cpp
--- 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;