Hi! I gave it a shot to create a endpoint to offer more flexible response.

Changes:

• Add /recipes/ endpoint to get multiple recipes.
• Query parameter (limit, offset) allows to vary how many recipes to be returned and skip rows in DB.

Sample request:

import requests
r = requests.get("http://localhost:8000/recipes/?limit=2&offset=5")
data = r.json()

Sample response:

{
    "status": 200,
    "results": [
        {
            "id": 14,
            "name": "Pumpernickel Bread II Recipe",
            "total_duration": 60,
            "ingredients": [
                "brown sugar",
                "cocoa powder",
                "salt",
                "cornmeal",
                "milk",
                "flour",
                "molasses",
                "bread",
                "yeast",
                "vegetable oil"
            ],
            "directions": "Mix well bread flour, rye flour, cornmeal, salt, yeast, cocoa, and brown sugar. Add milk, oil, and molasses. Mix thoroughly. When mixed well enough that the dough holds together, knead by hand 15-20 minutes.Cover, let rise in bowl 30 minutes. Punch down, form, and place into 9 1/2x5 inch pan. Cover with damp cloth and let rise about 1 hour.Bake in preheated 375 degree F (190 degrees C) oven 25 to 30 minutes, covering top with aluminum foil last 10 minutes."
        },
        {
            "id": 18,
            "name": "Light Oat Bread Recipe",
            "total_duration": 180,
            "ingredients": [
                "brown sugar",
                "water",
                "salt",
                "flour",
                "margarine",
                "oat",
                "yeast"
            ],
            "directions": "Add ingredients to bread machine pan in order recommended by your manufacturer. Use regular light setting."
        }
    ]
}

Hi there!

I came across this repository when I was looking for OSS I can contribute. While I l am playing with the app, I realized it would be helpful for new coder like me if there is how to run locally in README.md.

I am quite new to Github. Please feel free to suggest me if there is any area does not make sense!

Updates:

README: Add markdown syntax highlighting to README. Update response example in README.

RESPONSE: Normalize titles to remove extra quotes and trailing spaces. Return ingredients as list rather than string representation of a list to make it easier to manipulate. See #5 Return status code in JSON response now. Update JSON response key names to lowercase and changed "Cook Time (Minutes)" to "total_duration" for simpler manipulation. Add pydantic models for FastAPI openapi docs and response.

FEATURES: Path param to fetch recipe by id.

DATABASE: Rename "Unnamed: 0" column in sqlite database to id for easier querying.

Hey there, awesome API, I read about it on reddit and came here, When I use the Ingredients get method to fetch ingredients, it returns it as a string

Would be awesome if you parsed it as a list, I had to use regex to solve the problem, thanks!

Well done. I am looking forward that you will add more recipes. If you turn it on to an flask application (website using flask python library) it will be supercool. If any user comes to your website, you show the list of recipes from your api and they can select the recipe and you show all other things by fetching from your api. Well done

Hi there! I would think that reloading could yield more comfortable development experience for coders. Please let me know if you have any comment on this!

Fixed the problem with json rendering in readme. JSON syntax does not allow multiline strings with line-breaks. Github was highlighting this as an issue. Solved by trimming the response string.

• noticed each entry in items is duplicated 8X ( original entry + 8 copies)
• removed 11977 duplicate entries in items table from recipes.db
• final row count for items table is 1487

Hi, I've noticed this SQL SELECT * FROM items ORDER BY RANDOM() LIMIT 1 in your database.

What it does, as far as I know, is it orders WHOLE database in some random way, then selects first element. This is really slow way of fetching one random row.

Faster way of doing this is generating random number (between 0 and table size) and then doing something like SELECT * FROM items WHERE ID = <generated number>". (It seems you don't have ID column, but column Unnamed: 0 looks like ID-like column, so making it primary key is a good idea)