sqlalchemy.exc.InvalidRequestError: Table ‘portfolio_risk_data’ is already defined for this MetaData instance. Specify ‘extend_existing=True’ to redefine options and columns on an existing Table object.

在两个不同数据库中有同名的表,建model的时候报这个bug
加一个metadata = MetaData()即可

from sqlalchemy import MetaData

class TestA(db.Model, FormatMixin):
    __tablename__ = "test"

    test= db.Column(db.String(16), primary_key=True)
    
    
class TestB(db.Model, FormatMixin):
    __bind_key__ = 'conf'
    __tablename__ = "test"
    metadata = MetaData()

    test= db.Column(db.String(16), primary_key=True)
    
Logo

一站式 AI 云服务平台

更多推荐