为此，您首先需要
session制作一个
Query。此外，
relationship在MessageModel上使用可以很方便。
class MessageModel(base): __tablename__ = 'messages' player_id = Column(Integer,ForeignKey('chats.id'), nullable=False) message = Column(String(2000), nullable=False) time = Column(TIMESTAMP, server_default=func.now()) player = relationship(PlayerModel, backref="messages")这将在两个模型上创建关系。
results = (session.query(PlayerModel) .join(PlayerModel.messages) .values(PlayerModel.username, MessageModel.message, MessageModel.time))# results will be a generator object# This seems a bit convoluted, but here you go.resultlist = []for username, message, time in results: resultlist.append({'message': message, 'username': username, 'time': time})可能会有更优雅的方法来处理您的数据结构，但是这种方法应该可行。
