/db-recipe-book

Migrating and Seeding a Database

Primary LanguageJavaScript

Recipe Book

Topics

  • database modeling.
  • migration scripts.
  • seeding.
  • knex.

Assignment

Design the data model for a recipe book application, then use Knex migrations and seeding functionality to build a SQLite3 database based on the model and seed it with test data.

The requirements for the system, as stated by the client are:

  • have a way to manage dishes. A dish is something the client wants to cook like pizza or tacos.
  • have a way to manage recipes. A dish can have different recipes for tacos, like tex-mex or granny's. A recipe belongs only to one dish.
  • have a way to manage ingredients.
  • a recipe could have more than one ingredient and the same ingredient can be used in multiple recipes. Examples are "cup of corn flour" or "gram of butter".
  • when saving the ingredients for a recipe capture the quantity required for that ingredient as a floating number.
  • have a way to save instructions for cooking a recipe. Instructions will be a series of steps involved in cooking a recipe.
  • for some recipes, the order in which the steps are performed matters, please provide a way to specify that order.
  • have a way to pick a dish and a recipe and get a shopping list with all the ingredients, and quantity of each, needed to cook the dish.

In addition to the migration and seed scripts write a data access library that publishes the following API:

  • getDishes(): should return a list of all dishes in the database.
  • addDish(dish): should add the dish to the database and return the id of the new dish.
  • getDish(id): should return the dish with the provided id and include a list of the related recipes.
  • getRecipes(): should return a list of all recipes in the database including the dish they belong to.
  • addRecipe(recipe): should add a recipe to the database and return the id of the new recipe.

Stretch Problems

  • add a method called getRecipe(id) to your data access library that should return the recipe with the provided id. The recipe should include:
    • name of the dish.
    • name of the recipe.
    • the list of ingredients with the quantity.
    • the list of steps in the order they need to be executed.
  • follow the same pattern to add the CRUD operations for other entities in the system.
  • add units of measure support for the ingredients.
  • add a table of unit of measure convertions, so that we can record the quantity for an ingredient using a unit of measure and see the values for other units reading the recipe.