Friday, May 10, 2024
 Popular · Latest · Hot · Upcoming
18
rated 0 times [  22] [ 4]  / answers: 1 / hits: 26486  / 10 Years ago, mon, june 9, 2014, 12:00:00

In products collection, i have an Array of recentviews which has 2 fields viewedBy & viewedDate.



In a scenario if i already have a record with viewedby, then i need to update it. For e.g if i have array like this :-





recentviews : [ 
{
viewedby : abc,
vieweddate : ISODate(2014-05-08T04:12:47.907Z)
}
]


And user is abc, so i need to update the above & if there is no record for abc i have to $push.



I have tried $set as follows :-



db.products.update( { _id: ObjectId(536c55bf9c8fb24c21000095) },
{ $set:
{ recentviews:
{
viewedby: 'abc',
vieweddate: ISODate(2014-05-09T04:12:47.907Z)
}
}
}
)


The above query erases all my other elements in Array.


More From » node.js

 Answers
37

Actually doing what it seems like you say you are doing is not a singular operation, but I'll walk through the parts required in order to do this or otherwise cover other possible situations.



What you are looking for is in part the positional $ operator. You need part of your query to also find the element of the array you want.





db.products.update(
{
_id: ObjectId(536c55bf9c8fb24c21000095),
recentviews.viewedby: abc
},
{
$set: {
recentviews.$.vieweddate: ISODate(2014-05-09T04:12:47.907Z)
}
}
)


So the $ stands for the matched position in the array so the update portion knows which item in the array to update. You can access individual fields of the document in the array or just specify the whole document to update at that position.



db.products.update(
{
_id: ObjectId(536c55bf9c8fb24c21000095),
recentviews.viewedby: abc
},
{
$set: {
recentviews.$: {
viewedby: abc,
vieweddate: ISODate(2014-05-09T04:12:47.907Z)
}
}
)


If the fields do not in fact change and you just want to insert a new array element if the exact same one does not exist, then you can use $addToSet



db.products.update(
{
_id: ObjectId(536c55bf9c8fb24c21000095),
recentviews.viewedby: abc
},
{
$addToSet:{
recentviews: {
viewedby: abc,
vieweddate: ISODate(2014-05-09T04:12:47.907Z)
}
}
)


However if you are just looking for for pushing to an array by a singular key value if that does not exist then you need to do some more manual handling, by first seeing if the element in the array exists and then making the $push statement where it does not.



You get some help from the mongoose methods in doing this by tracking the number of documents affected by the update:



Product.update(
{
_id: ObjectId(536c55bf9c8fb24c21000095),
recentviews.viewedby: abc
},
{
$set: {
recentviews.$: {
viewedby: abc,
vieweddate: ISODate(2014-05-09T04:12:47.907Z)
}
},
function(err,numAffected) {

if (numAffected == 0) {
// Document not updated so you can push onto the array
Product.update(
{
_id: ObjectId(536c55bf9c8fb24c21000095)
},
{
$push: {
recentviews: {
viewedby: abc,
vieweddate: ISODate(2014-05-09T04:12:47.907Z)
}
}
},
function(err,numAffected) {

}
);
}

}
);


The only word of caution here is that there is a bit of an implementation change in the writeConcern messages from MongoDB 2.6 to earlier versions. Being unsure right now as to how the mongoose API actually implements the return of the numAffected argument in the callback the difference could mean something.



In prior versions, even if the data you sent in the initial update exactly matched an existing element and there was no real change required then the modified amount would be returned as 1 even though nothing was actually updated.



From MongoDB 2.6 the write concern response contains two parts. One part shows the modified document and the other shows the match. So while the match would be returned by the query portion matching an existing element, the actual modified document count would return as 0 if in fact there was no change required.



So depending on how the return number is actually implemented in mongoose, it might actually be safer to use the $addToSet operator on that inner update to make sure that if the reason for the zero affected documents was not just that the exact element already existed.


[#70658] Friday, June 6, 2014, 10 Years  [reply] [flag answer]
Only authorized users can answer the question. Please sign in first, or register a free account.
miles

Total Points: 256
Total Questions: 111
Total Answers: 104

Location: Benin
Member since Fri, Mar 24, 2023
1 Year ago
;