async def test_doublefk_filter(self):
qset = DoubleFK.filter(left__name="one")
result = await qset
query = qset.query.get_sql()
self.assertRegex(query, self.join1_match)
self.assertEqual(result, [self.middle])
async def test_doublefk_filter_values(self):
qset = DoubleFK.filter(left__name="one").values("name")
result = await qset
query = qset.query.get_sql()
self.assertRegex(query, self.select_match)
self.assertRegex(query, self.join1_match)
self.assertEqual(result, [{"name": "middle"}])
