Rows Scan Gorm

rowscan.go

func (repo QuoteRepo) FindUserFavorites(userID int) ([]domain.Quote, error) {
	query := `SELECT q.id, q.body, q.author, q.quote_source FROM quotes q
	JOIN userfavoritesquotes on (q.id = userfavoritesquotes.quote_id)
	JOIN users ON (users.id = userfavoritesquotes.user_id)
	WHERE users.id = @userID`

	rows, err := repo.DB.Debug().Raw(query, sql.Named("userID", userID)).Rows()
	if err != nil {
		return nil, err
	}
	defer rows.Close()

	var quotes []domain.Quote

	for rows.Next() {
		var quote domain.Quote
		if err := rows.Scan(&quote.ID, &quote.Body, &quote.Author, &quote.QuoteSource); err != nil {
			return quotes, err
		}
		quotes = append(quotes, quote)
	}
	if err = rows.Err(); err != nil {
		return nil, err
	}

	return quotes, nil
}