full-stack-fastapi-template icon indicating copy to clipboard operation
full-stack-fastapi-template copied to clipboard

Implement Paginated Database Query with Schema and Total Count

Open fredericogago opened this issue 2 years ago • 0 comments

Problem Statement: Currently, our application lacks the functionality to paginate database queries with skip and limit while also returning the schema of the queried table and the total count of records matching the query. This feature is essential for improving the user experience and providing a more comprehensive response to API clients.

The API response should include the following components:

Data: The paginated records based on the provided skip and limit parameters.
Schema: The schema or structure of the queried table to help clients understand the data.
Total Count: The total count of records that match the query, regardless of pagination.

fredericogago avatar Sep 01 '23 10:09 fredericogago