Paginator for the :many context? #978

Activity

1. videate-karim commented on Apr 17, 2021

   

   videate-karim

   on Apr 17, 2021

   Last edited by videate-karim

   More actions

   In my reading of the docs, you would do:

   -- name: GetThings :many
   SELECT * FROM things
    WHERE field = $1
    ORDER BY created_at desc
    LIMIT $2 OFFSET $3;

   The generated function looks like this:

   type GetThingsParams struct {
   	Field string
   	Limit    int32
   	Offset   int32
   }
   
   type GetThingsRow struct {
   	ID          int32
   	Field      string
          ...
   }
   func (q *Queries) GetThings(ctx context.Context, arg GetThingsParams) ([]GetThingRow, error) {
      ...
   }
2. sqlc-dev

   locked and limited conversation to collaborators on Sep 12, 2021
3. kyleconroy

   closed this as completedon Sep 12, 2021