4:20pm elaine11:~/cs145/hw5> perl interface.pl

Select from the following options:
(a) Do useful queries
(b) Insert a new actor
(c) Insert a new series
(d) Update an episode description
(e) Delete an entire episode
(f) Quit
a
Select from the following queries:
(a) Find an actor's website
(b) Find an episode description
(c) Find all episodes with featuring a character
a
Enter an actor name: actor39
---------------
Website for actor actor39: 
http://www.actor39.com
---------------

Select from the following options:
(a) Do useful queries
(b) Insert a new actor
(c) Insert a new series
(d) Update an episode description
(e) Delete an entire episode
(f) Quit
a
Select from the following queries:
(a) Find an actor's website
(b) Find an episode description
(c) Find all episodes with featuring a character
b
Enter an episode title: Episode 0
Enter series title: series44
Enter series creator: creator44
---------------
Description for episode Episode 0 of series series44:
| http://www.multimediaclips.com/?id=6
| This is a description of episode 0
---------------

Select from the following options:
(a) Do useful queries
(b) Insert a new actor
(c) Insert a new series
(d) Update an episode description
(e) Delete an entire episode
(f) Quit
a
Select from the following queries:
(a) Find an actor's website
(b) Find an episode description
(c) Find all episodes with featuring a character
c
Enter a character: character106
Enter series title: series135
Enter series creator: creator135
---------------
| Description for episode Episode 1788 of series series135:
| http://www.multimediaclips.com/?id=81
| This is a description of episode 1788
---------------
| Description for episode Episode 385 of series series135:
| http://www.multimediaclips.com/?id=67
| This is a description of episode 385
---------------
| Description for episode Episode 423 of series series135:
| http://www.multimediaclips.com/?id=1
| This is a description of episode 423
---------------

Select from the following options:
(a) Do useful queries
(b) Insert a new actor
(c) Insert a new series
(d) Update an episode description
(e) Delete an entire episode
(f) Quit
b
Enter actor name: Eric Silverberg
Enter actor website: http://es.com
Inserted Eric Silverberg, http://es.com into database

Select from the following options:
(a) Do useful queries
(b) Insert a new actor
(c) Insert a new series
(d) Update an episode description
(e) Delete an entire episode
(f) Quit
a
Select from the following queries:
(a) Find an actor's website
(b) Find an episode description
(c) Find all episodes with featuring a character
a
Enter an actor name: Eric Silverberg
---------------
Website for actor Eric Silverberg: 
http://es.com
---------------

Select from the following options:
(a) Do useful queries
(b) Insert a new actor
(c) Insert a new series
(d) Update an episode description
(e) Delete an entire episode
(f) Quit
c
Enter series title: Eric's Life
Enter series creator: EJS
Enter series website: http://es.com
Enter series premier date (mm-dd-yyyy): (Default 01-01-1990): 05-01-2000
Enter series finale date (mm-dd-yyyy): (Default 01-01-1990): 05-31-2000
Inserted (Eric's Life,EJS,http://es.com,05-01-2000,05-31-2000) into database

Select from the following options:
(a) Do useful queries
(b) Insert a new actor
(c) Insert a new series
(d) Update an episode description
(e) Delete an entire episode
(f) Quit
d
Enter episode title: Episode 0
Enter series title: series44
Enter series creator: creator44
Enter new episode title (Default Episode 0): 
Enter new airdate (Default 09-23-1992): 
Enter new quality (Default 7): 10
Enter new description (Default This is a description of episode 0): A new desc for Episode 0!
Enter new multimedia url (Default http://www.multimediaclips.com/?id=6): http://www.yahoo.com/
Enter new season (Default 7): 6
Enter new series title (Default series44): series0
Enter new series creator (Default creator44): creator0
Update successful

Select from the following options:
(a) Do useful queries
(b) Insert a new actor
(c) Insert a new series
(d) Update an episode description
(e) Delete an entire episode
(f) Quit
a
Select from the following queries:
(a) Find an actor's website
(b) Find an episode description
(c) Find all episodes with featuring a character
b
Enter an episode title: Episode 0
Enter series title: series0
Enter series creator: creator0
---------------
Description for episode Episode 0 of series series0:
| http://www.yahoo.com/
| A new desc for Episode 0!
---------------

Select from the following options:
(a) Do useful queries
(b) Insert a new actor
(c) Insert a new series
(d) Update an episode description
(e) Delete an entire episode
(f) Quit
e
Enter episode title: Episode 0
Enter series title: series0
Enter series creator: creator0
Delete for episode 'Episode 0' completed.

Select from the following options:
(a) Do useful queries
(b) Insert a new actor
(c) Insert a new series
(d) Update an episode description
(e) Delete an entire episode
(f) Quit
a
Select from the following queries:
(a) Find an actor's website
(b) Find an episode description
(c) Find all episodes with featuring a character
b
Enter an episode title: Episode 0
Enter series title: series0
Enter series creator: creator0
No information for Episode 0 of series series0, creator creator0

Select from the following options:
(a) Do useful queries
(b) Insert a new actor
(c) Insert a new series
(d) Update an episode description
(e) Delete an entire episode
(f) Quit
f
4:26pm elaine11:~/cs145/hw5>