Shell Script Catalog System Step 1

This is step 1 of the project that will be due later: the full project description is here

Goal: Code a set of shell scripts that writes and queries a file system containing an Catalog of items that you would like to search on a web site. The catalog needs to link through an association file: (ex: list of movie theaters and list of movies to search by movie name, movie genre, theater name or theater location) Submit this to moodle with the code and all the files inside one zip file.

Groups: This can be a group of up to 3 people. Everyone is responsible for knowing how every option is coded.

What you will upload to moodle: a zip file of 4 files: the first data file, the second data file, the third data (linking) file, one script that has 2 search options. (If you prefer to make a different script for each of your search options, you can do that.) The scripts should have all group member names in comments (starting with #) so I know who to grade. Only one group member needs to submit.

Details:

First, create 3 files, two that have numeric indexes and one that links the two files together. Each file needs 2 columns.

• search from one table (for example - ask for town and list movies) It must cross from one table to another via a key.
• search from the other table (for example - ask for genre and list theaters) It must cross from one table to another via a key.

The search option needs to allow the user to find a word in one table and find all the related rows in the other table. The field that you are matching cannot exist in the second table, so you have to use the key to look up the association table.

Recommendation: use grep to find matching rows and then sed to pick out the key. A list of keys can be used in grep with an -f option. Print the results using a read loop.

Sample Tables:

Movie Table
1,Mission: Impossible, Action
2,Fantastic Four, Action
3,The Gift, Drama
4,Vacation, Comedy
5,Ant-Man, Action
6,Minions, Family
7,Ricki and the Flash, Action
8,Trainwreck, Action
9,Pixels, Family
10,Southpaw, Action

Movie Theater Table
1,AMC Loews Stony Brook,(888)AMC-4FUN, 2196 Nesconset Highway, Stony Brook
2,Bellmore Movies, (516)783-7200,222 Petit Avenue, Bellmore
3.Bellmore Playhouse, (516)783-5440, 525 Bedford Avenue, Bellmore
4,Bow Tie Franklin Square Cinemas, (516)775-3257, 989 Hempstead Turnpike, Franklin Square

Association Table (theater key followed by movie key)
1,1
1,2
1,3
2,1
2,4
2,9
2,10
3,1
3,3
4,1
4,3

Note: 1,2 means that AMC Loewis playing Fantastic Four

Examples of other subjects:

Games and characters.

• possible table #1 game name, console played on, genre of game (ex: horror, story, battle) in one table
• possible table #2 character in a game, character's gender, character's genus (human, alien, animal) in another table
• possible table #3 link rows in table 1 to table 2. (Add a row number to each of the two tables above).
• Your first search might be ask for a console and then list all the characters that are in games in that console.
• Your second search might be to ask for a character's genus and then list all the games that have characters in that genus

Games and stores that sell them.

• possible table #1 game name, console played on, genre of game (ex: horror, story, battle) in one table
• possible table #2 store name, store city, store state
• possible table #3 link rows in table 1 to table 2. (Add a row number to each of the two tables above).
• Your first search might be to ask for a console and then list all the stores that sell games using that console
• Your second search might be to ask for a city and list all the games sold in that city.

Games and stats

• possible table #1 game name, console played on, genre of game (ex: horror, story, battle) in one table
• possible table #2 character or player in a game, character or player's gender, character or player's genus (human, alien, animal) in another table
• possible table #3 link rows in table 1 to table 2, (Add a row number to each of the two tables above). Also add the date played, and the scores. Example: 1,2,10/20/2015,30,40 would mean: game #1 mario brothers, player#2 mario or jim, depending upon whether you were listing characters or the people moving them, played on 10/20/2015 and had a health score of 30 and an energy score of 40. (I know that does not happen, but pick score types that match reality given your own game knowledge.)
• Your first search might be to ask for a console and then list all the dates that the player played on that console, and list their scores, and the genus of the players
• Your second search might be to ask for a player genus and then list all the scores with the game names.