This lesson's interactive features are locked, please to keep using them

Get All Chirps

We need a way to retrieve all the chirps from the database. Later, we'll add sorting and filtering functionality, but you can think of this as a very basic version of an endpoint that might serve a timeline of chirps.

Assignment

Add a new query that retrieves all chirps in ascending order by created_at.
Add a GET /api/chirps endpoint that returns all chirps in the database. It should return them in the same structure as the POST /api/chirps endpoint, but as an array. Use a 200 status code for success.

[
  {
    "id": "94b7e44c-3604-42e3-bef7-ebfcc3efff8f",
    "createdAt": "2021-01-01T00:00:00Z",
    "updatedAt": "2021-01-01T00:00:00Z",
    "body": "Yo fam this feast is lit ong",
    "userId": "123e4567-e89b-12d3-a456-426614174000"
  },
  {
    "id": "f0f87ec2-a8b5-48cc-b66a-a85ce7c7b862",
    "createdAt": "2022-01-01T00:00:00Z",
    "updatedAt": "2023-01-01T00:00:00Z",
    "body": "What's good king?",
    "userId": "123e4567-e89b-12d3-a456-426614174000"
  }
]

Run and submit the CLI tests.