![]() |
QxOrm
1.3.2
C++ Object Relational Mapping library
|
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_MANY_TO_ONE_H_ 00033 #define _QX_SQL_RELATION_MANY_TO_ONE_H_ 00034 00035 #ifdef _MSC_VER 00036 #pragma once 00037 #endif 00038 00046 #include <QxDao/QxSqlRelation.h> 00047 00048 namespace qx { 00049 00054 template <class DataType, class Owner> 00055 class QxSqlRelation_ManyToOne : public QxSqlRelation<DataType, Owner> 00056 { 00057 00058 private: 00059 00060 typedef typename QxSqlRelation<DataType, Owner>::type_owner type_owner; 00061 typedef typename QxSqlRelation<DataType, Owner>::type_data type_data; 00062 00063 public: 00064 00065 QxSqlRelation_ManyToOne(IxDataMember * p) : QxSqlRelation<DataType, Owner>(p) { this->m_eRelationType = qx::IxSqlRelation::many_to_one; } 00066 virtual ~QxSqlRelation_ManyToOne() { ; } 00067 00068 virtual QString getDescription() const { return "relation many-to-one"; } 00069 virtual QString getExtraTable() const { return ""; } 00070 virtual QString createExtraTable() const { return ""; } 00071 virtual bool getCartesianProduct() const { return false; } 00072 virtual void lazyFrom(QxSqlRelationParams & params) const { Q_UNUSED(params); } 00073 virtual void eagerFrom(QxSqlRelationParams & params) const { Q_UNUSED(params); } 00074 virtual void lazyJoin(QxSqlRelationParams & params) const { Q_UNUSED(params); } 00075 virtual void lazyWhere(QxSqlRelationParams & params) const { Q_UNUSED(params); } 00076 virtual void eagerWhere(QxSqlRelationParams & params) const { Q_UNUSED(params); } 00077 virtual void lazyWhereSoftDelete(QxSqlRelationParams & params) const { Q_UNUSED(params); } 00078 virtual void lazyFetch_ResolveInput(QxSqlRelationParams & params) const { Q_UNUSED(params); } 00079 virtual void eagerFetch_ResolveInput(QxSqlRelationParams & params) const { Q_UNUSED(params); } 00080 virtual QSqlError onAfterSave(QxSqlRelationParams & params) const { Q_UNUSED(params); return QSqlError(); } 00081 00082 virtual QSqlError onBeforeSave(QxSqlRelationParams & params) const 00083 { 00084 if (this->isNullData(params) || params.recursiveMode()) { return QSqlError(); } 00085 return qx::dao::save(this->getData(params), (& params.database())); 00086 } 00087 00088 virtual void lazyUpdate_ResolveInput(QxSqlRelationParams & params) const 00089 { this->lazyInsert_ResolveInput(params); } 00090 00091 virtual QVariant getIdFromQuery(bool bEager, QxSqlRelationParams & params) const 00092 { return this->getIdFromQuery_ManyToOne(bEager, params); } 00093 00094 virtual void updateOffset(bool bEager, QxSqlRelationParams & params) const 00095 { this->updateOffset_ManyToOne(bEager, params); } 00096 00097 virtual void createTable(QxSqlRelationParams & params) const 00098 { this->createTable_ManyToOne(params); } 00099 00100 virtual void lazySelect(QxSqlRelationParams & params) const 00101 { this->lazySelect_ManyToOne(params); } 00102 00103 virtual void eagerSelect(QxSqlRelationParams & params) const 00104 { this->eagerSelect_ManyToOne(params); } 00105 00106 virtual void eagerJoin(QxSqlRelationParams & params) const 00107 { this->eagerJoin_ManyToOne(params); } 00108 00109 virtual void eagerWhereSoftDelete(QxSqlRelationParams & params) const 00110 { this->eagerWhereSoftDelete_ManyToOne(params); } 00111 00112 virtual void lazyFetch_ResolveOutput(QxSqlRelationParams & params) const 00113 { 00114 if (! this->verifyOffset(params, false)) { return; } 00115 QSqlQuery & query = params.query(); 00116 typename QxSqlRelation<DataType, Owner>::type_owner & currOwner = this->getOwner(params); 00117 IxDataMember * pData = this->getDataMember(); qAssert(pData); if (! pData) { return; } 00118 bool bValidId(false); 00119 for (int i = 0; i < pData->getNameCount(); i++) 00120 { QVariant vId = query.value(params.offset() + i); bValidId = (bValidId || qx::trait::is_valid_primary_key(vId)); } 00121 if (pData && bValidId) { for (int i = 0; i < pData->getNameCount(); i++) { pData->fromVariant((& currOwner), query.value(params.offset() + i), i); } } 00122 this->updateOffset(false, params); 00123 } 00124 00125 virtual void * eagerFetch_ResolveOutput(QxSqlRelationParams & params) const 00126 { 00127 if (! this->verifyOffset(params, false)) { return NULL; } 00128 QSqlQuery & query = params.query(); 00129 typename QxSqlRelation<DataType, Owner>::type_owner & currOwner = this->getOwner(params); 00130 IxDataMember * pData = this->getDataMember(); qAssert(pData); if (! pData) { return NULL; } 00131 IxDataMember * p = NULL; IxDataMember * pId = this->getDataId(); qAssert(pId); if (! pId) { return NULL; } 00132 long lIndex = 0; long lOffsetId = (pId ? pId->getNameCount() : 0); long lOffsetData = (pData ? pData->getNameCount() : 0); 00133 long lOffsetOld = params.offset(); this->updateOffset(true, params); 00134 long lOffsetRelation = (lOffsetOld + lOffsetId + lOffsetData); 00135 long lRelation = 0; IxSqlRelation * pRelation = NULL; 00136 bool bValidId(false), bValidIdBis(false); 00137 for (int i = 0; i < pData->getNameCount(); i++) 00138 { QVariant vId = query.value(lOffsetOld + i); bValidId = (bValidId || qx::trait::is_valid_primary_key(vId)); } 00139 for (int i = 0; i < pId->getNameCount(); i++) 00140 { QVariant vIdBis = query.value(lOffsetOld + lOffsetData + i); bValidIdBis = (bValidIdBis || qx::trait::is_valid_primary_key(vIdBis)); } 00141 if (pData && bValidId) { for (int i = 0; i < pData->getNameCount(); i++) { pData->fromVariant((& currOwner), query.value(lOffsetOld + i), i); } } 00142 if (! bValidIdBis) { return NULL; } 00143 type_data & currData = this->getData(params); 00144 if (! this->callTriggerBeforeFetch(currData, params)) { return NULL; } 00145 if (pId) { for (int i = 0; i < pId->getNameCount(); i++) { pId->fromVariant((& currData), query.value(lOffsetOld + lOffsetData + i), i); } } 00146 while ((p = this->nextData(lIndex))) 00147 { p->fromVariant((& currData), query.value(lOffsetRelation++)); } 00148 00149 if (params.relationX()) 00150 { 00151 long lIndexOwnerOld = params.indexOwner(); params.setIndexOwner(params.index()); 00152 void * pOwnerOld = params.owner(); params.setOwner(& currData); 00153 lOffsetOld = params.offset(); params.setOffset(lOffsetRelation++); 00154 while ((pRelation = this->nextRelation(lRelation))) 00155 { if (this->addLazyRelation(params, pRelation)) { pRelation->lazyFetch_ResolveOutput(params); } } 00156 params.setOwner(pOwnerOld); params.setOffset(lOffsetOld); 00157 params.setIndexOwner(lIndexOwnerOld); 00158 } 00159 00160 if (! this->callTriggerAfterFetch(currData, params)) { return NULL; } 00161 return (& currData); 00162 } 00163 00164 virtual void lazyInsert(QxSqlRelationParams & params) const 00165 { this->lazyInsert_ManyToOne(params); } 00166 00167 virtual void lazyInsert_Values(QxSqlRelationParams & params) const 00168 { this->lazyInsert_Values_ManyToOne(params); } 00169 00170 virtual void lazyUpdate(QxSqlRelationParams & params) const 00171 { this->lazyUpdate_ManyToOne(params); } 00172 00173 virtual void lazyInsert_ResolveInput(QxSqlRelationParams & params) const 00174 { 00175 QSqlQuery & query = params.query(); 00176 typename QxSqlRelation<DataType, Owner>::type_owner & currOwner = this->getOwner(params); 00177 IxDataMember * pData = this->getDataMember(); qAssert(pData); 00178 if (pData) { pData->setSqlPlaceHolder(query, (& currOwner)); } 00179 } 00180 00181 }; 00182 00183 } // namespace qx 00184 00185 #endif // _QX_SQL_RELATION_MANY_TO_ONE_H_