Movie Application backend with Springboot, MySQL
User can:
- register/login to website.
- view all sample movies.
- navigate to particular movie and view all the cast and info related to movie.
- go to any particular actor to see in which movie the cast played a role and info about the cast.
- add a movie to Favourites.
- delete a movie from Favourites.
- view all Favourites.
- create a review
- Created spring boot application and added code for API endpoints.
- Tested API endpoints using Postman application.
The application uses a database in MySQL called 'moviesApi' which consist of the following tables:
- actors_table
- movies_table
- movie_actor
- review_table
- users_table
- wishlist_table
Out of which the first 3 tables have to imported to MySQL workbench from the attached .csv files (utilities->SqlTable) and the dataTypes have to be checked and for movie_poster and actor_img datatype is set to blob and to set up the project the images should be updated in blobs using Right click->Load from file for each entry.
Other tables will be created when we run the application.
Application starting point is MovieApplication.java
.