This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
labs:namethatmovie [2016/04/22 12:19] lpeer [Exercise 4 - Query the IMDB Database] |
labs:namethatmovie [2020/08/31 21:03] (current) |
||
---|---|---|---|
Line 11: | Line 11: | ||
- Extract all relevant entries from the academy award nominees table on the linked website. | - Extract all relevant entries from the academy award nominees table on the linked website. | ||
- | - Design a database schema and create a sqlite database with the collected data. Make sure you give your database the columns: ** year **, ** event **, **movie**, **actor**, **role** and **won**. | + | - Design a database schema and create a sqlite database with the collected data. Make sure you give your database the columns: ** year **, ** event **, **movie**, **actor**, **role** and **won**. Be careful to [[https://docs.python.org/2/library/sqlite3.html|escape]] all strings when adding rows to the database. |
Line 25: | Line 25: | ||
===== Exercise 3 - Crawl Rottentomatoes ===== | ===== Exercise 3 - Crawl Rottentomatoes ===== | ||
- | To keep web traffic low and reduce the risk of being blacklisted, we have cloned some rottentomatoes pages and are hosting them locally. You can access the detail page through a unique url. Combine the year and movie title like this: http://10.0.0.2/m/year/title to access the local clone of the movie detail page. (Transform the movie title to lower case. Remove any apostrophe characters (') and replace spaces and backslashes (/) with underline characters (_)). | + | To keep web traffic low and reduce the risk of being blacklisted, we have cloned some rottentomatoes pages and are hosting them locally. You can access the detail page through a unique url. Combine the year and movie title like this: http://10.0.0.1/m/year/title to access the local clone of the movie detail page. (Transform the movie title to lower case. Remove any apostrophe characters (') and replace spaces and backslashes (/) with underline characters (_)). |
- Visit any of the local movie sites. Which element contains the [[https://en.wikipedia.org/wiki/Rotten_Tomatoes#Tomatometer_critic_aggregate_score|tomatometer]] score of the movie? Which element contains the audience score? | - Visit any of the local movie sites. Which element contains the [[https://en.wikipedia.org/wiki/Rotten_Tomatoes#Tomatometer_critic_aggregate_score|tomatometer]] score of the movie? Which element contains the audience score? |