/** * 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; }