changeset 101:2477f46282c8

Split getPersonInfo() to getPersonInfoRec().
author Matti Hamalainen <ccr@tnsp.org>
date Wed, 28 Jun 2017 08:11:33 +0300
parents 6d02b4ae936c
children 064138b6d34e
files src/main.cpp
diffstat 1 files changed, 23 insertions(+), 16 deletions(-) [+]
line wrap: on
line diff
--- a/src/main.cpp	Tue Jun 13 13:41:50 2017 +0300
+++ b/src/main.cpp	Wed Jun 28 08:11:33 2017 +0300
@@ -119,31 +119,38 @@
 
 
 //
-// Get PersonInfo record from SQL database for specified persn ID #
+// Get PersonInfo record from SQL query object
+//
+void getPersonInfoRec(QSqlQuery &query, PersonInfo &info)
+{
+    info.id         = query.value(0).toInt();
+    info.firstName  = query.value(1).toString();
+    info.lastName   = query.value(2).toString();
+    info.extraInfo  = query.value(3).toString();
+    info.added      = query.value(4).toDateTime();
+    info.updated    = query.value(5).toDateTime();
+    info.balance    = query.value(6).toDouble();
+}
+
+
+//
+// Get PersonInfo record from SQL database for specified person ID #
 //
 bool getPersonInfo(qint64 id, PersonInfo &info)
 {
-    QSqlQuery person;
-    person.prepare(
+    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 "
         "FROM people WHERE id=?");
 
-    person.addBindValue(id);
-    person.exec();
-    if (!person.next())
+    query.addBindValue(id);
+    query.exec();
+    if (!query.next())
         return false;
 
-    info.id         = person.value(0).toInt();
-    info.firstName  = person.value(1).toString();
-    info.lastName   = person.value(2).toString();
-    info.extraInfo  = person.value(3).toString();
-    info.added      = person.value(4).toDateTime();
-    info.updated    = person.value(5).toDateTime();
-    info.balance    = person.value(6).toDouble();
-
-    person.finish();
-
+    getPersonInfoRec(query, info);
+    query.finish();
     return true;
 }