MongoDB for Developers with Python Transcripts
Chapter: Working with MongoDB directly from Python: PyMongo
Lecture: Concept: Atomic updates
0:01 Let's review the ideas behind these in place updates. So here we have more or less a complete MongoDB Python program
0:07 using PyMongo here, so we're going to import PyMongo, connect the local database, all the default options,
0:12 and we're going to either create or get access to the bookstore by saying client.bookstore, now we're going to insert an object
0:20 that has no favorited by element, right no list, it just has a title and isbn,
0:25 so after the insert, we're going to end up with an _id and a title and an isbn. And then maybe we want to add this idea of favorited by,
0:35 maybe you want to design this already that way and have an empty list there, but whichever more or less would work the same,
0:42 so we can say I would like to go find the book, the first part of our update statement is the where clause,
0:47 so find by primary key and remember, that's when we call insert_one that's results.inserted_id, so that's going to find the one and only the item
0:56 and then we're going to use the add to set operator and we just pass that as a string in PyMongo, and then we'll push on favorited by such and such.
1:04 We could also use $set to set, say $setTitle: the new book with updated title, or something like this right, so you can use this all over the place
1:15 and what's really cool, now you may be thinking oh this api is kind of crazy, we've got these these dollar operators
1:22 and it's a lot to learn if you're totally new to it, I realize but when we get to MongoEngine, you'll see that
1:27 MongoEngine does this transparently under the cover for us, so you can actually not have to do this,
1:32 you won't have to necessarily remember all of these but you'll get all the benefits that we're describing here.
1:37 If you're using PyMongo, you have to know the api really intimately so we're going to push this 1001 user id on to favorited by
1:43 and maybe we'll push 1002 as well if people signed up at the same time, they saw the same book, they loved it
1:51 and let's go head and push this 1002 again, well not the push operator, but the add to set operator, do this again, because it's add to set
1:57 we're going to get a new document that has new book title, the same isbn and two items and it's favorited by
2:04 and it's going to be 1001 and 1002, because add to set is item potent calling it once or calling it a hundred thousand times,
2:11 it has the same result, other than it might take longer to call it a hundred thousand times, right. So if it's already there it makes no difference
2:17 but if it's not there to push it in super cool operator, really taking advantage of the hierarchical nature of these documents.