GORMでモデルのstructをwhereに使うと動かない

Problem

I defined model like below:

type Hostname struct {
	ID       uint    `gorm:"primaryKey"`
	IP       string  `gorm:"type:string;index:ip_uq,unique;"`
	Hostname *string `gorm:"type:string;"`
	ErrorFlg bool    `gorm:"type:bool;default:false;"`
}

And I’d like to perform like below:

SELECT * FROM `hostnames` WHERE hostname is null and error_flg = false LIMIT 10

I tried with db.Where(&models.Hostname{Hostname: nil, ErrorFlg: false}).Find(&hostnames), then got message which represented raw SQL without “where” a log below:

[11.348ms] [rows:78] SELECT * FROM `hostnames`

Solution

No use model struct in “Where”. db.Where("hostname is null and error_flg = ?", false).Limit(10).Find(&hostnames)

References

(TIL) Don’t use struct in GORM while building “where” clause | by Michał Kutrzeba | Medium