Mastering GUI Programming with Python

Chapter 9

1. Compose an SQL CREATE statement that builds a table to hold television schedule listings. Make sure it has fields for the date, time, channel, and program name. Also, make sure it has a primary key and constraints to prevent nonsensical data (such as two shows at the same time on the same channel, or a show with no time or date).

An example might look like this:

   CREATE TABLE tv_schedule AS (       id INTEGER PRIMARY KEY,       channel TEXT NOT NULL,       date DATE NOT NULL,       time TIME NOT NULL,       program TEXT NOT NULL,       UNIQUE(channel, date, time)   )

2. The following SQL query is returning a syntax error; can you fix it?

DELETE * FROM my_table IF category_id == 12;

There are several problems here:

• • DELETE does not take a field list, so * must be ...