X-Git-Url: https://git.toastfreeware.priv.at/toast/confclerk.git/blobdiff_plain/6df32f20316aab78c979f50ff17798cc6dd7e9e0..83481c684518420be3c2d2c604ba85b2e72be9e4:/src/orm/ormrecord.h diff --git a/src/orm/ormrecord.h b/src/orm/ormrecord.h index 583ff5b..8357b6b 100644 --- a/src/orm/ormrecord.h +++ b/src/orm/ormrecord.h @@ -1,5 +1,6 @@ /* * Copyright (C) 2010 Ixonos Plc. + * Copyright (C) 2011-2013 Philipp Spitzer, gregor herrmann, Stefan Stahl * * This file is part of ConfClerk. * @@ -92,8 +93,8 @@ T OrmRecord::hydrate(const QSqlRecord& record) } // updates specified column 'col' -// if the value is not specified as an argument, -// it's taken from the reford itself +// if the value is not specified as an argument, +// it's taken from the record itself // see also: setValue() method for more details template void OrmRecord::update(QString col, QVariant value) @@ -105,7 +106,6 @@ void OrmRecord::update(QString col, QVariant value) else // take 'col' value from the record; see setValue() query.bindValue(":col", convertToDb(this->value(col), this->value(col).type())); query.bindValue(":id", this->value("id")); - //query.bindValue(":id", convertToDb(value("id"), QVariant::Int)); query.exec(); } @@ -150,10 +150,6 @@ QList OrmRecord::load(QSqlQuery query) qDebug() << "Error: " << query.lastError().driverText() << "; Type: " << query.lastError().type(); throw OrmSqlException(query.lastError().text()); } - else - { - /*qDebug() << "SQL OK";*/ - } } QList objects; @@ -161,7 +157,6 @@ QList OrmRecord::load(QSqlQuery query) { objects << hydrate(query.record()); } - /*qDebug() << "Fetch done";*/ return objects; } @@ -220,7 +215,9 @@ QVariant OrmRecord::convertToDb(QVariant value, QVariant::Type colType) { if (colType == QVariant::DateTime && value.canConvert()) { - return value.toDateTime().toTime_t(); + QDateTime dateTime = value.toDateTime(); + dateTime.setTimeSpec(Qt::UTC); // this is to avoid that dateTime.toTime_t changes the time depending on the local time zone + return dateTime.toTime_t(); } return value;