How can I use regex in django's Replace function

Viewed 622

I'm trying to update all urls in my query by using django's update and Replace function using regex. Here's what I've tried so far but it seems like django's Value expression did not recognize my regex.

from django.db.models import Value
from django.db.models.functions import Replace

Foo.objects.filter(
    some_url__iregex=r'^\/some-link\/\d+\/').update(
    some_url=Replace(
        'some_url', Value(r'^\/some-link\/\d+\/'),
        Value('/some-link/')))

My goal is to remove all numbers after /some-link/ (e.g. /some-link/55/test to just /some-link/test)

1 Answers
Related