查询表1
user = session.query(User).filter(User.name==‘myname‘).all()
查询表2
User.__table__.name = ‘users_1‘ user = session.query(User).filter(User.name==‘myname‘).all()
在SQLAlchemy ORM中动态变更表名
标签：column 127.0.0.1 root ESS 需要 mys 查询 query 其他
在SQLAlchemy ORM中动态变更表名
sqlalchemy import create_engine
from sqlalchemy import Table, Column, Integer, String, MetaData
from sqlalchemy.orm import sessionmaker
metadata = MetaData()
from sqlalchemy.ext.declarative import declarative_base
Base = declarative_base()
class User(Base):
__tablename__ = ‘users‘
__table_args__ = {
‘mysql_engine‘: ‘InnoDB‘,
‘mysql_charset‘: ‘utf8‘
}
id = Column(Integer, primary_key=True)
name = Column(String(30))
fullname = Column(String(120))
password = Column(String(30))
engine = create_engine(‘mysql://root:@127.0.0.1/test?charset=utf8‘, echo=True)
Session = sessionmaker(bind=engine)
session = Session()