Home > database >  Gorm serialize struct on save/create
Gorm serialize struct on save/create

Time:08-06

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?

CodePudding user response:

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} 

enter image description here

According to documentation you can register serializer and implement how to serialize and deserialize data. https://gorm.io/docs/serializer.html#Register-Serializer

  • Related