Re: [Sqlalchemy-users] sqlite: 3-way join fails

2006-07-28 Thread Jonathan Ellis
Looking closer it doesn't look like there is a workable SA fix. :-|On 7/25/06, Michael Bayer <[EMAIL PROTECTED] > wrote:whats the SA fix for this ?  other than just documenting, say "join(foo, bar).join(bat)" instead of "join(foo, join(bar, bat))" ? On Jul 24, 2006, at 10:29 PM, Jonathan Ellis wrot

Re: [Sqlalchemy-users] sqlite: 3-way join fails

2006-07-25 Thread Michael Bayer
whats the SA fix for this ?  other than just documenting, say "join(foo, bar).join(bat)" instead of "join(foo, join(bar, bat))" ?On Jul 24, 2006, at 10:29 PM, Jonathan Ellis wrote:Looks like sqlite is allergic to the sql generated; works fine in postgres[for test/orm/mapper.py again]    def testjoi

Re: [Sqlalchemy-users] sqlite: 3-way join fails

2006-07-24 Thread Jonathan Ellis
On 7/24/06, Jamie Wilkinson <[EMAIL PROTECTED]> wrote: This one time, at band camp, Jonathan Ellis wrote:>Looks like sqlite is allergic to the sql generated; works fine in postgres>>[for test/orm/mapper.py again]>   def testjoin3tables(self):>   class Joined(object): >   pass>   j =

Re: [Sqlalchemy-users] sqlite: 3-way join fails

2006-07-24 Thread Jamie Wilkinson
This one time, at band camp, Jonathan Ellis wrote: >Looks like sqlite is allergic to the sql generated; works fine in postgres > >[for test/orm/mapper.py again] > def testjoin3tables(self): > class Joined(object): > pass > j = join(users, join(orders, orderitems), isouter=Tr

[Sqlalchemy-users] sqlite: 3-way join fails

2006-07-24 Thread Jonathan Ellis
Looks like sqlite is allergic to the sql generated; works fine in postgres[for test/orm/mapper.py again]    def testjoin3tables(self):    class Joined(object):            pass    j = join(users, join(orders, orderitems), isouter=True)     m = mapper(Joined, j, allow_null_pks=True)