Support for aggregation functions and grouping about graphql-sequelize HOT 11 CLOSED

@abelosorio I'm looking myself - I've found this: https://github.com/blueflag/graphql-aggregate but I'm still mid-evaluation

from graphql-sequelize.

Not sure we can come up with a design that accurately handles all the cases of aggregations.
The aggregations i have in my code are custom implementations, did not see a pattern that i could make generic.

from graphql-sequelize.

OK, thanks - so I'm better off doing a raw query from GraphQL? That's fine - just checking I wasn't missing anything really.

from graphql-sequelize.

@joewood or using Model.aggregate possibly

from graphql-sequelize.

Ah, it seems I was missing something. Thanks.

from graphql-sequelize.

One suggestion that would be really great to add to the library would be a special resolver function that performs an aggregation function on the linked association. This would mean modifying the resolver factory function to include the details of the .aggregate function. And also modify generateIncludes to integrate this into the generated SQL. So it would be used something like this:

let customerType = new GraphQLObjectType({
    name:"Customer",
    fields: () => _.extend(attributeFrields(customerTable), {
        orderCount: {
            type: GraphQLInt,
            resolve: aggregateResolver(customerTable.associations.orders,"count")
        }
    });

The generated SQL would have to group by all the fields outside of the aggregate association.

from graphql-sequelize.

@joewood Mixing aggregations and includes can be tricky. With window functions you can do the most basic ones though.

from graphql-sequelize.

Any news about this? I need to use aggregations but I can't found any documentation of that...

from graphql-sequelize.

@lauraannwilliams could be useful. I'm using raw queries by now, but it's not a great solution. There is another way else to use aggregation in GraphQL?

from graphql-sequelize.

Hello @abelosorio, I think I figure out the pattern to get COUNT:

const modelType = new GraphQLObjectType({
  name: 'Model',
  fields: attributeFields(models.Model)
});
const modelWithCountType = new GraphQlObjectType({
  name: 'ModelWithCount',
  fields: {
    models: { type: new GraphQLList(modelType) },
    count: { type: GraphQLInt }
  }
});

const query = {
  type: modelWithCountType,
  args: { // some query arguments },
  resolve: resolver(models.Model, {
    list: true,  // NOTE: we return list of Models but using ModelWithCountType
    after: (models) => ({ models, count: models.length })
  }),
}

To summarize that: you need to create a GraphQL wrapper and manipulate a little with returned results. I hope it helps :)

from graphql-sequelize.

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

from graphql-sequelize.