Go-Gorm有一个孩子桌总是空的

Question

我试着用Golang开发Restfull，但是gorm关系有一个问题。

我是刚在戈朗和戈伦工作的，我遵循官方网站one.html的结构例子。

这里的代码片段：

type Server struct {
    DB *gorm.DB
    Router *mux.Router
}

type CreditCard struct {
    gorm.Model
    Number   string
    UserID   uint
}

type User struct {
    gorm.Model
    Name    string
    Card    CreditCard
}

func (u *User) FindUsersWithRelation(db *gorm.DB) (*[]User, error) {
    var err error
    users := []User{}
    err = db.Debug().Model(&User{}).Limit(100).Find(&users).Error
    if err != nil {
        return &[]User{}, err
    }
    return &users, err
}

/============
func (s *Server) GetUsersWithRelation(w http.ResponseWriter, r *http.Request) {
    user := models.User{}

    users, err := user.FindUsersWithRelation(s.DB)
    if err != nil {
        responses.ERROR(w, http.StatusInternalServerError, err)
        return
    }
    responses.JSON(w, http.StatusOK, users)
}

//============
func (s *Server) InitializeRoutes() {
    s.Router.HandleFunc("/test", middlewares.SetMiddlewareJSON(s.GetUsersWithRelation)).Methods("GET")
}

用户：

+----+---------------------+---------------------+------------+------+
| id | created_at          | updated_at          | deleted_at | name |
+----+---------------------+---------------------+------------+------+
|  1 | 2020-01-22 11:51:42 | 2020-01-22 11:51:42 | NULL       | John |
|  2 | 2020-01-22 11:51:43 | 2020-01-22 11:51:43 | NULL       | Ann  |
+----+---------------------+---------------------+------------+------+

credit_cards:

+----+---------------------+---------------------+------------+------------------+---------+
| id | created_at          | updated_at          | deleted_at | number           | user_id |
+----+---------------------+---------------------+------------+------------------+---------+
|  1 | 2020-01-22 11:51:42 | 2020-01-22 11:51:42 | NULL       | 123-456-90123    |       1 |
|  2 | 2020-01-22 11:51:43 | 2020-01-22 11:51:43 | NULL       | 098-765-432-1010 |       2 |
+----+---------------------+---------------------+------------+------------------+---------+

--这是从邮递员获得测试端点的结果

[
    {
        "ID": 1,
        "CreatedAt": "2020-01-22T11:51:42+07:00",
        "UpdatedAt": "2020-01-22T11:51:42+07:00",
        "DeletedAt": null,
        "Name": "John",
        "Card": {
            "ID": 0,
            "CreatedAt": "0001-01-01T00:00:00Z",
            "UpdatedAt": "0001-01-01T00:00:00Z",
            "DeletedAt": null,
            "Number": "",
            "UserID": 0
        }
    },
    {
        "ID": 2,
        "CreatedAt": "2020-01-22T11:51:43+07:00",
        "UpdatedAt": "2020-01-22T11:51:43+07:00",
        "DeletedAt": null,
        "Name": "Ann",
        "Card": {
            "ID": 0,
            "CreatedAt": "0001-01-01T00:00:00Z",
            "UpdatedAt": "0001-01-01T00:00:00Z",
            "DeletedAt": null,
            "Number": "",
            "UserID": 0
        }
    }
]

为什么卡总是在每个用户中为空

Answer 1

如果要获取相关内容，则需要使用预压：

db.Model(&User{}).Limit(100).Preload("CreditCards").Find(&users)

它是空的，因为您没有获取数据，默认情况下Go将使用结构的零值。