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.
