Gorm: Insert data into database using interface{}

[achu1612]

In my use case, I have to insert data into a table. I am unaware of the schema of the table. I have the data in json format. Is there any way, I can insert the data in the table with out defining any structs because the data and tables will change very frequently.

I have tried this, but it did not work.

data := {"uid":"1234", "email_id":"[email protected]"}

var insertData interface{}
_ = json.Unmarshal([]byte(data), &insertData )
db.Table("USR_DATA").Create(&insert)

[imdatngo]

That's not possible with Gorm, you have to use a struct to create new record. Otherwise, try to build the raw SQL sentence yourself.

By the way, it sounds weird to me that the table schema would be changed "very frequently" when you're using Gorm, which is an ORM lib for the relational database (SQL)... You might want to use the non-relational database (NoSQL) instead.

[achu1612]

The schema would change "very frequently" for the application. I meant I have to store the data in different database tables and I have no idea about the schema of the tables.

[zaneli]

try to build the raw SQL sentence yourself.

Agree.

I think Gorm (and any other ORM libraries) is not suitable for such use case.

[github-actions[bot]]

This issue will be automatically closed because it is marked as GORM V1 issue, we have released the public testing GORM V2 release and its documents https://v2.gorm.io/docs/ already, the testing release has been used in some production services for a while, and going to release the final version in following weeks, we are still actively collecting feedback before it, please open a new issue for any suggestion or problem, thank you

Also check out https://github.com/go-gorm/gorm/wiki/GORM-V2-Release-Note-Draft for how to use the public testing version and its changelog