+/*
+ * Copyright (C) 2010 Ixonos Plc.
+ * Copyright (C) 2011 Philipp Spitzer, gregor herrmann
+ *
+ * This file is part of ConfClerk.
+ *
+ * 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.
+ *
+ * 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
+ * ConfClerk. If not, see <http://www.gnu.org/licenses/>.
+ */
#ifndef ORMRECORD_H
#define ORMRECORD_H
#include <QDateTime>
#include <QDebug>
-// INFO:
-// all record items/columns may be defined in one table (1.), or
-// they can be splitted in two separate tables (2.) (eg. for FTS support)
-// 1.) you have to define "static QString const sTableName"
-// 2.) you have to define two table names:
-// "static QString const sTable1Name"
-// "static QString const sTable2Name"
-// and since all record items/columns are handled by one QSqlRecord,
-// you have to also define number of columns that belongs to table 1 (1.), and table 2 (2.)
-// 1.) "static int const sTable1ColCount"
-// 2.) "static int const sTable2ColCount"
-// there are also defined auxiliary methods for 1-Table/2-Tables approach, see bellow
-
class OrmException
{
+public:
+ OrmException(const QString& text) : mText(text) {}
+ virtual ~OrmException(){}
+ virtual const QString& text() const { return mText; }
+private:
+ QString mText;
};
-class OrmNoObjectException : OrmException
+class OrmNoObjectException : public OrmException
{
+public:
+ OrmNoObjectException() : OrmException("No object exception"){}
+ ~OrmNoObjectException(){}
};
-class OrmSqlException : OrmException
+class OrmSqlException : public OrmException
{
public:
- OrmSqlException(const QString& text) : mText(text) {}
- QString text() const { return mText; }
-
-private:
- QString mText;
+ OrmSqlException(const QString& text) : OrmException( QString("Sql error: ") + text ) {}
+ ~OrmSqlException(){}
};
template <typename T>
static QString columnsForSelect(const QString& prefix = QString());
static QString selectQuery();
static QString updateQuery();
- // record items/columns are stored in two tables
- static QString columnsForSelectJoin2T(); // for joining two tables
- static QString selectQueryJoin2T(const QString &key); // for joining two tables
static QVariant convertToC(QVariant value, QVariant::Type colType);
static QVariant convertToDb(QVariant value, QVariant::Type colType);
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;
}
return prefixedColumns.join(",");
}
-template <typename T>
-QString OrmRecord<T>::columnsForSelectJoin2T()
-{
- Q_ASSERT((T::sTable1ColCount+T::sTable2ColCount) == T::sColumns.count());
-
- QStringList prefixedColumns;
- for (int i=0; i<T::sTable1ColCount; i++)
- {
- prefixedColumns.append(QString("%1.%2").arg(T::sTable1Name, T::sColumns.field(i).name()));
- }
- for (int j=0; j<T::sTable2ColCount; j++)
- {
- prefixedColumns.append(QString("%1.%2").arg(T::sTable2Name, T::sColumns.field(T::sTable1ColCount+j).name()));
- }
- return prefixedColumns.join(",");
-}
-
template <typename T>
QString OrmRecord<T>::selectQuery()
{
return QString("SELECT %1 FROM %2 ").arg(columnsForSelect(), T::sTableName);
}
-
-template <typename T>
-QString OrmRecord<T>::selectQueryJoin2T(const QString &key)
-{
- return QString("SELECT %1 FROM %2 INNER JOIN %3 ON %4.%5 = %6.%7 ").arg(
- columnsForSelectJoin2T(),
- T::sTable1Name,
- T::sTable2Name,
- T::sTable1Name,
- key,
- T::sTable2Name,
- key);
-}
-
template <typename T>
QString OrmRecord<T>::updateQuery()
{
- return QString("UPDATE %1 ").arg(T::sTable1Name);
+ return QString("UPDATE %1 ").arg(T::sTableName);
}
template <typename T>
QSqlRecord OrmRecord<T>::toRecord(const QList<QSqlField> & columnList)
{
QSqlRecord record;
- foreach (const QSqlField & col, columnList)
+ for(int i=0; i< columnList.count(); i++)
{
- record.append(col);
+ record.append(columnList[i]);
}
return record;
}