Add group_by action method about prisma-client-py HOT 6 CLOSED

@HKGx Not yet, although this is not a difficult change. I'll work on it now.

from prisma-client-py.

any updates?

from prisma-client-py.

@HKGx Do you need to also query by _count, _avg, _sum, _min or _max? (https://www.prisma.io/docs/reference/api-reference/prisma-client-reference#groupby)

I forgot about these aggregation fields before mentioning that this is not a difficult change. Adding support for querying by these fields is more difficult due to internal features that I haven't implemented yet. If you don't need these, I can prioritise getting an initial proof of concept implemented which you would be able to use until the next release.

from prisma-client-py.

@RobertCraigie I'd say so as I'm currently doing

SELECT field, COUNT(field) FROM table GROUP BY field

Not sure how it applies to Prisma, though.

from prisma-client-py.

@HKGx You would be correct, I'll see what I can do.

For reference, the missing internal feature is serializing queries for selecting fields (#19).

from prisma-client-py.

@HKGx I've added the initial support for this feature.

You can try it out by installing from the wip/group-by branch:

pip install -U git+https://github.com/RobertCraigie/prisma-client-py@wip/group-by

It should be noted that the group_by method returns a TypedDict, not a BaseModel.

This is also very much a work in progress, please let me know if you encounter any issues.

from prisma-client-py.