On Jun 11, 2008, at 10:45 AM, [EMAIL PROTECTED] wrote:
> > here this trouble... > > i have a "forest" of bitemporal/versioned objects that are all linked > via m2m relations, and all they "own" parameters, via m2m again. > > any idea how to map something like this then without going down to > tables: > (pseudocode) > Doc.ver == ver > and ( > Doc.dbid == Doc2Place.doc and > Doc2Place.place == ParamOwnership._place > or > Doc.dbid == Doc2Position.doc and ( > Doc2Position.poz == ParamOwnership._poz > or > Doc2Position.poz == Position2Dept.poz and ( > Position2Dept.dept == ParamOwnership._dept > or > Position2Dept.dept == Dept2Dept.child and > Dept2Dept.parent == ParamOwnership._dept > ) > ) > ) > and ParamOwnership.value == ParamValue.db_id overnormalized ? (not really sure, just something to ask) > > the good news is that i'm generating the above on level of tables/ > plain column expressions (unrolling); the bad is that i may need all > the intermediate objects as well... will add_entity( all them Doc > Place Position Dept Ownership) do it? dont use add_entity(), just send everything you need to session.query(....). > another trouble is the ParamOwnership m2m, it has different links for > diff. types of owners (mutualy exclusive), because otherwise i hit > multiple inheritance. > > any idea about multiple inheritance? i.e. it looks like creating > same object via different polymorhic hierarchies.. The ORM doesn't support multiple inheritance directly (I've never worked with multiple inheritance of tables before so I'm not an authority on what that even looks like). --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
