bulk insert in zend framework

Question

Possible Duplicate:
How do I add more than one row with Zend_Db?

everyone,

I need to have a bulk insert in zend framework. For normal sql I have the below query, I want to do the same in zend framework.

INSERT INTO `dbname`.'tablename` (`id`, `user_id`, `screen_name`, `screen_name_server`) VALUES (NULL, '15', 'test', 'test'), (NULL, '15', 'test', 'test');

Thanks.

Jerry Saravia · Accepted Answer · 2011-07-23T15:54:49.757

8

There's no way to do this, as Marcin states.

If you'd like to do some messing around with the Zend Framework you'd could try to alter the insert.

You could try to make it so that the insert method can take an array of arrays for the data. Then you could use the arrays of data to build the bulk insert.

For example,



$data1 = array( ); //data for first insert

$data2 = array( ); //data for 2nd insert

//a zend_db_table object

$dbTable->insert( array( $data1, $data, ) );

You would have to edit the insert method a bit to detect multiple data inserts and then build the insert accordingly. Unfortunately I haven't looked into how the code is built or I would just put it up here for you to use.

edited Jul 23 '11 at 15:54

answered Jul 22 '11 at 13:53

Jerry Saravia

3,737
3
24
39

1

+1 for the approach. I've actually done this to generate a single query to insert all rows at once. In my testing it was about 10 times faster than iterating over the data and executing a query for each tuple. – David Snabel-Caunt Jul 22 '11 at 15:05
Oog genius Man .. you save my time :) – chhameed Sep 10 '12 at 11:39
@Hameed Thanks but I haven't implemented this myself so I can't take credit for actually doing it. – Jerry Saravia Sep 10 '12 at 13:28

score 5 · Answer 2 · answered Jul 22 '11 at 13:35

5

There is no insert method in zend_db that would insert multiple rows. What you can do though, is to use query method of Zend_Db_Adapter and put there your own insert sql.

answered Jul 22 '11 at 13:35

Marcin

215,873
14
235
294

bulk insert in zend framework

2 Answers2