- Build an API to handle GET requests.
- Application Programming Interface (API): a software application that allows two or more software applications to communicate with one another. Can be standalone or incorporated into a larger product.
- HTTP Request Method: assets of HTTP requests that tell the server which actions the client is attempting to perform on the located resource.
GET: the most common HTTP request method. Signifies that the client is attempting to view the located resource.POST: the second most common HTTP request method. Signifies that the client is attempting to submit a form to create a new resource.PATCH: an HTTP request method that signifies that the client is attempting to update a resource with new information.DELETE: an HTTP request method that signifies that the client is attempting to delete a resource.
This is a test-driven lab. Run pipenv install to create your virtual
environment and pipenv shell to enter the virtual environment. Then run
pytest -x to run your tests. Use these instructions and pytest's error
messages to complete your work in the server/ folder. Remember to set up your
environment in the server/ folder as well:
$ export FLASK_APP=app.py
$ export FLASK_RUN_PORT=5555In this application, we'll be working on a JSON API to get a list of bakeries and their baked goods. We have two models, bakeries and baked goods, in a one-to-many relationship. The migrations are already set up. Here's what the ERD for these tables looks like:
You can run the app and explore your API in the browser by using Flask command:
$ flask run- Update the
BakeryandBakedGoodmodels to set up the correct associations based on the structure of the tables. Use therelationship()SQLAlchemy method and SQLAlchemy-serializer'sSerializerMixinclass. flask db inithas already been run. You will need to direct your Flask app to a database atapp.db, create models, run a migration withflask db revision --autogenerate -m'<your message>'and create the database file withflask db upgrade.- You should fill your database with the script in
server/seed.py. (Though you can certainly write your own if you'd prefer!) GET /bakeries: returns an array of JSON objects for all bakeries in the database.GET /bakeries/<int:id>: returns a single bakery as JSON with its baked goods nested in an array. Use theidfrom the URL to look up the correct bakery.GET /baked_goods/by_price: returns an array of baked goods as JSON, sorted by price in descending order. (HINT: how can you use SQLAlchemy to sort the baked goods in a particular order?)GET /baked_goods/most_expensive: returns the single most expensive baked good as JSON. (HINT: how can you use SQLAlchemy to sort the baked goods in a particular order and limit the number of results?)
Once all of your tests are passing, commit and push your work using git to
submit.
[
{
"baked_goods": [
{
"bakery_id": 1,
"created_at": "2022-09-12 21:01:00",
"id": 8,
"name": "Veronica",
"price": 7,
"updated_at": null
},
{
"bakery_id": 1,
"created_at": "2022-09-12 21:01:00",
"id": 15,
"name": "Sean",
"price": 9,
"updated_at": null
},
{
"bakery_id": 1,
"created_at": "2022-09-12 21:01:00",
"id": 25,
"name": "Robin",
"price": 3,
"updated_at": null
},
{
"bakery_id": 1,
"created_at": "2022-09-12 21:01:00",
"id": 27,
"name": "Derek",
"price": 7,
"updated_at": null
},
{
"bakery_id": 1,
"created_at": "2022-09-12 21:01:00",
"id": 105,
"name": "Holly",
"price": 10,
"updated_at": null
},
{
"bakery_id": 1,
"created_at": "2022-09-12 21:01:00",
"id": 173,
"name": "Maureen",
"price": 8,
"updated_at": null
},
{
"bakery_id": 1,
"created_at": "2022-09-12 21:01:00",
"id": 187,
"name": "Jennifer",
"price": 5,
"updated_at": null
}
],
"created_at": "2022-09-12 21:01:00",
"id": 1,
"name": "Jones-Erickson",
"updated_at": null
},
{
"baked_goods": [
{
"bakery_id": 2,
"created_at": "2022-09-12 21:01:00",
"id": 76,
"name": "Samantha",
"price": 7,
"updated_at": null
},
{
"bakery_id": 2,
"created_at": "2022-09-12 21:01:00",
"id": 95,
"name": "Jeffrey",
"price": 5,
"updated_at": null
},
{
"bakery_id": 2,
"created_at": "2022-09-12 21:01:00",
"id": 125,
"name": "Pamela",
"price": 5,
"updated_at": null
},
{
"bakery_id": 2,
"created_at": "2022-09-12 21:01:00",
"id": 149,
"name": "Brandy",
"price": 7,
"updated_at": null
},
{
"bakery_id": 2,
"created_at": "2022-09-12 21:01:00",
"id": 175,
"name": "Kendra",
"price": 8,
"updated_at": null
}
],
"created_at": "2022-09-12 21:01:00",
"id": 2,
"name": "Cook-Cunningham",
"updated_at": null
},
// ...
]{
"baked_goods": [
{
"bakery_id": 2,
"created_at": "2022-09-12 21:01:00",
"id": 76,
"name": "Samantha",
"price": 7,
"updated_at": null
},
{
"bakery_id": 2,
"created_at": "2022-09-12 21:01:00",
"id": 95,
"name": "Jeffrey",
"price": 5,
"updated_at": null
},
{
"bakery_id": 2,
"created_at": "2022-09-12 21:01:00",
"id": 125,
"name": "Pamela",
"price": 5,
"updated_at": null
},
{
"bakery_id": 2,
"created_at": "2022-09-12 21:01:00",
"id": 149,
"name": "Brandy",
"price": 7,
"updated_at": null
},
{
"bakery_id": 2,
"created_at": "2022-09-12 21:01:00",
"id": 175,
"name": "Kendra",
"price": 8,
"updated_at": null
}
],
"created_at": "2022-09-12 21:01:00",
"id": 2,
"name": "Cook-Cunningham",
"updated_at": null
}[
{
"bakery": {
"created_at": "2022-09-12 21:15:43",
"id": 3,
"name": "Schneider Ltd",
"updated_at": null
},
"bakery_id": 3,
"created_at": "2022-09-12 21:15:43",
"id": 11,
"name": "Antonio",
"price": 1,
"updated_at": null
},
{
"bakery": {
"created_at": "2022-09-12 21:15:43",
"id": 4,
"name": "Ingram, Griffith and Morris",
"updated_at": null
},
"bakery_id": 4,
"created_at": "2022-09-12 21:15:43",
"id": 15,
"name": "Drew",
"price": 1,
"updated_at": null
},
// ...
]{
"bakery": {
"created_at": "2022-09-12 21:15:43",
"id": 11,
"name": "Hodge-Stuart",
"updated_at": null
},
"bakery_id": 11,
"created_at": "2022-09-12 21:15:43",
"id": 91,
"name": "Jessica",
"price": 100,
"updated_at": "2022-09-12 21:15:43"
}
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent