/**************************************************************************** ** ** 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_DeleteById_Generic { static QSqlError deleteById(T & t, QSqlDatabase * pDatabase, bool bVerifySoftDelete) { qx::IxSqlQueryBuilder * pBuilder = new qx::QxSqlQueryBuilder_DeleteById(); pBuilder->init(); qx::QxSoftDelete oSoftDelete = pBuilder->getSoftDelete(); if (bVerifySoftDelete && ! oSoftDelete.isEmpty()) { delete pBuilder; pBuilder = new qx::QxSqlQueryBuilder_SoftDeleteById(); } qx::dao::detail::QxDao_Helper dao(t, pDatabase, "delete by id", pBuilder); if (! dao.isValid()) { return dao.error(); } if (dao.isReadOnly()) { return dao.errReadOnly(); } if (! dao.isValidPrimaryKey(t)) { return dao.errInvalidId(); } #ifdef _QX_ENABLE_MONGODB if (dao.isMongoDB()) { qx::dao::on_before_delete((& t), (& dao)); if (! dao.isValid()) { return dao.error(); } qx::dao::mongodb::QxMongoDB_Helper::deleteOne((& dao), dao.getDataMemberX()->getClass(), qx::serialization::json::to_string(t, 1, "mongodb:only_id"), NULL); if (! dao.isValid()) { return dao.error(); } qx::dao::on_after_delete((& t), (& dao)); if (! dao.isValid()) { return dao.error(); } return dao.error(); } #endif // _QX_ENABLE_MONGODB QString sql = dao.builder().buildSql().getSqlQuery(); if (! dao.getDataId() || sql.isEmpty()) { return dao.errEmpty(); } if (! dao.prepare(sql)) { return dao.errFailed(true); } IxSqlGenerator * pSqlGenerator = dao.getSqlGenerator(); if (pSqlGenerator) { pSqlGenerator->onBeforeDelete((& dao), (& t)); } qx::dao::on_before_delete((& t), (& dao)); if (! dao.isValid()) { return dao.error(); } { qx::dao::detail::IxDao_Timer timer((& dao), qx::dao::detail::IxDao_Helper::timer_cpp_read_instance); qx::dao::detail::QxSqlQueryHelper_DeleteById::resolveInput(t, dao.query(), dao.builder()); } if (! dao.exec(true)) { return dao.errFailed(); } if (pSqlGenerator) { pSqlGenerator->onAfterDelete((& dao), (& t)); } qx::dao::on_after_delete((& t), (& dao)); if (! dao.isValid()) { return dao.error(); } return dao.error(); } }; template struct QxDao_DeleteById_Container { static QSqlError deleteById(T & t, QSqlDatabase * pDatabase, bool bVerifySoftDelete) { typedef typename qx::trait::generic_container::type_value_qx type_item; qx::IxSqlQueryBuilder * pBuilder = new qx::QxSqlQueryBuilder_DeleteById(); pBuilder->init(); qx::QxSoftDelete oSoftDelete = pBuilder->getSoftDelete(); if (bVerifySoftDelete && ! oSoftDelete.isEmpty()) { delete pBuilder; pBuilder = new qx::QxSqlQueryBuilder_SoftDeleteById(); } if (qx::trait::generic_container::size(t) <= 0) { return QSqlError(); } qx::dao::detail::QxDao_Helper_Container dao(t, pDatabase, "delete by id", pBuilder); if (! dao.isValid()) { return dao.error(); } if (dao.isReadOnly()) { return dao.errReadOnly(); } #ifdef _QX_ENABLE_MONGODB if (dao.isMongoDB()) { for (typename T::iterator it = t.begin(); it != t.end(); ++it) { if (! deleteItem((* it), dao)) { return dao.error(); } } QStringList & itemsAsJson = dao.itemsAsJson(); qx::dao::mongodb::QxMongoDB_Helper::deleteMany((& dao), dao.getDataMemberX()->getClass(), itemsAsJson, NULL); if (! dao.isValid()) { return dao.error(); } dao.qxQuery().queryAt(2, ""); dao.itemsAsJson().clear(); for (typename T::iterator it = t.begin(); it != t.end(); ++it) { if (! deleteItem((* it), dao)) { return dao.error(); } } return dao.error(); } #endif // _QX_ENABLE_MONGODB QString sql = dao.builder().buildSql().getSqlQuery(); if (sql.isEmpty()) { return dao.errEmpty(); } if (! dao.prepare(sql)) { return dao.errFailed(true); } for (typename T::iterator it = t.begin(); it != t.end(); ++it) { if (! deleteItem((* it), dao)) { return dao.error(); } } return dao.error(); } private: template static inline bool deleteItem(U & item, qx::dao::detail::QxDao_Helper_Container & dao) { return deleteItem_Helper::value || qx::trait::is_smart_ptr::value>::deleteById(item, dao); } template struct deleteItem_Helper { static inline bool deleteById(U & item, qx::dao::detail::QxDao_Helper_Container & dao) { return (item ? qx::dao::detail::QxDao_DeleteById_Container::deleteItem((* item), dao) : true); } }; template struct deleteItem_Helper, false> { static inline bool deleteById(std::pair & item, qx::dao::detail::QxDao_Helper_Container & dao) { return qx::dao::detail::QxDao_DeleteById_Container::deleteItem(item.second, dao); } }; template struct deleteItem_Helper, false> { static inline bool deleteById(const std::pair & item, qx::dao::detail::QxDao_Helper_Container & dao) { return qx::dao::detail::QxDao_DeleteById_Container::deleteItem(item.second, dao); } }; template struct deleteItem_Helper, false> { static inline bool deleteById(QPair & item, qx::dao::detail::QxDao_Helper_Container & dao) { return qx::dao::detail::QxDao_DeleteById_Container::deleteItem(item.second, dao); } }; template struct deleteItem_Helper, false> { static inline bool deleteById(const QPair & item, qx::dao::detail::QxDao_Helper_Container & dao) { return qx::dao::detail::QxDao_DeleteById_Container::deleteItem(item.second, dao); } }; template struct deleteItem_Helper { static bool deleteById(U & item, qx::dao::detail::QxDao_Helper_Container & dao) { if (! dao.isValidPrimaryKey(item)) { dao.errInvalidId(); return false; } #ifdef _QX_ENABLE_MONGODB if (dao.isMongoDB()) { if (dao.qxQuery().queryAt(2) == "") { qx::dao::on_after_delete((& item), (& dao)); return dao.isValid(); } qx::dao::on_before_delete((& item), (& dao)); if (! dao.isValid()) { return false; } QVariant id = (dao.getDataId() ? dao.getDataId()->toVariant(& item) : QVariant()); if (! id.isNull() && ! id.toString().isEmpty()) { dao.itemsAsJson().append(id.toString()); } return dao.isValid(); } #endif // _QX_ENABLE_MONGODB IxSqlGenerator * pSqlGenerator = dao.getSqlGenerator(); if (pSqlGenerator) { pSqlGenerator->onBeforeDelete((& dao), (& item)); } qx::dao::on_before_delete((& item), (& dao)); if (! dao.isValid()) { return false; } { qx::dao::detail::IxDao_Timer timer((& dao), qx::dao::detail::IxDao_Helper::timer_cpp_read_instance); qx::dao::detail::QxSqlQueryHelper_DeleteById::resolveInput(item, dao.query(), dao.builder()); } if (! dao.exec(true)) { dao.errFailed(); return false; } if (pSqlGenerator) { pSqlGenerator->onAfterDelete((& dao), (& item)); } qx::dao::on_after_delete((& item), (& dao)); if (! dao.isValid()) { return false; } return dao.isValid(); } }; }; template struct QxDao_DeleteById_Ptr { static inline QSqlError deleteById(T & t, QSqlDatabase * pDatabase, bool bVerifySoftDelete) { if (! t) { return QSqlError(); } if (bVerifySoftDelete) { return qx::dao::delete_by_id((* t), pDatabase); } return qx::dao::destroy_by_id((* t), pDatabase); } }; template struct QxDao_DeleteById { static inline QSqlError deleteById(T & t, QSqlDatabase * pDatabase, bool bVerifySoftDelete) { typedef typename std::conditional< std::is_pointer::value, qx::dao::detail::QxDao_DeleteById_Ptr, qx::dao::detail::QxDao_DeleteById_Generic >::type type_dao_1; typedef typename std::conditional< qx::trait::is_smart_ptr::value, qx::dao::detail::QxDao_DeleteById_Ptr, type_dao_1 >::type type_dao_2; typedef typename std::conditional< qx::trait::is_container::value, qx::dao::detail::QxDao_DeleteById_Container, type_dao_2 >::type type_dao_3; return type_dao_3::deleteById(t, pDatabase, bVerifySoftDelete); } }; } // namespace detail } // namespace dao } // namespace qx