comp3311-assignment2辅导

COMP3311 22T1 Assignment 2
Python, Psycopg2 and IMDB Database Systems
Last updated: Sunday 27th March 4:15pm
Most recent changes are shown in red … older changes are shown in brown.
[Assignment Spec] [Database Design] [SQL Schema] [Testing] [Sample Outputs] [Fixes+Updates]

Aims
This assignment aims to give you practice in

manipulating a moderately large database (IMDB)
implementing SQL views to satisfy requests for information
implementing PLpgSQL functions to satisfy requests for information
implementing Python scripts to extract and display data
The goal is to build some useful data access operations on the Internet Movie Database (IMDB), which contains a wealth of information about movies, actors, etc. You need to write Python scripts, using the Psycopg2 database connectivity module, to extract and display information from this database.

Summary
Submission: Submit required files on moodle
Required Files: q1.py q2.py q3.py q4.py xtras.sql (not necessary)
Deadline: 21:00 Friday 15 April
Marks: 20 marks toward your total mark for this course
Late Penalty: 0.1 marks off the ceiling mark for each hour late, no submission is accepted 5 days (120h) after the deadline
How to do this assignment:

read this specification carefully and completely
create a directory for this assignment
unpack the supplied files into this directory
run your PostgreSQL server
set up the supplied database (must be called imdb)
complete the tasks below by editing the files
q1.py … Python script to list people who have directed the most movies
q2.py … Python script to show world releases for a Movie
q3.py … Python script to show cast+crew for a Movie
q4.py … Python script to show biography/filmography of a Name
xtras.sql … Put any helper views or plpgsql functions here. It is not necessary.
submit these files on moodle (you can submit multiple times)
If there exists xtras.sql in your submission, we will first load the file into the database by “psql imdb -f xtras.sql” and then test your python scripts. Details of the above steps are given below.

Introduction
The Internet Movie Database (IMDB) is a huge collection of information about all kinds of video media. It has data about most movies since the dawn of cinema, but also a vast amount of information about TV series, documentaries, short films, etc. Similarly, it holds information about the people who worked on and starred in these video artefacts. It also hold viewer ratings and crticis reviews for video artefacts as well as a host of other trivia (e.g. bloopers).

The full IMDB database is way too large to let you all build copies of it, so we have have created a cut-down version of the database that deals with well-rated movies from the last 60 years. You can find more details on the database schema in the [Database Design] page.

Some comments about the data in our copy of IMDB: there seems to be preponderance of recent Bollywood movies; some of the aliases look incorrect (e.g. for “Shawshank Redemption”); the data only goes to mid 2019, so you won’t find recent blockbusters.

Assignment Setup
Server Setup. This section describes how to carry out this assignment. Some of the instructions must be followed exactly; others require you to exercise some discretion. The initial instructions are targetted at people doing the assignment on d.cse. For the assignment setup on your home computer, you’ll need to adapt instructions in Local Setup.

The first step in setting up this assignment is to go to your directory and get templates of your python scripts for this assignment. Note that you can create a subfolder to store all assignment files if you like.

vxdb$ cd /localstorage/YourZid … go to your working directory
vxdb$ unzip /home/cs3311/web/22T1/assignments/ass2/ass2.zip … unzip all template files to your current directory
Archive: /home/cs3311/web/22T1/assignments/ass2/ass2.zip
inflating: q1.py
inflating: q2.py
inflating: q3.py
inflating: q4.py
inflating: xtras.sql
The second step is to load the database. Note that the database dump is quite large. Do not copy into your assignment directory on the CSE servers, because you only need to read it once to build your database (see below).

… login to d.cse and source env as usual …
vxdb$ dropdb imdb … if you already had such a database
vxdb$ createdb imdb
vxdb$ bzcat /home/cs3311/web/22T1/assignments/ass2/database/imdb.dump.bz2 | psql imdb
vxdb$ psql imdb
… examine the database contents …
Note the database contains non-ascii characters, and so you will need to make sure that your PostgreSQL server uses UTF8 encoding (and corresponding collation) before it will load.

Loading the database should take less than 10 seconds on d.cse, assuming that d.cse is not under heavy load. (If you leave your assignment until the last minute, loading the database on d.cse will be considerably slower, thus delaying your work even more. The solution: at least load the database Right Now, even if you don’t start using it for a while.) (Note that the imdb.dump file is 20MB in size; copying the compressed version under your CSE home directory or your localstorage/ directory is not a good idea).

If you have other large databases under your PostgreSQL server on d.cse or you have large files under your /localstorage/YOU/ directory, it is possible that you will exhaust your d.cse disk quota. In particular, you will not be able to store a copy of the MyMyUNSW database as well as the IMDB database under your d.cse server. The solution: remove any existing databases before loading your IMDB database. Using remote-ssh extension of VScode may also cause the disk quota issue. So stop using it.

Local Setup. Before downloading assignment files, your local machine should have installed PostgreSQL, Python3 and Psycopg2. All files required in the assignment are listed below. You can download them by clicking the file name.

ass2.zip … templates of python script
imdb.dump.bz2 … compressed database dump file.
Download ass2.zip and imdb.dump.bz2 to your home computer, unzip them, and perform commands analogous to the above. You should have a copy of the IMDB database that you can use at home to do this assignment. Think of some questions you could ask on the database and work out SQL queries to answer them. One useful query is
imdb=# select * from dbpop();
This will give you a list of tables and the number of tuples in each.

Your Tasks
Answer each of the following questions by writing a Python/Psycopg2 script. You can add any SQL views or PLpgSQL functions that are used in your Python scripts into the file xtras.sql. If you want to use any other Python modules, make sure that they are available on d.cse; your submitted code will be tested on d.cse using the Python installed there. You can change the indentation from the two-space indent in the templates. Note that hardcoding is strictly forbidden. Below are several tips to do the assignment.

Use PostgreSQL’s case-insensitive regular expression pattern matching operator (~*) for matching partial names and titles. If you do this, it has the added advantage that your command-line arguments can be in any case you like, and you can even put regular expression chars into them.
Some of the questions below require you to display crew roles. In the database, these are stored as all lower-case with underscores replacing spaces, e.g. “production_manager”. When these are displayed, the first letter should be capitalised and each underscore should be replaced by a space character.
Several questions require to sort items in the result. These can be achieved by the SQL keyword ORDER BY.
Below is an example to run your scripts:

vxdb$ python3 q1.py 5
Q1 (2 marks)
Complete the script called “q1.py” so that it prints a list of the top N people who have directed the most movies (default N = 10). The script takes a single command-line argument which specifies how many people should appear in the list. People should be ordered from largest to smallest by the number of movies he/she directed, and should be displayed as, e.g.

vxdb$ python3 q1.py 5
48 Woody Allen
40 Takashi Miike
39 Jean-Luc Godard
37 Claude Chabrol
36 Martin Scorsese
Within groups of people with the same number of movies, people should be ordered alphabetically by his/her name (Names.name). If the user supplies a number less than 1, print the following message and exit.

vxdb$ python3 q1.py 0
Usage: q1.py [N]
For more examples of how the script behaves, see [Sample Outputs].

Q2 (3 marks)
Complete the script called “q2.py” so that it prints a list of the different releases (different regions, different languages) for a movie. The script takes a single command-line argument which gives a part of a movie name (could be the entire name or a pattern). If no argument is given, print the following message and exit.

vxdb$ python3 q2.py
Usage: q2.py ‘PartialMovieTitle’
If there are no movies matching the supplied partial-name, then you should print a message to this effect and quit the program, e.g.

vxdb$ python3 q2.py xyzzy
No movie matching ‘xyzzy’
If the partial-name matches multiple movies, simply print a list of matching movies (rating, title, year of release), ordered by rating (highest to lowest), then year of release (earliest to latest) and then by title (alphabetical order), e.g.

vxdb$ python3 q2.py mothra Movies matching ‘mothra’

7.1 Godzilla, Mothra and King Ghidorah: Giant Monsters All-Out Attack (2001)
6.6 Mothra (1961)
6.5 Mothra vs. Godzilla (1964)
6.2 Godzilla and Mothra: The Battle for Earth (1992)
If the partial name matches exactly one movie, then print that movie’s title and year, and then print a list of all of the other releases (aliases) of the movie. If there are no aliases, print “Title (Year) has no alternative releases”. For each alias, show at least the title. If a region exists, add this, and if a language is specified, add it as well, e.g.,

vxdb$ python3 q2.py 2001
2001: A Space Odyssey (1968) was also released as
‘2001’ (region: XWW, language: en)
‘Two Thousand and One: A Space Odyssey’ (region: US)
‘2001: Odisea del espacio’ (region: UY)
‘2001: Een zwerftocht in de ruimte’ (region: NL)
Movie releases should be ordered accoring to the ordering attribute in the Aliases table.

If an alias has no region or language, then put the string in the extra_info field in the parentheses. If it has neither region, language or extra info, just print the local title (without parentheses).

Note that if there are two movies with exactly the same original title, you will not be able to view their releases, since the title alone does not distinguish them. We consider this problem in the next question. Such tests will not be covered in this question.

For more examples of how the script behaves, see [Sample Outputs].

Q3 (5 marks)
Complete the script called “q3.py” so that it prints a list of cast and crew for a movie. The script takes a command-line argument which gives a part of a movie name (could be the entire name or a pattern). It also takes an optional command-line argument, which is a year and can be used to distinguish movies with the same title (or, at least, titles which match the partial movie name).

vxdb$ python3 q3.py
Usage: q3.py ‘MovieTitlePattern’ [Year]
If there are no movies matching the supplied partial-name, then you should print a message to this effect and quit the program, e.g.,

vxdb$ python3 q3.py xyzzy
No movie matching ‘xyzzy’
If the partial-name matches multiple movies, simply print a list of matching movies, the same as in Q2. If you need to disambiguate, either use a larger partial-name or add a year to the command line. If a longer partial-name and year still doesn’t disambiguate, print a list of matching movies as above.

If the command-line arguments identify a single movie, then print the movie details (title and year), followed by a list of the principal actors and their roles, followed by a list of the principal crew members and their roles. The list of actors should be sorted according to the ordering attribute in the Principals table (i.e the biggest star comes first) and then by the name of the role they played if the ordering attribute is equal (i.e. one actor plays multiple roles). The list of crew members should also be sorted according to the ordering attribute in the Principals table and then by role name, if the ordering attribute is the same (e.g. one person has multiple crew roles).

Some movies are not in Principals table, they will not be tested. For more examples of how the script behaves, see [Sample Outputs].

Q4 (6 marks)
Complete the script called “q4.py” so that it prints a filmography for a given person (Names), showing their roles in each of the movies they have been a principal in. The script takes a command-line argument which gives a part of a person’s name (could be the entire name or a pattern). It also takes an optional command-line argument, which is a year (their birth year) and which can be used to distinguish people with similar names. If there are no arguments or there are invalid arguments, print the following message and exit.

vxdb$ python3 q4.py
Usage: q4.py ‘NamePattern’ [Year]
If the name pattern, optionally combined with a year, doesn’t match anyone in the Names table, then you should print a message to this effect and quit the program

vxdb$ python3 q4.py Smmith
No name matching ‘Smmith’
If the name pattern, optionally combined with a year, matches more than one person, then print a list of the matching people, with the years they were born and died in parentheses afer the name. If birth year is invalid, e.g., null, regardless of whether death year is valid or not, print (???); if birth year is valid but death year is invalid, print (bbbb-); if both are valid, print (bbbb-dddd). Below is an example.

vxdb$: python3 q4.py rooney Names matching ‘rooney’

Darrell Rooney (???)
Frank Rooney (1913-)
Jennie Rooney (???)
Mickey Rooney (1920-2014)
Nancy Rooney (???)
Rooney Mara (1985-)
Sharon Rooney (1988-)
Order people by their names alphabetically, then by birth year in chronological order. If two people have the same name and birth year, put them in order of their Names.id value (ascending).

If the name pattern, optionally combined with a year, matches a single person, then you should print their name and birth and death years (use the above rules), followed by two parts:

The first part
Two pieces of information, the first one gives their ‘personal rating’, that is the average rating of all movies they have been a principal in. Use AVG() function to calculate the average, convert the average to decimal, then use ROUND(avg,1) to one decimal place. If no movie is found, set the persoanl rating as 0; the second one gives top 3 movie genres of all movies they have been a principal in. The movie genres should be ordered by the number of such movies they have been a principal in, then the genre name (alphabetically). If there are less than 3 genres in total, just print all of them. If no genre, leave blank. (See examples)
The second part
A list of all the movies (with start years) they have been a principal in. Movies should be in chronological order; if there are multiple movies in a given year, order them by title within the year. For each movie, show first any acting roles they had, including the role they played, and then any production crew roles they had. If a movie has him/her in its principal list but no acting roles or crew roles can be found, only print the movie title and its start year. If no movie is found, leave blank. (See examples)
Note that one person could be both an actor and a director in the same movie. If a person has multiple roles as an actor in one movie, then show the records in order of the role name. Similarly for multiple roles as a crew member, order by role name.

vxdb$ python3 q4.py ‘spike lee’ Filmography for Spike Lee (1957-)

Personal Rating: 7.1 Top 3 Genres: drama comedy documentary

She’s Gotta Have It (1986)
playing Mars Blackmon – acting role
as Director – crew role
as Writer
School Daze (1988)
as Director
as Writer
Do the Right Thing (1989)
as Director
as Writer
Mo’ Better Blues (1990)
playing Giant
as Director
as Writer
… etc. etc. etc. …
For more examples of how the script behaves, see [Sample Outputs].

Style & Performance (2 marks)
Your programming style will be marked according to the following criteria

consistent indentation (somewhat forced by Python)
meaningful variable/function names
efficient use of the database (see details below)
There is a performance requirement in each task. Any solution that takes longer than 10 seconds on any of our test cases will be penalised for that case, even if it eventually produces the correct result.

Submission & Testing
We will test your submission as follows:

create a testing subdirectory containing your xtras.sql and Python scripts
create a new database imdb and initialise it with imdb.dump.bz2
run the command: psql imdb -f xtras.sql (if you provide xtras.sql)
load and run the tests in the check script. (Additional test cases will be used for marking)
Your submitted code must be complete so that when we do the above, your python scripts and xtras.sql will load without errors, which accounts for 2 marks out of 20. You should throgouhly test your scripts before you submit them. If your Python or SQL scripts generate load-time errors and/or have missing definitions, you will be penalised by a 2 mark administrative penalty.

An example for the test script is provided in [testing]. Before submission, it would be useful to test out whether the submitted files work by following a similar sequence of steps to those noted above.

COMP3311 22T1 Assignment 2
The IMDB Database Database Systems
Last updated: Saturday 26th March 7:21pm
Most recent changes are shown in red … older changes are shown in brown.
[Assignment Spec] [Database Design] [SQL Schema] [Testing] [Sample Outputs] [Fixes+Updates]

Introduction
This document contains a description of the data model for the IMDB database. Note that schema is simplified from the original downloadable data available on line, and contains substantially less data. We consider only movies that were made after 1959 and have a reasonable rating. The original data contains a variety of other media types (e.g. TV series) and considers movies from the late 1800’s onwards, even junk ones with low ratings.

Data Model and Schema
This section aims to give an overview of the data model. It concentrates mainly on the entities and their relationships.
Treat the ER data model description below as an overview, and consult the SQL Schema for full details. The SQL schema makes some deviations from the ER design:

entity names are singular here, but plural in the SQL schema
attribute names are often shortened in the SQL schema
the Aliases entity is given as a weak entity here,
but has its own id (i.e strong entity) in the SQL schema
To make the presentation clearer, the data model is presented in a number of sections.

“People”
Entities and relationships related to people and other entities who appear in movies.

Movies and Aliases
Entities and relationships linking people and the unit they work in …

Overview
All entities (without attributes) and relationships between them

COMP3311 22T1 Assignment 2
MyMyUNSW Schema Database Systems
Last updated: Sunday 20th March 11:26pm
Most recent changes are shown in red … older changes are shown in brown.
[Assignment Spec] [Database Design] [SQL Schema] [Testing] [Sample Outputs] [Fixes+Updates]

database/schema.sql

– COMP3311 22T1 Ass2 … schema for IMDB data

create domain Counter integer check (value >= 0);
– these are ideal domain definitions
– create domain Minutes integer check (value > 0);
– create domain YearType integer check (value > 1800);
– unfortunately, the data in IMDB doesn’t agree
– so we use these instead
create domain Minutes integer check (value >= 0);
create domain YearType integer check (value >= 0);

create table Movies (
id integer,
title text not null,
orig_title text,
start_year YearType not null,
end_year YearType,
runtime Minutes,
rating float,
nvotes Counter,
primary key (id)
);

create table Movie_genres (
movie_id integer, – not null because PK
genre text, – not null because PK
foreign key (movie_id) references Movies(id),
primary key (movie_id, genre)
);

create table Aliases (
id integer,
movie_id integer not null,
ordering Counter not null,
local_title text not null,
region char(4),
language char(4),
extra_info text,
foreign key (movie_id) references Movies(id),
primary key (id)
);

create table Names (
id integer,
name text not null,
birth_year YearType, – ideally, not null
death_year YearType,
primary key (id)
);

create table Principals (
movie_id integer, – not null because PK
ordering Counter, – not null because PK
name_id integer not null,
foreign key (movie_id) references Movies(id),
foreign key (name_id) references Names(id),
primary key (movie_id, ordering)
);

create table Acting_roles (
movie_id integer, – not null because PK
name_id integer, – not null because PK
played text, – not null because PK
foreign key (movie_id) references Movies(id),
foreign key (name_id) references Names(id),
primary key (movie_id,name_id,played)
);

create table Crew_roles (
movie_id integer, – not null because PK
name_id integer, – not null because PK
role text, – not null because PK
foreign key (movie_id) references Movies(id),
foreign key (name_id) references Names(id),
primary key (movie_id,name_id,role)
);

COMP3311 22T1 Assignment 2
Testing Database Systems
Last updated: Monday 28th March 11:30pm
Most recent changes are shown in red … older changes are shown in brown.
[Assignment Spec] [Database Design] [SQL Schema] [Testing] [Sample Outputs] [Fixes+Updates]

A shell script is available to assist with testing:

/home/cs3311/web/22T1/assignments/ass2/check
Note that the check script can only be used on Linux platforms. For Windows local users, you can run each test case and compare the results manually on your local machine. Then upload your codes and run the check script on d.cse server.

First, get test cases (tests.zip for both Linux and MacOS) and the check script (check for Linux or check for MacOS) into your working directory. Extract test cases from the zip file. Keep them in the tests folder. Below is the commands on the server. Download the files to your home machine by clicking the file names above.

vxdb$ cd /localstorage/YourZid
vxdb$ cp /home/cs3311/web/22T1/assignments/ass2/check .
vxdb$ cp /home/cs3311/web/22T1/assignments/ass2/tests.zip .
vxdb$ unzip tests.zip -d tests
Archive: tests.zip
inflating: tests/01.expected
extracting: tests/02.expected
inflating: tests/03.expected
extracting: tests/04.expected
extracting: tests/05.expected
…
Put all your Python scripts in the same directory of check. If you list all files and directories in your working directory. You should at least have: check script, your python scripts q1.py, q2.py, q3.py, q4.py, and tests/ folder which includes all test cases.

vxdb$ ls
check q1.py q2.py q3.py q4.py xtras.sql tests tests.zip
Next, load the IMDB database if you don’t have one or if you want a fresh copy.

vxdb$ psql imdb -f xtras.sql
Now you can run check script to check your outputs and running times. This may take a while, especially if some of your queries are slow.

vxdb$ ./check
Test 01 PASSED (.18s)
Test 02 PASSED (.20s)
Test 03 PASSED (.18s)
Test 04 PASSED (.05s)
Test 05 PASSED (.05s)
Test 06 PASSED (.25s)
Test 07 PASSED (.05s)
Test 08 PASSED (.12s)
…
Cases 1–6 test q1.sql. Cases 7–15 test q2.sql. Cases 16–25 test q3.sql. Cases 26–39 test q4.sql. See the tests/tests script file for details of each case. If your output has the same records to the expected one but in an incorrect order, or your output is incorrect, you may get the following messages:

vxdb$ ./check
Test 01 Different order (.18s)
Check differences using ‘diff tests/01.observed tests/01.expected’
…
Test 10 FAILED (.20s)
Check differences using ‘diff tests/10.observed tests/10.expected’
…
If you have errors, you can always look at the expected results and compare them manually to your results. If you think that any of our expected results are incorrect, let us know and we can make a new version of check that you can reload.

COMP3311 22T1 Assignment 2
Sample Outputs Database Systems
Last updated: Saturday 26th March 5:31pm
Most recent changes are shown in red … older changes are shown in brown.
[Assignment Spec] [Database Design] [SQL Schema] [Testing] [Sample Outputs] [Fixes+Updates]

The following give some sample inputs and outputs that you can use to estimate the correctness of your scripts These examples are by no means exhaustive, and more cases will be used in the auto-marking, so it is up to you to perform comprehensive checking of your solution.

Warning: sometimes, non-ascii characters don’t render the same on this web page as they do in a terminal window.

People who directed most Movies (most)

vxdb$ python3 q1.py xyz
Usage: q1.py [N]

vxdb$ python3 q1.py
48 Woody Allen
40 Takashi Miike
39 Jean-Luc Godard
37 Claude Chabrol
36 Martin Scorsese
35 Johnnie To
34 Clint Eastwood
34 Werner Herzog
31 Kartal Tibet
31 Steven Spielberg

vxdb$ python3 q1.py 20
48 Woody Allen
40 Takashi Miike
39 Jean-Luc Godard
37 Claude Chabrol
36 Martin Scorsese
35 Johnnie To
34 Clint Eastwood
34 Werner Herzog
31 Kartal Tibet
31 Steven Spielberg
30 Priyadarshan
29 Ingmar Bergman
29 Satyajit Ray
29 Sidney Lumet
28 John Huston
28 Steven Soderbergh
26 Hark Tsui
26 John Sturges
26 Ken Loach
26 Luis Buñuel

vxdb$ python3 q1.py 5
48 Woody Allen
40 Takashi Miike
39 Jean-Luc Godard
37 Claude Chabrol
36 Martin Scorsese

vxdb$ python3 q1.py 0
Usage: q1.py [N]

vxdb$ python3 q1.py 1
48 Woody Allen

Alternative Releases (aliases) for a Movie (rels)

vxdb$ python3 q2.py
Usage: q2.py ‘PartialMovieTitle’

vxdb$ python3 q2.py 1999
No movie matching ‘1999’

vxdb$ python3 q2.py ocean Movies matching ‘ocean’

8.0 A Plastic Ocean (2016)
7.9 Planet Ocean (2012)
7.8 Ocean’s Eleven (2001)
7.8 Oceans (2009)
7.6 Ocean Heaven (2010)
7.2 The Light Between Oceans (2016)
7.0 711 Ocean Drive (1950)
6.9 Ocean’s Thirteen (2007)
6.6 Ocean’s 11 (1960)
6.5 Ocean’s Twelve (2004)
6.4 The Deep End of the Ocean (1999)
6.2 Ocean’s Eight (2018)

vxdb$ python3 q2.py dangerous Movies matching ‘dangerous’

7.7 The Most Dangerous Man in America: Daniel Ellsberg and the Pentagon Papers (2009)
7.6 Dangerous Liaisons (1988)
7.5 Dangerous Encounters of the First Kind (1980)
7.3 On Dangerous Ground (1951)
7.3 Dangerous Beauty (1998)
7.2 Living Dangerously (1987)
7.1 Dangerous Crossing (1953)
7.1 The Year of Living Dangerously (1982)
7.1 Young and Dangerous (1996)
7.0 Confessions of a Dangerous Mind (2002)
7.0 The Dangerous Lives of Altar Boys (2002)
6.7 Young and Dangerous 2 (1996)
6.7 Young and Dangerous 3 (1996)
6.7 Gringo: The Dangerous Life of John McAfee (2016)
6.6 Dangerous Moves (1984)
6.6 Bangkok Dangerous (2000)
6.6 Dangerous Parking (2007)
6.5 Johnny Dangerously (1984)
6.5 Dangerous Minds (1995)
6.4 Young and Dangerous 1997 (1997)
6.4 A Dangerous Method (2011)
6.2 Dangerous When Wet (1953)
6.1 Young and Dangerous 1998 (1998)
6.1 Cute & Dangerous (2015)

vxdb$ python3 q2.py breakfast Movies matching ‘breakfast’

7.9 The Breakfast Club (1985)
7.7 Breakfast at Tiffany’s (1961)
7.7 Breakfast with Hunter (2003)
7.5 Rooster’s Breakfast (2007)
7.2 Breakfast on Pluto (2005)
6.8 A Dog’s Breakfast (2007)
6.8 Breakfast with Scot (2007)

vxdb$ python3 q2.py “Ocean’s Eleven”
Ocean’s Eleven (2001) was also released as
‘11’ (region: US)
‘O11’ (region: US)
‘Ocean’s 11’ (region: US)
‘I symmoria ton enteka’ (region: GR)
‘La gran estafa’ (region: UY)

vxdb$ python3 q2.py ‘Ne Zha’
Ne Zha (2019) was also released as
‘Nezha’ (region: XWW, language: en)
‘Nezha: Birth of the Demon Child’ (region: XWW, language: en)
‘Nezha’ (region: HK, language: en)
‘Nezha’ (region: XAS, language: en)
‘Naazaa’ (region: CN, language: yue)
‘Nezha’ (region: XAS, language: cmn)
‘Nezha’ (region: US)
‘Nezha’ (region: CA, language: en)
‘Nezha’ (region: MY, language: cmn)
‘Nezha’ (region: TW)
‘Nezha’ (region: HK, language: cmn)
‘Nezha’ (region: SG, language: cmn)
‘Naazaa’ (region: HK, language: yue)
‘Nezha’ (region: CN, language: cmn)
‘Birth of the Demon Child Nezha’ (region: XWW, language: en)

vxdb$ python3 q2.py ‘You Are the Apple of My Eye’
You Are the Apple of My Eye (2011) has no alternative releases

vxdb$ python3 q2.py ‘Dragon Ball Z: Super Android 13’
Dragon Ball Z: Super Android 13 (1992) was also released as
‘Dragon Ball Z: Super Android 13’ (new title)
‘Dragon Ball Z: Super Android 13’ (region: US)
‘Dragon Ball Z Movie: Super Battle of 3 Super Saiyas’ (region: MY, language: en)
‘Dragon Ball Z: Kyokugen Battle!! Sandai Super Saiyajin’ (region: JP)
‘Dragon Ball Z 7: Battle Limit!! Three Great Super Saiyans’ (literal english title)
‘Dragon Ball Z: O Retorno dos Andróides’ (region: BR)
‘Dragon Ball Z: Super Battle of Three Super Saiyas’ (region: MY, language: en)
‘Zmajeva kugla Z: Tri super Saiyana’ (region: HR)

Movie Information (minfo)

vxdb$ python3 q3.py
Usage: q3.py ‘MovieTitlePattern’ [Year]

vxdb$ python3 q3.py xyzzy
No movie matching ‘xyzzy’

vxdb$ python3 q3.py ‘Avatar’ Avatar (2009)

Starring
Sam Worthington as Jake Sully
Zoe Saldana as Neytiri
Sigourney Weaver as Dr. Grace Augustine
Michelle Rodriguez as Trudy Chacón
and with
James Cameron: Director
James Cameron: Writer
Jon Landau: Producer
James Horner: Composer
Mauro Fiore: Cinematographer
John Refoua: Editor
Stephen E. Rivkin: Editor

vxdb$ python3 q3.py ‘The Ring’ Movies matching ‘The Ring’

8.9 The Lord of the Rings: The Return of the King (2003)
8.8 The Lord of the Rings: The Fellowship of the Ring (2001)
8.7 The Lord of the Rings: The Two Towers (2002)
7.1 The Ring (2002)
6.6 The Ring-necked Dove (1970)
6.5 Closing the Ring (2007)
6.3 Again the Ringer (1965)
6.2 The Ring (1952)
6.2 The Lord of the Rings (1978)
6.2 The Ring Finger (2005)

vxdb$ python3 q3.py ‘^The Ring$’ 2002 The Ring (2002)

Starring
Naomi Watts as Rachel
Martin Henderson as Noah
Brian Cox as Richard Morgan
David Dorfman as Aidan
and with
Gore Verbinski: Director
Ehren Kruger: Writer
Kôji Suzuki: Writer
Hiroshi Takahashi: Writer
Laurie MacDonald: Producer
Walter F. Parkes: Producer

vxdb$ python3 q3.py ‘: the return of the king’ The Lord of the Rings: The Return of the King (2003)

Starring
Elijah Wood as Frodo
Viggo Mortensen as Aragorn
Ian McKellen as Gandalf
Orlando Bloom as Legolas
and with
Peter Jackson: Director
Peter Jackson: Writer
J.R.R. Tolkien: Writer
Fran Walsh: Writer
Philippa Boyens: Writer
Barrie M. Osborne: Producer
Howard Shore: Composer

vxdb$ python3 q3.py ‘strangelove’ 1964 Dr. Strangelove or: How I Learned to Stop Worrying and Love the Bomb (1964)

Starring
Peter Sellers as Dr. Strangelove
Peter Sellers as Group Capt. Lionel Mandrake
Peter Sellers as President Merkin Muffley
George C. Scott as Gen. ‘Buck’ Turgidson
Sterling Hayden as Brig. Gen. Jack D. Ripper
Keenan Wynn as Col. ‘Bat’ Guano
and with
Stanley Kubrick: Director
Stanley Kubrick: Writer
Terry Southern: Writer
Peter George: Writer
Laurie Johnson: Composer
Gilbert Taylor: Cinematographer
Anthony Harvey: Editor

vxdb$ python3 q3.py ‘stars’ xyzzy
Usage: q3.py ‘MovieTitlePattern’ [Year]

vxdb$ python3 q3.py ‘return of the king’ 1234
No movie matching ‘return of the king’ 1234

vxdb$ python3 q3.py ring 2002 Movies matching ‘ring’ 2002

8.7 The Lord of the Rings: The Two Towers (2002)
7.3 On the Occasion of Remembering the Turning Gate (2002)
7.1 The Ring (2002)
6.9 Springtime in a Small Town (2002)
6.5 Ringeraja (2002)

Biography/Filmography for a Name (bio)

vxdb$ python3 q4.py
Usage: q4.py ‘NamePattern’ [Year]

vxdb$ python3 q4.py xyzzy
No name matching ‘xyzzy’

vxdb$ python3 q4.py ‘Rafal Zimowski’ Filmography for Rafal Zimowski (1974-)

Personal Rating: 7.3 Top 3 Genres: biography drama

300 Miles to Heaven (1989)
playing Jedrek

vxdb$ python3 q4.py belushi Names matching ‘belushi’

Jim Belushi (1954-)
John Belushi (1949-1982)

– no movie is found vxdb$ python3 q4.py ‘Gary Rosen’ Filmography for Gary Rosen (???)

Personal Rating: 0 Top 3 Genres:

– person is in the principal list but has no roles vxdb$ python3 q4.py ‘nutan prasad’ Filmography for Nutan Prasad (1945-2011)

Personal Rating: 8.9 Top 3 Genres: comedy

Aha Naa Pellanta (1987)

vxdb$ python3 q4.py belushi 1954 Filmography for Jim Belushi (1954-)

Personal Rating: 6.4 Top 3 Genres: action comedy crime

Thief (1981)
playing Barry
About Last Night… (1986)
playing Bernie
Salvador (1986)
playing Dr. Rock
Real Men (1987)
playing Nick Pirandello
The Principal (1987)
playing Rick Latimer
Red Heat (1988)
playing Art Ridzik
K-9 (1989)
playing Dooley
Mr. Destiny (1990)
playing Larry Burrows
Taking Care of Business (1990)
playing Jimmy
Gang Related (1997)
playing Det. Frank Divinci
Retroactive (1997)
playing Frank
Angel’s Dance (1999)
playing Stevie ‘The Rose’ Rosellini
Made Men (1999)
playing Bill Manucci
Hoodwinked! (2005)
playing Kirk the Woodsman

vxdb$ python3 q4.py ‘spike lee’ Filmography for Spike Lee (1957-)

Personal Rating: 7.1 Top 3 Genres: drama comedy documentary

She’s Gotta Have It (1986)
playing Mars Blackmon
as Director
as Writer
School Daze (1988)
as Director
as Writer
Do the Right Thing (1989)
as Director
as Writer
Mo’ Better Blues (1990)
playing Giant
as Director
as Writer
Jungle Fever (1991)
playing Cyrus
as Director
as Writer
Malcolm X (1992)
playing Shorty
as Director
as Writer
Crooklyn (1994)
as Director
as Writer
Clockers (1995)
as Director
as Writer
Get on the Bus (1996)
as Director
4 Little Girls (1997)
as Director
He Got Game (1998)
as Director
as Writer
Summer of Sam (1999)
as Director
as Writer
The Best Man (1999)
as Producer
Bamboozled (2000)
as Director
as Writer
Love & Basketball (2000)
as Producer
The Original Kings of Comedy (2000)
as Director
25th Hour (2002)
as Director
Ten Minutes Older: The Trumpet (2002)
as Director
All the Invisible Children (2005)
as Director
Inside Man (2006)
as Director
Miracle at St. Anna (2008)
as Director
Bad 25 (2012)
as Director
Michael Jackson’s Journey from Motown to Off the Wall (2016)
as Director
Amazing Grace (2018)
as Producer
BlacKkKlansman (2018)
as Director
as Writer
Pavarotti (2019)
playing Himself
as Archive footage