英文:
Gorm serialize struct on save/create
问题
我有一个结构体，它是一个表的模型。一切都很好，直到我想将类型结构体添加到其中并将其序列化为JSON（Location）。
type Dome struct {
gorm.Model
Location Location `json:"location" gorm:"serializer:json"`
Title string `json:"title" gorm:"type:varchar(100)"`
}
type Location struct {
X1 int
Y1 int
X2 int
Y2 int
}
当使用.Updates()方法时，这些值被序列化并保存到列中。但是当使用Create或Save方法时，会抛出错误：
sql: converting argument $ type: unsupported type Location, a struct
据我所了解，Gorm已经有一些默认的序列化器，比如json。它似乎在Updates方法上起作用，但在任何Create方法上都不起作用。而且在调试时，我看到这些值被反序列化并再次出现在结构体中。
我找不到答案，我可能漏掉了什么，也许需要添加其他内容，但我经验不够丰富。如何使用Gorm将结构体序列化到列中？
英文:
I have struct, that is model for table. All was good, until I want to add type struct into it and serialize it to json (Location).
type Dome struct {
gorm.Model
Location Location `json:"location" gorm:"serializer:json"`
Title string `json:"title" gorm:"type:varchar(100)"`
}
type Location struct {
X1 int
Y1 int
X2 int
Y2 int
}
When doing .Updates(), those values are serialized and saved into column. But when doing Create or Save, it throw error
sql: converting argument $ type: unsupported type Location, a struct
From what I understood, Gorm already have some default serializers, like json. And it seems to work on Updates, but not on any Create. Also when debugging I see those values deserialized and again in struct.
I can't find answer what am I missing, maybe need to add something else, but I am not that experienced. How to do that serialization into column from struct using Gorm?
答案1
得分: 1
package main
import (
"fmt"
"gorm.io/driver/sqlite"
"gorm.io/gorm"
)
type Dome struct {
gorm.Model
Location Location `json:"location" gorm:"serializer:json"`
Title string `json:"title" gorm:"type:varchar(100)"`
}
type Location struct {
X1 int
Y1 int
X2 int
Y2 int
}
func main() {
db, _ := gorm.Open(sqlite.Open("gorm.db"), &gorm.Config{})
/*err := db.AutoMigrate(&Dome{})
if err != nil {
return
}*/
l := Location{}
l.Y1 = 1
l.X1 = 2
l.X2 = 3
l.Y2 = 4
d := Dome{}
d.Title = "test"
d.Location = l
db.Create(&d)
d.Location.Y2 = 6
db.Save(&d)
d.Location.X2 = 4
db.Updates(&d)
_target := []*Dome{}
db.Find(&_target)
for _, t := range _target {
fmt.Printf("%+v \n", t)
}
}
我尝试了这种方式，serializer:json 没有问题。
输出结果：
&{Model:{ID:1 CreatedAt:2022-08-06 14:39:59.184012808 +0530 +0530 UpdatedAt:2022-08-06 14:39:59.184012808 +0530 +0530 DeletedAt:{Time:0001-01-01 00:00:00 +0000 UTC Valid:false}} Location:{X1:2 Y1:1 X2:3 Y2:4} Title:test}
&{Model:{ID:2 CreatedAt:2022-08-06 14:40:55.666162544 +0530 +0530 UpdatedAt:2022-08-06 14:40:55.677998201 +0530 +0530 DeletedAt:{Time:0001-01-01 00:00:00 +0000 UTC Valid:false}} Location:{X1:2 Y1:1 X2:3 Y2:6} Title:test}
&{Model:{ID:3 CreatedAt:2022-08-06 14:41:29.361814733 +0530 +0530 UpdatedAt:2022-08-06 14:41:29.367237119 +0530 +0530 DeletedAt:{Time:0001-01-01 00:00:00 +0000 UTC Valid:false}} Location:{X1:2 Y1:1 X2:4 Y2:6} Title:test}
根据文档，你可以注册序列化器并实现如何序列化和反序列化数据。
https://gorm.io/docs/serializer.html#Register-Serializer
英文:
package main
import (
"fmt"
"gorm.io/driver/sqlite"
"gorm.io/gorm"
)
type Dome struct {
gorm.Model
Location Location `json:"location" gorm:"serializer:json"`
Title string `json:"title" gorm:"type:varchar(100)"`
}
type Location struct {
X1 int
Y1 int
X2 int
Y2 int
}
func main() {
db, _ := gorm.Open(sqlite.Open("gorm.db"), &gorm.Config{})
/*err := db.AutoMigrate(&Dome{})
if err != nil {
return
}*/
l := Location{}
l.Y1 = 1
l.X1 = 2
l.X2 = 3
l.Y2 = 4
d := Dome{}
d.Title = "test"
d.Location = l
db.Create(&d)
d.Location.Y2 = 6
db.Save(&d)
d.Location.X2 = 4
db.Updates(&d)
_target := []*Dome{}
db.Find(&_target)
for _, t := range _target {
fmt.Printf("%+v \n", t)
}
}
I tried like this way and serializer:json worked without an issue.
output:
&{Model:{ID:1 CreatedAt:2022-08-06 14:39:59.184012808 +0530 +0530 UpdatedAt:2022-08-06 14:39:59.184012808 +0530 +0530 DeletedAt:{Time:0001-01-01 00:00:00 +0000 UTC Valid:false}} Location:{X1:2 Y1:1 X2:3 Y2:4} Title:test}
&{Model:{ID:2 CreatedAt:2022-08-06 14:40:55.666162544 +0530 +0530 UpdatedAt:2022-08-06 14:40:55.677998201 +0530 +0530 DeletedAt:{Time:0001-01-01 00:00:00 +0000 UTC Valid:false}} Location:{X1:2 Y1:1 X2:3 Y2:6} Title:test}
&{Model:{ID:3 CreatedAt:2022-08-06 14:41:29.361814733 +0530 +0530 UpdatedAt:2022-08-06 14:41:29.367237119 +0530 +0530 DeletedAt:{Time:0001-01-01 00:00:00 +0000 UTC Valid:false}} Location:{X1:2 Y1:1 X2:4 Y2:6} Title:test}
According to documentation you can register serializer and implement how to serialize and deserialize data.
https://gorm.io/docs/serializer.html#Register-Serializer
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论