MongoDB for Developers with Python Transcripts
Chapter: High-performance MongoDB
Lecture: Creating the big DB
0:01 Here we are in the github repository for this course
0:04 and notice we have this data section
0:06 and in here I have this thing called dealership db 250 K
0:09 that is this data that I just talked about,
0:12 with the 250 thousand cars, 100 thousand owners, that sort of thing.
0:16 So I'm going to put that over here on the desktop and unzip it
0:21 and if we look in here, you'll see that there's a cars collection and an owners collection,
0:29 and I don't believe we've spoken about how to get this data into MongoDB,
0:33 so let's go over here and I'll use RoboMongo,
0:37 notice we have these two dealership things that I have been playing with
0:42 and I want to create one called like test dealership or something to that effect.
0:46 We're going to restore this— how do we do that,
0:51 we'll go like this, we'll say mongorestore
0:55 and this is the way that we get this exported data imported into MongoDB,
1:00 now, the first thing you have to ask yourself is this additive to the database,
1:05 if it exists do you want to also insert this,
1:07 or do you want to have this be the database and replace anything it exists,
1:11 we want this one to replace existing data
1:14 so I'll say --drop and then I need to tell it what database
1:18 so I'll say db and I could say what you should say is this dealership,
1:23 but just because I don't want to wipe away what I currently have,
1:28 I'll say dealership example, but the code that you're going to run
1:31 expects the name of the database to be just a dealership;
1:34 and then I need to give it the folder that it's going to work from,
1:37 so I am just going to give it this folder like so, all right.
1:41 So mongorestore, drop to replace the data -- db to name it, and then the location,
1:46 we hit go, and it's going to go cranking away on this
1:50 and you can see it's inserting, inserting and done,
1:53 that was really fast for like close to 1.5 million records.
1:57 All right, so let's go over here and refresh
2:00 and here's our example and we can see that we have our collection,
2:03 here's our cars and we could just ask how many cars are there.
2:07 Notice, there is that many, and if we change this to owners,
2:11 remember you can also write it like this, owners like this,
2:16 Now notice, I think the restore data we got here,
2:19 you want to drop this index right here, I have it only have the id indexes, ok
2:26 so that's this example I just restored,
2:28 we're going to work with something you can imagine is exactly the same.
2:33 So we're going to work with this dealership code
2:36 but the way it got there, I'll show you the app I used to originally create it,
2:39 and then I just restored it using mongorestore just as I showed you up here.
2:43 So the way to generate the data that goes into mongorestore, you say mongo dump.