Chapter 13. List Comprehensions: Database Integrations
With your database tables ready, it’s time to integrate.
Your webapp can gain the flexibility the Coach requires by using the datasets in your database tables, and in this chapter you create a module of utilities that lets your webapp exploit your database engine. And, in a never-ending quest to do more with less code, you’ll learn how to read and write list comprehensions, which are a genuine Python superpower. You’ll also reuse a lot of your pre-existing code in new and interesting ways, so let’s get going. There’s lots of integration work to do.
We’re looking forward to that, too.
To help us get there, the Head First Coders, concerned that our SQL skills might be a bit rusty, have sent over a file of SQL queries for you to consider using with your webapp.
The Coders suggested you’ll need to do a bit of extra work to use these queries to tackle Task #3 and #4, but they think the queries will help extract the data your webapp needs.
Recall the next two tasks, then take a look at the queries (copied from queries.py) on the next page.
Extract the data you need from your database tables.
At the moment, your webapp’s code ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Extract the data you need from your database tables.