Generate SQLite database scheme from Java code

Question

Is there any way to generate SQLite database model from Java code using JOOQ?

Lukas Eder · Accepted Answer · 2017-06-08 19:43:45Z

1

You can generate DDL statements like CREATE TABLE .. or ALTER TABLE .. ADD CONSTRAINT .. using the DSLContext.ddl() API, for instance:

// SCHEMA is the generated schema that contains a reference to all generated tables
Queries ddl =
DSL.using(configuration)
   .ddl(SCHEMA);

for (Query query : ddl.queries()) {
    System.out.println(query);
}

This is documented here: https://www.jooq.org/doc/latest/manual/sql-building/ddl-statements/generating-ddl/

answered Jun 8, 2017 at 19:43

Lukas Eder

223k138 gold badges731 silver badges1.6k bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Peter Penzov Over a year ago

Can you give some example what is SCHEMA? Are these Java classes similar to JPA Entities?

Lukas Eder Over a year ago

@PeterPenzov: It's a generated schema reference. But hey, perhaps I misunderstood your question. Would you mind being explicit about what you'd like to do?

Collectives™ on Stack Overflow

Generate SQLite database scheme from Java code

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related