Hi
 

> Just an idea: If you're using jOOQ for migrations with Flyway, the jOOQ 
> code is really also just a text file (*.java). Taking the checksum of that 
> would be easy. If you could manage to compile (and run) the jOOQ code after 
> taking the checksum, that might work around your issue, no? Perhaps, that 
> might be something worth requesting from Flyway as an enhancement. The 
> ability to provide programmatic migrations in source format, letting Flyway 
> compile the migration using the JDK's built-in compiler...
>
> Or, we build that on our end and ship a jOOQ-migrations module based on 
> Flyway, as I've mentioned before.
>
> Tracking the *'.java is going to have to many complications as it is 
likely to be changed during the development life cycle due to formatting 
and the made rush to add documentation/comments at some point when someone 
remembers to turn the metric scoring system on :) Also tracking the source 
does not catch my previous example where the SQL statement changes over 
time because JOOQ has gained capabilities to support new features (BIT vs 
BOOL) which will result in no java changes, but will result in different 
DDL.

I've raised the issue with Flyway as a question on stackexchange as that 
seems to be their primary way of communicating. Going forwards I would much 
prefer to see Flyway become JOOQ friendly, rather than you having to fork 
it for your own needs.
 

>
> You could do something along the lines of:
>
> Query query = create.createTable("...").column("...").column("...");
> Runnable[] result = { 
>     () -> query.hashCode(), 
>     () -> query.getSQL(),
>     () -> query.execute()
> };
>
>  
> And then work on that. Not sure if that responds to your concerns, 
> though...?
>

Please, I was not raising any concerns, rather just the issue of trying to 
fit the fluent interface into a new edge case role which it was never 
designed for. My own working knowledge is also a major factor here as I'm 
not a development, my focus is networks, databases and infrastructure. To 
me method chaining and fluent interfaces are new and shiny (then again they 
have only really been talked about for just the last 10 years or so), so 
moving into lambda expressions means I've got some catching up to do.

-- 
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