adaptation within query.join() etc. being weird for column prop against instrumented col

the column_property expression fails to get adapted

from sqlalchemy import *
from sqlalchemy.orm import *
from sqlalchemy.ext.declarative import declarative_base

Base= declarative_base()


class A(Base):
    __tablename__ = "a"
    id      = Column(Integer, primary_key=True)
    type    = Column(String(40), nullable=False)
    __mapper_args__ = {'polymorphic_on': type}

    # works
    # anything = column_property(id + 1000)

# works
# A.anything = column_property(A.__table__.c.id + 1000)

# fails
A.anything = column_property(A.id + 1000)

class B(A):
    __tablename__ = "b"
    account_id      = Column(Integer, ForeignKey('a.id'), primary_key=True)
    x_id            = Column(Integer, ForeignKey('x.id'), nullable=False)
    __mapper_args__ = {'polymorphic_identity': 'named'}

class X(Base):
    __tablename__ = "x"
    id = Column(Integer, primary_key=True)
    b = relationship("B")

s = Session()

# joins:

print s.query(X, B).join("b")

# or joinedload()

print s.query(X).options(joinedload("b"))

# or subqueryload()

Comments (3)