Yep, I was afraid of that... Oh well, it's implemented now using fetchGroups() and some mapper methods I wrote. Should be OK, but I will look into using ModelMapper in a future refactoring.
Thanks Lukas! Deven On Monday, September 8, 2014 3:40:28 AM UTC-4, Lukas Eder wrote: > > Hello, > > Out of the box, jOOQ supports in-memory grouping of records into > Map<Record, List<Record>> structures via various Result.intoGroups() > methods, e.g.: > > http://www.jooq.org/javadoc/latest/org/jooq/Result.html#intoGroups-org.jooq.Field:A- > > This isn't an actual OR-mapping feature, just grouping results by row > values. I just realised that there is room for more such intoGroups() > methods. I have registered a feature request for that: > https://github.com/jOOQ/jOOQ/issues/3626 > > Of course, you can always implement your own RecordMapper, e.g. via > RecordMapperProviders: > > http://www.jooq.org/doc/latest/manual/sql-execution/fetching/pojos-with-recordmapper-provider/ > > ... or possibly using a third-party library, like ModelMapper, which has > an official jOOQ integration: > http://modelmapper.org/user-manual/jooq-integration/ > > > 2014-09-05 18:08 GMT+02:00 Deven Phillips <[email protected] > <javascript:>>: > >> I'm getting bogged down on this, so I thought I would ask the group.. >> >> I have a query which joins across about 9 tables. The relationship is >> essentially a 1 -> Many with associated fields from other tables added. I >> would like to map the results using an class which has a field which is a >> List of the "Many" relationship... Do I have to create a customer mapper to >> accomplish that, or is there a way to make that work? >> >> So, example: >> >> Table: Customer 1 ... N Table: Locations and have the associated >> locations placed into a single Customer object >> >> Thanks in advance for any help, >> >> Deven >> >> -- >> You received this message because you are subscribed to the Google Groups >> "jOOQ User Group" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
