Group By Support

[edeesis]

It seems like GROUP BY and HAVING support is one of the things missing from the library. There's some references to it in the Criteria API implementations with notSupportedOperations and in the QueryModel GroupPropertyProjections.

I'm considering what the API for this would look like. There could be an implementation using just the Criteria API, or perhaps something similar to Sort which controls order by? Or perhaps an Annotation similar to @where?

A similar interesting addition to this would be to add Maps as possible return types, where the keys are the group by fields, and the values are some sort of projection.

[dstepanov]

Definitely Criteria API which is using the query model to build the query. After that we can even add the support for it in the method finders

[dstepanov]

I will take a look at the issue with the suspend methods soon. Regarding 2) I think with a specification, you are responsible for creating a DTO manually, so I don't think there is anything automatic that can be done. Maybe I don't understand the Q. Can you provide an example?

[dstepanov]

Ah I see you have some examples in your branch. I will check.

[edeesis]

Thank you Denis. Hopefully they're quick fixes.

[dstepanov]

Just released a new version with the Kotlin fixes. Maybe you can update your branch and see if it helped.

[edeesis]

Seems to work! Some of my tests are passing now, but some still aren't. So will work through those issues.