Add pagination to GET /api/items

[rak3rman]

Description

Add pagination to the GET /api/items route using limit and offset modifiers to the query: https://orm.drizzle.team/docs/select#limit--offset. Should accept a page query that defaults to 0 if omitted AND a size query that defaults to 25 if omitted. Ensure that both queries are validated properly using Zod.

Both attributes should be passed in as a query, not a parameter: https://hono.dev/api/request#queries

Acceptance Criteria

Generated by Zenhub AI

• [x] Scenario: Pagination with default values
  • Given the GET /api/items route is called with no queries
  • When the route is called with no queries
  • Then the response should have a page number of 0 and a size of 25
  • The response should also return the total number of records in the db associated with the authorUsername
  • [x] Scenario: Pagination with custom values
  • Given the GET /api/items route is called with a page query of 2 and a size query of 10
  • When the route is called with a page query of 2 and a size query of 10
  • Then the response should be validated with Zod and have a page number of 2 and a size of 10
  • The response should also return the total number of records in the db associated with the authorUsername
  • [x] Scenario: Invalid page parameter
  • Given the GET /api/items route is called with a page query of -1
  • When the route is called with a page query of -1
  • Then the response should return an error
  • [x] Scenario: Invalid size parameter
  • Given the GET /api/items route is called with a size query of 0
  • When the route is called with a size query of 0
  • Then the response should return an error