Python Application for Chinook Database
Learn how to use the Chinook database in an application using Python.
We'll cover the following...
We’re going to write it in Python to make it easy to browse the code using the anosql Python library. It’s very easy to embed SQL code in Python and keep the SQL clean and tidy in .sql
files.
Steps to implement the idea in the application code
To implement the same thing in application code, we have to do the following:
-
Fetch the list of genres (that’s one
select name from genre
query). -
Then, for each ...