Eve: Building RESTful APIs with MongoDB and Flask Transcripts
Chapter: Appendix: Deploying MongoDB
Lecture: Connecting to MongoDB via Python

Login or purchase this course to watch this video and the rest of the course contents.
0:01 Let's go back to our little play-around service app,
0:04 I'll go and run this for you, it probably looks familiar,
0:07 remember our service central version 2.0, this is demo edition
0:11 let me actually change that little header to prod edition, not that it much matters,
0:16 but we're going to set this up to run in our production environment.
0:19 If I try to do things like list the car, it will show me my local cars
0:24 because I'm running on my Mac, however if I push this up to the server
0:28 and I put it onto that fake web server server,
0:32 it's going to try to talk to local host and have a big fall,
0:35 right that's not going to work well.
0:38 So instead, what we need to do is we need to do is
0:41 we need to go and adjust our little connection bit here.
0:45 Now, let me go and actually add some parameters to this
0:50 we're going to add a password, say user, a password,
0:57 a port, a server, use ssl, and I think that'll do, okay.
1:07 So now I want to use those things to actually connect,
1:10 so we're going to have like this dual mode thing going on,
1:15 and I'll do it like this, we'll say if user or password,
1:20 so if either of those are set we're going to do something else,
1:24 we're going to just fall back and just do this little simple bit or right here,
1:30 here I'll do a print, registering dev connection,
1:35 so go like this, and it is not going to love it,
1:40 so let's go over here and give this some defaults, so none for all of these;
1:46 default here's to 27017, server=local host and use_ssl = false
2:01 actually let's go and default that to true.
2:06 Okay so now I should be able to run this here and list cars
2:11 actually up here we'll see registering dev connection
2:16 and let's put a little kind of indicator, something to the say
2:22 hey this is like an extra thing, so go over here and we'll say registering prod connection
2:32 and I want to give it some extra info, and let's hold off
2:36 and what goes there just for a second,
2:39 okay so we want to gather this up, we actually have to pass more information than this
2:42 and just to make sort of recording how we connected a little bit easier,
2:46 I'm going to create this dictionary where we set all these,
2:51 so username is this, password, server, port, authentication sources, admin
2:55 authentication mechanism is SCRAM-SHA-1,
2:59 ssl is, use ssl and we have to say ignore the self signed certificate
3:04 if we don't do this, it will say your certificate is not valid.
3:09 Now PyCharm warns that this thing is basically missing from ssl
3:15 but it's not, just ignore that.
3:17 So we're going to come over here, and we're going to do this as well
3:22 let's go and say, actually let me change the order real quick,
3:29 so we're going to say all of these are keyword arguments for this method
3:32 so we can just say **data
3:35 and that's going to basically set username= user, password = password and so on,
3:39 why did I put it like this— because I'd like to capture all those details.
3:42 So let me just do really quick data of password equals this,
3:52 and then I'll just print out this dictionary here
3:56 so registering, production, connection with those details.
3:59 Okay, so if you pass a username or password in
4:03 it's going to work differently, let's just make sure everything still runs
4:06 can I list the cars, see the dev connection, yeah, excellent.
4:11 So things are still working good on of the dev side of the story.
4:14 The next thing we've got to do is come over here where we're calling this,
4:18 and let's just go ahead and pass in all the details here.
4:25 We wanted to use ssl that defaults to true, so that's all good.
4:31 Now if I run this, you're going to see not amazing stuff
4:35 so like list is probably going to time out, it takes a while for it to time actually,
4:40 let's try to renegotiate the connection and it really doesn't want to crash
4:43 but eventually this is going to timeout,
4:46 we already saw we can't connect to the server here.
4:49 So let me push this up to the git repository
4:55 and then we'll get it on to the server and production and make sure everything works.
5:00 I pushed those changes to github and let's go over to the web server
5:05 see I am already here, I'm just in my home directory/root
5:10 so what I want to do is I want to go and get that code over here,
5:14 so we're going to go and go to the github repository for our code here
5:20 notice when I do a refresh, you should see
5:22 that I just added now with production capabilities,
5:26 so let's copy this, and let's say git clone this, its a public repository
5:31 so I don't need any credentials or any of that business.
5:39 Okay, so things are good, we'll go to Mongo and notice there's a source
5:44 and I have 09 deploys, so if we look in here,
5:50 we've got service central deploy and service starter,
5:55 server central deploy is the starter obviously it's what we started with,
5:58 the service central deploys is the one that we just changed;
6:03 so for example, if we look at this
6:08 you can see it's using this complicated version here,
6:12 if we look at this one, you can see we're setting a MongoDB just the way we like.
6:18 Okay, so now what we have to do is run it and let's go over here
6:24 connect to the MongoDb server and say show dbs,
6:29 hey there's nothing here, so let's go and run this,
6:33 so we've got our service deploy, so we'll say it Python 3
6:36 we didn't use a … or change its execution states.
6:41 Now one thing we need is we need to install Mongoengine of course
6:44 so let's do this, we'll just let Python do it,
6:47 so we'll save Python 3 -m venv to create a virtual environment,
6:56 here we need to apt install Python 3 -venv, try again,
7:08 so now we'll source activate this and our prompt changes.
7:15 Okay good, so now we should be able to run our Python 3 thing again,
7:19 oh yeah, well it's active, we still need to pip install Mongoengine
7:23 and that'll take PyMongo along with it.
7:27 I believe that failed building a wheel because set up tools is out of date,
7:32 anyway, it should still work. Let's give this another shot,
7:36 now we have Mongoengine registered in a virtual environment,
7:39 a virtual environment is active, our code is here
7:42 a lot of deployment stuff, let's go.
7:45 Oh, look at that, so now we're registering the production connection,
7:48 I mean, you probably don't want to print this out all the time
7:51 but notice the hosts, authentication, everything,
7:54 it seemed to take it like the register worked
7:56 we haven't tried to talk to the database yet, let's try to list the cars.
7:59 There are no cars, did that make in a dent?
8:04 No, no dent yet. Let's add a car this is going to be an F40,
8:10 it's going to be built in 2010, that didn't crash, let's try to list the cars,
8:17 look at that, let's add a service record, service that car.
8:24 The vin number is that, the price of the service is a thousand dollars
8:30 and this is going to be a new tires, the customer is extremely happy, loved it.
8:36 Now we've got our new tires, so look at this, show dbs,
8:40 use demo dealership, show collections, db.cars.find.pretty
8:52 bam, look at that, we were able to make our Python code
8:58 on the right machine with all the right settings,
9:00 and all the farewell rules and everything,
9:04 go over and talk to the MongoDB server.
9:06 This is pretty excellent, we can go add another car
9:10 obviously like at this point once you see it creating some documents
9:13 and working to some degree everything is going to work, right,
9:16 there's really nothing to it, so this is excellent,
9:19 let me just go create one more car so we have two things,
9:22 this is going to be Enzo and this was build very recently
9:29 let's list the cars and add a service record for it.
9:33 The Enzo needs some work, so for a 100 dollars that will be oil change,
9:40 pretty happy, yeah, one more, the same car,
9:47 this is going to be 250 tire rotation moderately happy,
9:53 so let's go over here and do this again.
9:56 There we go, we've got our Enzo with two service histories
9:59 our F40 with one service history and so on.
10:02 Okay excellent, so it looks like this is working,
10:05 I added this other record here so we have a little bit of data
10:08 because the next thing that we want to look at is how do we manage this,
10:11 how do we connect our database management tools
10:14 and backup things and what not to.
10:16 As far as Python goes, this baby is rocking.
10:19 I guess maybe connect one more time, boom, list the cars,
10:23 there they are, yeah looks good to me.