/**************************************************************************** ** ** 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_Update_Generic { static QSqlError update(const qx::QxSqlQuery & query, T & t, QSqlDatabase * pDatabase, const QStringList & columns) { qx::dao::detail::QxDao_Helper dao(t, pDatabase, "update", new qx::QxSqlQueryBuilder_Update(), (& query)); if (! dao.isValid()) { return dao.error(); } if (dao.isReadOnly()) { return dao.errReadOnly(); } if (! dao.isValidPrimaryKey(t)) { return dao.errInvalidId(); } if (! dao.validateInstance(t)) { return dao.error(); } #ifdef _QX_ENABLE_MONGODB if (dao.isMongoDB()) { qx::dao::on_before_update((& t), (& dao)); if (! dao.isValid()) { return dao.error(); } QString ctx = QString("mongodb") + ((columns.count() > 0) ? (QString(":columns{,") + columns.join(",") + QString(",}")) : QString()); qx::dao::mongodb::QxMongoDB_Helper::updateOne((& dao), dao.getDataMemberX()->getClass(), qx::serialization::json::to_string(t, 1, ctx), (& query)); if (! dao.isValid()) { return dao.error(); } qx::dao::on_after_update((& t), (& dao)); if (! dao.isValid()) { return dao.error(); } return dao.error(); } #endif // _QX_ENABLE_MONGODB QString sql = dao.builder().buildSql(columns).getSqlQuery(); if (! dao.getDataId() || sql.isEmpty()) { return dao.errEmpty(); } if (! query.isEmpty()) { dao.addQuery(false); sql = dao.builder().getSqlQuery(); } if (! pDatabase) { dao.transaction(); } if (! dao.prepare(sql)) { return dao.errFailed(true); } IxSqlGenerator * pSqlGenerator = dao.getSqlGenerator(); if (pSqlGenerator) { pSqlGenerator->onBeforeUpdate((& dao), (& t)); } qx::dao::on_before_update((& 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_Update::resolveInput(t, dao.query(), dao.builder(), columns); } if (! query.isEmpty()) { query.resolve(dao.query()); } if (! dao.exec(true)) { return dao.errFailed(); } if (pSqlGenerator) { pSqlGenerator->onAfterUpdate((& dao), (& t)); } qx::dao::on_after_update((& t), (& dao)); if (! dao.isValid()) { return dao.error(); } return dao.error(); } }; template struct QxDao_Update_Container { static QSqlError update(const qx::QxSqlQuery & query, T & t, QSqlDatabase * pDatabase, const QStringList & columns) { typedef typename qx::trait::generic_container::type_value_qx type_item; if (qx::trait::generic_container::size(t) <= 0) { return QSqlError(); } qx::dao::detail::QxDao_Helper_Container dao(t, pDatabase, "update", new qx::QxSqlQueryBuilder_Update(), (& query)); if (! dao.isValid()) { return dao.error(); } if (dao.isReadOnly()) { return dao.errReadOnly(); } if (! dao.validateInstance(t)) { return dao.error(); } #ifdef _QX_ENABLE_MONGODB if (dao.isMongoDB()) { dao.setSqlColumns(columns); for (typename T::iterator it = t.begin(); it != t.end(); ++it) { if (! updateItem((* it), dao)) { return dao.error(); } } QStringList & itemsAsJson = dao.itemsAsJson(); qx::dao::mongodb::QxMongoDB_Helper::updateMany((& dao), dao.getDataMemberX()->getClass(), itemsAsJson, (& query)); 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 (! updateItem((* it), dao)) { return dao.error(); } } return dao.error(); } #endif // _QX_ENABLE_MONGODB QString sql = dao.builder().buildSql(columns).getSqlQuery(); if (! dao.getDataId() || sql.isEmpty()) { return dao.errEmpty(); } if (! query.isEmpty()) { dao.addQuery(false); sql = dao.builder().getSqlQuery(); } if (! pDatabase) { dao.transaction(); } if (! dao.prepare(sql)) { return dao.errFailed(true); } dao.setSqlColumns(columns); for (typename T::iterator it = t.begin(); it != t.end(); ++it) { if (! updateItem((* it), dao)) { return dao.error(); } } return dao.error(); } private: template static inline bool updateItem(U & item, qx::dao::detail::QxDao_Helper_Container & dao) { bool bUpdateOk = updateItem_Helper::value || qx::trait::is_smart_ptr::value>::update(item, dao); if (bUpdateOk) { qx::dao::detail::QxDao_Keep_Original::backup(item); } return bUpdateOk; } template struct updateItem_Helper { static inline bool update(U & item, qx::dao::detail::QxDao_Helper_Container & dao) { return (item ? qx::dao::detail::QxDao_Update_Container::updateItem((* item), dao) : true); } }; template struct updateItem_Helper, false> { static inline bool update(std::pair & item, qx::dao::detail::QxDao_Helper_Container & dao) { return qx::dao::detail::QxDao_Update_Container::updateItem(item.second, dao); } }; template struct updateItem_Helper, false> { static inline bool update(const std::pair & item, qx::dao::detail::QxDao_Helper_Container & dao) { return qx::dao::detail::QxDao_Update_Container::updateItem(item.second, dao); } }; template struct updateItem_Helper, false> { static inline bool update(QPair & item, qx::dao::detail::QxDao_Helper_Container & dao) { return qx::dao::detail::QxDao_Update_Container::updateItem(item.second, dao); } }; template struct updateItem_Helper, false> { static inline bool update(const QPair & item, qx::dao::detail::QxDao_Helper_Container & dao) { return qx::dao::detail::QxDao_Update_Container::updateItem(item.second, dao); } }; template struct updateItem_Helper { static bool update(U & item, qx::dao::detail::QxDao_Helper_Container & dao) { QStringList columns = dao.getSqlColumns(); #ifdef _QX_ENABLE_MONGODB if (dao.isMongoDB()) { if (dao.qxQuery().queryAt(2) == "") { qx::dao::on_after_update((& item), (& dao)); return dao.isValid(); } QString ctx = QString("mongodb") + ((columns.count() > 0) ? (QString(":columns{,") + columns.join(",") + QString(",}")) : QString()); qx::dao::on_before_update((& item), (& dao)); if (! dao.isValid()) { return false; } dao.itemsAsJson().append(qx::serialization::json::to_string(item, 1, ctx)); return dao.isValid(); } #endif // _QX_ENABLE_MONGODB if (! dao.isValidPrimaryKey(item)) { dao.errInvalidId(); return false; } IxSqlGenerator * pSqlGenerator = dao.getSqlGenerator(); if (pSqlGenerator) { pSqlGenerator->onBeforeUpdate((& dao), (& item)); } qx::dao::on_before_update((& 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_Update::resolveInput(item, dao.query(), dao.builder(), columns); } if (! dao.qxQuery().isEmpty()) { dao.qxQuery().resolve(dao.query()); } if (! dao.exec(true)) { dao.errFailed(); return false; } if (pSqlGenerator) { pSqlGenerator->onAfterUpdate((& dao), (& item)); } qx::dao::on_after_update((& item), (& dao)); if (! dao.isValid()) { return false; } return dao.isValid(); } }; }; template struct QxDao_Update_Ptr { static inline QSqlError update(const qx::QxSqlQuery & query, T & t, QSqlDatabase * pDatabase, const QStringList & columns) { return (t ? qx::dao::update_by_query(query, (* t), pDatabase, columns) : QSqlError()); } }; template struct QxDao_Update { static inline QSqlError update(const qx::QxSqlQuery & query, T & t, QSqlDatabase * pDatabase, const QStringList & columns) { typedef typename std::conditional< std::is_pointer::value, qx::dao::detail::QxDao_Update_Ptr, qx::dao::detail::QxDao_Update_Generic >::type type_dao_1; typedef typename std::conditional< qx::trait::is_smart_ptr::value, qx::dao::detail::QxDao_Update_Ptr, type_dao_1 >::type type_dao_2; typedef typename std::conditional< qx::trait::is_container::value, qx::dao::detail::QxDao_Update_Container, type_dao_2 >::type type_dao_3; QSqlError error = type_dao_3::update(query, t, pDatabase, columns); if (! error.isValid()) { qx::dao::detail::QxDao_Keep_Original::backup(t); } return error; } }; } // namespace detail } // namespace dao } // namespace qx