QxOrm  1.4.5
C++ Object Relational Mapping library
QxSqlRelationLinked.h
Go to the documentation of this file.
00001 /****************************************************************************
00002 **
00003 ** https://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 <QtSql/qsqlerror.h>
00047 
00048 #include <QxCommon/QxBool.h>
00049 
00050 #include <QxDao/IxSqlRelation.h>
00051 
00052 #include <QxCollection/QxCollection.h>
00053 
00054 namespace qx {
00055 
00082 class QX_DLL_EXPORT QxSqlRelationLinked
00083 {
00084 
00085 public:
00086 
00087    typedef std::shared_ptr<QxSqlRelationLinked> type_ptr;
00088    typedef std::tuple<qx::dao::sql_join::join_type, IxSqlRelation *, QPair<QSet<QString>, long> > type_relation;
00089    typedef qx::QxCollection<QString, type_relation> type_lst_relation;
00090    typedef QHash<QString, type_ptr> type_lst_relation_linked;
00091 
00092 private:
00093 
00094    struct QxSqlRelationLinkedImpl;
00095    std::unique_ptr<QxSqlRelationLinkedImpl> m_pImpl; 
00096 
00097 public:
00098 
00099    QxSqlRelationLinked();
00100    QxSqlRelationLinked(bool bRoot);
00101    virtual ~QxSqlRelationLinked();
00102 
00103    qx_bool buildHierarchy(IxSqlRelationX * pRelationX, const QStringList & sRelationX);
00104 
00105    void hierarchySelect(QxSqlRelationParams & params);
00106    void hierarchyFrom(QxSqlRelationParams & params);
00107    void hierarchyJoin(QxSqlRelationParams & params);
00108    void hierarchyWhereSoftDelete(QxSqlRelationParams & params);
00109    void hierarchyResolveOutput(QxSqlRelationParams & params);
00110    QSqlError hierarchyOnBeforeSave(QxSqlRelationParams & params);
00111    QSqlError hierarchyOnAfterSave(QxSqlRelationParams & params);
00112    void updateOffset(QxSqlRelationParams & params);
00113 
00114    bool getCartesianProduct() const;
00115    long getAllRelationCount() const;
00116    long getRelationCount() const;
00117    bool existRelation(const QString & sKey) const;
00118    type_lst_relation_linked getRelationLinkedX() const;
00119    type_lst_relation getRelationX() const;
00120 
00121    bool checkRootColumns(const QString & s) const;
00122    long getRootColumnsCount() const;
00123    long getRootColumnsOffset() const;
00124    void setRootColumnsOffset(long l);
00125 
00126 protected:
00127 
00128    QStringList removeColumns(const QStringList & columnsToRemove, IxSqlRelation * pRelation) const;
00129    qx_bool insertRelationToHierarchy(const QStringList & sRelationX, const QString & sKey, qx::dao::sql_join::join_type eJoinType);
00130    bool isValidDaoHelper(QxSqlRelationParams & params) const;
00131 
00132 };
00133 
00134 typedef std::shared_ptr<QxSqlRelationLinked> QxSqlRelationLinked_ptr;
00135 
00136 } // namespace qx
00137 
00138 #endif // _QX_SQL_RELATION_LINKED_H_