Find and replace text in Django objects' fields

README.md

Django Find and Replace

This was used to replace all the instances of old Media URLs with new ones, but could be used for any kind of text search/replace across Django objects.

1. Change the model import to whatever your app and model is.
2. Set the to_find and to_replace strings to whatever you need.
3. Change Post to your model name, and the fields to whatever field(s) you want to search and replace across.

I pasted all this into the Django shell to run it as I only needed it once.

To run it again you can then just change to_find and to_replace and run the same Post.objects.update... again.

django_find_replace.py

from django.db.models import F, Func, Value
from weblogs.models import Post

to_find = 'src="http://www.exmample.org/my/old/path/'
to_replace = 'src="https://my-new-bucket.s3.amazonaws.com/media/'

def replace_func(field_name, find_str, replace_str):
    return Func(
        F(field_name),
        Value(find_str), Value(replace_str),
        function='replace'
    )

Post.objects.update(
    excerpt     = replace_func('excerpt', to_find, to_replace),
    body        = replace_func('body', to_find, to_replace),
)