Re: [Openinteract-help] OI2 and DB Entity Relationships

[<ti...@re...>]

The penny has dropped ... I now understand the comment someone made about the
extra hassle for the DBAs managing schemas designed to accomodate the SPOPS DB
object relationships.

The missing link was in here
http://spops.sourceforge.net/doc/SPOPS/Manual/Relationships.shtml

For my main application this means an extra 12-15 tables

Quoting Coder <mli...@re...>:

> All,
>
> I am having trouble understanding how the OI2 architecture models entity
> relationships in code and susequently referes to the at run time.
>
> I have been using Class::DBI for a while now and understand it's mapping
> quite
> well - it's pretty straightforward:
>
> Each entity/object is represented by a table and that object has
> relationships
> (one-to-one, and one-to-many) with other objects.
>
> Each object can tell you what it's children are and each child it's parent
> when
> queried using the correct method.
>
> These are the main functions I am having probelms translating into 'OI2
> speak'.
>
> Can anyone shed some light? I have looked through the archives, but have to
> admit am a little more confused. The OI2 Tutorial is good, but uses only a
> one
> table, and the Advanced Tutorial does not appear to have been written as yet.
>
> I have seen reference to the fact that Class::DBI could be incorporated, but
> no
> concrete examples of how.
>
> This is the last stumbling block for me before I migrate my apps to OI2, so
> your
> assistance is much appreciated.
>
> Ticha
>
> ----------------------------------------------------------------
> This message was sent using IMP, the Internet Messaging Program.
>
>
>
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real users.
> Discover which products truly live up to the hype. Start reading now.
> http://productguide.itmanagersjournal.com/
> _______________________________________________
> openinteract-help mailing list
> ope...@li...
> https://lists.sourceforge.net/lists/listinfo/openinteract-help
>




----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.