SQLAlchemy: Dynamically loaded backreference to another module

Question

Let's suppose that I have a User model in one module.

class User(Model):
    id = Column(Integer, primary_key=True)

Then I want to add a dynamically-loaded, many-to-one relationship towards User from a Post model in another module. Also, I don't want to 'pollute' the User's model definition with relationships from this other module.

Is there a cleaner way of doing this other than adding a field to the User class from outside of the Post model, like this?

class Post(Model):
    user_id = Column(Integer, ForeignKey('user.id'))

User.posts = relationship('Post', backref='user', lazy='dynamic')

Thanks

Answer 1

Well, you can define it in the Post model (see below)

class Post(Model):
    user_id = Column(Integer, ForeignKey('user.id'))
    user = relationship('User', backref=backref('posts', lazy='dynamic'))