如何更新有关与Gorm插入冲突的嵌套字段？

Question

我有两种模型，即字典和字典记录，并带有词典上的外键。

type DictionaryRecord struct {
    Id           string `gorm:"primaryKey"`
    Name         string
    DictionaryId string
}

type Dictionary struct {
    Id      string `gorm:"primaryKey"`
    Name string 
    Records []DictionaryRecord
}

我想确保在创建带有嵌套记录的字典时，请在UpSert期间反映更改。

package main

import (

    // Sqlite driver based on GGO
    "gorm.io/driver/sqlite"
    "gorm.io/gorm"
    "gorm.io/gorm/clause"
)

func main() {
    db, err := gorm.Open(sqlite.Open("gorm.db"), &gorm.Config{})

    if err != nil {
        panic(err)
    }

    db.AutoMigrate(
        &DictionaryRecord{},
        &Dictionary{},
    )

    db.Clauses(clause.OnConflict{
        Columns:   []clause.Column{{Name: "id"}},
        DoUpdates: clause.AssignmentColumns([]string{"name"}),
    }).Create(&Dictionary{
        Name: "AAAAA",
        Id:   "e831ab86-db60-4a71-ba63-f20a181cd69b",
        Records: []DictionaryRecord{
            {
                Id:           "66f73e9b-61b8-4bc9-941d-80d7fd80f8f4",
                Name:         "will be updated",
            },
        },
    })

}

您如何指定必须更新dictionaryRecord中的列名？

Answer 1

您可以尝试使用指针吗

type DictionaryRecord struct {
    Id           string `gorm:"primaryKey"`
    Name         string
    DictionaryId string
}

type Dictionary struct {
    Id      string `gorm:"primaryKey"`
    Name string 
    Records []*DictionaryRecord //on this records
}