跨数据库加入sqlalchemy
|
SQLAlchemy中是否有一种方法可以进行跨数据库联接。具体来说，这是我的用例：
架构图
db1.entity1
entity1_id：主键
entity2_id：db2.entity2.entity2_id的外键
db2.entity2
entity2_id：主键
模型
我正在为模型使用声明式样式。
class Entity1(Base):
__tablename__ = \'entity1\' ## I tried combination of <db>.<table> with no success
entity1_id = Column(Integer, primary_key=True)
entity2_id = Column(Integer, ForeignKey(\'db2.entity2.entity2_id\'))
entity2 = relationship(\'Entity2\')
class Entity2(Base):
__tablename__ = \'entity2\' ## I tried combination of <db>.<table> with no success
entity2_id = Column(Integer, primary_key=True)
没有找到相关结果
已邀请:
1 个回复
摊揉售
参数传递给。当使用声明式基进行ORM映射时，可以通过类的属性提供此额外参数。class Entity2(Base): __tablename__ = \'entity2\' ## I tried combination of <db>.<table> with no success __table_args__ = {\'schema\': \'db2\'} entity2_id = Column(Integer, primary_key=True) class Entity1(Base): __tablename__ = \'entity1\' ## I tried combination of <db>.<table> with no success __table_args__ = {\'schema\': \'db1\'} entity1_id = Column(Integer, primary_key=True) entity2_id = Column(Integer, ForeignKey(Entity2.entity2_id)) entity2 = relationship(\'Entity2\')