Hi, I've encountered the same issue using jooq 3.8.6 and gradle-jooq-plugin 2.0.2. While the <includes> trick works, jooq is still generating packages, CatalogImpl and SchemaImpl implementations for the rest of the catalogs. Although <inputCatalog> is available for 3.8.6, gradle-jooq-plugin will not execute as it references jooq-codegen-3.8.0.xsd due to the value of Constants.XSD_CODEGEN (that is, if my analysis is correct). Is there a way around this? namely, I'd like to have jooq ignore all catalogs except one. Thanks
On Tuesday, October 18, 2016 at 9:55:56 AM UTC+3, Denis Miorandi wrote: > > Hi Lukas, > you are right about documentation, it mention "excludes match > before includes", but it's not so clear if and how you can mix include / > exclude. > > Tks for interesting. > > 2016-10-17 20:56 GMT+02:00 Lukas Eder <lukas...@gmail.com <javascript:>>: > >> Hi Denis, >> >> Thank you very much for your feedback. The documentation that you've >> linked mentiones "excludes match before includes". Perhaps that's a bit too >> implicit to conclude that "match before" might mean "have priority"? I'll >> reword this to make it more clear. I've created an issue for this: >> https://github.com/jOOQ/jOOQ/issues/5595 >> >> 2016-10-14 12:22 GMT+02:00 Denis Miorandi <denis.m...@gmail.com >> <javascript:>>: >> >>> Hi Lukas, >>> ok, got it. It worked for me. Just a note. Is not clear from >>> documentation how include / exclude work lookin at >>> http://www.jooq.org/doc/3.8/manual/code-generation/codegen-configuration/ >>> . >>> I saw this method on source code to achieve this: >>> >>> protected final <T extends Definition> List<T> >>> filterExcludeInclude(List<T> definitions, String[] e, String[] i, >>> List<Filter> f) { >>> >>> probably should be better explain in documentation that exclude have >>> priority and i.e. exclude .* cut all irrispective of include definition. >>> >>> >>> <plugin> >>> <groupId>org.jooq.pro</groupId> >>> <artifactId>jooq-codegen-maven</artifactId> >>> <configuration> >>> <generator> >>> <database> >>> <includes>(?i:MYCATALOG.dbo.*)</includes> >>> </database> >>> </generator> >>> </configuration> >>> <executions> >>> <execution> >>> >>> >>> >>> Il giorno martedì 20 settembre 2016 11:01:28 UTC+2, Lukas Eder ha >>> scritto: >>>> >>>> Hi Denis, >>>> >>>> Thank you for reporting this. In jOOQ 3.8, we've started supporting the >>>> org.jooq.Catalog type in the code generator, which is very useful in SQL >>>> Server, one of the few databases that allows multi-catalog queries >>>> (they're >>>> called databases in SQL Server). >>>> >>>> Unfortunately, jOOQ 3.8 was shipped without #4794, which allows for >>>> configuring catalogs in the code generator, as many users don't want all >>>> the catalogs to be generated: >>>> https://github.com/jOOQ/jOOQ/issues/4794 >>>> >>>> The best workaround so far is to use <includes/> and <excludes/> to >>>> exclude all the undesired catalogs. The catalogs themselves will still be >>>> generated, but they will at least be empty. If that's still an issue, you >>>> could remove those catalogs in a post-generation build step. >>>> >>>> I hope this helps - and I'm sorry for the inconvenience. >>>> Lukas >>>> >>>> 2016-09-19 13:34 GMT+02:00 Denis Miorandi <denis.m...@gmail.com>: >>>> >>>>> Switching from jooq 3.7.4 to 3.8.4, when I generate a single db on a >>>>> schema using and ulr like this >>>>> >>>>> jdbc:jtds:sqlserver://xxxxxx:1433;databaseName=yyyyyyyyyy; >>>>> >>>>> Results is a generation of all databases on dbo.* schema. I want to >>>>> generate just one of it, like on 3.7.4. >>>>> >>>>> How can I achieve this via maven plugin? >>>>> I've seen a schema selector but not a database selector. This prevent >>>>> me to migrating >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> 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+...@googlegroups.com. >>>>> For more options, visit https://groups.google.com/d/optout. >>>>> >>>> >>>> -- >>> 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+...@googlegroups.com <javascript:>. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> -- >> You received this message because you are subscribed to a topic in the >> Google Groups "jOOQ User Group" group. >> To unsubscribe from this topic, visit >> https://groups.google.com/d/topic/jooq-user/nWE8RZKak5E/unsubscribe. >> To unsubscribe from this group and all its topics, send an email to >> jooq-user+...@googlegroups.com <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > Dott. Denis Miorandi > via dei Vignai 27 > 38060 - Nogaredo (TN) > > > > -- 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+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
