我正在使用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()中运行相同的东西,它没有产生任何额外的信息 .
显然我做错了什么,但我不清楚它是什么 . 如果需要更多信息,请告诉我 .