CODEWITHSUNDEEP
sequelize.jsgraphqlgraphql-js
Amir
Amir

Reputation: 4770

How do I define pagination parameters in my schema?

I am trying to create the ability to paginate through my data, but I'm not sure where I need to place the pagination variables.

Here is what I have in my schema: 

const Query = new GraphQLObjectType({
  name: 'Query',
  description: 'This is a root Query',
  fields: () => {
    return {
      allPosts: {
        type: new GraphQLList(Post),
        args: {
          offset: {
            type: GraphQLInt
          },
          first: {
            type: GraphQLInt
          }
        },
        resolve(root, args) {
          return Db.models.post.findAll({where: args});
        }
      }
    };
  }
});

In my args, I've created the variables offset and first to be able to use them. Inside in my graphiQL interface I can do this:

{
    allPosts() {
    id
    }
}

And it correctly retrieves all my posts. However if I try to do this:

{
    allPosts(offset:10, first: 10) {
    id
    }
}

"message": "Unknown column 'post.offset' in 'where clause'",

Upvotes: 0

Views: 557

Answers (2)

Baer
Baer

Reputation: 3790

I would be very careful about passing args directly into your DB, but as a point of clarity, I should say that GraphQL does not do pagination for you. You can pass in args like you are doing but there is no right answer here about where to put them or how to use them since everybody gets data in their way.

Upvotes: 0

Daniel Rearden
Daniel Rearden

Reputation: 84837

In Sequelize, offset is a separate option from where. Sequelize also doesn't have a first option, but it does have a limit. You can do something like:

resolve(root, { offset, first: limit }) {
  return Db.models.post.findAll({offset, limit});
}

You can check out the docs here to see all the options supported by findAll.

Upvotes: 1

Related Questions