Add a real and efficient logging system to debug easily.
It should :

• Display hour and date for every logging line
• Be displayed directly on terminal or in a file -> user choice
• Have several logging levels (info, debug, warning, error)
• Use color on command line according line to logging level

Recipe ingredients are currently not checked when a recipe is added to the database.
It should be better if recipe adding is canceled if recipe ingredients are missing in the database.

The way of handling dependencies on this project is deprecated and we must update it by using Poetry.

Setup the Django Basic Stuff on the project in an objective to add web pages in the next steps.

Unit test creation for every function of the project.

Add CI to the project with unit tests running and coverage measure

It will be a good thing if dataclass objects (Ingredient, Recipe, ShoppingList, etc) could inherit excel functionnalities.

It will be great to add some functional tests to the project in addition to unit tests.

The project will be transformed as a web application to used it more easily.

It will be implemented with Django and will be accessible on www.list_generation.ez-courses.fr.

File paths are not currently well handled on the project. It become necessary to handle them better.
-> maybe use Pathlib module

It could be great if there is some auto completion when using command line

Create and use dedicated exceptions to handle some behaviors instead of default Exception.
Example :

• RecipeNotFoundException
• IngredientNotFoundException

Constants are currently declared without hierarchy in a python file. It should be handled properly by using groups.

It could be cool to generate all database and excel files based on some config files.
It will avoid to rewrite every files related to unit tests at every changes.
The generation process will be added to the tox environment generation.

Improve the quantity of unit tests by expanding the testing range.
So, basically, it necessitate to add data to test more cases.

Add a configuration file which contains :

• Database info

Ingredients and recipes information are currently handled as dictionaries.
It will be better to use dataclass for this type of information.

CI Tests are not passing.
It must be fix.

Improve CI by adding coverage, mypy and flake8 to automatic tests.

The idea is to sort shopping elements in 3 categories :

• frozen food
• market (fruits and vegetables mostly)
• supermarket

It will permit to generate one shopping list per category

Shopping lists are currently generated where the command is executed.
It should be generated in a folder shopping_lists which would be searched at the first place and then, be created if it's not found.
The location should also be configurable via the config file config.ini