def setUp(self):
self.con = MockAlchemyBackend()
self.alltypes = self.con.table('functional_alltypes')
self.sa_alltypes = self.con.meta.tables['functional_alltypes']
self.meta = sa.MetaData()
self.sa_star1 = self._get_sqla('star1')
def test_multiple_db_different_backends():
con1 = MockBackend()
con2 = MockAlchemyBackend()
backend1_table = con1.table('alltypes')
backend2_table = con2.table('alltypes')
with pytest.raises(RelationError):
backend1_table.union(backend2_table)
def test_multiple_db_different_backends():
con1 = MockBackend()
con2 = MockAlchemyBackend()
backend1_table = con1.table('alltypes')
backend2_table = con2.table('alltypes')
expr = backend1_table.union(backend2_table)
with pytest.raises(
ValueError,
match=re.compile("multiple backends", flags=re.IGNORECASE),
):
expr.compile()
def test_multiple_db():
con1 = MockBackend()
con2 = MockAlchemyBackend()
con1.table('alltypes').union(con2.table('alltypes')).execute()
def con():
return MockAlchemyBackend()