Insert multiple records with entities

Insert multiple records with entities - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: CodeIgniter 4 (https://forum.codeigniter.com/forumdisplay.php?fid=28)
+--- Forum: CodeIgniter 4 Feature Requests (https://forum.codeigniter.com/forumdisplay.php?fid=29)
+--- Thread: Insert multiple records with entities (/showthread.php?tid=75855)

Insert multiple records with entities - luispastendev - 03-23-2020

Hello!

I am trying to insert multiple values that are saved in an entity, the problem is that when I try to save with the function model->save (), it sends an error because it seems not ready to accept entity objects

I am trying to do it as follows

PHP Code:
$batch = [];
foreach ($this->request->getVar('name_option') as $key => $value) {
  $variantOption = new VariantOption();     
  $variantOption->name = $this->request->getVar('name_option')[$key];
  $variantOption->price = $this->request->getVar('price_option')[$key];
  $variantOption->price_discount = $this->request->getVar('discount_option')[$key];
  $batch[] = $variantOption;
}
$this->modelVariantOptions->save($batch); 

Is it possible to save entities in such a way that it generates a single insert, not multiple ones?

I have also tried the

Code:
insertBatch()

function of the query builder class but it doesn't work.

grettings