(function() { 'use strict'; var s = new ShardingTest({shards: 2}); // Make sure that findAndModify with upsert against a non-existent database and collection will // implicitly create them both assert.eq(undefined, assert.commandWorked(s.s0.adminCommand({listDatabases: 1, nameOnly: 1})) .databases.find((dbInfo) => { return (dbInfo.name === 'NewUnshardedDB'); })); var newlyCreatedDb = s.getDB('NewUnshardedDB'); assert.eq(0, newlyCreatedDb.unsharded_coll.find({}).itcount()); newlyCreatedDb.unsharded_coll.findAndModify( {query: {_id: 1}, update: {$set: {Value: 'Value'}}, upsert: true}); assert.eq(1, newlyCreatedDb.unsharded_coll.find({}).itcount()); // Tests with sharded database assert.commandWorked(s.s0.adminCommand({enablesharding: "test"})); s.ensurePrimaryShard('test', s.shard1.shardName); assert.commandWorked(s.s0.adminCommand({shardcollection: "test.sharded_coll", key: {_id: 1}})); var db = s.getDB('test'); var numObjs = 20; // Pre-split the collection so to avoid interference from auto-split assert.commandWorked(s.s0.adminCommand({split: "test.sharded_coll", middle: {_id: numObjs / 2}})); assert.commandWorked(s.s0.adminCommand( {movechunk: "test.sharded_coll", find: {_id: numObjs / 2}, to: s.shard0.shardName})); var bulk = db.sharded_coll.initializeUnorderedBulkOp(); for (var i = 0; i < numObjs; i++) { bulk.insert({_id: i}); } assert.commandWorked(bulk.execute()); // Put two docs in each chunk (avoid the split in 0, since there are no docs less than 0) for (var i = 2; i < numObjs; i += 2) { if (i == numObjs / 2) continue; assert.commandWorked(s.s0.adminCommand({split: "test.sharded_coll", middle: {_id: i}})); } s.printChunks(); assert.eq(numObjs / 2, s.config.chunks.count({"ns": "test.sharded_coll"}), 'Split was incorrect'); assert.eq(numObjs / 4, s.config.chunks.count({shard: s.shard0.shardName, "ns": "test.sharded_coll"})); assert.eq(numObjs / 4, s.config.chunks.count({shard: s.shard1.shardName, "ns": "test.sharded_coll"})); // update for (var i = 0; i < numObjs; i++) { assert.eq(db.sharded_coll.count({b: 1}), i, "2 A"); var out = db.sharded_coll.findAndModify({query: {_id: i, b: null}, update: {$set: {b: 1}}}); assert.eq(out._id, i, "2 E"); assert.eq(db.sharded_coll.count({b: 1}), i + 1, "2 B"); } // remove for (var i = 0; i < numObjs; i++) { assert.eq(db.sharded_coll.count(), numObjs - i, "3 A"); assert.eq(db.sharded_coll.count({_id: i}), 1, "3 B"); var out = db.sharded_coll.findAndModify({remove: true, query: {_id: i}}); assert.eq(db.sharded_coll.count(), numObjs - i - 1, "3 C"); assert.eq(db.sharded_coll.count({_id: i}), 0, "3 D"); assert.eq(out._id, i, "3 E"); } s.stop(); })();