SQL's IN query in Golang

go-sql-in-query.go

func updateAll(ids []string) {
	var params []string
	var values []interface{}
	for k, v := range ids {
		params = append(params, fmt.Sprintf("$%d", k+1))
		values = append(values, v)
	}
	db := viper.Get("db").(*gorp.DbMap)
	sql := "UPDATE stores SET active = false WHERE id IN (" + strings.Join(params, ",") + ")"
	rs, err := db.Exec(sql, values...)
	if err != nil {
		panic(err)
	}
	rows, err := rs.RowsAffected()
	if err != nil {
		panic(err)
	}
  fmt.Printf("%d rows updated.\n", rows)
}