public void AddMovie(MovieFinder.Data.Movie movie) { using (var cmd = new SQLiteCommand(connection)) { cmd.CommandText = String.Format("INSERT INTO MOVIE(ID,Name,ImageUrl,ReleaseDate,LanguageCode,Description, CreatedDate,ModifiedDate, Version, UniqueID, HasSubtitle) " + "VALUES({0},'{1}','{2}','{3}','{4}','{5}','{6}','{7}',{8},'{9}',{10})", movie.ID, Sanitize(movie.Name), movie.ImageUrl, movie.ReleaseDate.ToString("yyyy-MM-dd"), movie.LanguageCode,Sanitize( movie.Description), movie.CreateDate.ToString("yyyy-MM-dd"), movie.ModifiedDate != null ? movie.ModifiedDate.Value.ToString("yyyy-MM-dd") : null, movie.Version, movie.UniqueID, movie.MovieLinks.Any(x => x.HasSubtitle) ? 1 : 0); cmd.ExecuteNonQuery(); foreach (var link in movie.MovieLinks) { if (link.FailedAttempts > 3) continue; cmd.CommandText = String.Format("INSERT INTO MOVIELINK(ID,MovieID,LinkTitle,PageUrl,PageSiteID,DownloadUrl,DownloadSiteID,Version, HasSubtitle) " + "VALUES({0},{1},'{2}','{3}','{4}','{5}','{6}',{7},{8})", link.ID, link.MovieID, Sanitize(link.LinkTitle), link.PageUrl, link.PageSiteID, link.DowloadUrl, link.DownloadSiteID, link.Version, link.HasSubtitle ? 1 : 0); cmd.ExecuteNonQuery(); } } }
public void ShouldReturnKubrickFilm() { var expectedMovie = new Movie() { Name = "Full Metal Jacket", Director = "Stanley Kubrick", Language = "en-us" }; MovieRepo .Setup(repo => repo.GetMovies()) .Returns(allMovies.Append(CloneMovie(expectedMovie))); TranslationService .Setup(service => service.Translate(It.IsAny <string>(), It.IsAny <CultureInfo>())) .Returns("Have you ever seen a Commie drink a glass of water?"); var actualMovie = MovieFinder.GetMoviesByDirector("Stanley Kubrick").First(); Assert.Equal(expectedMovie.Director, actualMovie.Director); Assert.Equal(expectedMovie.Name, actualMovie.Name); Assert.Equal(expectedMovie.Language, actualMovie.Language); }