I want to ignore a field, but I need to join to query the field. What should I do?

[hinet]

type Article struct {
    Id         int64 `db:"id, primarykey, autoincrement"`
    Title      string
    CategoryName   string `db:"-" json:"category_name"`
    CategoryId int64  `db:"category_id" json:"category_id"`
}

type Category struct{
    Id         int64 `db:"id, primarykey, autoincrement"`
    Name string
}

var list []Article
_,err := Dbm.Select(&list,"select a.*,c.name CategoryName from Article a,Category c where a.category_id = c.id")

I want to ignore a field, but I need to join to query the field. What should I do?

[hinet]

error:

query article error%!(EXTRA *gorp.NoFieldInTypeError=gorp: no fields [category] in type Article)

[nelsam]

For anyone who comes across this: I showed something of a workaround in gitter; I'll see if I can find time to work on a real solution, as well. However, since I rarely have time to work on gorp these days, it's highly encouraged that anyone who has an idea propose a solution in a PR.

[hinet]

thanks,I'll paste your reply from gitter here for others to refer to..

type Article struct {
     ID         int64 `db:"id, primarykey, autoincrement"` // ID, not Id; read Effective Go for reasoning
    Title      string
    CategoryID `db:"category_id" json:"-"`
    Category Category `db:"-" json:"category"`
}

type Category struct{
    ID         int64 `db:"id, primarykey, autoincrement"`
    Name string
}

// Note: *never* use 'select *' in code.  It makes your code less forward-compatible, which causes
// a huge mess of issues when you start needing to do rolling deploys.  Among other things.
rows, err := Dbm.Query("SELECT a.id, a.title, a.category_id, c.id, c.name FROM Article AS a INNER JOIN Category AS c ON a.category_id = c.id")
if err != nil {
    // handle err
}
for rows.Next() {
    var (
        article Article
        cat Category
    )
    rows.Scan(&a.ID, &a.Title, &a.CategoryID, &c.ID, &c.Name)
    // do what you need to with the article and category
}
if err := rows.Err(); err != nil {
    // handle err
}