public void testInsertDeleteComment() { FilmManager filmManager = new FilmManager(GetDbContextOptions.getFilmDbContextOptions()); Comment comment = new Comment() { Content = "test de content pour le commentaire", Date = DateTime.Now, Film = filmManager.getFilmFromId(11) /*star wars*/, Rate = 19, Username = "******" }; Console.WriteLine("insert comment..."); filmManager.InsertComment(comment); Console.WriteLine("insert comment ok : affichage à partir de la lecture de la bd :"); Film film = filmManager.getFilmFromId(comment.Film.Id); int idComment = 0; foreach (Comment filmComment in film.Comments) { idComment = filmComment.Id; } Console.WriteLine("Film : \n" + film.ToStringAll()); Comment commentFromBd = filmManager.getCommentFromId(idComment); Console.WriteLine("Comment : \n" + commentFromBd.ToStringWithFilm()); Console.WriteLine(); Console.WriteLine("Delete comment..."); filmManager.DeleteComment(commentFromBd); Console.WriteLine("Apres Delete comment..."); film = filmManager.getFilmFromId(comment.Film.Id); Console.WriteLine("Film : \n" + film.ToStringAll()); commentFromBd = filmManager.getCommentFromId(commentFromBd.Id); if (commentFromBd == null) { Console.WriteLine("commentaire bien supprimé"); } else { Console.WriteLine("commentaire pas supprimé : " + commentFromBd); } Assert.Pass(); }
[TestCase(15)] //personne ! public void testGetActorFromId(int id) { FilmManager filmManager = new FilmManager(GetDbContextOptions.getFilmDbContextOptions()); Actor actor = filmManager.getActorFromId(id); if (actor != null) { Console.WriteLine("Actor pour l'id(" + id + ") : " + actor.ToStringWithFilms()); } else { Console.WriteLine("Pas d'actor trouvé pour l'id : " + id); } }
public void TestGetFavoriteActors(int from, int to) { FilmManager filmManager = new FilmManager(GetDbContextOptions.getFilmDbContextOptions()); List <Actor> actors = filmManager.GetFavoriteActors(from, to).ToList(); Console.WriteLine("Acteur qui joue dans 2 films ou plus : de " + from + ", to " + to); int i = 1; foreach (Actor actor in actors) { Console.WriteLine("[" + i + "]" + actor.ToStringWithFilms()); i++; } }
public void testGetCommentsFromTo(int from, int to) { FilmManager filmManager = new FilmManager(GetDbContextOptions.getFilmDbContextOptions()); List <Comment> comments = filmManager.getCommentsFromTo(from, to).ToList(); Console.WriteLine("Comments de " + from + " a " + to + " :"); int i = 1; foreach (Comment comment in comments) { Console.WriteLine("Comments [" + i + "]" + " : " + comment.ToStringWithFilm()); i++; } Console.WriteLine("Comments de : " + "Comments de " + from + " a " + to); }
public void testGetGenresFromTo(int from, int to) { FilmManager filmManager = new FilmManager(GetDbContextOptions.getFilmDbContextOptions()); List <Genre> genres = filmManager.getGenresFromTo(from, to).ToList(); Console.WriteLine("Genres de " + from + " a " + to + " :"); int i = 1; foreach (Genre genre in genres) { Console.WriteLine("Genres [" + i + "]" + " : " + genre.ToStringWithFilms()); i++; } Console.WriteLine("Genres de : " + "Genres de " + from + " a " + to); }
public void testGetActorsFromTo(int from, int to) { FilmManager filmManager = new FilmManager(GetDbContextOptions.getFilmDbContextOptions()); List <Actor> actors = filmManager.getActorsFromTo(from, to).ToList(); Console.WriteLine("Acteurs de " + from + " a " + to + " :"); int i = 1; foreach (Actor actor in actors) { Console.WriteLine("Acteurs [" + i + "]" + " : " + actor.ToStringWithFilms()); i++; } Console.WriteLine("Acteurs de : " + "Acteurs de " + from + " a " + to); }
public void testGetFilmsFromTo(int from, int to) { FilmManager filmManager = new FilmManager(GetDbContextOptions.getFilmDbContextOptions()); List <Film> films = filmManager.getFilmsFromTo(from, to).ToList(); Console.WriteLine("Films de " + from + " a " + to + " :"); int i = 1; foreach (Film film in films) { Console.WriteLine("Film [" + i + "]" + " : " + film.ToStringAll()); i++; } Console.WriteLine("fin de : " + "Films de " + from + " a " + to); }
public void testFindFilmsByPartialTitle(int from, int to, string titre) { FilmManager filmManager = new FilmManager(GetDbContextOptions.getFilmDbContextOptions()); IQueryable <Film> testNull = filmManager.FindFilmsByPartialTitle(from, to, titre); Console.WriteLine("Liste des films dont le titre contient : " + titre); if (testNull != null) { List <Film> films = testNull.ToList(); int i = 1; Console.WriteLine("DEBUG nbr films = " + films.Count); foreach (Film film in films) { Console.WriteLine("[" + i + "]\n" + film.ToStringAll()); i++; } } }
[TestCase(0, 10, "a b c d")] //plus de 2 mots public void testFindListFilmByPartialActorName(int from, int to, string nomActeur) { FilmManager filmManager = new FilmManager(GetDbContextOptions.getFilmDbContextOptions()); IQueryable <Film> testNull = filmManager.FindListFilmByPartialActorName(from, to, nomActeur); Console.WriteLine("Liste des films dans lequel un acteur dont on donne un nom partiellement ou entierement : " + nomActeur); if (testNull != null) { List <Film> films = testNull.ToList(); int i = 1; Console.WriteLine("DEBUG nbr films = " + films.Count); foreach (Film film in films) { Console.WriteLine("[" + i + "]\n" + film.ToStringAll()); i++; } } }
[TestCase(10)] //rien ! public void testGetFilmFromId(int id) { FilmManager filmManager = new FilmManager(GetDbContextOptions.getFilmDbContextOptions()); Film film = filmManager.getFilmFromId(id); if (film != null) { Console.WriteLine("Film pour l'id(" + id + ") : " + film.ToStringAll()); Console.WriteLine("comments du film en détails : "); foreach (Comment filmComment in film.Comments) { Console.WriteLine(filmComment.ToStringWithFilm()); } } else { Console.WriteLine("Pas de Film trouvé pour l'id : " + id); } }
public void testFindNumberFilmsByPartialTitle(string titre) { FilmManager filmManager = new FilmManager(GetDbContextOptions.getFilmDbContextOptions()); Console.WriteLine("Nombre de films dont le titre contient(" + titre + ") = " + filmManager.FindFilmsByPartialTitle(titre)); }
public void testGetNumberFavoriteActor() { FilmManager filmManager = new FilmManager(GetDbContextOptions.getFilmDbContextOptions()); Console.WriteLine("nombre d'acteur qui jouent dans au moins 2 films : " + filmManager.GetFavoriteActors()); }
[TestCase("a b c d")] //plus de 2 mots public void testNumberFindListFilmByPartialActorName(string nomActeur) { FilmManager filmManager = new FilmManager(GetDbContextOptions.getFilmDbContextOptions()); Console.WriteLine("nombre de films pour l'acteur dont le nom contient(" + nomActeur + ") = " + filmManager.FindListFilmByPartialActorName(nomActeur)); }
public void testGetNumberCommentsFromTo() { FilmManager filmManager = new FilmManager(GetDbContextOptions.getFilmDbContextOptions()); Console.WriteLine("nombre de comments dans la bd = " + filmManager.getCommentsFromTo()); }
public void testGetNumberActorsFromTo() { FilmManager filmManager = new FilmManager(GetDbContextOptions.getFilmDbContextOptions()); Console.WriteLine("nombre d'acteurs dans la bd = " + filmManager.getActorsFromTo()); }