Multiple-table criteria within DELETE

[pawamoy]

Opening a discussion rather than a bug since it's clearly marked as "not implemented".

I was trying to delete rows based on two criteria: the ID of a foreign key, and a string field.

return await ProjectDependency.objects.delete(project__id=project_id, git_branch=branch)

...and was getting the following error:

NotImplementedError: This backend does not support multiple-table criteria within DELETE

Fine, I can just filter first then delete using IDs only:

ids = await ProjectDependency.objects.filter(project__id=project_id, git_branch=branch).values_list(fields="id", flatten=True)
return await ProjectDependency.objects.delete(id__in=ids)

Nice.

But in fact there's an even easier way: a foreign key is an int, so it accepts an int (the ID), therefore it does not have to be "multiple-table criteria" (no join):

return await ProjectDependency.objects.delete(project=project_id, git_branch=branch)

🎉