ORDERID_correct_type_mongo.py

import pymongo

# get mongo sslog ids and ORDERIDS
ORDERIDs = {log['_id']: log['data']['fieldvalues']['ORDERID']['value']
            for log in sslog.find({'data.fieldvalues.ORDERID.value': {'$exists': True}}, {'data.fieldvalues.ORDERID.value': 1})}

# do some parsing because there was all sorts of badness - floats cast as strings, integers, etc
def order_id_to_string(_id, orderid):
    try: 
        orderid = str(int(float(orderid)))
    except ValueError:
        pass
    
    return _id, orderid

# run that function against the result set from my mongo query
type_corrected_orderids = [order_id_to_string(k,v) for k, v in ORDERIDs.items()]

# Update the sslogs
for k,v in type_corrected_orderids:
    sslog.update_one({'_id': k},
                 {'$set': {'data.fieldvalues.ORDERID.value': v}})