Hi Lukas, On Feb 19, 9:58 am, Lukas Eder <[email protected]> wrote: > Adding support for DDL statements is on the jOOQ > roadmap:https://sourceforge.net/apps/trac/jooq/ticket/883 > > I've found a sample OSS project on Google Code using jOOQ for > DDL:http://lukaseder.wordpress.com/2011/10/27/jooq-in-the-wild/ Thanks for this resource. I don't know if you wish to update the links in the blog post, the project is now hosted over @ GitHub [0]
> As you can see, this makes use of MySQL syntax (AUTO_INCREMENT). > Unfortunately, I've had no idea yet, how to formalise even simple DDL > features into a common API. So now that we are in discussion, what technical problems/hurdles are you experiencing when trying to represent DDL within JOOQ? As you mention, the example above uses MySQL syntax, in your experience does this differ significantly from SqlStore to SqlStore? > > > I need to replace/alternative getter and setter implementations which > > (privately) set a column constraint, which can then used when we > > createSchema() in our SqlStore. > What I was attempting to explain here was that when we are trying to create a schema (if one doesn't already exist), we want to execute the CREATE TABLE query then specify various column constraints describing the nature of the table. We currently have private methods for getting and setting Column Constraints which also need to be adapted to drop the offending code... Does this make sense? > Any questions welcome! As always a great help,thank you Lewis [0] https://github.com/blizzy78/blizzys-backup/
