我正在使用GORM和PostgreSQL数据库 . 我有预先存在的迁移(不使用gorm来处理迁移) . 我有2个彼此相关的结构,它们代表2个在所述数据库中具有许多关系的表 .

移民:

CREATE TABLE IF NOT EXISTS items_captions (
  id varchar(50) NOT NULL,
  item_id varchar(50) NOT NULL REFERENCES items(item_id) ON DELETE CASCADE,
  source varchar(50) NOT NULL, 
  filepath varchar(256) NOT NULL, 
  language varchar(50),
  language_confidence decimal,
  created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
  updated_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
  PRIMARY KEY(id)
);

CREATE TABLE IF NOT EXISTS captions (
  id varchar(50) NOT NULL,
  item_captions_id varchar(50) NOT NULL REFERENCES items_captions(id) ON DELETE CASCADE,
  start_at DECIMAL NOT NULL,
  end_at DECIMAL NOT NULL,
  "text" TEXT NOT NULL, 
  created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
  updated_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
  PRIMARY KEY(id)
);

结构定义:

type ItemsCaptions struct {
    ID                 string    `gorm:"id"`
    ItemID             string    `gorm:"item_id"`
    Source             string    `gorm:"source"`
    Filepath           string    `gorm:"filepath"`
    Language           string    `gorm:"language"`
    LanguageConfidence float64   `gorm:"language_confidence"`
    CreatedAt          time.Time `gorm:"created_at"`
    UpdatedAt          time.Time `gorm:"updated_at"`
    Captions           []Caption `gorm:"foreignkey:ItemCaptionsID"`
}

type Caption struct {
    ID             string    `gorm:"id"`
    ItemCaptionsID string    `gorm:"item_captions_id"`
    StartAt        float64   `gorm:"start_at"`
    EndAt          float64   `gorm:"end_at"`
    Text           string    `gorm:"text"`
    CreatedAt      time.Time `gorm:"created_at"`
    UpdatedAt      time.Time `gorm:"updated_at"`
}

问题:在执行插入操作时,数据似乎正确插入 . 尝试从数据库中查询数据时出现问题 .

var itemCaptions []ItemsCaptions
db.Find(&itemCaptions).Error

var captions []Caption
db.Model(&itemCaptions[0]).Related(&captions)
// no items from db are returned
// However querying the database directly shows that the data was inserted as expected.

另外,我在gorm invalid association [] 的日志中收到以下消息

附加信息:我试图在db.Debug()中运行相同的东西,它没有产生任何额外的信息 .

显然我做错了什么,但我不清楚它是什么 . 如果需要更多信息,请告诉我 .