Fetching new Entities

Learn how to fetch data from the database using the exposed library.

We'll cover the following...

Following the REST practices, the URL for fetching all cats should be /cats, while for fetching a single cat, it should be /cats/123, where 123 is the ID of the cat we are trying to fetch all the rows from the table for. Then, we map each row to our data class.

Adding new routes to the App.kt file:

Let’s add two new routes for that in the App.kt:

get("/cats") {
   ...
}
get("/cats/{id}") {
   ...
}

The first route is very similar to the /status ...