Make addrecipe command add ingredients.

1 files changed, 6 insertions, 1 deletions

diff --git a/mat b/mat
index f5bcaa4..22b7cf5 100755
--- a/mat
+++ b/mat
@@ -295,13 +295,18 @@ sub cmd_addrecipe {
   $uri = <STDIN>;
   chomp $uri;
 
-  $sql = "INSERT INTO recipes (name, uri) VALUES ('$recipe_name', '$uri');";
+  $sql = "INSERT INTO recipes (name, uri) VALUES (".$db->quote($recipe_name).
+      ", ".$db->quote($uri).");";
   print "$sql\n\n";
   print "Add to database? (y/n): ";
   $answer = <STDIN>;
   if ($answer eq "y\n") {
     $db->do($sql);
   }
+
+  $sql = "SELECT id FROM recipes WHERE name='$recipe_name' AND uri='$uri';";
+  my @recipe_id = $db->selectrow_array($sql);
+  return interactive_edit_recipe_ingredients($recipe_id[0]);
 }
 
 # MAIN PROGRAM ################################################################