Uploaded image for project: 'Spring Roo'
  1. Spring Roo
  2. ROO-3268

Database reverse engineering included tables with foreign keys to no included tables fails

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.2.2.RELEASE
    • Fix Version/s: None
    • Component/s: @ CORE, PERSISTENCE
    • Labels:
    • Environment:
      Ubuntu 12.04, JDK 1.6.0_33, Maven 3.0.4

      Description

      When reverse engineering large database schemas with a lot of tables and relations, is required to filter selected tables with "--includeTables" command parameter.

      Also is required to ignore related tables from included ones with "--excludeTables" command parameter, if not, commands fails because foreign keys can not be applied.

      In very large database schemas, there are a lot of relations and search table names to exclude by foreign key is tedious.

      Better solution is ignore this foreign keys without exclude related tables when related tables are not included. Then relation columns can be generated as simple type properties (Long by Example) instead of object type properties (MyEntity by example).

      This applies too to database reverse engineering a complete scheme because tables in one schema may have relations with other not generated schemas tables. It applies too when "--enableViews" is not present because one table or view may have relations with not generated table or view.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              mmartinez Mario Martínez Sánchez - gvNIX - DISID
            • Votes:
              3 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:

                Time Tracking

                Estimated:
                Original Estimate - 1d
                1d
                Remaining:
                Remaining Estimate - 1d
                1d
                Logged:
                Time Spent - Not Specified
                Not Specified