Create a recipe with ingredients

[Norbbs]

As a User
I want to create and save a recipe with ingredients
So that I can easily access and prepare my favorite dishes with more information

Definition Of Ready (DoR)

	Definition	Observations
	The story meet the INVEST and SMART criteria
	Dependencies identified and resolved
	Written acceptance criteria with test scenarios, understood by the team and agreed upon
	The user story was understood and agreed upon in a refinement session with the dev team
	The team has an idea of how to make the demonstration of the finished story

Scope

1. Create data in the entity Recipe_Ingredients:

Property	Key	Type	Nullable	Limit	Example
id	PRIMARY	INTEGER	NOT NULL	AUTO INCREMENT	1
recipe_id	FOREIGN	INTEGER	NOT NULL	3	1
quantity		DECIMAL(10, 2)	NOT NULL	99999999.99	100.00
uom_id	FOREIGN	INTEGER	NOT NULL	unit_of_measurement	1
comment_id	FOREIGN	INTEGER		ingredient_comments	2

2. Create data in the entity ingredient_comments:

Property	Key	Type	Nullable	Limit	Example
id	PRIMARY	INTEGER	NOT NULL	AUTO INCREMENT	1
description	UNIQUE	TEXT	NOT NULL	30	a temperatura ambiente

Out of scope

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

Wireframes

Acceptance Criteria

Keep it in mind the same AC for the recipe creation process

		AC	GIVEN	WHEN	THEN
	1	Create a recipe with a ingredient successfully	a recipe with correct data and an ingredient with quantity greater than zero, mass or volume unit and a product	the recipe and ingredient creation processes are triggered	the recipe will be created in the table recipes AND the ingredient will be created in the table ingredients with the recipe_id linked to the recipe that has just been created.
	2	Don't create a recipe with ingredients because of lack of product, quantity or uom	a recipe WITHOUT product	the recipe and ingredient creation processes are triggered	the recipe WON'T be created in the table recipes NOR will be created in table ingredients.
	3	Don't create a recipe because of quantity is less than or equal to zero	a recipe with one or more ingredients, an quantity is less than or equal to zero	the recipe an ingredient creation processes are triggered	the recipe WON'T be created in the table recipes NOR will be created in table ingredients.
	4	Don't create a recipe because of uom is not a mass or volume unit	a recipe with one or more ingredients with uom which is not a mass or volume unit	the recipe an ingredient creation processes are triggered	the recipe WON'T be created in the table recipes NOR will be created in table ingredients.
	5	Don't create a recipe because of data duplication	a recipe with ingredients and our database has one ingredient with the SAME product and the SAME comment	the recipe an ingredient creation processes are triggered	the recipe WON'T be created in the table recipes NOR will be created in table ingredients.
	6	Create a recipe with ingredients correctly with comments	a recipe with ingredients and comments correctly	the recipe an ingredient creation processes are triggered	the recipe will be created in the table recipes AND if the comment EXISTS in the description column of the table recipe_comments, get the comment ID, set to comment_id of the entity ingredients AND an ingredient entity with comment_id will be created in table ingredients ELSE a new entity comment will be created in the table recipe_comments, then get the comment ID, set to comment_id of the entity ingredients AND an ingredient entity with comment_id will be created in table ingredients .

Definition of Done (DoD)

	Definition	Result
	All acceptance criteria have been met
	No significant or critical defects
	Deskcheck ceremony has been made
	Keep minimum test coverage of 80% over the necessary code and components
	Technical documentation published
	Spike, PoC or benchmarks findings documented