How to make the relationship?

[newerton]

Hello qiangxue, miss you on the Yii team.

I'm diversifying my portfolio, and improving my clients' APIs, I'm learning Go lang.

I followed several tutorials and blog about relationship, and I am 3 days without being able to make a BELONGS TO relationship.

What am I doing wrong, can you help me?

daos/product.go

func (dao *ProductDAO) Query(rs app.RequestScope, offset, limit int) ([]models.Product, error) {
    products := []models.Product{}
    err := rs.Tx().Select().
                    InnerJoin("establishment", dbx.NewExp("`product`.`establishment_id` = `establishment`.`id`")).
                    OrderBy("product.id").
                    Offset(int64(offset)).
                    Limit(int64(limit)).
                    All(&products)
    return products, err
}

models/product.go

type Product struct {
    Id int                                      `json:"id" db:"id"`
    Establishment       Establishment           `json:"establishment" db:"establishment"`
}

models/establishment.go

type Establishment struct {
    Id int                          `json:"id" db:"id"`
    Subtitle string                 `json:"subtitle" db:"subtitle"`
}