Mercurial > hg > syntilista
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; }