Well, it's a regular expression, so just add view1|view2|view3|... On Mon, Jun 13, 2022 at 10:40 PM lubo mihailov <[email protected]> wrote:
> Thanks will try it > Is there any way to add multiple views manually in > <excludes> </excludes> until find a way to do it with the code > programmatic > > В 21:38:27 ч. UTC+3на понеделник, 13 юни 2022 г. [email protected] > написа: > >> Oh, I see, you took inspiration from this issue here, then: >> https://github.com/jOOQ/jOOQ/issues/6489 >> >> But the feature hasn't been implemented yet, so you can't use that >> approach... You could run such a query with manual code generation >> configuration: >> >> https://www.jooq.org/doc/latest/manual/code-generation/codegen-programmatic/ >> >> >> On Mon, Jun 13, 2022 at 6:54 PM lubo mihailov <[email protected]> wrote: >> >>> Hi >>> this is my configuration >>> <executions> >>> <execution> >>> <id>generate-mysql-schemaName</id> >>> <phase>generate-sources</phase> >>> <goals> >>> <goal>generate</goal> >>> </goals> >>> <configuration> >>> <jdbc> >>> <driver>${driverName}</driver> >>> <url>${url}</url> >>> <user>${user}</user> >>> <password>${password}</password> >>> </jdbc> >>> <generator> >>> <database> >>> <includes>.*</includes> >>> <excludes>SQL [ >>> SELECT GROUP_CONCAT(table_schema,'.', >>> table_name,'|') >>> FROM information_schema.views; >>> <!-- >>> SELECT CONCAT(table_schema,'.', table_name,'|') >>> FROM information_schema.views >>> SELECT CONCAT(table_schema,'.', table_name,'|') >>> FROM information_schema.tables; >>> SELECT GROUP_CONCAT(table_schema,'.', table_name,'|') >>> FROM information_schema.tables; >>> --> >>> </excludes> >>> <inputSchema>inputSchema</inputSchema> >>> </database> >>> <target> >>> <packageName>com.inputSchema</packageName> >>> <directory>${someDir}</directory> >>> </target> >>> <generate> >>> <sources>true</sources> >>> <sourcesOnViews>false</sourcesOnViews> >>> </generate> >>> </generator> >>> </configuration> >>> </execution> >>> </executions> >>> >>> В 19:31:01 ч. UTC+3на понеделник, 13 юни 2022 г. [email protected] >>> написа: >>> >>>> Hello, >>>> >>>> Can you please share the exact code generation configuration? >>>> Also, please do check if you picked the correct name case (upper / >>>> lower) >>>> >>>> On Mon, Jun 13, 2022 at 6:22 PM lubo mihailov <[email protected]> >>>> wrote: >>>> >>>>> Hi >>>>> i want to exclude all the views when i generate the code >>>>> I tried this approach >>>>> https://jooq-user.narkive.com/QKDrg2rp/code-gen-skip-views >>>>> but with no result. >>>>> Probably i missed something but i cant make it to skip them >>>>> i even add them manually but i still generate all the views >>>>> Example:: >>>>> tabe_schema.viewname_1|tabe_schema.viewname_2|tabe_schema.viewname_2 >>>>> ... >>>>> And i still cant make it work. >>>>> Where i do it wrong. >>>>> >>>>> -- >>>>> 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]. >>>>> To view this discussion on the web visit >>>>> https://groups.google.com/d/msgid/jooq-user/ccb86645-a51b-461c-a55c-b07b161fe233n%40googlegroups.com >>>>> <https://groups.google.com/d/msgid/jooq-user/ccb86645-a51b-461c-a55c-b07b161fe233n%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>> . >>>>> >>>> -- >>> 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]. >>> >> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/jooq-user/5196f7ef-3f4a-4792-aceb-223a168307b4n%40googlegroups.com >>> <https://groups.google.com/d/msgid/jooq-user/5196f7ef-3f4a-4792-aceb-223a168307b4n%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> >> -- > 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]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/jooq-user/fc3e7b3c-6ada-40cd-8e92-d73bec046f58n%40googlegroups.com > <https://groups.google.com/d/msgid/jooq-user/fc3e7b3c-6ada-40cd-8e92-d73bec046f58n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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]. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/CAB4ELO61iRNDpiqyX-mvV1JneCYit%2Bdj2KOp1L2b_-37%2BujCTA%40mail.gmail.com.
