【Python】sqlalchemy

创建数据库

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


# 创建Base类
Base  = declarative_base()

class Test(Base):
    __tablename__ = 'user'  # 表名
    id = Column(Integer, primary_key=True, autoincrement=True)  # id: int 主键 自增
    username = Column(String(20))
    password = Column(String(20))

# 连接mysql
# 参数：echo (调试程序时True，使用时False)
#       pool_size(默认5)  max_overflow=5
# engine = create_engine('mysql+pymysql://root:root@127.0.0.1:3306/test?charset=utf8',echo=True)
engine = create_engine('mysql+pymysql://root:root@127.0.0.1:3306/test?charset=utf8')


if __name__ == "__main__":
    # 创建所有表
    Base.metadata.create_all(engine)

增删改查

from sqlalchemy import create_engine, Column, String, Integer
from s