创建数据库
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