QxOrm  1.4.3
C++ Object Relational Mapping library
QxSqlRelationLinked.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 _QX_SQL_RELATION_LINKED_H_
00033 #define _QX_SQL_RELATION_LINKED_H_
00034 
00035 #ifdef _MSC_VER
00036 #pragma once
00037 #endif
00038 
00046 #include <boost/tuple/tuple.hpp>
00047 #include <boost/tuple/tuple_comparison.hpp>
00048 #include <boost/tuple/tuple_io.hpp>
00049 
00050 #include <QtSql/qsqlerror.h>
00051 
00052 #include <QxCommon/QxBool.h>
00053 
00054 #include <QxDao/IxSqlRelation.h>
00055 
00056 #include <QxCollection/QxCollection.h>
00057 
00058 namespace qx {
00059 
00086 class QX_DLL_EXPORT QxSqlRelationLinked
00087 {
00088 
00089 protected:
00090 
00091    typedef qx_shared_ptr<QxSqlRelationLinked> type_ptr;
00092    typedef boost::tuple<qx::dao::sql_join::join_type, IxSqlRelation *, QPair<QSet<QString>, long> > type_relation;
00093    typedef qx::QxCollection<QString, type_relation> type_lst_relation;
00094    typedef QHash<QString, type_ptr> type_lst_relation_linked;
00095 
00096    type_lst_relation m_relationX;               
00097    type_lst_relation_linked m_relationLinkedX;  
00098    IxSqlRelationX * m_allRelationX;             
00099    bool m_bRoot;                                
00100    QSet<QString> m_lstRootColumns;              
00101    long m_lRootColumnsOffset;                   
00102    bool m_bRootColumnsModeRemove;               
00103 
00104 public:
00105 
00106    QxSqlRelationLinked();
00107    QxSqlRelationLinked(bool bRoot);
00108    virtual ~QxSqlRelationLinked();
00109 
00110    qx_bool buildHierarchy(IxSqlRelationX * pRelationX, const QStringList & sRelationX);
00111 
00112    void hierarchySelect(QxSqlRelationParams & params);
00113    void hierarchyFrom(QxSqlRelationParams & params);
00114    void hierarchyJoin(QxSqlRelationParams & params);
00115    void hierarchyWhereSoftDelete(QxSqlRelationParams & params);
00116    void hierarchyResolveOutput(QxSqlRelationParams & params);
00117    QSqlError hierarchyOnBeforeSave(QxSqlRelationParams & params);
00118    QSqlError hierarchyOnAfterSave(QxSqlRelationParams & params);
00119    void updateOffset(QxSqlRelationParams & params);
00120 
00121    bool getCartesianProduct() const;
00122    long getAllRelationCount() const;
00123    long getRelationCount() const;
00124    bool existRelation(const QString & sKey) const;
00125 
00126    bool checkRootColumns(const QString & s) const  { return (m_lstRootColumns.isEmpty() || (m_bRootColumnsModeRemove ? (! m_lstRootColumns.contains(s)) : m_lstRootColumns.contains(s))); }
00127    long getRootColumnsCount() const                { return m_lstRootColumns.count(); }
00128    long getRootColumnsOffset() const               { return m_lRootColumnsOffset; }
00129    void setRootColumnsOffset(long l)               { m_lRootColumnsOffset = l; }
00130 
00131 protected:
00132 
00133    QStringList removeColumns(const QStringList & columnsToRemove, IxSqlRelation * pRelation) const;
00134    qx_bool insertRelationToHierarchy(const QStringList & sRelationX, const QString & sKey, qx::dao::sql_join::join_type eJoinType);
00135    bool isValidDaoHelper(QxSqlRelationParams & params) const;
00136 
00137 };
00138 
00139 typedef qx_shared_ptr<QxSqlRelationLinked> QxSqlRelationLinked_ptr;
00140 
00141 } // namespace qx
00142 
00143 #endif // _QX_SQL_RELATION_LINKED_H_