/**
* Gets all movies from database
*
* @param sortBy Sort field, see SortType.*
* @param sortOrder Sort order, must be either SortType.ASC or SortType.DESC.
* @return Updated movie
*/
public Movie updateMovieDetails(INotifiableManager manager, Movie movie) {
StringBuilder sb = new StringBuilder();
sb.append("SELECT c03, c01, c04, c18, c12, c19");
sb.append(
" FROM movie, files, path WHERE movie.idFile=files.idFile AND path.idPath=files.idPath AND movie.idmovie = ");
sb.append(movie.getId());
parseMovieDetails(mConnection.query("QueryVideoDatabase", sb.toString(), manager), movie);
sb = new StringBuilder();
sb.append("SELECT actors.idActor, strActor, strRole");
sb.append(" FROM actors, actorlinkmovie");
sb.append(" WHERE actors.idActor = actorlinkmovie.idActor");
sb.append(" AND actorlinkmovie.idMovie =");
sb.append(movie.getId());
movie.actors = parseActorRoles(mConnection.query("QueryVideoDatabase", sb.toString(), manager));
return movie;
}
