自定义Gorm预加载不会获取数据 [英] Custom Gorm preloading does not fetch data

问题描述

我有一个查询，该查询从 jobs 表及其作者(每个作业都有一个 author )中提取行，但是我想选择特定的字段.

I have a query that fetches rows from jobs table and its author (each job has an author), but I want to select specific fields.

type User struct {
    ID         uint      `gorm:"primarykey" json:"-"`
    UUID       uuid.UUID `gorm:"type:uuid not null" json:"-"`
    Email      string    `gorm:"type:varchar(255); not null" json:"email"`
    Name       string    `gorm:"type:varchar(255); not null" json:"name"`
    AvatarURL  string    `gorm:"type:varchar(255); not null" json:"avatar_url"`
    Provider   string    `gorm:"type:varchar(255); not null" json:"provider"`
    ProviderID string    `gorm:"type:varchar(255); not null" json:"-"`
    Jobs       []Job     `json:"-"`
}

type Job struct {
    ID      uint   `gorm:"primarykey" json:"id"`
    Title   string `gorm:"type:varchar(255); not null" json:"title"`
    Content string `gorm:"not null" json:"content"`
    UserID  uint   `json:"-"`
    User    User   `json:"author"`
}

func (jobRepo repository) FindAll() ([]entity.Job, error) {
    var jobs []entity.Job

    if dbc := jobRepo.db.Preload("User", func(db *gorm.DB) *gorm.DB {
        return db.Select("Name", "Email")
    }).Find(&jobs); dbc.Error != nil {
        return nil, dbc.Error
    }

    return jobs, nil
}

自定义预加载行为不理想.如果我未指定具体字段，则查询有效并返回所有内容.否则，如果我指定了某些字段，则不返回任何内容.

The custom preload does not behave as desired. If I do not specify concrete fields, the query works and returns everything. Otherwise, If I specify some fields, it returns nothing.

推荐答案

这是因为您没有选择主键.添加"ID"进入select子句:

This is because you didn't select primary key. Add "ID" into select clause:

func(db *gorm.DB) *gorm.DB {
    return db.Select("ID", "Name", "Email")
}

否则，GORM不知道如何将用户加入工作.

Otherwise GORM doesn't know how to join users to jobs.

这篇关于自定义Gorm预加载不会获取数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！