Scan into a map.

[CmpHDL]

Occasionally, I'll use a 3rd party API call that returns a slice of X.
Usually I'll double store these in our database so users can soft-delete etc.
Thus to filter, I have to fetch all X from the 3rd party API then iterate through and check if its in the slice returned from our database.

It is possible to instead scan into a map so as I iterate, rather than iterate through the entire slice, I can just match the primary key to the struct?

Ideally we could scan into some sort of map[PrimaryKeyType]dest instead of []dest .

[Right now I technically do the opposite, converting the 3rd party api into a map by looping, then loop through db records matching the primary key and creating a new slice. But I can see this being useful for other things involving mapping in general.]

[go-jet]

This should be already possible using Rows method. For instance:

stmt := SELECT(
	Rental.AllColumns,
).FROM(
	Rental,
)

rows, err := stmt.Rows(context.Background(), db)

var result = make(map[int32]model.Rental)

for rows.Next() {
	var rental model.Rental

	err := rows.Scan(&rental)

	result[rental.RentalID] = rental
}