sqlalchemy:如何通过一个查询联接多个表? [英] sqlalchemy: how to join several tables by one query?
本文介绍了sqlalchemy:如何通过一个查询联接多个表?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有以下SQLAlchemy映射的类:
I have the following SQLAlchemy mapped classes:
class User(Base):
__tablename__ = 'users'
email = Column(String, primary_key=True)
name = Column(String)
class Document(Base):
__tablename__ = "documents"
name = Column(String, primary_key=True)
author = Column(String, ForeignKey("users.email"))
class DocumentsPermissions(Base):
__tablename__ = "documents_permissions"
readAllowed = Column(Boolean)
writeAllowed = Column(Boolean)
document = Column(String, ForeignKey("documents.name"))
我需要为user.email = "user@email.com"
获取这样的表:
I need to get a table like this for user.email = "user@email.com"
:
email | name | document_name | document_readAllowed | document_writeAllowed
如何使用一个对SQLAlchemy的查询请求来完成?以下代码对我不起作用:
How can it be made using one query request for SQLAlchemy? The code below does not work for me:
result = session.query(User, Document, DocumentPermission).filter_by(email = "user@email.com").all()
谢谢
推荐答案
尝试一下
q = (Session.query(User,Document,DocumentPermissions)
.filter(User.email == Document.author)
.filter(Document.name == DocumentPermissions.document)
.filter(User.email == 'someemail')
.all())
这篇关于sqlalchemy:如何通过一个查询联接多个表?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文