Hi Daniele, Thanks for your message. That's a very interesting topic. I will comment inline.
On Tue, Dec 18, 2018 at 11:53 PM Daniele Antonini < [email protected]> wrote: > Hi, > I'm sincere, I didn't search old posts on this topic, but I don't remember > anything similar in the docs so I'm quite sure there is room for some > enhancement. Please point me at the docs if this topic is already > discussed. > We don't offer this functionality, so we don't have such documentation to point you to :) > Anyone use jooq to create database, setup data and assert database tables? > I'm sure others do - I hope they will chime in. > I usually use dbunit for that, so I've created a little thin layer that > use jooq table/field to create "typesafe" dataset directly in the code, > without rely on external xml file. The interesting part is that using > generated metadata the dataset creation takes care of required column and > you are not forced to provide values not related to the test. > > My concern is, why jooq don't provide a native way to create this dataset? > Because time is limited and this is a product that will be very cool to have, but does take a while to implement. It is definitely on the roadmap, but was not a priority so far. > For sure it overlaps with other libraries, but I think that having a > single library to write sql AND write test more easily could be very > usefull. What do you think about this? Are you interested to discuss more > in details this aspect? > Yes of course! However, it is not very easy to understand what the ideal approach will be, here. These days, using something like testcontainers with production data that can be reset after every test might be easier than setting up test data for individual tests manually every time. If this was an easy to solve problem with a one-solution-fits-all approach, I'm sure someone would have gotten very rich with their solution already. But I think that the expectations in the market are just way too diverse for that. I'm very keen on learning more about your approach and use-case. Are you interested to share some examples of what you're doing? Thanks, Lukas -- 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.
