python怎样实现多表连接查询_sqlalchemy：如何通过一个查询连接多个表？

正如@letitbee所说，将主键分配给表并正确定义关系以允许正确的ORM查询是最佳实践。有人说。。。

如果您有兴趣按照以下行编写查询：SELECT

user.email,

user.name,

document.name,

documents_permissions.readAllowed,

documents_permissions.writeAllowed

FROM

user, document, documents_permissions

WHERE

user.email = "user@email.com";

那么你应该去做一些事情，比如：session.query(

User,

Document,

DocumentsPermissions

).filter(

User.email == Document.author

).filter(

Document.name == DocumentsPermissions.document

).filter(

User.email == "user@email.com"

).all()

如果相反，您希望执行以下操作：SELECT 'all the columns'

FROM user

JOIN document ON document.author_id = user.id AND document.author == User.email

JOIN document_permissions ON document_permissions.document_id = document.id AND document_permissions.document = document.name

那么你应该按照以下思路来做：session.query(

User

).join(

Document

).join(

DocumentsPermissions

).filter(

User.email == "user@email.com"

).all()

关于那件事的一个说明。。。query.join(Address, User.id==Address.user_id) # explicit condition

query.join(User.addresses) # specify relationship from left to right

query.join(Address, User.addresses) # same, with explicit target

query.join('addresses') # same, using a string

有关详细信息，请访问docs。