I did just that this afternoon to link across heterogeneous
dataservers. Modulo the inevitable awkwardness from having two
different names for the same thing (i.e. Asset and EjvAsset), this was
very easy:
class_mapper(Asset).add_properties({
'EjvAsset' : relation(EjvAsset,
primaryjoin=Asset.asset_id ==
EjvAsset.asset_id,
foreign_keys=[Asset.asset_id],
viewonly=True,
),
})
very neat!
pjjH
On Apr 16, 10:57 am, Michael Bayer <[email protected]> wrote:
> On Apr 16, 2009, at 10:50 AM, JanW wrote:
>
>
>
> > OK, thanks, so does that mean that mapping one class against multiple
> > tables in different databases is something very exotic and probably
> > bad practice?
>
> its an impossible practice unless you're usingDBLINK...
>
>
>
> > Or is there some elegant way to achieve this?
>
> map a class to each table and use a relation() between them to load
> from one, then the other.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
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
-~----------~----~----~----~------~----~------~--~---
