Write an automation script using RPAFramework that does the following:
- Opens rottentomatoes.com
- Searches each movie in the provided excel file. (only movies should be searched, not tv shows etc.)
- Search for exact matches only.(case insensitive) e.g. if the provided movie is Titanic, then Titanic 666 is not a match.
- If multiple exact matches are found, take the movie that was released most recently by year.
- Extract TOMATOMETER score, AUDIENCE SCORE, storyline, rating, genres and top 5 critic reviews. The data should be saved to sqlite database
- Sqlite database should be created on the first run with following columns. On subsequent runs, data is inserted only id, movie_name, tomatometer_score, audience_score, storyline, rating, genres, review_1, review_2, review_3, review_4, review_5, status
- If no exact match is found in search, insert ‘No exact match found’ in the status field otherwise success in status.
- Get started from a simple task template in
tasks.robot
.- Uses Robot Framework syntax.
- You can configure your robot
robot.yaml
. - You can configure dependencies in
conda.yaml
.