Hi, I'm wondering if there is easy way of combining multiple resultsets into a single object? I know that I can manipulate the heck out of a MockResultSet but I figured it's worth checking to see if there is an easier way with Jooq.
I need to get a ResultSet that is a combination of multiple queries. Sub-selects are a 1:many of the first SQL: Q1: SELECT id,name,model,manufacturer from cars; Q2: .. for each car.id -> SELECT '',name,model,manufacturer,carId_fk from tires where tire.id=carId_fk; The final output would be: 1,Foo,Toyota,RAV4 ,XXX,GoodYear,Eagle Sport,1 ,X1Y,GoodYear,Snow,1 2,Bar,BMW,325i ,YYY,BFGoodrich,AllTrain,2 ,Y22,BFGoodrich,G-Force,2 ,X2Y,GoodYear,SnowExtreme,2 etc.... I used do this as one main outer for loop and one inner ones that build the spreadsheet over time. The new system will accept a ResultSet argument, and a Type[] array (for each column), that is then taken and converted into a spreadsheet. Thanks. -- 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.
