Bulk insert into DB with Zend

Question

I've seen on SO that you can do multiple inserts without having to do them in a loop, with the createRowset and createRow methods.

My problem is, that I'm not sure in which class the createRowset method is defined. I have the following code, which fails with an 500 internal error:

$twitterUsersModel = new TwitterUsers($this->db_adapter);
$rowset = $twitterUsersModel->createRowset(); // this is the line that fails
foreach ($data as $d) 
{
    $row = $twitterUsersModel->createRow($d);
    $rowset->addRow($row);
}
$rowset->save();

My TwitterUsers class extends the Zend_Db_Table_Abstract class, which (as far as I can tell) doesn't have a createRowset method (just tested with extending Zend_Db_Table, still not working). Is there any other way to do this from a Zend_Db_Table_Abstract extending class?

Raj · Accepted Answer · 2011-12-14 17:51:08Z

5

Its defined nowhere actually. This feature is not yet implemented in Zend framework. However this is proposed as a new feature in Zend Framework Issue tracker.

http://framework.zend.com/issues/browse/ZF-2322

Vote for it, to get the feature sooner.

answered Dec 14, 2011 at 17:51

Raj

23.1k14 gold badges105 silver badges148 bronze badges

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

1 Comment

Eduard Luca Over a year ago

I see, so I'll have to do my inserts in a loop afterall :( just sad that it doesn't offer this kind of stuff. Thank you!

Collectives™ on Stack Overflow

Bulk insert into DB with Zend

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related