sqlalchemy.exc.ArgumentError: Mapper mapped class Myclass-＞myclass could not assemble any primary ke

【报错】sqlalchemy.exc.ArgumentError: Mapper mapped class Myclass->myclass could not assemble any primary key columns for mapped table ‘myclass’

错误代码

class Myclass(Base):
    __tablename__ = "myclass"
    id = db.Column(db.Integer, nullable=False)
    latest_success_time = db.Column(db.DateTime, nullable=True)  
    latest_failed_time = db.Column(db.DateTime, nullable=True)   
    success_time = db.Column(db.Integer)  # 用例执行成功次数
    run_count = db.Column(db.Integer)  # 用例执行次数

错误原因

mysql创建的表必须包含一个主键，以上orm模型中，缺少主键，故创建失败

正确代码

class Myclass(Base):
    __tablename__ = "myclass"
    id = db.Column(db.Integer, primary_key=True, index=True)
    latest_success_time = db.Column(db.DateTime, nullable=True)  
    latest_failed_time = db.Column(db.DateTime, nullable=True)   
    success_time = db.Column(db.Integer)  # 用例执行成功次数
    run_count = db.Column(db.Integer)  # 用例执行次数