rgstephens/exportPepper.sh

## 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