Check Overlapping intervals integerfield validation django python

user_18747855 0
Viewed 52

can anyone help me how to solve overlapping validation in django

moldel.py

 start = IntegerRangeField()
 end = IntegerRangeField()

form.py

class CheckForm(forms.ModelForm): def clean(self):

start=cleaned_data.get("start")
    end = cleaned_data.get("end")
    conflicts = Check.objects.filter(
        start_bbch__lte=end,
        end_end__gte=start,
    )
    if any(conflicts):
        raise forms.ValidationError(_("overlapping not allowed" % conflicts.count()))
    return cleaned_data
django-validation django-forms django-models django python
1 Answers

I think to check for overlapping you need to make sure that neither the start nor the end of your new object is within an existing interval.

So I would suggest something like this:

conflicts = Check.objects.filter(
    start_bbch__gte=start, end_end__lte=start
) | Check.objects.filter(
    start_bbch__gte=end, end_end__lte=end
)
user_43791510
Related