Skip to content

3.13 DDL interpretation
  

Updated Nov 12, 2019

46 To do

5 In progress

0 Review in progress

0 Reviewer approved

42 Done

This project doesn’t have any columns or cards.

Menu

3.13 DDL interpretation #1

  
Updated Nov 12, 2019
For a variety of reasons, we want to be able to simulate / interpret DDL statements to produce a snapshot version of any meta model. We currently do that by parsing input SQL, translating it to H2, and running it on an in-memory H2 database.

For a variety of reasons, we want to be able to simulate / interpret DDL statements to produce a snapshot version of any meta model. We currently do that by parsing input SQL, translating it to H2, and running it on an in-memory H2 database.

This has a few caveats:

  • It is not secure to use in websites, e.g. https://www.jooq.org/translate
  • It is limited by what we can parse (that won't change)
  • It is limited by what H2 can execute

Instead, we would like to be able to interpret DDL (and possibly other statements) ourselves, creating incremental updates to an org.jooq.Meta representation of the migrated schema.

Activity

    Loading activity

Archived cards

Loading archived cards…

You can’t perform that action at this time.