{"id":307995,"date":"2021-10-03T05:38:50","date_gmt":"2021-10-03T05:38:50","guid":{"rendered":"https:\/\/webkul.com\/blog\/?p=307995"},"modified":"2024-06-19T12:45:55","modified_gmt":"2024-06-19T12:45:55","slug":"database-transactions-for-multiple-models-in-magento-2","status":"publish","type":"post","link":"https:\/\/webkul.com\/blog\/database-transactions-for-multiple-models-in-magento-2\/","title":{"rendered":"Database transactions for multiple Models in Magento 2"},"content":{"rendered":"\n

Hello Friends!

In this blog, we are going to learn how we can make database transactions to save records in multiple tables using their model classes.<\/p>\n\n\n\n

For example, we have to save information of a customer in customer_personal_info, customer_wallet_transaction, customer_reward_points, customer_wallet<\/em> database tables. So, we will create resource model and model classes for these tables.<\/p>\n\n\n\n

To insert the data in the database sequentially, we will add model objects in the instance of \\Magento\\Framework\\DB\\Transaction<\/strong> Class.<\/p>\n\n\n\n

\n

For more information about database transactions and saving a number of records in the database table, you can check the following blogs:
Working With Database Transactions In Magento2<\/a>
Optimization Tips For Magento and Magento2 \u2013 Part 2<\/a><\/p>\n<\/blockquote>\n\n\n\n

Here I have used model factory classes for saving the information. Let’s see in the following Helper class (app\/code\/Vendor\/CustomModule\/Helper\/SaveCustomerInfo), how we create the model object and add it to the transaction object to do the database trasaction.
<\/p>\n\n\n\n

<?php\n\/**\n * Vendor Desc..\n *\n * @category  Vendor\n * @package   Vendor_CustomerModule\n * @author    Vendor\n * @copyright Copyright (c) Vendor\n * @license   https:\/\/example.com\/license.html\n *\/\nnamespace Vendor\\CustomerModule\\Helper;\n\nclass SaveCustomerInfo extends \\Magento\\Framework\\App\\Helper\\AbstractHelper\n{\n    \/**\n     * @param \\Magento\\Framework\\App\\Helper\\Context $context\n     * @param \\Vendor\\CustomerModule\\Model\\CustomerPersonalInfoFactory $customerInfo\n     * @param \\Vendor\\CustomerModule\\Model\\CustomerWalletFactory $customerWallet\n     * @param \\Vendor\\CustomerModule\\Model\\CustomerWalletTransactionFactory $customerWalletTrans\n     * @param \\Vendor\\CustomerModule\\Model\\CustomerRewardPointsFactory $customerRewards\n     * @param \\Magento\\Framework\\DB\\TransactionFactory $dbTransactionF\n     *\/\n    public function __construct(\n        \\Magento\\Framework\\App\\Helper\\Context $context,\n        \\Vendor\\CustomerModule\\Model\\CustomerPersonalInfoFactory $customerInfo,\n        \\Vendor\\CustomerModule\\Model\\CustomerWalletFactory $customerWallet,\n        \\Vendor\\CustomerModule\\Model\\CustomerWalletTransactionFactory $customerWalletTrans,\n        \\Vendor\\CustomerModule\\Model\\CustomerRewardPointsFactory $customerRewards,\n        \\Magento\\Framework\\DB\\TransactionFactory $dbTransactionF\n    ) {\n        parent::__construct($context);\n        $this->customerInfo   = $customerInfo;\n        $this->customerWallet = $customerWallet;\n        $this->customerWalletTrans = $customerWalletTrans;\n        $this->customerRewards = $customerRewards;\n        $this->dbTransactionF  = $dbTransactionF;\n    }\n\n    \/**\n     * Execute method to save information\n     * \n     * @return void\n     *\/\n    public function execute()\n    {\n        $dbTransaction = $this->dbTransactionF->create();\n\n        \/\/add information in customerPersonalInfo model\n        $customerPersonalInfo = $this->customerInfo->create();\n        $customerPersonalInfo->setFirstName("Jack");\n        $customerPersonalInfo->setLastName("D'souza");\n        $customerPersonalInfo->setCode("Jack420");\n        $customerPersonalInfo->setGender("male");\n        $customerPersonalInfo->setDob("2000-10-10");\n        \n        \/\/add customerPersonalInfo object for transaction\n        $dbTransaction->addObject($customerPersonalInfo);\n\n        \/\/add information in customerWalletTrans model\n        $walletTrans = $this->customerWalletTrans->create();\n        $walletTrans->setCode("Jack420");\n        $walletTrans->setTransType("credit");\n        $walletTrans->setCurrentAmount(1000);\n        $walletTrans->setTransAmount(1000);\n        $walletTrans->setDesc("CREDIT: By admin");\n        \n        \/\/add customerWalletTrans object for transaction\n        $dbTransaction->addObject($walletTrans);\n\n        \/\/add information in customerWallet model\n        $wallet = $this->customerWallet->create();\n        $wallet->setCode("Jack420");\n        $wallet->setTotalAmount(1000);\n        $wallet->setUsedAmount(0);\n        \n        \/\/add customerWallet object for transaction\n        $dbTransaction->addObject($wallet);\n\n        \/\/add information in customerWallet model\n        $reward = $this->customerRewards->create();\n        $reward->setCode("Jack420");\n        $reward->setTotalRewards(2000);\n        $reward->setRemainingRewards(2000);\n        $reward->setUsedRewards(0);\n        $reward->setDesc("CREDIT: rewards assigned on registration");\n        \n        \/\/add customerWallet object for transaction\n        $dbTransaction->addObject($reward);\n    \n        $dbTransaction->save();\n        return;\n    }\n}<\/pre>\n\n\n\n
Hope this will be helpful. Thanks \ud83d\ude42

Previous Blog:<\/strong> Use Zend_Mail_Protocol_Imap in Magento 2<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Hello Friends! In this blog, we are going to learn how we can make database transactions to save records in multiple tables using their model classes. For example, we have to save information of a customer in customer_personal_info, customer_wallet_transaction, customer_reward_points, customer_wallet database tables. So, we will create resource model and model classes for these tables. […]<\/a><\/p>\n","protected":false},"author":249,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9121],"tags":[6027,12139,12140],"class_list":["post-307995","post","type-post","status-publish","format-standard","hentry","category-magento-2","tag-database-transaction","tag-database-transaction-for-multiple-models","tag-multiple-database-transaction"],"yoast_head":"\nDatabase transactions for multiple Models in Magento 2 - Webkul Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/webkul.com\/blog\/database-transactions-for-multiple-models-in-magento-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Database transactions for multiple Models in Magento 2 - Webkul Blog\" \/>\n<meta property=\"og:description\" content=\"Hello Friends! In this blog, we are going to learn how we can make database transactions to save records in multiple tables using their model classes. For example, we have to save information of a customer in customer_personal_info, customer_wallet_transaction, customer_reward_points, customer_wallet database tables. So, we will create resource model and model classes for these tables. [...]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/webkul.com\/blog\/database-transactions-for-multiple-models-in-magento-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Webkul Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/webkul\/\" \/>\n<meta property=\"article:published_time\" content=\"2021-10-03T05:38:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-06-19T12:45:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-og.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Khushboo Sahu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@webkul\" \/>\n<meta name=\"twitter:site\" content=\"@webkul\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Khushboo Sahu\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/webkul.com\/blog\/database-transactions-for-multiple-models-in-magento-2\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/webkul.com\/blog\/database-transactions-for-multiple-models-in-magento-2\/\"},\"author\":{\"name\":\"Khushboo Sahu\",\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/person\/f94b8f53397bf85810761d76c98fadca\"},\"headline\":\"Database transactions for multiple Models in Magento 2\",\"datePublished\":\"2021-10-03T05:38:50+00:00\",\"dateModified\":\"2024-06-19T12:45:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/webkul.com\/blog\/database-transactions-for-multiple-models-in-magento-2\/\"},\"wordCount\":183,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/webkul.com\/blog\/#organization\"},\"keywords\":[\"database transaction\",\"database transaction for multiple models\",\"multiple database transaction\"],\"articleSection\":[\"Magento 2\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/webkul.com\/blog\/database-transactions-for-multiple-models-in-magento-2\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/webkul.com\/blog\/database-transactions-for-multiple-models-in-magento-2\/\",\"url\":\"https:\/\/webkul.com\/blog\/database-transactions-for-multiple-models-in-magento-2\/\",\"name\":\"Database transactions for multiple Models in Magento 2 - Webkul Blog\",\"isPartOf\":{\"@id\":\"https:\/\/webkul.com\/blog\/#website\"},\"datePublished\":\"2021-10-03T05:38:50+00:00\",\"dateModified\":\"2024-06-19T12:45:55+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/webkul.com\/blog\/database-transactions-for-multiple-models-in-magento-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/webkul.com\/blog\/database-transactions-for-multiple-models-in-magento-2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/webkul.com\/blog\/database-transactions-for-multiple-models-in-magento-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/webkul.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Database transactions for multiple Models in Magento 2\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/webkul.com\/blog\/#website\",\"url\":\"https:\/\/webkul.com\/blog\/\",\"name\":\"Webkul Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/webkul.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/webkul.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/webkul.com\/blog\/#organization\",\"name\":\"WebKul Software Private Limited\",\"url\":\"https:\/\/webkul.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-logo-accent-sq.png\",\"contentUrl\":\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-logo-accent-sq.png\",\"width\":380,\"height\":380,\"caption\":\"WebKul Software Private Limited\"},\"image\":{\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/webkul\/\",\"https:\/\/x.com\/webkul\",\"https:\/\/www.instagram.com\/webkul\/\",\"https:\/\/www.linkedin.com\/company\/webkul\",\"https:\/\/www.youtube.com\/user\/webkul\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/person\/f94b8f53397bf85810761d76c98fadca\",\"name\":\"Khushboo Sahu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/cabac965df656d114e6bf340df07518c990eda03bb09265dbd5c17f1097adaae?s=96&d=https%3A%2F%2Fcdnblog.webkul.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F10%2Feva.png&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/cabac965df656d114e6bf340df07518c990eda03bb09265dbd5c17f1097adaae?s=96&d=https%3A%2F%2Fcdnblog.webkul.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F10%2Feva.png&r=g\",\"caption\":\"Khushboo Sahu\"},\"url\":\"https:\/\/webkul.com\/blog\/author\/khushboo-sahu062\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Database transactions for multiple Models in Magento 2 - Webkul Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/webkul.com\/blog\/database-transactions-for-multiple-models-in-magento-2\/","og_locale":"en_US","og_type":"article","og_title":"Database transactions for multiple Models in Magento 2 - Webkul Blog","og_description":"Hello Friends! In this blog, we are going to learn how we can make database transactions to save records in multiple tables using their model classes. For example, we have to save information of a customer in customer_personal_info, customer_wallet_transaction, customer_reward_points, customer_wallet database tables. So, we will create resource model and model classes for these tables. [...]","og_url":"https:\/\/webkul.com\/blog\/database-transactions-for-multiple-models-in-magento-2\/","og_site_name":"Webkul Blog","article_publisher":"https:\/\/www.facebook.com\/webkul\/","article_published_time":"2021-10-03T05:38:50+00:00","article_modified_time":"2024-06-19T12:45:55+00:00","og_image":[{"width":1200,"height":630,"url":"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-og.png","type":"image\/png"}],"author":"Khushboo Sahu","twitter_card":"summary_large_image","twitter_creator":"@webkul","twitter_site":"@webkul","twitter_misc":{"Written by":"Khushboo Sahu","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/webkul.com\/blog\/database-transactions-for-multiple-models-in-magento-2\/#article","isPartOf":{"@id":"https:\/\/webkul.com\/blog\/database-transactions-for-multiple-models-in-magento-2\/"},"author":{"name":"Khushboo Sahu","@id":"https:\/\/webkul.com\/blog\/#\/schema\/person\/f94b8f53397bf85810761d76c98fadca"},"headline":"Database transactions for multiple Models in Magento 2","datePublished":"2021-10-03T05:38:50+00:00","dateModified":"2024-06-19T12:45:55+00:00","mainEntityOfPage":{"@id":"https:\/\/webkul.com\/blog\/database-transactions-for-multiple-models-in-magento-2\/"},"wordCount":183,"commentCount":0,"publisher":{"@id":"https:\/\/webkul.com\/blog\/#organization"},"keywords":["database transaction","database transaction for multiple models","multiple database transaction"],"articleSection":["Magento 2"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/webkul.com\/blog\/database-transactions-for-multiple-models-in-magento-2\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/webkul.com\/blog\/database-transactions-for-multiple-models-in-magento-2\/","url":"https:\/\/webkul.com\/blog\/database-transactions-for-multiple-models-in-magento-2\/","name":"Database transactions for multiple Models in Magento 2 - Webkul Blog","isPartOf":{"@id":"https:\/\/webkul.com\/blog\/#website"},"datePublished":"2021-10-03T05:38:50+00:00","dateModified":"2024-06-19T12:45:55+00:00","breadcrumb":{"@id":"https:\/\/webkul.com\/blog\/database-transactions-for-multiple-models-in-magento-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/webkul.com\/blog\/database-transactions-for-multiple-models-in-magento-2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/webkul.com\/blog\/database-transactions-for-multiple-models-in-magento-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/webkul.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Database transactions for multiple Models in Magento 2"}]},{"@type":"WebSite","@id":"https:\/\/webkul.com\/blog\/#website","url":"https:\/\/webkul.com\/blog\/","name":"Webkul Blog","description":"","publisher":{"@id":"https:\/\/webkul.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/webkul.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/webkul.com\/blog\/#organization","name":"WebKul Software Private Limited","url":"https:\/\/webkul.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/webkul.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-logo-accent-sq.png","contentUrl":"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-logo-accent-sq.png","width":380,"height":380,"caption":"WebKul Software Private Limited"},"image":{"@id":"https:\/\/webkul.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/webkul\/","https:\/\/x.com\/webkul","https:\/\/www.instagram.com\/webkul\/","https:\/\/www.linkedin.com\/company\/webkul","https:\/\/www.youtube.com\/user\/webkul\/"]},{"@type":"Person","@id":"https:\/\/webkul.com\/blog\/#\/schema\/person\/f94b8f53397bf85810761d76c98fadca","name":"Khushboo Sahu","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/webkul.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/cabac965df656d114e6bf340df07518c990eda03bb09265dbd5c17f1097adaae?s=96&d=https%3A%2F%2Fcdnblog.webkul.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F10%2Feva.png&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/cabac965df656d114e6bf340df07518c990eda03bb09265dbd5c17f1097adaae?s=96&d=https%3A%2F%2Fcdnblog.webkul.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F10%2Feva.png&r=g","caption":"Khushboo Sahu"},"url":"https:\/\/webkul.com\/blog\/author\/khushboo-sahu062\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/posts\/307995","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/users\/249"}],"replies":[{"embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/comments?post=307995"}],"version-history":[{"count":3,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/posts\/307995\/revisions"}],"predecessor-version":[{"id":448787,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/posts\/307995\/revisions\/448787"}],"wp:attachment":[{"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/media?parent=307995"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/categories?post=307995"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/tags?post=307995"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}