Duplicate table in jooq with foreignkey and primary key

22 views
Skip to first unread message

iz8...@gmail.com

unread,
Mar 25, 2020, 8:41:23 AM3/25/20
to jOOQ User Group

Hi everyone,

i have a question, i duplicated a table with:

Table<?> table = DSL.table(DSL.name("dc2", "process"));
    dsl.createTable(table).as(dsl.select().from("dc1.process")).withNoData().execute();

but doesn't copy a primary key and foreignkey, how i do?

and if i want to duplicate schema in jooq? thanks Giuseppe

Lukas Eder

unread,
Mar 25, 2020, 9:26:26 AM3/25/20
to jOOQ User Group
Hi Giuseppe,

If you're using the code generator to produce your original schema, you can duplicate it relatively easily using:

- DSLContext.ddl() and/or Meta.ddl()

A more convenient syntax will be supported in the future via standard SQL CREATE TABLE (.. LIKE othertable) syntax:

Or a synthetic CREATE SCHEMA .. LIKE otherschema syntax:

This is a very interesting use-case to pursue in the future of jOOQ, so if you encounter any issues, please do report them.

I hope this helps,
Lukas

--
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/104c349b-4add-472d-97ac-01921da2c131%40googlegroups.com.

Lukas Eder

unread,
Mar 26, 2020, 4:42:47 AM3/26/20
to jOOQ User Group
For the record, this question was also asked on Stack Overflow: https://stackoverflow.com/q/60848882/521799


On Wednesday, March 25, 2020 at 2:26:26 PM UTC+1, Lukas Eder wrote:
Hi Giuseppe,

If you're using the code generator to produce your original schema, you can duplicate it relatively easily using:

- DSLContext.ddl() and/or Meta.ddl()

A more convenient syntax will be supported in the future via standard SQL CREATE TABLE (.. LIKE othertable) syntax:

Or a synthetic CREATE SCHEMA .. LIKE otherschema syntax:

This is a very interesting use-case to pursue in the future of jOOQ, so if you encounter any issues, please do report them.

I hope this helps,
Lukas

On Wed, Mar 25, 2020 at 1:41 PM <iz8...@gmail.com> wrote:

Hi everyone,

i have a question, i duplicated a table with:

Table<?> table = DSL.table(DSL.name("dc2", "process"));
    dsl.createTable(table).as(dsl.select().from("dc1.process")).withNoData().execute();

but doesn't copy a primary key and foreignkey, how i do?

and if i want to duplicate schema in jooq? thanks Giuseppe

--
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+unsubscribe@googlegroups.com.
Reply all
Reply to author
Forward
0 new messages