/**************************************************************************** ** ** 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_Insert_Generic { static QSqlError insert(T & t, QSqlDatabase * pDatabase) { qx::dao::detail::QxDao_Helper dao(t, pDatabase, "insert", new qx::QxSqlQueryBuilder_Insert()); 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()) { qx::dao::on_before_insert((& t), (& dao)); if (! dao.isValid()) { return dao.error(); } QString insertedId; qx::dao::mongodb::QxMongoDB_Helper::insertOne((& dao), dao.getDataMemberX()->getClass(), qx::serialization::json::to_string(t, 1, "mongodb"), insertedId); if (! dao.isValid()) { return dao.error(); } if (! insertedId.isEmpty() && dao.getDataId()) { dao.getDataId()->fromVariant((& t), insertedId, -1, qx::cvt::context::e_database); } qx::dao::on_after_insert((& t), (& dao)); if (! dao.isValid()) { return dao.error(); } return dao.error(); } #endif // _QX_ENABLE_MONGODB IxSqlGenerator * pSqlGenerator = dao.getSqlGenerator(); QString sql = dao.builder().buildSql().getSqlQuery(); if (sql.isEmpty()) { return dao.errEmpty(); } if (! pDatabase) { dao.transaction(); } if (pSqlGenerator) { pSqlGenerator->checkSqlInsert((& dao), sql); } if (! dao.prepare(sql)) { return dao.errFailed(true); } if (pSqlGenerator) { pSqlGenerator->onBeforeInsert((& dao), (& t)); } qx::dao::on_before_insert((& 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_Insert::resolveInput(t, dao.query(), dao.builder()); } if (! dao.exec(true)) { return dao.errFailed(); } dao.updateLastInsertId(t); if (pSqlGenerator) { pSqlGenerator->onAfterInsert((& dao), (& t)); } qx::dao::on_after_insert((& t), (& dao)); if (! dao.isValid()) { return dao.error(); } return dao.error(); } }; template struct QxDao_Insert_Container { static QSqlError insert(T & t, QSqlDatabase * pDatabase) { 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, "insert", new qx::QxSqlQueryBuilder_Insert()); 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()) { for (typename T::iterator it = t.begin(); it != t.end(); ++it) { if (! insertItem((* it), dao)) { return dao.error(); } } QStringList & itemsAsJson = dao.itemsAsJson(); QStringList insertedId; qx::dao::mongodb::QxMongoDB_Helper::insertMany((& dao), dao.getDataMemberX()->getClass(), itemsAsJson, insertedId); if (! dao.isValid()) { return dao.error(); } dao.qxQuery().queryAt(2, ""); dao.itemsAsJson().clear(); dao.itemsAsJson().append(insertedId); for (typename T::iterator it = t.begin(); it != t.end(); ++it) { if (! insertItem((* it), dao)) { return dao.error(); } } return dao.error(); } #endif // _QX_ENABLE_MONGODB IxSqlGenerator * pSqlGenerator = dao.getSqlGenerator(); QString sql = dao.builder().buildSql().getSqlQuery(); if (sql.isEmpty()) { return dao.errEmpty(); } if (! pDatabase) { dao.transaction(); } if (pSqlGenerator) { pSqlGenerator->checkSqlInsert((& dao), sql); } if (! dao.prepare(sql)) { return dao.errFailed(true); } for (typename T::iterator it = t.begin(); it != t.end(); ++it) { if (! insertItem((* it), dao)) { return dao.error(); } } return dao.error(); } private: template static inline bool insertItem(U & item, qx::dao::detail::QxDao_Helper_Container & dao) { bool bInsertOk = insertItem_Helper::value || qx::trait::is_smart_ptr::value>::insert(item, dao); if (bInsertOk) { qx::dao::detail::QxDao_Keep_Original::backup(item); } return bInsertOk; } template struct insertItem_Helper { static inline bool insert(U & item, qx::dao::detail::QxDao_Helper_Container & dao) { return (item ? qx::dao::detail::QxDao_Insert_Container::insertItem((* item), dao) : true); } }; template struct insertItem_Helper, false> { static inline bool insert(std::pair & item, qx::dao::detail::QxDao_Helper_Container & dao) { return qx::dao::detail::QxDao_Insert_Container::insertItem(item.second, dao); } }; template struct insertItem_Helper, false> { static inline bool insert(const std::pair & item, qx::dao::detail::QxDao_Helper_Container & dao) { return qx::dao::detail::QxDao_Insert_Container::insertItem(item.second, dao); } }; template struct insertItem_Helper, false> { static inline bool insert(QPair & item, qx::dao::detail::QxDao_Helper_Container & dao) { return qx::dao::detail::QxDao_Insert_Container::insertItem(item.second, dao); } }; template struct insertItem_Helper, false> { static inline bool insert(const QPair & item, qx::dao::detail::QxDao_Helper_Container & dao) { return qx::dao::detail::QxDao_Insert_Container::insertItem(item.second, dao); } }; template struct insertItem_Helper { static bool insert(U & item, qx::dao::detail::QxDao_Helper_Container & dao) { #ifdef _QX_ENABLE_MONGODB if (dao.isMongoDB()) { if (dao.qxQuery().queryAt(2) == "") { if (! dao.itemsAsJson().isEmpty()) { QString oid = dao.itemsAsJson().takeFirst(); if (! oid.isEmpty() && dao.getDataId()) { dao.getDataId()->fromVariant((& item), oid, -1, qx::cvt::context::e_database); } } qx::dao::on_after_insert((& item), (& dao)); return dao.isValid(); } qx::dao::on_before_insert((& item), (& dao)); if (! dao.isValid()) { return false; } dao.itemsAsJson().append(qx::serialization::json::to_string(item, 1, "mongodb")); return dao.isValid(); } #endif // _QX_ENABLE_MONGODB IxSqlGenerator * pSqlGenerator = dao.getSqlGenerator(); if (pSqlGenerator) { pSqlGenerator->onBeforeInsert((& dao), (& item)); } qx::dao::on_before_insert((& 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_Insert::resolveInput(item, dao.query(), dao.builder()); } if (! dao.exec(true)) { dao.errFailed(); return false; } dao.updateLastInsertId(item); if (pSqlGenerator) { pSqlGenerator->onAfterInsert((& dao), (& item)); } qx::dao::on_after_insert((& item), (& dao)); if (! dao.isValid()) { return false; } return dao.isValid(); } }; }; template struct QxDao_Insert_Ptr { static inline QSqlError insert(T & t, QSqlDatabase * pDatabase) { return (t ? qx::dao::insert((* t), pDatabase) : QSqlError()); } }; template struct QxDao_Insert { static inline QSqlError insert(T & t, QSqlDatabase * pDatabase) { typedef typename std::conditional< std::is_pointer::value, qx::dao::detail::QxDao_Insert_Ptr, qx::dao::detail::QxDao_Insert_Generic >::type type_dao_1; typedef typename std::conditional< qx::trait::is_smart_ptr::value, qx::dao::detail::QxDao_Insert_Ptr, type_dao_1 >::type type_dao_2; typedef typename std::conditional< qx::trait::is_container::value, qx::dao::detail::QxDao_Insert_Container, type_dao_2 >::type type_dao_3; QSqlError error = type_dao_3::insert(t, pDatabase); if (! error.isValid()) { qx::dao::detail::QxDao_Keep_Original::backup(t); } return error; } }; } // namespace detail } // namespace dao } // namespace qx