sqlalchemy.exc.NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:pymysql

来源：6-7 开启flask多线程所带来的问题

鱼右

2018-12-13

from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker


# 创建数据库连接
engine = create_engine('mysql+pymysql://root@127.0.0.1:3306/flask')
session = sessionmaker(bind=engine)()


def require_trade():
    session.execute('select * from User')
    session.execute("insert into User(name, age) values('bomo', 13)")
    session.execute("insert into User(name, age) values(:name, :age)", {'name': 'bomo', 'age': 12})

    # 如果是增删改，需要commit
    session.commit()


def main():
    require_trade()
if __name__=="__main__":
    main()

requirement
sqlalchemy
pymysql
mac环境

老师,你能不能帮我看一下这个是什么错误.谢谢了

写回答

2回答