Sample Output For Lab 4
The times shown are for runs of executing each query osprey.cs.swarthmore.edu (one of the machines in 256). First, here is an example use of createDB.py
where I am saving my result in /local/asas/ (you are not required to use time, this is just to give you an idea of how long my script takes to run):
$ cd cs44/labs/Lab4-asoni1/
$ time python3 createdb.py /local/asas/movie.db
File already exists; enter 0 to quit and 1 to remove: 1
Creating new movie database!
...Creating Tables...
...Inserting Records...
...Building Indexes...
real 1m5.695s
user 0m53.014s
sys 0m10.565s
Here is an example of queryDB.txt:
$ python3 queryDB.py /local/asas/movie.db
Welcome to the Movie Database!
Menu of options:
(0) Exit
(1) Query 1: Cast of the Princess Bride
(2) Query 2: Actor Filmography
(3) Query 3: Co-stars
(4) Query 4: Prolific Directors
(5) Query 5: Bacon's Favorites
(6) Query 6: Versatile Actors
(7) Query 7: Programmer's Choice
Enter your choice: 1
24 results; Completed in 0.000 seconds
fname lname
----------------------------------------
André the Giant
Anne Dyson
Betsy Brantley
Billy Crystal
Carol Kane
Cary Elwes
Chris Sarandon
Christopher Guest
Derek Pykett
Fred Savage
Garrett Brawith
Lauren Mora
Malcolm Storry
Mandy Patinkin
Margery Mason
Mel Smith
Paul Badger
Peter Cook
Peter Falk
Regan Burns
Rob Reiner
Robin Wright Penn
Wallace Shawn
Willoughby Gray
Query Plan:
-----------
SEARCH TABLE Movie...
#result redacted as it reveals indices I built
Menu of options:
(0) Exit
(1) Query 1: Cast of the Princess Bride
(2) Query 2: Actor Filmography
(3) Query 3: Co-stars
(4) Query 4: Prolific Directors
(5) Query 5: Bacon's Favorites
(6) Query 6: Versatile Actors
(7) Query 7: Programmer's Choice
Enter your choice: 2
Please enter actor's first name: Samantha
Please enter actor's last name: Goldstein
4 results; Completed in 0.000 seconds
title
--------------------
Anywhere But Here
Firetrap
Surfer Girl House
The Three Faces of Phoebe
Query Plan:
-----------
...
Menu of options:
(0) Exit
(1) Query 1: Cast of the Princess Bride
(2) Query 2: Actor Filmography
(3) Query 3: Co-stars
(4) Query 4: Prolific Directors
(5) Query 5: Bacon's Favorites
(6) Query 6: Versatile Actors
(7) Query 7: Programmer's Choice
Enter your choice: 2
Please enter actor's first name: Kevin
Please enter actor's last name: Bacon
[~215-230 results] Completed in 0.001 seconds
title
--------------------
'Hollow Man': Anatomy of a Thriller
(#1.2)
(#1.8319)
[more results]
You Don't Know Jack: Volume 2
Query Plan:
-----------
...
Menu of options:
(0) Exit
(1) Query 1: Cast of the Princess Bride
(2) Query 2: Actor Filmography
(3) Query 3: Co-stars
(4) Query 4: Prolific Directors
(5) Query 5: Bacon's Favorites
(6) Query 6: Versatile Actors
(7) Query 7: Programmer's Choice
Enter your choice: 3
Please enter first actor's first name: James
Please enter first actor's last name: Stewart
Please enter second actor's first name: Katharine
Please enter second actor's last name: Hepburn
[10-15 results] Completed in 0.000 seconds
id title
----------------------------------------
86099 America at the Movies
150873 Fonda on Fonda
[more results]
Query Plan:
-----------
...
Menu of options:
(0) Exit
(1) Query 1: Cast of the Princess Bride
(2) Query 2: Actor Filmography
(3) Query 3: Co-stars
(4) Query 4: Prolific Directors
(5) Query 5: Bacon's Favorites
(6) Query 6: Versatile Actors
(7) Query 7: Programmer's Choice
Enter your choice: 4
[~50 results] Completed in 0.163 seconds
fname lname FilmCount
------------------------------------------------------------
Ellen Brown 2270
[mores results]
Paul Miller 506
Query Plan:
-----------
...
Menu of options:
(0) Exit
(1) Query 1: Cast of the Princess Bride
(2) Query 2: Actor Filmography
(3) Query 3: Co-stars
(4) Query 4: Prolific Directors
(5) Query 5: Bacon's Favorites
(6) Query 6: Versatile Actors
(7) Query 7: Programmer's Choice
Enter your choice: 5
[~20 results]; Completed in 0.038 seconds
fname lname NumFilms
------------------------------------------------------------
Kyra Sedgwick 18
[More results]
#You'll get Tom Hanks as your top result if you double-count movies with multiple roles]
Query Plan:
-----------
...
Menu of options:
(0) Exit
(1) Query 1: Cast of the Princess Bride
(2) Query 2: Actor Filmography
(3) Query 3: Co-stars
(4) Query 4: Prolific Directors
(5) Query 5: Bacon's Favorites
(6) Query 6: Versatile Actors
(7) Query 7: Programmer's Choice
Enter your choice: 6
[~25 results]; Completed in 0.404 seconds
fname lname title NumRoles
--------------------------------------------------------------------------------
Scott Morales Is This a Joke? 8
Nicky Figueredo Is This a Joke? 8
[more results]
Query Plan:
-----------
Menu of options:
(0) Exit
(1) Query 1: Cast of the Princess Bride
(2) Query 2: Actor Filmography
(3) Query 3: Co-stars
(4) Query 4: Prolific Directors
(5) Query 5: Bacon's Favorites
(6) Query 6: Versatile Actors
(7) Query 7: Programmer's Choice
Enter your choice: 0
Thank you for using the Movie Database!