summaryrefslogtreecommitdiff
path: root/jstests/upsert4.js
blob: cbf7f2646f313bd457653b9f0635bebe80a7c7f0 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
// tests to ensure fields in $and conditions are created when using the query to do upsert
coll = db.upsert4;
coll.drop();

coll.update({_id: 1, $and: [{c: 1}, {d: 1}], a: 12} , {$inc: {y: 1}} , true);
assert.gleSuccess(db, "");
assert.docEq(coll.findOne(), {_id: 1, c: 1, d: 1, a: 12, y: 1})

coll.remove({})
coll.update({$and: [{c: 1}, {d: 1}]} , {$setOnInsert: {_id: 1}} , true);
assert.gleSuccess(db, "");
assert.docEq(coll.findOne(), {_id: 1, c: 1, d: 1})

coll.remove({})
coll.update({$and: [{c: 1}, {d: 1}, {$or: [{x:1}]}]} , {$setOnInsert: {_id: 1}} , true);
assert.gleSuccess(db, "");
assert.docEq(coll.findOne(), {_id: 1, c: 1, d: 1, x:1})

coll.remove({})
coll.update({$and: [{c: 1}, {d: 1}], $or: [{x: 1}, {x: 2}]} , {$setOnInsert: {_id: 1}} , true);
assert.gleSuccess(db, "");
assert.docEq(coll.findOne(), {_id: 1, c: 1, d: 1})

coll.remove({})
coll.update({r: {$gt: 3}, $and: [{c: 1}, {d: 1}], $or: [{x:1}, {x:2}]} , {$setOnInsert: {_id: 1}} , true);
assert.gleSuccess(db, "");
assert.docEq(coll.findOne(), {_id: 1, c: 1, d: 1})

coll.remove({})
coll.update({r: /s/, $and: [{c: 1}, {d: 1}], $or: [{x:1}, {x:2}]} , {$setOnInsert: {_id: 1}} , true);
assert.gleSuccess(db, "");
assert.docEq(coll.findOne(), {_id: 1, c: 1, d: 1})

coll.remove({})
coll.update({c:2, $and: [{c: 1}, {d: 1}]} , {$setOnInsert: {_id: 1}} , true);
assert.gleError(db, "");