Re: Relationships without FK constraints?

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Mon Mar 30 2009 - 03:19:17 EDT

  • Next message: Dave Lamy: "Importing DataMaps"

    I may have missed it being discussed already in this thread, but it
    occurs to me that inferring relationships based on the key naming
    convention is actually independent from reverse engineering, and can
    be a useful shortcut even if the model is built manually in the
    Modeler. So maybe we can have a separate menu item for that.

    Andrus

    On Mar 27, 2009, at 6:30 PM, Joseph Schmidt wrote:

    >
    > Can Cayenne work (consistently) with relationships where the
    > underlying foreign key constraint is missing? (e.g. when the fields
    > for foreign key are there and respect the standard naming convention
    > - artist_id for the relationship pointing to artists but the
    > constraint is not set ?
    >
    > I tried to reverse engineer such databases, but if the FK
    > constraints are missing, Cayenne Modeler doesn't seem to recognize
    > them (despite of the naming convention) :(.
    > It looks like many existing databases don't use the FK constraints
    > (only the naming convention - e.g. all RoR and similar frameworks
    > based applications).
    >
    >
    > Thanks,
    > Joseph.



    This archive was generated by hypermail 2.0.0 : Mon Mar 30 2009 - 03:19:50 EDT