擅长:python、mysql、java
<p>我需要添加一个<code>backref</code>到我的<code>SalesManager</code>模型中,它允许SQLAlchemy计算如何从<code>SalesManager</code>到分支。</p>
<pre><code>class SalesManager(Model):
__tablename__ = 'sales_manager'
id = Column(Integer, primary_key=True)
branches = relationship(
'Branch', secondary=sales_manager_branches, backref="salesmanagers")
</code></pre>
<p>然后像这样构造查询:</p>
<pre><code>Customer.query.\
join(Branch).\
join(Branch.salesmanagers).\
filter(SalesManager.id == 1).all()
</code></pre>