MongoDB – How to Convert Field to Bool

mongodb

I'm trying to change field type to bool among all documents in collection. Here is the code

db.product.find().forEach(function(doc) {
if (doc.checked === "Y") {
doc.checked = true;
} else if (doc.checked === "N") {
doc.checked = false;
}
db.product.save(doc);
});

Mongodb returns no error but doesn't convert fields.

Best Answer

I solved problem using 'db.product.update' instead of 'db.product.save'

Related Solutions

MongoDB: Should I combine fields for performance in limited circumstances

Without combining the fields in your data set you could just create a compound index using both. No changes to your data necessary. To do so, just create the index like so:

db.collection.ensureIndex({"user" : 1, "domain" : 1})

Docs are here:

http://www.mongodb.org/display/DOCS/Indexes#Indexes-CompoundKeys

Once you have created such a compound key it essentially makes an index on the leftmost element (user in my example above) redundant, and so an index on user (if it exists) could be removed.

Don't forget that the query optimizer only runs every ~1000 queries, so you will have to hint() the index to make sure it is used if you are testing it out.

PHP MongoDB – How to Unset All Fields in a Document

To remove all fields (aside from _id), you can just update with an empty document:

<?php
    $collection->update(array('name' => 'Amy'), array());
?>

That will update the document leaving only the _id field.

Note that this won't free up any of the preallocated space for your capped collection.

Best Answer

Related Solutions

MongoDB: Should I combine fields for performance in limited circumstances

PHP MongoDB – How to Unset All Fields in a Document

Related Question