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"}])