Building data-driven web apps with Flask and SQLAlchemy Transcripts
Chapter: Using SQLAchemy
Lecture: Inserting real PyPI data

Login or purchase this course to watch this video and the rest of the course contents.
0:00 One other thing, we also need to add system.path
0:03 Append to our path, this folder right here.
0:07 Because we're importing pypi.org
0:10 in PyCharm this is going to totally work smooth
0:13 because guess what?
0:14 PyCharm does that for us right there.
0:16 But if we try to run this outside
0:18 without setting this up as a package or something like this
0:21 it's not going to work so great.
0:24 So we're going to run Python out of our virtual environment.
0:27 Point it at and load data, here it goes.
0:29 So in the end we found 84 users, 96 packages, 5400 releases
0:34 embedded within those documents, 10 maintainers
0:36 25 languages, and 30 different licenses.
0:41 All right, well, that's it.
0:42 We should now have a whole lot more data over here.
0:45 And if we go look real quick
0:46 let's just go to the packages and jump to the console.
0:53 Say select * from packages, we run it.
0:58 We got a whole bunch of 'em.
0:59 Here's amqp, apters, argparse, flake8 and so on.
1:06 If we run it for releases
1:07 you're going to see a whole bunch of stuff.
1:08 And they're related to they're various packages
1:11 over here on the right. Pretty awesome huh?
1:13 So now when we run our app.
1:16 Move here and we click on it.
1:18 You can see, well, we're not quite using the data yet.
1:21 But, we're going to start using
1:22 all that data we just loaded up.
1:24 And dropping it into these locations.
1:27 So, that's going to be real awesome.
1:28 We have true, accurate, realistic, or even snapshot in time
1:33 real data from pypi
1:35 to work with to finish building out and testing our app.