Search and replace for OpenPype's MongoDB

main.py

import re
from pymongo import MongoClient

# Connect to the MongoDB server
client = MongoClient("mongodb://mongodb://localhost:27017")

# Select the desired database and collection
db = client["avalon"]
collection = db["your-project-name"]

# Select what we should change from -> to
from_str = r"\\publish\\"
to_str = r"\\work\\publish\\"

# Change all "data" and "path" to match the location you wish to search and replace in
documents = collection.find({"data.path": {"$regex": from_str}})
for document in documents:
    updated_path = re.sub(from_str, to_str, document["data"]["path"])
    result = collection.update_one(
        {"_id": document["_id"]}, {"$set": {"data.path": updated_path}}
    )
    print(f"Modified {result.modified_count} documents.")