sqlalchemy 不同数据库相同表名model时bug解决方法 Table ‘xxx‘ is already defined for this MetaData

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

dangsh_

2510人浏览 · 2021-02-26 13:57:01

dangsh_ · 2021-02-26 13:57:01 发布

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)