rgstephens · November 6, 2016 22:11 · MrRobotMan · Oct 1, 2019 · bjb1959 · Oct 9, 2019
diff --git a/exportPepper.sh b/exportPepper.sh
 #!/bin/sh

 ids=`sqlite3 ./recipes_2.db <<!
 .mode csv
 select Id from Recipe;
 !`

 dumprecipe() {
 sqlite3 ./recipes_2.db <<!
 .separator ' '
 select '- name: ', Title from Recipe where Id = $1;
 select '  servings: ', Yield from Recipe where Id = $1;
 select '  source: ', Source from Recipe where Id = $1;
 select '  description: ', Description from Recipe where Id = $1;
 select '  prep_time: ', ActiveTime from Recipe where Id = $1;
 select '  cook_time: ', TotalTime from Recipe where Id = $1;
 select '  notes: ', Note from Recipe where Id = $1;
 !
 sqlite3 ./recipes_2.db <<!
 .separator ' '
 select 'categories: [', Tag.Text, ']' from ItemTag join Tag on Tag.Id = ItemTag.TagId where ItemTag.RecipeId = $1;
 !
 echo '  ingredients: |'
 sqlite3 ./recipes_2.db <<!
 .separator ' '
 select '   ', IngredientGroup.Title, Ingredient.Quantity, Ingredient.Text from IngredientGroup join Ingredient on Ingredient.GroupId = IngredientGroup.Id where IngredientGroup.RecipeId = $1 order by IngredientGroup.DisplayOrder, Ingredient.DisplayOrder;
 !
 echo '  directions: |'
 sqlite3 ./recipes_2.db <<!
 .separator ' '
 select '   ', DirectionGroup.Title, Direction.Text from DirectionGroup join Direction on Direction.GroupId = DirectionGroup.Id where DirectionGroup.RecipeId = $1 order by DirectionGroup.DisplayOrder, Direction.DisplayOrder;
 !
 }

 #for id in $ids
 for id in 483 1 435
 do
    dumprecipe $id
    echo
 done
	#!/bin/sh

	ids=`sqlite3 ./recipes_2.db <<!
	.mode csv
	select Id from Recipe;
	!`

	dumprecipe() {
	sqlite3 ./recipes_2.db <<!
	.separator ' '
	select '- name: ', Title from Recipe where Id = $1;
	select ' servings: ', Yield from Recipe where Id = $1;
	select ' source: ', Source from Recipe where Id = $1;
	select ' description: ', Description from Recipe where Id = $1;
	select ' prep_time: ', ActiveTime from Recipe where Id = $1;
	select ' cook_time: ', TotalTime from Recipe where Id = $1;
	select ' notes: ', Note from Recipe where Id = $1;
	!
	sqlite3 ./recipes_2.db <<!
	.separator ' '
	select 'categories: [', Tag.Text, ']' from ItemTag join Tag on Tag.Id = ItemTag.TagId where ItemTag.RecipeId = $1;
	!
	echo ' ingredients: \|'
	sqlite3 ./recipes_2.db <<!
	.separator ' '
	select ' ', IngredientGroup.Title, Ingredient.Quantity, Ingredient.Text from IngredientGroup join Ingredient on Ingredient.GroupId = IngredientGroup.Id where IngredientGroup.RecipeId = $1 order by IngredientGroup.DisplayOrder, Ingredient.DisplayOrder;
	!
	echo ' directions: \|'
	sqlite3 ./recipes_2.db <<!
	.separator ' '
	select ' ', DirectionGroup.Title, Direction.Text from DirectionGroup join Direction on Direction.GroupId = DirectionGroup.Id where DirectionGroup.RecipeId = $1 order by DirectionGroup.DisplayOrder, Direction.DisplayOrder;
	!
	}

	#for id in $ids
	for id in 483 1 435
	do
	dumprecipe $id
	echo
	done