Gorm预加载时如何制定关联关系表中某个字段的值

结构体代码如下:

type UpgradeTask struct {
    Id          int      `json:"id" gorm:"primaryKey"`
    PreScripts  []Script `json:"pre_scripts" gorm:"many2many:yb_task_script_relation;ForeignKey:id;JoinForeignKey:task_id;References:id;JoinReferences:script_id;constraint:OnUpdate:CASCADE,OnDelete:CASCADE;"`
    PostScripts []Script `json:"post_scripts" gorm:"many2many:yb_task_script_relation;ForeignKey:id;JoinForeignKey:task_id;References:id;JoinReferences:script_id;constraint:OnUpdate:CASCADE,OnDelete:CASCADE;"`
}

type Script struct {
    Id         int    `json:"id" gorm:"primaryKey"`
    ScriptName string `json:"script_name"`
}

type TaskScript struct {
    Id         int `json:"-" gorm:"id;primaryKey"`
    TaskId     int `json:"task_id"`
    ScriptId   int `json:"script_id"`
    ScriptType int `json:"script_type"`
}

在UpgradeTask表中存在PreScripts和PostScripts字段信息,其中PreScripts为关联关系表TaskScript表中ScriptType为1的Script数据信息,PostScripts为关联关系表TaskScript表中ScriptType为2的Script数据信息,在查询UpgradeTask时需同时查询出该记录所对应的PreScripts和PostScripts信息,该怎么写代码?

讨论数量: 0
(= ̄ω ̄=)··· 暂无内容!

讨论应以学习和精进为目的。请勿发布不友善或者负能量的内容,与人为善,比聪明更重要!