Match/diff at runtime between Jooq generated code and real DB ?

[Ronan Michaux]

Hi,

does it exists a way to check at runtime that the generated Jooq code match the real database in production ?

Regards,
Ronan.

[Lukas Eder]

Hi Ronan,

To some extent: Yes. You can compare the generated code with the results of DSLContext.meta().getTables(), for instance.

In jOOQ 3.9, there will be the possibility to export a Catalog / Schema / Table to jOOQ's meta XML format:

http://www.jooq.org/xsd/jooq-meta-3.5.4.xsd

This will simplify the job, as the comparison will be text based.

I hope this helps. If you have any specific questions / feature requests about this topic, please let me know

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 jooq-user+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Ronan Michaux]

Thank you, I've started to create a diff between DSLContext.meta().getTables() and fields of Tables.

To unsubscribe from this group and stop receiving emails from it, send an email to jooq-user+...@googlegroups.com.