the relationship will not be fetched if it is never accessed. If you'd like to call append()/remove() on it, but not have it load when this occurs, lazy="dynamic" will do that. To disable loading under all circumstances including iteration, lazy="noload".
On Oct 24, 2011, at 6:10 PM, Devraj Mukherjee wrote: > Hi all, > > I have a model that loads a many relationship (User has many addresses) > > class User(Base): > __table__ = Base.metadata.tables['user'] > > addresses = relationship("Address", backref="user") > > For one of our queries I want to ensure that the relationship is not fetched. > > Is this possible? > > Thanks. > > -- > 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 > sqlalchemy+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. > -- 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 sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.