tsqlqueryormapper.h

Go to the documentation of this file.

#pragma once
#include <QList>
#include <QtSql>
#include <TCriteriaConverter>
#include <TSqlQuery>
#include <TSystemGlobal>
 
template <class T>
class TSqlQueryORMapper : public TSqlQuery {
public:
    TSqlQueryORMapper(int databaseId = 0);
 
    TSqlQueryORMapper<T> &prepare(const QString &query);
    bool load(const QString &filename);
    TSqlQueryORMapper<T> &bind(const QString &placeholder, const QVariant &val);
    TSqlQueryORMapper<T> &bind(int pos, const QVariant &val);
    TSqlQueryORMapper<T> &addBind(const QVariant &val);
    bool exec(const QString &query);
    bool exec();
    T execFirst(const QString &query);
    T execFirst();
    int numRowsAffected() const;
    int size() const;
    bool next();
    T value() const;
    QString fieldName(int index) const;
 
    class ConstIterator;
    inline ConstIterator begin() { return ConstIterator(this, 0); }
    inline ConstIterator end() { return ConstIterator(this, size()); }
 
    class ConstIterator {
    public:
        TSqlQueryORMapper<T> *m {nullptr};
        int it {0};
 
        inline ConstIterator() { }
        inline ConstIterator(const ConstIterator &o) :
            m(o.m), it(o.it) { }
        inline ConstIterator &operator=(const ConstIterator &o)
        {
            m = o.m;
            it = o.it;
            return *this;
        }
        inline const T operator*() const
        {
            if (it == 0)
                m->first();
            return m->value();
        }
        inline bool operator==(const ConstIterator &o) const { return m == o.m && it == o.it; }
        inline bool operator!=(const ConstIterator &o) const { return m != o.m || it != o.it; }
        inline ConstIterator &operator++()
        {
            it = qMin(it + 1, m->size());
            m->next();
            return *this;
        }
 
    private:
        inline ConstIterator(TSqlQueryORMapper<T> *mapper, int i) :
            m(mapper), it(i) { }
        friend class TSqlQueryORMapper;
    };
};
 
 
template <class T>
inline TSqlQueryORMapper<T>::TSqlQueryORMapper(int databaseId) :
    TSqlQuery(databaseId)
{
}
 
 
template <class T>
inline TSqlQueryORMapper<T> &TSqlQueryORMapper<T>::prepare(const QString &query)
{
    TSqlQuery::prepare(query);
    return *this;
}
 
 
template <class T>
inline bool TSqlQueryORMapper<T>::load(const QString &filename)
{
    return TSqlQuery::load(filename);
}
 
 
template <class T>
inline TSqlQueryORMapper<T> &TSqlQueryORMapper<T>::bind(const QString &placeholder, const QVariant &val)
{
    TSqlQuery::bind(placeholder, val);
    return *this;
}
 
 
template <class T>
inline TSqlQueryORMapper<T> &TSqlQueryORMapper<T>::bind(int pos, const QVariant &val)
{
    TSqlQuery::bind(pos, val);
    return *this;
}
 
 
template <class T>
inline TSqlQueryORMapper<T> &TSqlQueryORMapper<T>::addBind(const QVariant &val)
{
    TSqlQuery::addBind(val);
    return *this;
}
 
 
template <class T>
inline bool TSqlQueryORMapper<T>::exec(const QString &query)
{
    return TSqlQuery::exec(query);
}
 
 
template <class T>
inline bool TSqlQueryORMapper<T>::exec()
{
    return TSqlQuery::exec();
}
 
 
template <class T>
inline T TSqlQueryORMapper<T>::execFirst(const QString &query)
{
    return (exec(query) && next()) ? value() : T();
}
 
 
template <class T>
inline T TSqlQueryORMapper<T>::execFirst()
{
    return (exec() && next()) ? value() : T();
}
 
 
template <class T>
inline int TSqlQueryORMapper<T>::numRowsAffected() const
{
    return TSqlQuery::numRowsAffected();
}
 
 
template <class T>
inline int TSqlQueryORMapper<T>::size() const
{
    return TSqlQuery::size();
}
 
 
template <class T>
inline bool TSqlQueryORMapper<T>::next()
{
    return TSqlQuery::next();
}
 
 
template <class T>
inline T TSqlQueryORMapper<T>::value() const
{
    T rec;
    QSqlRecord r = record();
    rec.setRecord(r, lastError());
    return rec;
}
 
 
template <class T>
inline QString TSqlQueryORMapper<T>::fieldName(int index) const
{
    return TCriteriaConverter<T>::getPropertyName(index, driver());
}