Function test_subquery_select

tests/test_queryset.py:771–778

(db)

@pytest.mark.asyncio
async def test_subquery_select(db):
    t1 = await Tournament.create(name="1")
    ret = (
        await Tournament.filter(pk=t1.pk)
        .annotate(ids=Subquery(Tournament.filter(pk=t1.pk).values("id")))
        .values("ids", "id")
    )
    assert ret == [{"id": t1.pk, "ids": t1.pk}]


@pytest.mark.asyncio