On Apr 14, 2008, at 7:44 AM, Koen Bok wrote:
>
> Hey All,
>
> I was upgrading our app from 0.4.1 to 0.4.5 and this code broke:
>
> pg_user = Table('pg_user', metadata,
> Column('usesysid', Integer, primary_key=True),
> Column('usename', Unicode(), unique=True))
>
> pg_group = Table('pg_group', metadata,
> Column('grosysid', Integer, primary_key=True),
> Column('groname', Unicode(), unique=True),
> Column('grolist', PGArray(unicode)))
>
> mapper(PGUser, pg_user, properties={
> 'groups': relation(PGGroup, viewonly=True,
> primaryjoin=pg_user.c.usesysid==func.any(pg_group.c.grolist),
> foreign_keys=[pg_group.c.grolist])})
>
use the trunk and say:
mapper(PGUser, pg_user, properties={
'groups': relation(PGGroup, viewonly=True,
primaryjoin=pg_user.c.usesysid==func.any(pg_group.c.grolist),
foreign_keys=[pg_group.c.grolist],
_local_remote_pairs=[pg_user.c.usesysid, pg_group.c.grolist]
)})
this doesn't yet handle the full blown "functions/casts in primaryjoin
conditions" ticket but its part of the way there.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
