mysql出现sqlalchemy.exc.NoSuchModuleError: Can‘t load plugin: sqlalchemy.dialects:pymysql.mysql

根据已有数据库生成 sqlalchemy数据表   flask 或 tornado使用

一、安装

1. pip install sqlalchemy
2. pip install pymysql
3. pip install sqlacodegen

二、py文件中放入代码

import pymysql
import os
ret = os.popen(
    "sqlacodegen --noviews --noconstraints --noindexes mysql+pymysql://root:pwd@127.0.0.1:3306/table_name > models.py"
)
#'{}+{}://{}:{}@{}:{}/{}'.format(dialect,driver,username,password,host,port,database)

三、生成models.py

from sqlalchemy import Column, Float, String, Text
from sqlalchemy.dialects.mysql import BIGINT, INTEGER
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()
metadata = Base.metadata


class ErrorJson(Base):
    __tablename__ = 'error_json'

    id = Column(INTEGER(11), primary_key=True)
    uid = Column(BIGINT(20))
    uid_json = Column(Text)