Get all categories

getall-category.go

//GetAllCategory : Get all Categories from DB
func (c Category) GetAllCategory() ([]*models.Category, error) {
	var categories []*models.Category // this will hold final result
  //execute the query
	rows, err := client.DbClient.Query("SELECT * from category")
	defer rows.Close()
	// iterate through rows
	for rows.Next() {
		// Bind to model
		err = rows.Scan(&c.ID, &c.CategoryName)
		// type cast to models.Category
		cm := models.Category(c)
		//add to result
		categories = append(categories, &cm)
		if err != nil {
			return nil, err
		}

	}
	// handle any errors that are encountered during iteration
	err = rows.Err()
	if err != nil {
		return nil, err
	}
	return categories, nil
}