The upsert operation

MongoDB Fundamentals Updating and deleting
2 minutes
Share the link to this page
Copied
  Completed
You need to have access to the item to view this lesson.
One-time Fee
$49.99
List Price:  $69.99
You save:  $20
€48.05
List Price:  €67.28
You save:  €19.22
£39.95
List Price:  £55.93
You save:  £15.98
CA$70
List Price:  CA$98.01
You save:  CA$28
A$77.04
List Price:  A$107.87
You save:  A$30.82
S$67.44
List Price:  S$94.42
You save:  S$26.98
HK$389.10
List Price:  HK$544.78
You save:  HK$155.67
CHF 44.44
List Price:  CHF 62.22
You save:  CHF 17.78
NOK kr556.72
List Price:  NOK kr779.46
You save:  NOK kr222.73
DKK kr358.40
List Price:  DKK kr501.79
You save:  DKK kr143.39
NZ$85.70
List Price:  NZ$119.98
You save:  NZ$34.28
د.إ183.61
List Price:  د.إ257.07
You save:  د.إ73.45
৳6,001.50
List Price:  ৳8,402.58
You save:  ৳2,401.08
₹4,222.56
List Price:  ₹5,911.93
You save:  ₹1,689.36
RM223.33
List Price:  RM312.68
You save:  RM89.35
₦84,537.08
List Price:  ₦118,358.68
You save:  ₦33,821.60
₨13,893.48
List Price:  ₨19,451.98
You save:  ₨5,558.50
฿1,729.40
List Price:  ฿2,421.30
You save:  ฿691.90
₺1,728.30
List Price:  ₺2,419.75
You save:  ₺691.45
B$290.56
List Price:  B$406.81
You save:  B$116.24
R904.38
List Price:  R1,266.21
You save:  R361.82
Лв93.87
List Price:  Лв131.43
You save:  Лв37.55
₩70,321.20
List Price:  ₩98,455.31
You save:  ₩28,134.10
₪186.14
List Price:  ₪260.61
You save:  ₪74.47
₱2,946.86
List Price:  ₱4,125.84
You save:  ₱1,178.98
¥7,723.73
List Price:  ¥10,813.84
You save:  ¥3,090.11
MX$1,023.24
List Price:  MX$1,432.62
You save:  MX$409.38
QR183.09
List Price:  QR256.35
You save:  QR73.25
P685.61
List Price:  P959.91
You save:  P274.30
KSh6,473.70
List Price:  KSh9,063.70
You save:  KSh2,590
E£2,483.19
List Price:  E£3,476.67
You save:  E£993.47
ብር6,258.40
List Price:  ብር8,762.26
You save:  ብር2,503.86
Kz45,623.90
List Price:  Kz63,877.12
You save:  Kz18,253.21
CLP$48,677.26
List Price:  CLP$68,152.06
You save:  CLP$19,474.80
CN¥362.39
List Price:  CN¥507.37
You save:  CN¥144.98
RD$3,026.05
List Price:  RD$4,236.71
You save:  RD$1,210.66
DA6,682.11
List Price:  DA9,355.50
You save:  DA2,673.38
FJ$113.79
List Price:  FJ$159.32
You save:  FJ$45.52
Q387.67
List Price:  Q542.77
You save:  Q155.10
GY$10,507.02
List Price:  GY$14,710.67
You save:  GY$4,203.65
ISK kr6,982.10
List Price:  ISK kr9,775.50
You save:  ISK kr2,793.40
DH502.26
List Price:  DH703.21
You save:  DH200.94
L911.81
List Price:  L1,276.61
You save:  L364.79
ден2,937.49
List Price:  ден4,112.73
You save:  ден1,175.23
MOP$402.62
List Price:  MOP$563.70
You save:  MOP$161.08
N$908.73
List Price:  N$1,272.29
You save:  N$363.56
C$1,838.13
List Price:  C$2,573.53
You save:  C$735.40
रु6,757.51
List Price:  रु9,461.06
You save:  रु2,703.54
S/190.76
List Price:  S/267.08
You save:  S/76.32
K202.16
List Price:  K283.05
You save:  K80.88
SAR187.70
List Price:  SAR262.80
You save:  SAR75.09
ZK1,384.85
List Price:  ZK1,938.90
You save:  ZK554.05
L239.10
List Price:  L334.76
You save:  L95.66
Kč1,219.85
List Price:  Kč1,707.89
You save:  Kč488.04
Ft19,758.62
List Price:  Ft27,663.65
You save:  Ft7,905.03
SEK kr556.42
List Price:  SEK kr779.03
You save:  SEK kr222.61
ARS$50,191.65
List Price:  ARS$70,272.32
You save:  ARS$20,080.67
Bs347
List Price:  Bs485.83
You save:  Bs138.82
COP$221,888.26
List Price:  COP$310,661.31
You save:  COP$88,773.05
₡25,529.79
List Price:  ₡35,743.76
You save:  ₡10,213.96
L1,269.10
List Price:  L1,776.85
You save:  L507.74
₲394,167.14
List Price:  ₲551,865.53
You save:  ₲157,698.39
$U2,140.09
List Price:  $U2,996.30
You save:  $U856.20
zł208.79
List Price:  zł292.33
You save:  zł83.53
Already have an account? Log In

Transcript

Suppose I will find a product whose ID is hundred. And then I want to update few properties of the product. So we would say DB dot products dot update, and the query is underscore ID is 100. And then the updating document happens to be a new one, probably I can say, name equals to test product. And then I will say, unit price happens to be let's say 100.0. And a description of the same thing happens to be test description.

For now, I think these properties should be good enough. Let's save this and then run the same thing. To run that as a Mongo less than extend dot j s, press enter, and it comes back with a result. The result says number of matched documents is Zero upsetted zero modified zero. The reason is very simple. We don't have the document with an ID of 100.

So let's go check it out. I go to the Mongo test dB, and say, db dot products dot find underscore ID is 100. And you can see that it came back with nothing. We can also ask MongoDB to insert a new document in case if the update failed. Now this concept is called upsetting. So we come back to this particular code.

And then we specify here a third parameter where we say absurd is true. We say that search for this document, if it is found, you need to change this as the new document. If it's not found, you need to add that update or insert. So one more thing is that if the product already existed with multiple fields on The fields will be lost, and only these fields will be the new fields. So in order to avoid that I can say, dollar set. And then we can specify all these properties.

So let's execute the script and check the result. And this time it is number of matched documents is zero, number of absurd document is one modified is zero, the ID generated happens to be 100. And that's because we supplied that, let's go and verify the same thing. Type Mongo, test two DVDs, and then I'd say DB dot products dot find one with an ID of 100. And the VC that isn't

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.