/*
* Copyright (C) 2010 Ixonos Plc.
+ * Copyright (C) 2011-2024 Philipp Spitzer, gregor herrmann, Stefan Stahl
*
- * This file is part of fosdem-schedule.
+ * This file is part of ConfClerk.
*
- * fosdem-schedule is free software: you can redistribute it and/or modify it
+ * ConfClerk is free software: you can redistribute it and/or modify it
* under the terms of the GNU General Public License as published by the Free
* Software Foundation, either version 2 of the License, or (at your option)
* any later version.
*
- * fosdem-schedule is distributed in the hope that it will be useful, but
+ * ConfClerk is distributed in the hope that it will be useful, but
* WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY
* or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for
* more details.
*
* You should have received a copy of the GNU General Public License along with
- * fosdem-schedule. If not, see <http://www.gnu.org/licenses/>.
+ * ConfClerk. If not, see <http://www.gnu.org/licenses/>.
*/
#ifndef ORMRECORD_H
#define ORMRECORD_H
#include <QStringList>
#include <QDateTime>
#include <QDebug>
+#include <stdexcept>
-class OrmException
+class OrmException: public std::runtime_error
{
public:
- OrmException(const QString& text) : mText(text) {}
- virtual ~OrmException(){}
+ OrmException(const QString& text) : std::runtime_error(text.toStdString()), mText(text) {}
+ virtual ~OrmException() throw() {}
virtual const QString& text() const { return mText; }
private:
QString mText;
class OrmNoObjectException : public OrmException
{
public:
- OrmNoObjectException() : OrmException("No object exception"){}
- ~OrmNoObjectException(){}
+ OrmNoObjectException() : OrmException("SQL query expects one record but found none."){}
+ ~OrmNoObjectException() throw() {}
};
class OrmSqlException : public OrmException
{
public:
OrmSqlException(const QString& text) : OrmException( QString("Sql error: ") + text ) {}
- ~OrmSqlException(){}
+ ~OrmSqlException() throw() {}
};
template <typename T>
}
// 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 <typename T>
void OrmRecord<T>::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();
}
qDebug() << "Error: " << query.lastError().driverText() << "; Type: " << query.lastError().type();
throw OrmSqlException(query.lastError().text());
}
- else
- {
- /*qDebug() << "SQL OK";*/
- }
}
QList<T> objects;
{
objects << hydrate(query.record());
}
- /*qDebug() << "Fetch done";*/
return objects;
}
{
if (colType == QVariant::DateTime && value.canConvert<QDateTime>())
{
- 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;