Additional queries for database

SEP-VIA-GROUP5 / SEP6

6th Semester Project

0 stars 1 forks source link

Additional queries for database #59

Closed Titas212 closed 1 year ago

Titas212 commented 1 year ago

Since basic CRUD operations were added to the database, some more complex ones are required. What we need: Add Director/Star to a movie. Get n movies based on x ratings/votes. Get all Person movies. Get all People that belong to a movie. Get movies by year. Get n movies by year. Get Person by birth. Get n most popular movies. Get person by name. Get movie by title. Get n best rated movies.

Titas212 commented 1 year ago

Please add more queries, that you think we will need.

rycka13 commented 1 year ago

[ ] DirectorsMapper does not have getDirectorByIdmethod
[ ] RatingMapper does not have getRatingByIdmethod
[ ] StarMapper does not have geStarByIdmethod