How to bulk insert in GORM?

Question

go

Greetings!
There is an array of structures that need to be written to the appropriate database table using GORM.
Now I do it with a loop and gorm DB.Create one at a time.
How to save them all at once? DB.Create does not accept an array.

Answer 1

You can use the library https://github.com/t-tiger/gorm-bulk-insert
If you don't want to pull unnecessary dependencies into the project, you can wrap the cycle in a transaction, this will give a performance gain close to normal bulk insert.
Approximately like this:

tx.Begin()
for {
   DB.Create
}
tx.Commit()

I advise you to take a closer look at this library https://jmoiron.github.io/sqlx/
I use it in almost all projects.