Re: JOOQ to get Table Names from MySQL sql file

2025-08-22 Thread Lukas Eder
You can wrap syntax that jOOQ's parser doesn't understand with a special comment syntax explained here: https://www.jooq.org/doc/latest/manual/sql-building/dsl-context/custom-settings/settings-parser/ On Fri, Aug 22, 2025 at 11:55 AM tuk wrote: > Thanks for replying. > > I am using Jooq 3.19.25

Re: JOOQ to get Table Names from MySQL sql file

2025-08-22 Thread tuk
Thanks for replying. I am using Jooq 3.19.25 Open source edition. I tried something like below class TableExtractorTest { @Test @SneakyThrows void test() { String sql = new String(Files.readAllBytes(Paths.get("/tmp/create_db.sql"))); Parser parser = DSL.using(SQLDi

Re: JOOQ to get Table Names from MySQL sql file

2025-08-21 Thread Lukas Eder
Hello, You can use jOOQ's query object model API to extract all tables from your parsed queries: https://www.jooq.org/doc/latest/manual/sql-building/model-api/ It will be easiest to achieve using Traversers: https://www.jooq.org/doc/latest/manual/sql-building/model-api/model-api-traversal/ https:

JOOQ to get Table Names from MySQL sql file

2025-08-21 Thread tuk
We are using JOOQ with MySQL 8 for generating Java code. Can someone let me know if it is possible to also use JOOQ as a parser to extract all table names referenced in a MySQL .sql file? The .sql file can contain both DDL, DML statements. -- You received this message because you are subscrib