mongodb-remove-field.py

#!/usr/bin/python
"""
Remove every occurrence of some field, for every row, in MongoDB
"""

import sys, string
import common.mongodb
import common.json

from optparse import OptionParser

parser = OptionParser()
parser.add_option("-c", "--collection", dest="collection", help="collection name")
parser.add_option("-d", "--database", dest="database", help="database name")
parser.add_option("-f", "--field", dest="field", help="field name")
parser.add_option("-p", "--port", dest="port", help="port number for mongodb", type="int")
parser.add_option("--hostname", dest="hostname", help="hostname for mongodb")
(options, args) = parser.parse_args()

assert options.field is not None

collection = common.mongodb.collection(DATABASE=options.database, name=options.collection, PORT=options.port, HOSTNAME=options.hostname)
for doc in common.mongodb.findall_with_field(collection, field=options.field):
#    print "FAKING IT, not actually removing %s: %s" % (options.field, repr(doc[options.field]))
    print doc["_id"]
    del doc[options.field]
    collection.save(doc)