Hi! I don't even quote my old message since it's just confusing. In my head the question made sense ;)
So I try again with a code example: I have a class `User`: #+BEGIN_SRC python class User(Base): id = Column(Integer, primary_key=True) name = Column(String(64)) email = Column(String(64)) languages = relationship('Language', secondary='user_languages') #+END_SRC I already have a lot of users stored in my DB. And I know that I have, for example, this user in my DB: #+BEGIN_SRC python user_dict = { 'id': 23, 'name': 'foo', 'email': 'foo@bar', } #+END_SRC So I have all the attributes but the relations. Now I want to make a sqlalchemy `User` instance and kind of register it in sqlalchemy's system so I can get the `languages` if needed. #+BEGIN_SRC python user = User(**user_dict) # Now I can access the id, name email attributes assert user.id == 23 # but since sqlalchemy thinks it's a new model it doesn't # lazy load any relationships assert len(user.languages) == 0 # I want here that the languages for the user with id 23 appear # So I want that `user` is the same as when I would have done user_from_db = DBSession.query(User).get(23) assert user == user_from_db #+END_SRC The use-case is that I have a big model with lots of complex relationships but 90% of the time I don't need the data from those. So I only want to cache the direct attributes plus what else I need and then load those from the cache like above and be able to use the sqlalchemy model like I would have queried it from the db. Hope it makes a bit more sense now. Sorry for the confusing first question and wasting your time. Thanks, Daniel -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- 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 https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.