sqlalchemy查询MySQL视图_SqlAlchemy:动态查询

虽然还没有测试，但使用SQLAlchemy ORM，您可以将表链接在一起，如下所示：from sqlalchemy import create_engine, Integer, String

from sqlalchemy.ext.declarative import declarative_base

from sqlalchemy import Column, ForeignKey

from sqlalchemy.orm import relationship

from asgportal.database import Session

Engine = create_engine('mysql+mysqldb://user:password@localhost:3306/mydatabase', pool_recycle=3600)

Base = declarative_base(bind=Engine)

session = Session()

session.configure(bind=Engine)

class DBOrganization(Base):

__tablename__ = 'table_organization'

id = Column(Integer(), primary_key=True)

name = Column(ASGType.sa(ASGType.STRING))

class DBEmployee(Base):

__tablename__ = 'table_employee'

id = Column(Integer(), primary_key=True)

n