SQLAlchemy类的映射

from sqlalchemy import create_engine
from sqlalchemy.orm import Session
from sqlalchemy.ext.automap import automap_base
if __name__ == "__main__":
    engine_str = 'sqlite:///:test.db'
    engine = create_engine(engine_str)
    session = Session(engine)
    # 下面这两句话就完成了ORM映射 Base.classes.XXXX即为映射的类
    # Base.metadata.tables['XXX']即为相应的表
    Base = automap_base()
    Base.prepare(engine, reflect = True, schema='basketball')
    # 查询操作
    result = session.query(Base.classes.users).all()
    # 插入操作
    item = Base.classes.users(name='lxq', password='1234')
    session.add(item)
    session.commit()
    
    session.close()

详细用法：http://docs.sqlalchemy.org/en/latest/orm/extensions/automap.html