Feature Request: Batch Insert

[badoet]

pass in []interface{} to batch insert using db.Create([]interface{})

[badoet]

on the same point, batch row updates would be awesome too.

[jinzhu]

I have thought about it before, but haven't implement it due to can't run callbacks.

[birkirb]

👍

[areski]

+1 for Batch insert

[acasanova]

Is there still no way to accomplish this? I tried building a string of multiple queries and passed it to Exec or Raw but I get errors when using Exec. Raw just seems not to do anything.

INSERT IGNORE INTO img_info (name, filename, path, height,width, mime) VALUES ('a', 'a.jpg.jpg','../../imagedb/thumbs/getty360/a.jpg', '73','110', 'image/jpeg'), ('b', 'b.png.png','../../imagedb/thumbs/getty360/b.png', '73','110', 'image/jpeg'), ('c', 'c.png.png','../../imagedb/thumbs/getty360/c.png', '73','110', 'image/jpeg'), ('d', 'd.png.png','../../imagedb/thumbs/getty360/d.png', '73','110', 'image/jpeg');
INSERT IGNORE INTO pending_uploads (filename, status, created_at) VALUES ('a', 0, '2015-04-23 12:22:37.596460147 -0400 EDT'), ('b', 0, '2015-04-23 12:22:37.596473783 -0400 EDT'), ('c', 0, '2015-04-23 12:22:37.596482969 -0400 EDT'), ('d', 0, '2015-04-23 12:22:37.596489454 -0400 EDT');
INSERT IGNORE INTO metadata (MasterNumber, Prod_Title, Prod_Code, Caption, Keywords,UploadDate) VALUES ('a', 'Getty 360','getty360', '','', '2015-04-23 12:22:37.596323687 -0400 EDT'), ('b', 'Getty 360','getty360', '','', '2015-04-23 12:22:37.596470372 -0400 EDT'), ('c', 'Getty 360','getty360', '','', '2015-04-23 12:22:37.596480429 -0400 EDT'), ('d', 'Getty 360','getty360', '','', '2015-04-23 12:22:37.596487448 -0400 EDT');
&{<nil> Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT IGNORE INTO pending_uploads (filename, status, created_at) VALUES ('a', 0' at line 2 0 map[] <nil> 0xc20805e280 0xc20806aa50 0xc208090d80 0 <nil> <nil> false  map[] map[]}

/Users/acasanova/projects/go/src/com.drleonardo/imagelib/models/services/gettyservice_test.go:117Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT IGNORE INTO pending_uploads (filename, status, created_at) VALUES ('a', 0' at line 2

the actual sql works fine in mysql

for now I'll just use individual statements
Any suggestions?

[ilgooz]

+1

[badoet]

the problem is in the mysql db driver.
i already send a pull request for this capability.
go-sql-driver/mysql#339

[aspcartman]

+1, any way to do it now?

[derekperkins]

👍

[ptheunis]

Waiting for this feature eagerly aswell.

[rodcorsi]

👍

[viejodecaldas]

+1 for Batch Inserts