On Tue, Mar 19, 2024 at 9:36 AM Marcel Overdijk <[email protected]> wrote:
> Thanks Lukas, > > I created https://github.com/jOOQ/jOOQ/issues/16470 for this. > > > We can do a topological sort. > > That sounds hopeful! Not sure how to do it, so if there is anything you > share that would be great. > Well, if there are no cycles, then it's just a DAG where tables are vertices and foreign keys are edges. If there are cycles, then we must use this approach (the only way I can see how cycles can be made in SQLite): create table t (i int primary key); create table u (i int references t, j int primary key); alter table t add j int references u; This form of the ALTER statement currently cannot be represented in the jOOQ API, so it won't be an easy fix. -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/CAB4ELO7AXbipXHhK-JgWS%2B6VDkzbNbEm8R6BT3LKVdap%3DsB%3Dfw%40mail.gmail.com.
