# HG changeset patch
# User Matti Hamalainen <ccr@tnsp.org>
# Date 1490886909 -10800
# Node ID 8765397e45f44fb9fc3b5109c0ce579b4623af2d
# Parent  466417b7a1e4402267a1451887ceec7e787ea4b5
Cleanups.

diff -r 466417b7a1e4 -r 8765397e45f4 main.cpp
--- a/main.cpp	Thu Mar 30 17:10:22 2017 +0300
+++ b/main.cpp	Thu Mar 30 18:15:09 2017 +0300
@@ -10,12 +10,6 @@
 #include "ui_mainwindow.h"
 #include "ui_editperson.h"
 
-static QString query_Person =
-    "SELECT id,last_name,first_name,"
-    "(SELECT SUM(value) FROM transactions WHERE transactions.person=people.id) AS balance,"
-    "updated FROM people";
-
-
 
 void errorMsg(QString title, QString msg)
 {
@@ -412,6 +406,11 @@
 //
 void SyntilistaMainWindow::updatePersonList()
 {
+    static QString queryBase =
+        "SELECT id,last_name,first_name,"
+        "(SELECT SUM(value) FROM transactions WHERE transactions.person=people.id) AS balance,"
+        "updated FROM people";
+
     QSqlQuery query;
     QString queryOrderDir, queryOrderBy;
 
@@ -446,7 +445,7 @@
     {
         // Filter by name(s)
         QString tmp = "%"+ peopleFilter +"%";
-        query.prepare(query_Person +" WHERE first_name LIKE ? OR last_name LIKE ?" + queryOrderBy);
+        query.prepare(queryBase +" WHERE first_name LIKE ? OR last_name LIKE ?" + queryOrderBy);
 
         query.addBindValue(tmp);
         query.addBindValue(tmp);
@@ -454,7 +453,7 @@
     else
     {
         // No filter
-        query.prepare(query_Person + queryOrderBy);
+        query.prepare(queryBase + queryOrderBy);
     }
 
     // Execute the query and update model