From 9e81f2af7f4c0130217658c4c2fc73f8a933e183 Mon Sep 17 00:00:00 2001 From: Tucker Evans Date: Tue, 12 Nov 2019 09:51:17 -0500 Subject: Add id to ingredients so we can delete unused on update When updating ingredients if some # are remove we need to remove the same number from the database and update the rest, without an id column we don't know which ones to delete. --- backend/recipe.go | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/backend/recipe.go b/backend/recipe.go index fc34ba7..ab1b631 100644 --- a/backend/recipe.go +++ b/backend/recipe.go @@ -100,6 +100,7 @@ func RecipeFromId(id int, db *sql.DB) *Recipe { id) defer rows_ingr.Close() if err == nil { + var i int for rows_ingr.Next() { rows_ingr.Scan(&name, &amount, &unit) ingr = Ingredient{ @@ -164,8 +165,9 @@ func AddRecipeDB(r *Recipe, db *sql.DB) error { for i, ingr := range r.Ingredients { res, err := db.Exec(`INSERT INTO ingredients - (name, amount, unit, recipe_id) - VALUES ($1, $2, $3, $4)`, + (id, name, amount, unit, recipe_id) + VALUES ($1, $2, $3, $4, $5)`, + i, ingr.Name, ingr.Amount, ingr.Unit, -- cgit v1.1