Create a new category and return an id

create-category-with-id.go

//CreateCategory : create a new Category in DB
func (c *Category) CreateCategory() (int, error) {
	//Create and execute the query
	row := client.DbClient.QueryRow("INSERT INTO category (category_name) values ($1) RETURNING id;", c.CategoryName)
	// save the data in an object
	switch err := row.Scan(&c.ID); err {
	// success, no errors
	case nil:
		return c.ID, nil
	// In case of no output rows
	case sql.ErrNoRows:
		return c.ID, errors.New("Insert Failed")
	// other errors occured
	default:
		return c.ID, err
	}

}