Exclude views from the code generation MYSQL

[lubo mihailov]

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.

[Lukas Eder]

Hello,

Can you please share the exact code generation configuration?

Also, please do check if you picked the correct name case (upper / lower)

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/ccb86645-a51b-461c-a55c-b07b161fe233n%40googlegroups.com.

[lubo mihailov]

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>

[Lukas Eder]

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/

To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/5196f7ef-3f4a-4792-aceb-223a168307b4n%40googlegroups.com.

[lubo mihailov]

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 

[Lukas Eder]

Well, it's a regular expression, so just add view1|view2|view3|...

To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/fc3e7b3c-6ada-40cd-8e92-d73bec046f58n%40googlegroups.com.