COMP3311 22T3 |
Assignment 2 Examples |
Database Systems |
[Specification] [Database] [Examples] [Testing] [Submitting]
This document contains examples of output from the various scripts that you are required to develop.
$ ./dirby 'James Cameron' Terminator 2: Judgment Day (1991) True Lies (1994) Titanic (1997) Ghosts of the Abyss (2003) Avatar (2009) $ ./dirby 'Wim Wenders' Lisbon Story (1994) Die Gebrüder Skladanowsky (1995) The End of Violence (1997) Buena Vista Social Club (1999) The Million Dollar Hotel (2000) The Soul of a Man (2003) Land of Plenty (2004) Don't Come Knocking (2005) Palermo Shooting (2008) Pina (2011) Every Thing Will Be Fine (2015) Submergence (2017) Pope Francis: A Man of His Word (2018) $ ./dirby 'Cary Grant' Cary Grant has not directed any movies $ ./dirby 'Joe Blow' No such person # there are six people with this name $ ./dirby 'Michael Davis' Eight Days a Week (1997) 100 Girls (2000) Monster Man (2003) Shoot 'Em Up (2007) # there are three people with this name $ ./dirby 'Justin Kelly' I Am Michael (2015) King Cobra (2016) # there are two people with this name $ ./dirby 'Kevin Jones' None of the people called Kevin Jones has directed any films $ ./dirby 'Nicole Kidman' Nicole Kidman has not directed any movies
$ ./releases 'Crime + Punishment' 2018 Argentina China Greece Poland Russian Federation United States of America $ ./releases 'A Christmas to Remember' 2016 Bulgaria Canada Denmark France Italy Japan Russian Federation Slovenia Spain United States of America $ ./releases 'Hardkor Disko' 2014 Germany Poland Russian Federation $ ./releases 'Nenu Lenu' 2019 India
$ ./genres 1990 177 Drama 127 Comedy 73 Crime 70 Action 51 Thriller 50 Romance 39 Horror 29 Adventure 21 Fantasy 20 Sci-Fi $ ./genres 1991 207 Drama 130 Comedy 71 Romance 64 Crime 58 Action 40 Thriller 27 Mystery 26 Adventure 24 Horror 23 Fantasy $ ./genres 2020 509 Drama 294 Comedy 202 Romance 146 Documentary 126 Thriller 105 Action 100 Horror 90 Crime 84 Mystery 64 Adventure
$ ./roles xyz No such person $ ./roles 'Paul Newman' Walter Bridge in Mr. & Mrs. Bridge (1990) Sully in Nobody's Fool (1994) Sidney J. Mussburger in The Hudsucker Proxy (1994) Harry Ross in Twilight (1998) Dodge in Message in a Bottle (1999) Henry in Where the Money Is (2000) Doc Hudson in Cars (2006) Teller in The Meerkats (2008) $ ./roles 'Chris Hemsworth' Sam Phelan in Ca$h (2010) Curt in The Cabin in the Woods (2011) Thor in Thor (2011) Jed Eckert in Red Dawn (2012) The Huntsman in Snow White and the Huntsman (2012) James Hunt in Rush (2013) Thor in Thor: The Dark World (2013) Thor in Avengers: Age of Ultron (2015) Nick Hathaway in Blackhat (2015) Owen Chase in In the Heart of the Sea (2015) Eric in The Huntsman: Winter's War (2016) The Huntsman in The Huntsman: Winter's War (2016) Thor in Thor: Ragnarok (2017) Captain Mitch Nelson in 12 Strong (2018) Thor in Avengers: Infinity War (2018) Thor in Avengers: Endgame (2019) Agent H in Men in Black: International (2019) Tyler Rake in Extraction (2020) Abnesti in Spiderhead (2022) Thor in Thor: Love and Thunder (2022) $ ./roles 'Clint Eastwood' Nick Pulovski in The Rookie (1990) John Wilson in White Hunter Black Heart (1990) Bill Munny in Unforgiven (1992) Red Garnett in A Perfect World (1993) Frank Horrigan in In the Line of Fire (1993) Robert Kincaid in The Bridges of Madison County (1995) Luther Whitney in Absolute Power (1997) Steve Everett in True Crime (1999) Frank Corvin in Space Cowboys (2000) Terry McCaleb in Blood Work (2002) Frankie Dunn in Million Dollar Baby (2004) Harry Callahan in Mr. Warmth: The Don Rickles Project (2007) Private Kelly in Mr. Warmth: The Don Rickles Project (2007) Self in Mr. Warmth: The Don Rickles Project (2007) Walt Kowalski in Gran Torino (2008) Gus in Trouble with the Curve (2012) Self in Tab Hunter Confidential (2015) Earl Stone in The Mule (2018) Mike Milo in Cry Macho (2021) $ ./roles 'Marlon Brando' Carmine Sabatini in The Freshman (1990) Dr. Jack Mickler in Don Juan DeMarco (1994) McCarthy in The Brave (1997) The Swede in Free Money (1998) Max in The Score (2001) $ ./roles 'Cary Grant' No acting roles $ ./roles 'cary grant' No such person $ ./roles 'Sabrina Dhawan' No acting roles $ ./roles 'Eugene Lee' Eugene Lee #1 No acting roles Eugene Lee #2 No acting roles Eugene Lee #3 Lt. John Stokes in American Son (2019) $ ./roles 'Steve Jones' Steve Jones #1 Self in The Filth and the Fury (2000) Self in Joe Strummer: The Future Is Unwritten (2007) Quotations reader in London: The Modern Babylon (2012) Steve Jones #2 Earnest Reporter in It's a Wonderful Afterlife (2010) Steve Jones #3 Self - Geneticist (University College London) in Questioning Darwin (2014) Steve Jones #4 No acting roles Steve Jones #5 No acting roles
$ ./movie avatar Avatar (2009) Sam Worthington plays Jake Sully Zoe Saldana plays Neytiri Sigourney Weaver plays Dr. Grace Augustine Michelle Rodriguez plays Trudy Chacón James Cameron: director Jon Landau: producer James Horner: composer Mauro Fiore: cinematographer John Refoua: editor Stephen E. Rivkin: editor $ ./movie ooo 1. Eeb Allay Ooo! (2019) 2. Looop Lapeta (2022) Which movie? 2 Looop Lapeta (2022) Iftekhar Mahmud plays ??? Backagaindancer plays Sudhir Bhupesh Bandekar plays Inspector David Colaco Alistar Bennis plays Robert Aakash Bhatia: director Puneet Chadha: writer Vinay Chhawal: writer Arnav Nanduri: writer Ketan Pedgaonkar: writer Tanuj Garg: producer $ ./movie jeff 1. Jeff, Who Lives at Home (2011) 2. Jefferson in Paris (1995) 3. Jeffrey (1995) 4. Outlaw Prophet: Warren Jeffs (2014) 5. The Jeffrey Dahmer Files (2012) 6. The Secret Life: Jeffrey Dahmer (1993) 7. When Jeff Tried to Save the World (2018) Which movie? 5 The Jeffrey Dahmer Files (2012) Andrew Swant plays Jeffrey Dahmer Pamela Bass plays Self - Neighbor Jeffrey Jentzen plays Self - Medical Examiner Pat Kennedy plays Self - Detective Chris James Thompson: director Joe Riepenhoff: writer Jack Turner: producer Robert Mulrennan: composer Michael T. Vollmann: cinematographer $ ./movie 'Jack Irish: Black Tide' Jack Irish: Black Tide (2012) Guy Pearce plays Jack Irish Marta Dusseldorp plays Linda Hillier Aaron Pedersen plays Cam Delroy Roy Billing plays Harry Strang Jeffrey Walker: director Matt Cameron: writer Peter Temple: writer Ian Collie: producer Harry James Angus: composer Martin McGrath: cinematographer $ ./movie 'The Sapphires' The Sapphires (2012) Chris O'Dowd plays Dave Lovelace Deborah Mailman plays Gail Jessica Mauboy plays Julie Shari Sebbens plays Kay Wayne Blair: director Keith Thompson: writer Tony Briggs: writer Rosemary Blight: producer Kylie Du Fresne: producer Cezary Skubiszewski: composer $ ./movie 'Paint Drying' Paint Drying (2016) Charlie Shackleton plays Self $ ./movie xyz No movie matching: 'xyz'