Gorm call Where() with foreignkey

Question

I have a gorm model:

type Order struct {
    ID             int    `json:"id" gorm:"column:id"`
    ProductID      int    `json:"product_id" gorm:"column:product_id"`
    Price int    `json:"per_credit_price" gorm:"column:per_credit_price"`

    Product Product `gorm:"foreignkey:ProductID;AssociationForeignKey:ID"`
}

And i`d like to write a query, like:

p.DB.Preload("Product").Where(ord).First(ord).Error

if my ord struct contains the Product as struct, it returns with the following error:

sql: converting argument $8 type: unsupported type models.Product, a struct

It would work find Find() instead of Where(), but I'd like to query for others than ID.

How could I make it work?

Daniel TAN Daniel TAN · Accepted Answer · 2020-07-31T06:48:46

use pointer of the struct to do the find

var ord Order 
p.DB.Preload("Product").Where(ord).First(&ord).Error

Gorm call Where() with foreignkey

1 Answers