fjborquez / aang

0 stars 0 forks source link

[Update] nutritional profiles creation #98

Closed Norbbs closed 1 month ago

Norbbs commented 2 months ago

As a Data Owner I want to some changes in the nutritional profiles creation process So that the model will be better for get outcomes for our recommendations

Scope

  1. Modify nutritional_profiles table
    1. Delete nutritional_restriction_id from the table nutritional_profiles
    2. Add product_category_id (this will be use for consuming data from zuko microservice)
    3. Add consumption_level_id (foreign key to consumption_levels table)
Result: Property Key Type Nullable Limit Example
person_id FOREIGN INTEGER NOT NULL persons 1
product_category_id ZUKO_MS INTEGER NOT NULL product_categories 2
product_category_name ZUKO_MS TEXT NOT NULL 30 Lácteos
consumption_level_id FOREIGN INTEGER NOT NULL consumption_levels 4
  1. Create endpoints for user profile registration

    • Modify the endpoint for creation nutritional profile
  2. Implement get product categories api integration fromZUKO Microservice

Out of scope

  1. update, delete and other non-creation processes.

Acceptance Criteria

AC GIVEN WHEN THEN
  • - [ ]
1 Register a nutritional profile successfully person_id, product_category_id and consumption_level_id correct nutritional profile creation process is triggered the information will be saved successfully in the nutritional_profiles table
  • - [ ]
2 Don't register a nutritional profile because of lack of person_id data person_id is missing (null or empty) nutritional profile creation process is triggered an error message user information is required will be generated and the data won't be saved successfully
  • - [ ]
3 Don't register a nutritional profile because of lack of product_category_id product_category_id is missing (null or empty) nutritional profile creation process is triggered an error messageproduct category information is required will be generated and the data won't be saved successfully
  • - [ ]
4 Don't register a nutritional profile because of product_category_id is incorrect or doesn't exist product_category_id is incorrect nutritional profile creation process is triggered an error message product category information is incorrect or doesn't exist will be generated and the data won't be saved successfully
  • - [ ]
5 Don't register a nutritional profile because of zuko microservice integration fail product_category_id is incorrect because of zuko microservice failed nutritional profile creation process is triggered an error message product category information could not be provided will be generated and the data won't be saved successfully.
  • - [ ]
6 Don't register a nutritional profile because of lack of consumption_level_id consumption_level_id is missing (null or empty) nutritional profile creation process is triggered an error messageconsumption level information is required will be generated and the data won't be saved successfully
  • - [ ]
7 Don't register a nutritional profile because of consumption_level_id is incorrect or doesn't exist consumption_level_id is incorrect nutritional profile creation process is triggered an error message consumption level information is incorrect or doesn't exist will be generated and the data won't be saved successfully