Database Insert records from struct

[srikanth_c]

Hello,

Need help in inserting the data into a table from a Struct which is similar to that of a table.
I doesn’t want to write long insert script something like this
insert into <table_name> values (?,?,?,?..)
and passing values from each item in struct.

[Hultan (Per Hultqvist)]

I definitely recommend GORM : https://gorm.io/

You will basically not have to write another SQL-statement again I have used it in several projects and it worked well for my (fairly small) projects.

[Sibert]

@srikanth_c

I doesn’t want to write long insert script something like this

ORM is one way to go. I do not like it, because of all the magic creates limitations and you have to learn a new “language” supported by a smaller group. Getting help with plain SQL questions is easier than getting help with an ORM question.

That said, I do not like to write code that seems to be repeated either. So I use sqlx with .StructScan. Inserts is still boring though.

And there seems to be a tool - sqlc - that creates all boring stuff automatically. Pure SQL. https://www.youtube.com/watch?v=prh0hTyI1sU