#100DaysOfCode in Python Transcripts
Chapter: Days 79-81: Basic Database Access with SQLite3
Lecture: Pulling data with SELECT
Login or
purchase this course
to watch this video and the rest of the course contents.
0:00
All right, now that we have our lovely table with Mike, Bob, and myself in it, and our very realistic addresses,
0:09
let's actually print some of that data out. So we're going to do that within the Python shell. Again, import sqlite3, getting tedious by now.
0:19
So, we will run our connection, con equals sqlite3.connect. addressbook.db. 'Kay, c = con.cursor to get our cursor.
0:38
Now to print the actual data within the database, we need to put this into a for loop, okay? Just bear with me, because we're going to
0:46
iterate over these three rows, okay? So, the way we do that, is we go for row in c.execute. We're going to select data.
1:01
Now what data were we going to select? We're going to select everything from our details table, all right, so for row in c.execute.
1:10
Select all from details. What next? Well, once it's got the row, we want to print the row. And that's it. And there are our three lines.
1:25
You've got these, the formatting's a bit off, it's actually taking that data, or the literal, the tuple for that, for that row, you know?
1:34
So it doesn't look that great. So to actually make that look a little bit better, let's just bring that back up to save me some time.
1:43
We can actually choose which column to view, so we can go print row... Zero. Julian, Bob, Mike. And once we have this sort of information,
2:00
you can start to pop a few strings together, you know, start making sentences from these, these sorts of database pulls.
2:09
So let's do one really quickly here. And there we go. So Julian lives at 123 Fake Street, blah blah blah, and his phone number X, okay?
2:20
And that's the sort of manipulation we can do by pulling the data out of the database.