/**************************************************************************** ** ** https://www.qxorm.com/ ** Copyright (C) 2013 Lionel Marty (contact@qxorm.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 Lionel Marty ** ** 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 : ** contact@qxorm.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::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::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::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); } }; 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); } }; 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< std::is_pointer::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< qx::trait::is_smart_ptr::value, qx::dao::detail::QxDao_Save_WithRelation_Recursive_Ptr, type_dao_1 >::type type_dao_2; typedef typename std::conditional< qx::trait::is_container::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