Hi again Mike, or anyone else who has some good advice.
I've tried a similar setup but with a relation to a sub-class to context
and it seems that it doesn't have this problem when using joinedload. Any
hints on how to further debug this issue would be helpful
Thanks!
Mattias L
On Tuesday, November 3, 2015 at 3:32:02 PM UTC+1, Mattias Lagergren wrote:
>
> Hi Michael,
>
> I've been putting together a self-contained example. If you save it to a
> file test_model you should be able to run it:
>
>
> import sqlalchemy
> import sqlalchemy.orm
> import sqlalchemy.inspection
> import sqlalchemy.ext.declarative
>
> DATABASE_URL = <database-url>
>
> Base = sqlalchemy.ext.declarative.declarative_base()
>
>
> class Context(Base):
> '''Represent a context.'''
>
> context_type = sqlalchemy.Column(
> sqlalchemy.types.Unicode(32), nullable=False
> )
>
> __mapper_args__ = {
> 'polymorphic_on': context_type,
> 'polymorphic_identity': 'context'
> }
>
> __tablename__ = 'context'
>
> name = sqlalchemy.Column(
> sqlalchemy.types.Unicode(255), default=u'', nullable=False
> )
>
> id = sqlalchemy.Column(
> sqlalchemy.types.CHAR(36), primary_key=True
> )
>
> @classmethod
> def __declare_last__(cls):
> '''Return link expression query.'''
>
> # Import this module.
> import test_model as context
> context = sqlalchemy.orm.aliased(context.Context.__table__)
>
> # My real use-case is more complicated and involves a lot of
> joinst to
> # other tables, but this example reproduces the issue.
> cls.link = sqlalchemy.orm.column_property(
> sqlalchemy.select(
> [context.c.name + ' ' + context.c.context_type],
> from_obj=[context]
> ).where(
> context.c.id == cls.id
> ).label('link')
> )
>
>
> class Task(Context):
> '''Represent a task.'''
>
> __tablename__ = 'task'
>
> __mapper_args__ = {
> 'polymorphic_identity': 'task'
> }
>
> taskid = sqlalchemy.Column(
> sqlalchemy.types.CHAR(36),
> sqlalchemy.ForeignKey('context.id'),
> primary_key=True
> )
>
>
> class Asset(Base):
> '''Represent an Asset.'''
>
> __tablename__ = 'asset'
>
> assetid = sqlalchemy.Column(
> sqlalchemy.types.CHAR(36), primary_key=True
> )
>
> context_id = sqlalchemy.Column(
> sqlalchemy.CHAR(36), sqlalchemy.ForeignKey('context.id')
> )
>
> parent = sqlalchemy.orm.relationship(
> 'Context'
> )
>
>
> if __name__ == '__main__':
> print 'Loaded attributes: '
>
> # Create engine.
> engine = sqlalchemy.create_engine(
> DATABASE_URL
> )
> Session = sqlalchemy.orm.sessionmaker(bind=engine)
> session = Session()
>
> entity = session.query(
> Asset
> ).options(
> sqlalchemy.orm.joinedload('parent')
> ).first()
>
> state = sqlalchemy.inspection.inspect(entity.parent)
> for attribute in state.attrs:
> is_loaded = (
> attribute.loaded_value is not
> sqlalchemy.orm.base.NO_VALUE
> )
> if is_loaded:
> print attribute.key
>
>
>
>
>
> On Monday, November 2, 2015 at 3:16:07 PM UTC+1, Mattias Lagergren wrote:
>
> Hi,
>
> I'm trying to use load_only and joinedload on a relationship
> model.Asset.parent. The parent relation is polymorphic and can be either
> Task or Project with the common Base class called Context.
>
> import sqlalchemy.orm
> import sqlalchemy.inspection
>
> entity = model.session.query(
> model.Asset
> ).options(
> sqlalchemy.orm.joinedload('parent').load_only(
> 'context_type', 'name', 'link'
> )
> ).first()
>
> state = sqlalchemy.inspection.inspect(entity.parent)
> for attribute in state.attrs:
> is_loaded = (
> attribute.loaded_value is not
> sqlalchemy.orm.base.NO_VALUE
> )
> if is_loaded:
> print attribute.key
>
> # Output:
> id
> taskid
> name
> context_type
>
>
> The id, name and context_type is from Context. And taskid is primary key
> on the taskid and is a foreignkey to the context.id. As you can see
> "name" loads fine but "link" attribute is not loaded. The "link" column is
> added as a column_property to Context using a __declare_last__.
>
> These are simplified versions of the classes:
>
>
> class Context(Base):
> '''Represent a context.'''
> context_type = Column(Unicode(32), nullable=False)
>
> __mapper_args__ = {
> 'polymorphic_on': context_type,
> 'polymorphic_identity': 'context'
> }
>
> name = Column(Unicode(255), default=u'', nullable=False)
>
> @declared_attr
> def id(cls):
> return Column(CHAR(36), primary_key=True, default=lambda: str(uuid
> ()))
>
> @classmethod
> def __declare_last__(cls):
> '''Return link expression query.'''
>
> ...
>
> cls.link = column_property(
> sqla
>
> ...
--
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 [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
