crud_list_function.go

// List lists data and paging the result
func (crud *CRUD) List(pageID, perPage int64) ([]interface{}, error) {
	offset := (pageID - 1) * perPage
	rows, err := crud.Config.DB.Queryx(crud.Config.sqlCRUDList, offset, perPage)
	if err != nil {
		return nil, errors.Wrap(err, "error crud list")
	}
	defer rows.Close()

	result := []interface{}{}
	for rows.Next() {
		obj := crud.Config.Object.Get()
		err = rows.StructScan(obj)
		if err != nil {
			return nil, errors.Wrap(err, "error crud scan")
		}
		re, err := buildListOfFields(obj, crud.Config.listedFields)
		if err != nil {
			return nil, errors.Wrap(err, "error build list of fields")
		}
		result = append(result, re)
	}
	err = rows.Err()
	if err != nil {
		return nil, errors.Wrap(err, "error crud loop rows list")
	}
	return result, nil
}