MongoDb replacing a document and inserting when non-existant

Question

I want to replace a document when this already exists and if it doesn't I want it inserted. How can I do that in mongoDb?

I need something like this, but in one query:

find by a "where statement"
if exists, replace whole document
else, insert

Thank you!

Answer 1

you could also use the save operation, that is much faster than the update (x70 faster from my tests), and is adapt to your purpose, but in case remember to give in input the whole document

Answer 2

Use collection update.

In the example below, the first update call will "insert or replace" the document (including name field from the query). In the second the update call will insert the document or just update Joe's job leaving the rest of the document intact. The difference is the "$set" operation.

<?php

$c->update(
    array("name" => "joe"),
    array("username" => "joe312", "job" => "Codemonkey"), 
    array("upsert" => true));

$c->update(
    array("name" => "joe"),
    array("$set" => array("job" => "Bartender")), 
    array("upsert" => true));

?>