Hi Joseph,

I'm sorry for the delay.

2016-01-07 1:04 GMT+01:00 <[email protected]>:

> Ok, there you're :
> https://github.com/cluelessjoe/jOOQ-java-flyway-example
> It's pretty rough around the edges, and not only the edges ^^ Hopefully
> you'll still manage to make sense out of it.
>
> So, what do we have there ? An ApplicationRunner as the production entry
> point, starting an Application, in which it all starts by some migrations.
> These migrations are written in Java.
>
> As I'm not a big fan of maven install's time stuff generation, I also
> switched to Java model generation in the test resources, namely in
> ModelGenerator
>
> No model versioning there, and actually I encountered a funny issue :
> inserting data actually requires the model to be there already AFAIK. So
> actually I'll have to add an extra migration step : in the third I update
> the schema, then generate the model, then in a fourth step I can data into
> the DB. Unless I'm missing something for sure.
>

Interesting approach, this does look promising, but I can see that Maven's
different phases can get in the way of getting this right. Obviously, as
the schema migration is related to the jOOQ code generation, which is again
a pre-requisite for parts of the schema migration, things can get hairy
rather quickly. This is not an issue with text-based migrations, obviously,
as random statements can be put in random order in these text files.

With type safe jOOQ / Flyway migrations, I suspect that migrations would
need to be split into individual Maven modules, which makes me wonder, if
this doesn't produce too much overhead (at least with Maven)?

In any case, I've also registered a feature request to add an example to
the jOOQ repository and manual. Just as a reminder:
https://github.com/jOOQ/jOOQ/issues/4945

Let me know if you come to think of another missing feature.
>>
>
> That's all for now, but I'm only prototyping, no real production code yet.
>

OK, let me know if you have anything further to present. I'm very curious
about your progress.


> By the way, a side question: do you speak at conference ? I'm actually
> member of the ElsassJug, in Strasbourg, so next door to you so to say. If
> ever you had something to say/share, I would happily organize an event for
> you. What do you think of it ?
>

Sure, I'm always open for conference talks. Strasbourg is indeed not too
far from Zurich. I'll contact you off-list for this.

Best Regards,
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.

Reply via email to