rrabinovitch/aetna_movie_api

LinkedIn | Email

aetna_movie_api's Issues

Config ratings db

• connect to ratings db
• associate movies with ratings

Resources:

• https://guides.rubyonrails.org/active_record_multiple_databases.html#joining-across-databases
• https://medium.com/@shilpikayal/dual-database-connection-in-rails-76ca42e276a7

List All Movies sad path

Implement sad path / error handling for when page query param does not align with an available pagination

Return genres as objects within movies responses

Removed the JSON parsing from movies serializer when it caused issues with the tests, with the intention of returning to this later if time allows

original serialization:

attribute :genres #do |movie|
  JSON.parse(movie.genres)
end

errors:

2) List All Movies Returns 50 movies per page
Failure/Error: JSON.parse(movie.genres)

JSON::ParserError:
416: unexpected token at '{:id=>18, :name=>"Drama"}, {:id=>80, :name=>"Crime"}]'
# ./app/serializers/movie_serializer.rb:7:in `block in <class:MovieSerializer>'
# ./app/controllers/api/v1/movies_controller.rb:5:in `index'
# ./spec/requests/api/v1/all_movies_request_spec.rb:30:in `block (2 levels) in <top (required)>'

Movies By Year

route: /api/v1/movies?year=<year>
action: movies#index

AC:

• An endpoint exists that will list all movies from a particular year
• List is paginated: 50 movies per page, the page can be altered with the page query params
• List is sorted by date in chronological order
• Sort order can be descending
• Columns include: imdb id, title, genres, release date, budget

List All Movies

route: /api/v1/movies or /api/v1/movies?page=<page_num>
action: movies#index

AC:

• An endpoint exists that lists all movies
• List is paginated: 50 movies per page, the page can be altered with the page query params
• Columns should include: imdb id, title, genres, release date, budget
• Budget is displayed in dollars

Movie Details sad path

Implement sad path / error handling for when movie with specified id is not found

Movies By Genre

route: /api/v1/movies?genre=<genre>
action: movies#index

AC:

• An endpoint exists that will list all movies by a genre
• List is paginated: 50 movies per page, the page can be altered with the page query params
• Columns include: imdb id, title, genres, release date, budget

SQLite setup

Research should provide answers to the following questions:

• what software do I need to download?
• how does setting up a rails API with a PostgreSQL db differ from setting one up with a SQLite db?
• are there any additional nuances re: making queries of the db?
• how do I set up (and seed?) db's from existing files like those included in the gdrive directory?
• how does this impact testing?

Estimated research time: 1 - 1.5 poms

Local repo setup

• add gems (reference api building notes)
• start #7: SQLite setup
• create PR template
• outline readme

Compose README

• local setup instructions
• link to process gist
• endpoint documentation

Movie Details

route: /api/v1/movies/:id
action: movies#show

AC:

• An endpoint exists that lists the movie details for a particular movie
• Details should include: imdb id, title, description, release date, budget, runtime, average rating, genres, original language, production companies
• Budget should be displayed in dollars
• Ratings are pulled from the rating database