how do you insert multiple rows in a loop using doctrine 2

Question

i want to insert multiple rows in a loop using doctrine 2..

i usually insert 1 record using this:

$Entity->setData($posted); $this->_doctrine->persist($Entity); $this->_doctrine->flush();

Michael Ridgway · Accepted Answer · 2011-05-31 21:21:43Z

4

Simply persist all your objects and then call flush() after the loop.

    $entityDataArray = array();  // let's assume this is an array containing data for each entity
    foreach ($entityDataArray AS $entityData) {
        $entity = new \Entity();
        $entity->setData($entityData);
        $this->_doctrine->persist($entity);
    }
    $this->_doctrine->flush();

If you're inserting a large number of objects you will want to batch insert (see http://www.doctrine-project.org/docs/orm/2.0/en/reference/batch-processing.html)

answered May 31, 2011 at 21:21

Michael Ridgway

5,3191 gold badge18 silver badges6 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

David Weinraub · Accepted Answer · 2011-05-31 10:51:03Z

0

Inside your loop, you should be able to simply:

$entity1->setData($data1);
$this->_doctrine->persist($entity1);

$entity2->setData($data2);
$this->_doctrine->persist($entity2);

$this->_doctrine->flush();

answered May 31, 2011 at 10:51

David Weinraub

14.2k4 gold badges45 silver badges64 bronze badges

Collectives™ on Stack Overflow

how do you insert multiple rows in a loop using doctrine 2

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related