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)