That worked. Thanks! I'm excited for the 0.9 branch.
On Friday, November 1, 2013 1:26:31 PM UTC-6, Michael Bayer wrote:
>
> got lucky, the fix was pretty straightforward. if you can test again
> with latest master or rel_0_9 that would be great…thanks for the great bug
> report!
>
>
>
>
> On Nov 1, 2013, at 2:36 PM, Michael Bayer
> <mik...@zzzcomputing.com<javascript:>>
> wrote:
>
> its a significant issue, ticket #2858 is in progress.
>
>
> On Nov 1, 2013, at 2:08 PM, Rich <richar...@gmail.com <javascript:>>
> wrote:
>
> I'm having a small issue with 0.9b1. The example code below works for
> postgres, but fails with sqlite. It does work for sqlite on 0.8.3. It
> seems that the joinedload_all is causing something to reference the wrong
> alias.
>
>
> from sqlalchemy import *
> from sqlalchemy.orm import *
> from sqlalchemy.ext.declarative import *
>
>
> engine = create_engine('sqlite://')
> Base = declarative_base(bind=engine)
> metadata = Base.metadata
>
>
> account = Table('account', metadata,
> Column('account_id', Integer, key='id', primary_key=True),
> Column('name', String(255), nullable=False),
> )
>
> account_address_map = Table('account_address_map', metadata,
> Column('account_id', Integer, ForeignKey('account.id'),
> nullable=False),
> Column('address_id', Integer, ForeignKey('address.id'),
> nullable=False),
> Column('role_id', Integer, nullable=False)
> )
>
> address = Table('address', metadata,
> Column('address_id', Integer, key='id', primary_key=True),
> Column('address1', String(255), nullable=False),
> )
>
>
> mapping = account_address_map.select()\
> .where(account_address_map.c.role_id == 1)
>
>
> class Account(Base):
> __table__ = account
>
> service_address = relationship('Address',
> secondary=mapping,
> uselist=False,
> viewonly=True)
>
>
> class Address(Base):
> __table__ = address
>
>
> metadata.create_all()
> session = Session()
> session.query(Account).options(joinedload_all('service_address')).all()
>
>
> --
> You received this message because you are subscribed to the Google Groups
> "sqlalchemy" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to sqlalchemy+...@googlegroups.com <javascript:>.
> To post to this group, send email to sqlal...@googlegroups.com<javascript:>
> .
> Visit this group at http://groups.google.com/group/sqlalchemy.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
> --
> You received this message because you are subscribed to the Google Groups
> "sqlalchemy" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to sqlalchemy+...@googlegroups.com <javascript:>.
> To post to this group, send email to sqlal...@googlegroups.com<javascript:>
> .
> Visit this group at http://groups.google.com/group/sqlalchemy.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/groups/opt_out.
