#100DaysOfCode in Python Transcripts
Chapter: Days 91-93: Database access with SQLAlchemy
Lecture: Demo: Seeing the database
Login or
purchase this course
to watch this video and the rest of the course contents.
0:00
Before we put the wraps on our game, let's have a quick look inside the database. Julian already talked about DB Browser for SQlite,
0:07
runs on all the platforms this little thing. This is quite cool and if this is what you want to use I totally recommend it. It looks quite nice.
0:14
I'm a fan of PyCharm and PyCharm also already has tools for this. So if you go over to database, and you hit the + and say data source.
0:22
Now if we pick Sqlite serial, you'll have to make sure if it doesn't say driver, there's a little button to say download the driver here.
0:31
So if you don't do that, this is not going to work. But once that is done, I'm going to drag from here to there,
0:36
you can actually see what is in our database. Go to schema, to main, hit our moves players rolls. Roll moves is most interesting, let's look there.
0:43
Here you can see it's all the various pieces. These orange things mean these have indexes. Here's the actual details.
0:50
I can even come over here, jump to the console and say select star from, move to where, and you get all sorts of details.
0:57
Like let's say player id equals one, that's probably me. Then there's all the moves that I made since I entered first into the game.
1:06
Pretty sure my id is one, we can check that. Anyway here's how we query it, and you can see all the different games
1:12
that this has been running in and so on. So this is really nice when caveat this only works in PyCharm professional. If you have PyCharm community
1:19
well you're going to need to use something else right. The database access stuff is not part of that so I'd check out that DB browser for Sqlite.