Skip to content

Recipe Attributes

saxon-s edited this page Feb 7, 2019 · 2 revisions

Gourmet recipes have the following attributes:

> Column Format What it is Notes title text The title instructions text (with xml formatting markup) The instructions. modifications text (with xml formatting markup) "notes" field in interface source text the author or source of the recipe link text ( a url) a link to a webpage associated with the recipe preptime int The time it takes to prepare the recipe (stored in seconds) In the importer, you can use text here and Gourmet will try to convert from HH:MM:SS cooktime int The time it takes to cook the recipe (total) (stored in seconds) See preptime servings float The number of people the recipe is designed to serve This may be replaced in the future with two columns for "yield" and "yield unit". If it is, all current columns would be converted (we'd simply set yield_unit to servings. FIELDS YOU PROBABLY SHOULDN'T MESS WITH image binary An image of the recipe basically, this is a jpeg file stored internally. thumb binary the thumbnail of the recipe image see image deleted bool if True, the recipe is in the "Trash" last_modified int a timestamp FIELDS YOU DEFINITELY SHOULDN'T MESS WITH id int The unique identifier for the recipe recipe_hash VARCHAR(32) A hash for uniquely identifying the recipe information ingredient_hash VARCHAR(32) A hash for uniquely identifying the ingredient information last_modified FIELDS DEFINED BUT NEVER USED

|| description || text || || Presumably I had originally thought we might want the interface to show an overall "description" of the recipe in addition to the instructions and the notes. Seems like a good idea, but not yet implemented. ||

Clone this wiki locally