Select models by array of ids

[satanworker]

func (u *BalanceRepository) GetBalancesByIds(tx *db.Tx, ids []int32) ([]BalanceModel, error) {
	stmt := Balance.
		SELECT(Balance.AllColumns).
		WHERE(
			Balance.ID.IN(
				Int32(ids),
			),
		)
	var balances []BalanceModel
	err := stmt.Query(tx, &balances)
	return balances, err

}

I'm trying to select rows with a list of ids, but can't find proper type to do it and nowhere find any examples

[satanworker]

This seems to be working fine, but not sure if that's a proper way

func (u *BalanceRepository) GetBalancesByIds(tx *db.Tx, ids []int32) ([]BalanceModel, error) {
	intIds := make([]Expression, len(ids))
	// TODO: not sure if that works
	for i, id := range ids {
		intIds[i] = Int32(id)
	}
	stmt := Balance.
		SELECT(Balance.AllColumns).
		WHERE(
			Balance.ID.IN(intIds...),
		)

	var balances []BalanceModel
	err := stmt.Query(tx, &balances)
	return balances, err
}

[houtn11]

Yeah, that's the proper way. Also, check - https://github.com/go-jet/jet/wiki/FAQ#how-to-use-innot_in-with-dynamic-list-of-values.