sqlalchemy 补充

from sqlalchemy import Column, String, create_engine,Integer
from sqlalchemy.orm import sessionmaker
from sqlalchemy.ext.declarative import declarative_base

# 创建一个对象的基类
Base = declarative_base()


# 定义 USER对象
class User(Base):
    # 表的名字
    __tablename__ = 'users'
    # 表的结构
    id = Column(Integer, primary_key=True)
    name = Column(String(20))
    age = Column(String(20))
    # def __repr__(self):  可以定义返回值



engine = create_engine('mssql+pymssql://sa:sasa@localhost:1433/my')
DBsession = sessionmaker(bind=engine)

session = DBsession()
obj = session.query(User).all()
for i in obj:
    print(i.name)
session.close()