/**************************************************************************** ** ** https://www.qxorm.com/ ** Copyright (C) 2013 XDL Team (ic-east.com) ** ** This file is part of the QxOrm library ** ** This software is provided 'as-is', without any express or implied ** warranty. In no event will the authors be held liable for any ** damages arising from the use of this software ** ** Commercial Usage ** Licensees holding valid commercial QxOrm licenses may use this file in ** accordance with the commercial license agreement provided with the ** Software or, alternatively, in accordance with the terms contained in ** a written agreement between you and XDL Team ** ** GNU General Public License Usage ** Alternatively, this file may be used under the terms of the GNU ** General Public License version 3.0 as published by the Free Software ** Foundation and appearing in the file 'license.gpl3.txt' included in the ** packaging of this file. Please review the following information to ** ensure the GNU General Public License version 3.0 requirements will be ** met : http://www.gnu.org/copyleft/gpl.html ** ** If you are unsure which license is appropriate for your use, or ** if you have questions regarding the use of this file, please contact : ** ic-east.com ** ****************************************************************************/ namespace qx { namespace dao { namespace detail { template struct QxDao_Save_WithRelation_Recursive_Generic { static QSqlError save(T &t, qx::dao::save_mode::e_save_mode eSaveMode, QSqlDatabase *pDatabase, qx::QxSqlRelationParams *pRelationParams) { QStringList relation("*"); qx::dao::detail::QxDao_Helper dao(t, pDatabase, "save with relation recursive", new qx::QxSqlQueryBuilder_Update()); if (!dao.isValid()) { return dao.error(); } if (dao.isReadOnly()) { return dao.errReadOnly(); } if (!dao.updateSqlRelationX(relation)) { return dao.errInvalidRelation(); } if (!pDatabase) { dao.transaction(); } dao.quiet(); qx::QxSqlRelationParams params(0, 0, NULL, (&dao.builder()), (&dao.query()), (&t)); if (!pRelationParams) { params.setDatabase((&dao.database())); params.setSaveMode(eSaveMode); params.setRecursiveMode(true); } else { params = (*pRelationParams); params.setOwner(&t); } if (params.existRecursiveItem(&t)) { return dao.error(); } params.insertRecursiveItem(&t); qx::QxSqlRelationLinked *pRelationLinked = dao.getSqlRelationLinked(); if (pRelationLinked) { dao.updateError(pRelationLinked->hierarchyOnBeforeSave(params)); } if (!dao.isValid()) { return dao.error(); } if (eSaveMode == qx::dao::save_mode::e_check_insert_or_update) { qx_bool bExist = dao.isValidPrimaryKey(t); if (bExist) { bExist = qx::dao::exist(t, (&dao.database())); } if (bExist) { dao.updateError(qx::dao::update(t, (&dao.database()))); } else { dao.updateError(qx::dao::insert(t, (&dao.database()))); } } else if (eSaveMode == qx::dao::save_mode::e_insert_only) { dao.updateError(qx::dao::insert(t, (&dao.database()))); } else if (eSaveMode == qx::dao::save_mode::e_update_only) { dao.updateError(qx::dao::update(t, (&dao.database()))); } else { qAssert(false); } if (!dao.isValid()) { return dao.error(); } if (pRelationLinked) { dao.updateError(pRelationLinked->hierarchyOnAfterSave(params)); } if (!dao.isValid()) { return dao.error(); } return dao.error(); } }; template struct QxDao_Save_WithRelation_Recursive_Container { static QSqlError save(T &t, qx::dao::save_mode::e_save_mode eSaveMode, QSqlDatabase *pDatabase, qx::QxSqlRelationParams *pRelationParams) { typedef typename qx::trait::generic_container::type_value_qx type_item; QStringList relation("*"); if (qx::trait::generic_container::size(t) <= 0) { return QSqlError(); } qx::dao::detail::QxDao_Helper_Container dao(t, pDatabase, "save with relation recursive", new qx::QxSqlQueryBuilder_Update()); if (!dao.isValid()) { return dao.error(); } if (dao.isReadOnly()) { return dao.errReadOnly(); } if (!dao.updateSqlRelationX(relation)) { return dao.errInvalidRelation(); } if (!pDatabase) { dao.transaction(); } dao.quiet(); if (eSaveMode == qx::dao::save_mode::e_check_insert_or_update) { for (typename T::iterator it = t.begin(); it != t.end(); ++it) { if (!saveItem(eSaveMode, pRelationParams, (*it), dao)) { return dao.error(); } } } else if (eSaveMode == qx::dao::save_mode::e_insert_only) { for (typename T::iterator it = t.begin(); it != t.end(); ++it) { if (!hierarchyOnBeforeSave(eSaveMode, pRelationParams, (*it), dao)) { return dao.error(); } } dao.updateError(qx::dao::insert(t, (&dao.database()))); if (!dao.isValid()) { return dao.error(); } for (typename T::iterator it = t.begin(); it != t.end(); ++it) { if (!hierarchyOnAfterSave(eSaveMode, pRelationParams, (*it), dao)) { return dao.error(); } } } else if (eSaveMode == qx::dao::save_mode::e_update_only) { for (typename T::iterator it = t.begin(); it != t.end(); ++it) { if (!hierarchyOnBeforeSave(eSaveMode, pRelationParams, (*it), dao)) { return dao.error(); } } dao.updateError(qx::dao::update(t, (&dao.database()))); if (!dao.isValid()) { return dao.error(); } for (typename T::iterator it = t.begin(); it != t.end(); ++it) { if (!hierarchyOnAfterSave(eSaveMode, pRelationParams, (*it), dao)) { return dao.error(); } } } else { qAssert(false); } return dao.error(); } private: template static inline bool saveItem(qx::dao::save_mode::e_save_mode eSaveMode, qx::QxSqlRelationParams *pRelationParams, U &item, qx::dao::detail::QxDao_Helper_Container &dao) { bool bSaveOk = saveItem_Helper < U, std::is_pointer::value || qx::trait::is_smart_ptr::value > ::save(eSaveMode, pRelationParams, item, dao); if (bSaveOk) { qx::dao::detail::QxDao_Keep_Original::backup(item); } return bSaveOk; } template static inline bool hierarchyOnBeforeSave(qx::dao::save_mode::e_save_mode eSaveMode, qx::QxSqlRelationParams *pRelationParams, U &item, qx::dao::detail::QxDao_Helper_Container &dao) { bool bBeforeSaveOk = saveItem_Helper < U, std::is_pointer::value || qx::trait::is_smart_ptr::value > ::hierarchyOnBeforeSave(eSaveMode, pRelationParams, item, dao); if (bBeforeSaveOk) { qx::dao::detail::QxDao_Keep_Original::backup(item); } return bBeforeSaveOk; } template static inline bool hierarchyOnAfterSave(qx::dao::save_mode::e_save_mode eSaveMode, qx::QxSqlRelationParams *pRelationParams, U &item, qx::dao::detail::QxDao_Helper_Container &dao) { bool bAfterSaveOk = saveItem_Helper < U, std::is_pointer::value || qx::trait::is_smart_ptr::value > ::hierarchyOnAfterSave(eSaveMode, pRelationParams, item, dao); if (bAfterSaveOk) { qx::dao::detail::QxDao_Keep_Original::backup(item); } return bAfterSaveOk; } template struct saveItem_Helper { static inline bool save(qx::dao::save_mode::e_save_mode eSaveMode, qx::QxSqlRelationParams *pRelationParams, U &item, qx::dao::detail::QxDao_Helper_Container &dao) { return (item ? qx::dao::detail::QxDao_Save_WithRelation_Recursive_Container::saveItem(eSaveMode, pRelationParams, (*item), dao) : false); } static inline bool hierarchyOnBeforeSave(qx::dao::save_mode::e_save_mode eSaveMode, qx::QxSqlRelationParams *pRelationParams, U &item, qx::dao::detail::QxDao_Helper_Container &dao) { return (item ? qx::dao::detail::QxDao_Save_WithRelation_Recursive_Container::hierarchyOnBeforeSave(eSaveMode, pRelationParams, (*item), dao) : false); } static inline bool hierarchyOnAfterSave(qx::dao::save_mode::e_save_mode eSaveMode, qx::QxSqlRelationParams *pRelationParams, U &item, qx::dao::detail::QxDao_Helper_Container &dao) { return (item ? qx::dao::detail::QxDao_Save_WithRelation_Recursive_Container::hierarchyOnAfterSave(eSaveMode, pRelationParams, (*item), dao) : false); } }; template struct saveItem_Helper, false> { static inline bool save(qx::dao::save_mode::e_save_mode eSaveMode, qx::QxSqlRelationParams *pRelationParams, std::pair &item, qx::dao::detail::QxDao_Helper_Container &dao) { return qx::dao::detail::QxDao_Save_WithRelation_Recursive_Container::saveItem(eSaveMode, pRelationParams, item.second, dao); } static inline bool hierarchyOnBeforeSave(qx::dao::save_mode::e_save_mode eSaveMode, qx::QxSqlRelationParams *pRelationParams, std::pair &item, qx::dao::detail::QxDao_Helper_Container &dao) { return qx::dao::detail::QxDao_Save_WithRelation_Recursive_Container::hierarchyOnBeforeSave(eSaveMode, pRelationParams, item.second, dao); } static inline bool hierarchyOnAfterSave(qx::dao::save_mode::e_save_mode eSaveMode, qx::QxSqlRelationParams *pRelationParams, std::pair &item, qx::dao::detail::QxDao_Helper_Container &dao) { return qx::dao::detail::QxDao_Save_WithRelation_Recursive_Container::hierarchyOnAfterSave(eSaveMode, pRelationParams, item.second, dao); } }; template struct saveItem_Helper, false> { static inline bool save(qx::dao::save_mode::e_save_mode eSaveMode, qx::QxSqlRelationParams *pRelationParams, const std::pair &item, qx::dao::detail::QxDao_Helper_Container &dao) { return qx::dao::detail::QxDao_Save_WithRelation_Recursive_Container::saveItem(eSaveMode, pRelationParams, item.second, dao); } static inline bool hierarchyOnBeforeSave(qx::dao::save_mode::e_save_mode eSaveMode, qx::QxSqlRelationParams *pRelationParams, const std::pair &item, qx::dao::detail::QxDao_Helper_Container &dao) { return qx::dao::detail::QxDao_Save_WithRelation_Recursive_Container::hierarchyOnBeforeSave(eSaveMode, pRelationParams, item.second, dao); } static inline bool hierarchyOnAfterSave(qx::dao::save_mode::e_save_mode eSaveMode, qx::QxSqlRelationParams *pRelationParams, const std::pair &item, qx::dao::detail::QxDao_Helper_Container &dao) { return qx::dao::detail::QxDao_Save_WithRelation_Recursive_Container::hierarchyOnAfterSave(eSaveMode, pRelationParams, item.second, dao); } }; #if (QT_VERSION < QT_VERSION_CHECK(6, 0, 0)) template struct saveItem_Helper, false> { static inline bool save(qx::dao::save_mode::e_save_mode eSaveMode, qx::QxSqlRelationParams *pRelationParams, QPair &item, qx::dao::detail::QxDao_Helper_Container &dao) { return qx::dao::detail::QxDao_Save_WithRelation_Recursive_Container::saveItem(eSaveMode, pRelationParams, item.second, dao); } static inline bool hierarchyOnBeforeSave(qx::dao::save_mode::e_save_mode eSaveMode, qx::QxSqlRelationParams *pRelationParams, QPair &item, qx::dao::detail::QxDao_Helper_Container &dao) { return qx::dao::detail::QxDao_Save_WithRelation_Recursive_Container::hierarchyOnBeforeSave(eSaveMode, pRelationParams, item.second, dao); } static inline bool hierarchyOnAfterSave(qx::dao::save_mode::e_save_mode eSaveMode, qx::QxSqlRelationParams *pRelationParams, QPair &item, qx::dao::detail::QxDao_Helper_Container &dao) { return qx::dao::detail::QxDao_Save_WithRelation_Recursive_Container::hierarchyOnAfterSave(eSaveMode, pRelationParams, item.second, dao); } }; template struct saveItem_Helper, false> { static inline bool save(qx::dao::save_mode::e_save_mode eSaveMode, qx::QxSqlRelationParams *pRelationParams, const QPair &item, qx::dao::detail::QxDao_Helper_Container &dao) { return qx::dao::detail::QxDao_Save_WithRelation_Recursive_Container::saveItem(eSaveMode, pRelationParams, item.second, dao); } static inline bool hierarchyOnBeforeSave(qx::dao::save_mode::e_save_mode eSaveMode, qx::QxSqlRelationParams *pRelationParams, const QPair &item, qx::dao::detail::QxDao_Helper_Container &dao) { return qx::dao::detail::QxDao_Save_WithRelation_Recursive_Container::hierarchyOnBeforeSave(eSaveMode, pRelationParams, item.second, dao); } static inline bool hierarchyOnAfterSave(qx::dao::save_mode::e_save_mode eSaveMode, qx::QxSqlRelationParams *pRelationParams, const QPair &item, qx::dao::detail::QxDao_Helper_Container &dao) { return qx::dao::detail::QxDao_Save_WithRelation_Recursive_Container::hierarchyOnAfterSave(eSaveMode, pRelationParams, item.second, dao); } }; #endif // (QT_VERSION < QT_VERSION_CHECK(6, 0, 0)) template struct saveItem_Helper { static bool save(qx::dao::save_mode::e_save_mode eSaveMode, qx::QxSqlRelationParams *pRelationParams, U &item, qx::dao::detail::QxDao_Helper_Container &dao) { qx::QxSqlRelationParams params(0, 0, NULL, (&dao.builder()), (&dao.query()), (&item)); if (!pRelationParams) { params.setDatabase((&dao.database())); params.setSaveMode(eSaveMode); params.setRecursiveMode(true); } else { params = (*pRelationParams); params.setOwner(&item); } if (params.existRecursiveItem(&item)) { return true; } params.insertRecursiveItem(&item); qx::QxSqlRelationLinked *pRelationLinked = dao.getSqlRelationLinked(); if (pRelationLinked) { dao.updateError(pRelationLinked->hierarchyOnBeforeSave(params)); } if (!dao.isValid()) { return false; } if (eSaveMode == qx::dao::save_mode::e_check_insert_or_update) { qx_bool bExist = dao.isValidPrimaryKey(item); if (bExist) { bExist = qx::dao::exist(item, (&dao.database())); } if (bExist) { dao.updateError(qx::dao::update(item, (&dao.database()))); } else { dao.updateError(qx::dao::insert(item, (&dao.database()))); } } else if (eSaveMode == qx::dao::save_mode::e_insert_only) { dao.updateError(qx::dao::insert(item, (&dao.database()))); } else if (eSaveMode == qx::dao::save_mode::e_update_only) { dao.updateError(qx::dao::update(item, (&dao.database()))); } else { qAssert(false); } if (!dao.isValid()) { return false; } if (pRelationLinked) { dao.updateError(pRelationLinked->hierarchyOnAfterSave(params)); } if (!dao.isValid()) { return false; } return dao.isValid(); } static bool hierarchyOnBeforeSave(qx::dao::save_mode::e_save_mode eSaveMode, qx::QxSqlRelationParams *pRelationParams, U &item, qx::dao::detail::QxDao_Helper_Container &dao) { qx::QxSqlRelationParams params(0, 0, NULL, (&dao.builder()), (&dao.query()), (&item)); if (!pRelationParams) { params.setDatabase((&dao.database())); params.setSaveMode(eSaveMode); params.setRecursiveMode(true); } else { params = (*pRelationParams); params.setOwner(&item); } qx::QxSqlRelationLinked *pRelationLinked = dao.getSqlRelationLinked(); if (pRelationLinked) { dao.updateError(pRelationLinked->hierarchyOnBeforeSave(params)); } return dao.isValid(); } static bool hierarchyOnAfterSave(qx::dao::save_mode::e_save_mode eSaveMode, qx::QxSqlRelationParams *pRelationParams, U &item, qx::dao::detail::QxDao_Helper_Container &dao) { qx::QxSqlRelationParams params(0, 0, NULL, (&dao.builder()), (&dao.query()), (&item)); if (!pRelationParams) { params.setDatabase((&dao.database())); params.setSaveMode(eSaveMode); params.setRecursiveMode(true); } else { params = (*pRelationParams); params.setOwner(&item); } if (params.existRecursiveItem(&item)) { return true; } params.insertRecursiveItem(&item); qx::QxSqlRelationLinked *pRelationLinked = dao.getSqlRelationLinked(); if (pRelationLinked) { dao.updateError(pRelationLinked->hierarchyOnAfterSave(params)); } return dao.isValid(); } }; }; template struct QxDao_Save_WithRelation_Recursive_Ptr { static inline QSqlError save(T &t, qx::dao::save_mode::e_save_mode eSaveMode, QSqlDatabase *pDatabase, qx::QxSqlRelationParams *pRelationParams) { return (t ? qx::dao::save_with_relation_recursive((*t), eSaveMode, pDatabase, pRelationParams) : QSqlError()); } }; template struct QxDao_Save_WithRelation_Recursive { static inline QSqlError save(T &t, qx::dao::save_mode::e_save_mode eSaveMode, QSqlDatabase *pDatabase, qx::QxSqlRelationParams *pRelationParams) { typedef typename std::conditional::value, qx::dao::detail::QxDao_Save_WithRelation_Recursive_Ptr, qx::dao::detail::QxDao_Save_WithRelation_Recursive_Generic>::type type_dao_1; typedef typename std::conditional::value, qx::dao::detail::QxDao_Save_WithRelation_Recursive_Ptr, type_dao_1>::type type_dao_2; typedef typename std::conditional::value, qx::dao::detail::QxDao_Save_WithRelation_Recursive_Container, type_dao_2>::type type_dao_3; QSqlError error = type_dao_3::save(t, eSaveMode, pDatabase, pRelationParams); if (!error.isValid()) { qx::dao::detail::QxDao_Keep_Original::backup(t); } return error; } }; } // namespace detail } // namespace dao } // namespace qx