How To Bulk Insert in A Table Magento 2 : Sometime we need to insert multiple records in table using a single step. because insert record one by one it takes so much time. so for the better performance, you can insert multiple records in a table if you want. and it will take less time. so i am going to explain how you can insert bulk records in a database table.<\/p>\n
1 => First make a class where you will define the connection with table for bulk insert.
\nso here i have created a class in model directory on this location (Webkul\\BulkInsertTest\\Model\\Storage).<\/p>\n
namespace Webkul\\BulkInsertTest\\Model\\Storage;\n\nuse Magento\\Framework\\App\\ResourceConnection;\n\nclass DbStorage\n{\n \/**\n * DB Storage table name\n *\/\n const TABLE_NAME = 'wk_custom_table';\n\n \/**\n * Code of \"Integrity constraint violation: 1062 Duplicate entry\" error\n *\/\n const ERROR_CODE_DUPLICATE_ENTRY = 23000;\n\n \/**\n * @var \\Magento\\Framework\\DB\\Adapter\\AdapterInterface\n *\/\n protected $connection;\n\n \/**\n * @var Resource\n *\/\n protected $resource;\n\n \/**\n * @param \\Magento\\Framework\\App\\ResourceConnection $resource\n *\/\n public function __construct(\n ResourceConnection $resource\n ) {\n $this->connection = $resource->getConnection();\n $this->resource = $resource;\n }\n\n \/**\n * Insert multiple\n *\n * @param array $data\n * @return void\n * @throws \\Magento\\Framework\\Exception\\AlreadyExistsException\n * @throws \\Exception\n *\/\n public function insertMultiple($data, $tableName = self::TABLE_NAME)\n {\n try {\n $tableName = $this->resource->getTableName(self::TABLE_NAME);\n return $this->connection->insertMultiple($tableName, $data);\n } catch (\\Exception $e) {\n if ($e->getCode() === self::ERROR_CODE_DUPLICATE_ENTRY\n && preg_match('#SQLSTATE\\[23000\\]: [^:]+: 1062[^\\d]#', $e->getMessage())\n ) {\n throw new \\Magento\\Framework\\Exception\\AlreadyExistsException(\n __('URL key for specified store already exists.')\n );\n }\n throw $e;\n }\n }\n}<\/pre>\nHere TABLE_NAME constant contain table name.<\/p>\n
2 => Now you have to just create an array of data and call the method.<\/p>\n
foreach($records as $record) {\n $bulkInsert[] = [\n 'first_name' => $record['first_name'],\n 'last_name' => $record['last_name']\n ];\n}\n\n$objectManager = \\Magento\\Framework\\App\\ObjectManager::getInstance();\n$dbStorage = $objectManager->get('Webkul\\BulkInsertTest\\Model\\Storage');\n$dbStorage->insertMultiple($bulkInsert, 'wk_custom_table',);<\/pre>\nHope so it will help.<\/p>\n","protected":false},"excerpt":{"rendered":"