Function test_distinct

tests/test_queryset.py:175–187

(db, intfields_data)

@pytest.mark.asyncio
async def test_distinct(db, intfields_data):
    # Test distinct
    await IntFields.filter(intnum__gte=70).update(intnum_null=80)
    await IntFields.filter(intnum_null__isnull=True).update(intnum_null=-1)

    assert await IntFields.all().order_by("intnum_null").distinct().values_list(
        "intnum_null", flat=True
    ) == [-1, 80]

    assert await IntFields.all().order_by("intnum_null").distinct().values("intnum_null") == [
        {"intnum_null": -1},
        {"intnum_null": 80},
    ]


@pytest.mark.asyncio