| QxOrm 1.4.1 C++ Object Relational Mapping library

- Main Page
- Modules
- Namespaces
- Classes
- Files
- Directories

- File List
- File Members

IxSqlQueryBuilder.h
Go to the documentation of this file.

    00001 /****************************************************************************
    00002 **
    00003 ** http://www.qxorm.com/
    00004 ** Copyright (C) 2013 Lionel Marty (contact@qxorm.com)
    00005 **
    00006 ** This file is part of the QxOrm library
    00007 **
    00008 ** This software is provided 'as-is', without any express or implied
    00009 ** warranty. In no event will the authors be held liable for any
    00010 ** damages arising from the use of this software
    00011 **
    00012 ** Commercial Usage
    00013 ** Licensees holding valid commercial QxOrm licenses may use this file in
    00014 ** accordance with the commercial license agreement provided with the
    00015 ** Software or, alternatively, in accordance with the terms contained in
    00016 ** a written agreement between you and Lionel Marty
    00017 **
    00018 ** GNU General Public License Usage
    00019 ** Alternatively, this file may be used under the terms of the GNU
    00020 ** General Public License version 3.0 as published by the Free Software
    00021 ** Foundation and appearing in the file 'license.gpl3.txt' included in the
    00022 ** packaging of this file. Please review the following information to
    00023 ** ensure the GNU General Public License version 3.0 requirements will be
    00024 ** met : http://www.gnu.org/copyleft/gpl.html
    00025 **
    00026 ** If you are unsure which license is appropriate for your use, or
    00027 ** if you have questions regarding the use of this file, please contact :
    00028 ** contact@qxorm.com
    00029 **
    00030 ****************************************************************************/
    00031
    00032 #ifndef _IX_SQL_QUERY_BUILDER_H_
    00033 #define _IX_SQL_QUERY_BUILDER_H_
    00034
    00035 #ifdef _MSC_VER
    00036 #pragma once
    00037 #endif
    00038
    00046 #include <QxDataMember/IxDataMemberX.h>
    00047
    00048 #include <QxDao/IxSqlRelation.h>
    00049 #include <QxDao/QxSoftDelete.h>
    00050 #include <QxDao/QxSqlRelationLinked.h>
    00051
    00052 namespace qx {
    00053 namespace dao {
    00054 namespace detail {
    00055
    00056 class IxDao_Helper;
    00057
    00058 } // namespace detail
    00059 } // namespace dao
    00060 } // namespace qx
    00061
    00062 namespace qx {
    00063
    00068 class QX_DLL_EXPORT IxSqlQueryBuilder
    00069 {
    00070
    00071 public:
    00072
    00073    typedef QPair<QString, QString> type_id;
    00074    typedef QHash<type_id, void *> type_ptr_by_id;
    00075    typedef qx_shared_ptr<type_ptr_by_id> type_ptr_by_id_ptr;
    00076    typedef QList<type_ptr_by_id_ptr> type_lst_ptr_by_id;
    00077    typedef qx_shared_ptr<type_lst_ptr_by_id> type_lst_ptr_by_id_ptr;
    00078
    00079 protected:
    00080
    00081    QxCollection<QString, IxDataMember *> * m_lstDataMemberPtr;
    00082    IxSqlRelationX * m_lstSqlRelationPtr;
    00083    IxDataMember * m_pDataMemberId;
    00084    QString m_sSqlQuery;
    00085    QString m_sTableName;
    00086    QString m_sHashRelation;
    00087    bool m_bCartesianProduct;
    00088    type_lst_ptr_by_id_ptr m_pIdX;
    00089    QxSoftDelete m_oSoftDelete;
    00090    QHash<QString, QString> m_lstSqlQueryAlias;
    00091    qx::dao::detail::IxDao_Helper * m_pDaoHelper;
    00092
    00093 public:
    00094
    00095    IxSqlQueryBuilder() : m_lstDataMemberPtr(NULL), m_lstSqlRelationPtr(NULL), m_pDataMemberId(NULL), m_bCartesianProduct(false), m_pDaoHelper(NULL) { ; }
    00096    IxSqlQueryBuilder(const QString & sql) : m_lstDataMemberPtr(NULL), m_lstSqlRelationPtr(NULL), m_pDataMemberId(NULL), m_sSqlQuery(sql), m_bCartesianProduct(false), m_pDaoHelper(NULL) { ; }
    00097    virtual ~IxSqlQueryBuilder() = 0;
    00098
    00099    inline QxCollection<QString, IxDataMember *> * getLstDataMember() const    { return m_lstDataMemberPtr; }
    00100    inline IxSqlRelationX * getLstRelation() const                             { return m_lstSqlRelationPtr; }
    00101    inline qx::dao::detail::IxDao_Helper * getDaoHelper() const                { return m_pDaoHelper; }
    00102    inline void setDaoHelper(qx::dao::detail::IxDao_Helper * p)                { m_pDaoHelper = p; }
    00103
    00104    inline void setSqlQuery(const QString & sql)          { m_sSqlQuery = sql; }
    00105    inline void setHashRelation(const QString & s)        { m_sHashRelation = s; }
    00106    inline void setCartesianProduct(bool b)               { m_bCartesianProduct = b; }
    00107    inline QString getSqlQuery() const                    { return m_sSqlQuery; }
    00108    inline QString getHashRelation() const                { return m_sHashRelation; }
    00109    inline QString table() const                          { return m_sTableName; }
    00110    inline QxSoftDelete getSoftDelete() const             { return m_oSoftDelete; }
    00111    inline bool getCartesianProduct() const               { return m_bCartesianProduct; }
    00112    inline long getDataCount() const                      { return (m_lstDataMemberPtr ? m_lstDataMemberPtr->count() : 0); }
    00113    inline long getRelationCount() const                  { return (m_lstSqlRelationPtr ? m_lstSqlRelationPtr->count() : 0); }
    00114    inline IxDataMember * getDataId() const               { return m_pDataMemberId; }
    00115    inline IxDataMember * nextData(long & l) const        { if ((! m_lstDataMemberPtr) || (l < 0) || (l >= m_lstDataMemberPtr->count())) { return NULL; }; ++l; return m_lstDataMemberPtr->getByIndex(l - 1); }
    00116    inline IxSqlRelation * nextRelation(long & l) const   { if ((! m_lstSqlRelationPtr) || (l < 0) || (l >= m_lstSqlRelationPtr->count())) { return NULL; }; ++l; return m_lstSqlRelationPtr->getByIndex(l - 1); }
    00117
    00118    void initIdX(long lAllRelationCount);
    00119    bool insertIdX(long lIndex, const QVariant & idOwner, const QVariant & idData, void * ptr);
    00120    void * existIdX(long lIndex, const QVariant & idOwner, const QVariant & idData);
    00121    void addSqlQueryAlias(const QString & sql, const QString & sqlAlias);
    00122    bool getAddAutoIncrementIdToUpdateQuery() const;
    00123    void replaceSqlQueryAlias(QString & sql) const;
    00124    void displaySqlQuery(int time_ms = -1) const;
    00125
    00126    virtual void init() = 0;
    00127    virtual IxDataMemberX * getDataMemberX() const = 0;
    00128    virtual IxSqlQueryBuilder & count() = 0;
    00129    virtual IxSqlQueryBuilder & exist() = 0;
    00130    virtual IxSqlQueryBuilder & fetchAll() = 0;
    00131    virtual IxSqlQueryBuilder & fetchById() = 0;
    00132    virtual IxSqlQueryBuilder & insert() = 0;
    00133    virtual IxSqlQueryBuilder & update() = 0;
    00134    virtual IxSqlQueryBuilder & deleteAll() = 0;
    00135    virtual IxSqlQueryBuilder & softDeleteAll() = 0;
    00136    virtual IxSqlQueryBuilder & deleteById() = 0;
    00137    virtual IxSqlQueryBuilder & softDeleteById() = 0;
    00138    virtual IxSqlQueryBuilder & createTable() = 0;
    00139    virtual IxSqlQueryBuilder & fetchAll(const QStringList & columns) = 0;
    00140    virtual IxSqlQueryBuilder & fetchById(const QStringList & columns) = 0;
    00141    virtual IxSqlQueryBuilder & update(const QStringList & columns) = 0;
    00142    virtual IxSqlQueryBuilder & fetchAll_WithRelation(QxSqlRelationLinked * pRelationX) = 0;
    00143    virtual IxSqlQueryBuilder & fetchById_WithRelation(QxSqlRelationLinked * pRelationX) = 0;
    00144
    00145    static QString addSqlCondition(const QString & sql) { return (sql.contains(" WHERE ") ? " AND " : " WHERE "); }
    00146
    00147 };
    00148
    00149 typedef qx_shared_ptr<IxSqlQueryBuilder> IxSqlQueryBuilder_ptr;
    00150
    00151 } // namespace qx
    00152
    00153 #include <QxDao/IxDao_Helper.h>
    00154
    00155 #endif // _IX_SQL_QUERY_BUILDER_H_