Re: SQL generation of FK constraints for cross-model relationships

From: Fabian Peters (lists.fabia..-lumo.com)
Date: Thu Jul 31 2008 - 13:51:58 EDT

  • Next message: Guido Neitzer: "Re: SQL generation of FK constraints for cross-model relationships"

    >> I find that EM in WOLips 3.3.5281 does not generate these. I tried
    >> after clicking on "Show model group" but this doesn't change
    >> anything. Is this a known limitation?
    > It generates for whatever entities are passed into the generator,
    > which is either for the single model (if nothing is selected), or I
    > SUPPOSE you could select across models, but I've never tried. Try
    > selecting all your entities + select the entities in the other model
    > and see if that does it. All this does is call EOF API's, so it's
    > going to do whatever EOF does when handed that set of entities. I
    > suppose I could support selecting multiple models rather than
    > selected entities, too.

    Well, I've tried again and attempted to use any conceivable
    combination, but to no avail:

      * selecting the entity with a relationship to a different model and
    the referenced entity, SQL is generated for the entity that is part of
    the referenced model (i.e. not the one originally opened for editing)
    and vice versa
      * selecting the entity with a relationship to a different model and
    the referenced model, SQL for all entities in the latter is generated
    and vice-versa
      * selecting both models, SQL is generated for the one originally
    opened for editing

    The FK constraints for cross-model relationships don't get generated
    with any combination. It's not a big deal, I was just contemplating to
    create a fresh DB schema from scratch and dump the data into that,
    since I'm introducing quite a lot of additions right now.

    cheers, Fabian



    This archive was generated by hypermail 2.0.0 : Thu Jul 31 2008 - 13:52:51 EDT