| 447 | |
| 448 | @pytest.mark.asyncio |
| 449 | async def test_delete(db, intfields_data): |
| 450 | # Test delete |
| 451 | await (await IntFields.get(intnum=40)).delete() |
| 452 | |
| 453 | with pytest.raises(DoesNotExist): |
| 454 | await IntFields.get(intnum=40) |
| 455 | |
| 456 | assert await IntFields.all().count() == 29 |
| 457 | |
| 458 | rows_affected = ( |
| 459 | await IntFields.all().order_by("intnum").limit(10).filter(intnum__gte=70).delete() |
| 460 | ) |
| 461 | assert rows_affected == 10 |
| 462 | |
| 463 | assert await IntFields.all().count() == 19 |
| 464 | |
| 465 | |
| 466 | @requireCapability(support_update_limit_order_by=True) |