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);
}
