[Uml-devel] [Bug 76877] New: Exporting SQL code, order of tables and foreign keys

[Jaakko Holster]

------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
      
http://bugs.kde.org/show_bug.cgi?id=76877      
           Summary: Exporting SQL code, order of tables and foreign keys
           Product: umbrello
           Version: 1.2
          Platform: unspecified
        OS/Version: Linux
            Status: UNCONFIRMED
          Severity: wishlist
          Priority: NOR
         Component: general
        AssignedTo: umbrello-devel.kde.org
        ReportedBy: holster iki fi


Version:           1.2 (using KDE 3.2.0, Gentoo)
Compiler:          gcc version 3.2.3 20030422 (Gentoo Linux 1.4 3.2.3-r1, propolice)
OS:          Linux (i686) release 2.6.2

Generating code from SQL class diagrams makes a file for each table. However, if I try to create tables by 'psql < *.sql', not all tables can be created, because a table may have a foreign key referencing to another table, but the referenced table has not been created yet. To fix this problem, SQL code generator should put all the code into one file and intelligently order tables so that tables with foreign key are placed after their reference tables.