Skip to content

Instantly share code, notes, and snippets.

@rgstephens

rgstephens/exportPepper.sh

Created November 6, 2016 22:11
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save rgstephens/bd76d83510b772bacfa98e7d93746c5b to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save rgstephens/bd76d83510b772bacfa98e7d93746c5b to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. rgstephens created this gist Nov 6, 2016.
    40 changes: 40 additions & 0 deletions exportPepper.sh
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,40 @@
    #!/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