simplebank
simplebank copied to clipboard
help:How can this SQL statement be changed to an SQLC statement?
if len(roleApis) > 0 {
db := db.Orm.Debug().Model(&models.Api{}).
Select("system_api.id").
Joins("left join system_menu_api on system_menu_api.api = system_api.id")
for _, p := range roleApis {
db = db.Or("system_api.url = ? and system_api.method = ?", p[1], p[2])
}
err = db.Where("system_menu_api.menu = ?", menuId).Pluck("system_api.id", &apis).Error
if err != nil {
response.Error(c, err, response.GetApiError)
return
}
}
Hi, i think if you can translate it into a raw SQL query, you can feed it to sqlc.