public void TestCreateTrackCount() { var options = new DbContextOptionsBuilder <MusicSpotDbContext>().UseInMemoryDatabase("createTracksReturnCount").Options; var dbContext = new MusicSpotDbContext(options); var service = new TrackService(dbContext); var track = new Track { Name = "Joni", Duration = "4:44", AlbumId = 4 }; for (int i = 1; i < 5; i++) { service.Create(track.Name, track.Duration, track.AlbumId); dbContext.SaveChanges(); } dbContext.SaveChanges(); int result = dbContext.Tracks.CountAsync().Result; Assert.AreEqual(4, result); Assert.AreNotEqual(16, result); Assert.AreNotEqual("int", result); Assert.That(result, Is.Not.Null); Assert.That(track.Id, Is.Not.Null); dbContext.Remove(track); }
public void TestCreateMovieCount() { var options = new DbContextOptionsBuilder <MusicSpotDbContext>().UseInMemoryDatabase("createMovieReturnCount").Options; var dbContext = new MusicSpotDbContext(options); var service = new MovieService(dbContext); var movie = new Movie { Title = "Speed", Genre = "Action", ImageUrl = "aaa", Year = 1998, Description = "some description", UserId = "aaa" }; for (int i = 1; i < 5; i++) { service.Create(movie.Title, movie.Genre, movie.ImageUrl, movie.Year, movie.Description, movie.UserId); dbContext.SaveChanges(); } dbContext.SaveChanges(); int result = dbContext.Movies.CountAsync().Result; Assert.AreEqual(4, result); Assert.AreNotEqual(14, result); Assert.AreNotEqual("aa", result); Assert.That(result, Is.Not.Null); Assert.That(movie.Id, Is.Not.Null); dbContext.Remove(movie); }
public void TestTracks() { var options = new DbContextOptionsBuilder <MusicSpotDbContext>().UseInMemoryDatabase("tracksIndex").Options; var dbContext = new MusicSpotDbContext(options); var service = new TrackService(dbContext); var track = new Track { Id = 1, Name = "Joni", Duration = "4:44", AlbumId = 4 }; dbContext.Tracks.Add(track); dbContext.SaveChanges(); var result = service.Index("aaa", "Joni", 5, 5); Assert.That(result, Is.Not.Null); Assert.That(track.Id, Is.Not.Null); Assert.AreEqual("aaa", result.Result.UserId); Assert.AreNotEqual("bbbaaa", result.Result.UserId); Assert.AreNotEqual("aaaa", result.Result.AlbumId); Assert.AreNotEqual("aaa", result.Result.SearchTerm); Assert.AreEqual("Joni", result.Result.SearchTerm); Assert.AreEqual(5, result.Result.PageNum); Assert.AreNotEqual("int", result.Result.PageNum); Assert.AreEqual(5, result.Result.PageSize); Assert.AreNotEqual("aaa", result.Result.PageNum); }
public void TestBookDelete() { var options = new DbContextOptionsBuilder <MusicSpotDbContext>().UseInMemoryDatabase("bookDelete").Options; var dbContext = new MusicSpotDbContext(options); var service = new BookService(dbContext); var book = new Book { Id = 1, Title = "It", Genre = "Horror", ImageUrl = "aaa", Description = "some description", UserId = "aaa" }; dbContext.Books.Add(book); dbContext.SaveChanges(); var result = service.Delete(1); Assert.AreEqual(result, true); Assert.AreEqual(service.BookExist(1), false); Assert.AreNotEqual(result, false); Assert.That(book.Id, Is.Not.Null); }
public void TestCreateArtistCount() { var options = new DbContextOptionsBuilder <MusicSpotDbContext>().UseInMemoryDatabase("createArtistsReturnCount").Options; var dbContext = new MusicSpotDbContext(options); var service = new ArtistService(dbContext); var artist = new Artist { Name = "joni", Genre = "metal", UserId = "jshsdjhdajdh" }; for (int i = 1; i < 5; i++) { service.Create(artist.Name, artist.Genre, artist.UserId); dbContext.SaveChanges(); } dbContext.SaveChanges(); int result = dbContext.Artists.CountAsync().Result; Assert.AreEqual(5, result); }
public void TestArtistNotExit() { var options = new DbContextOptionsBuilder <MusicSpotDbContext>().UseInMemoryDatabase("artistNotExist").Options; var dbContext = new MusicSpotDbContext(options); var service = new ArtistService(dbContext); var artist = new Artist { Id = 1, Name = "Joni", Genre = "Horror", UserId = "aaa" }; dbContext.Artists.Add(artist); dbContext.SaveChanges(); var result = service.ArtistDetails(artist.Id); Assert.That(artist.Id, Is.Not.Null); Assert.That(result, Is.Not.Null); Assert.AreEqual(result.Result.Genre, artist.Genre); Assert.AreEqual(result.Result.Name, artist.Name); Assert.AreEqual(result.Result.Id, artist.Id); }
public void TestMovieDelete() { var options = new DbContextOptionsBuilder <MusicSpotDbContext>().UseInMemoryDatabase("movieDelete").Options; var dbContext = new MusicSpotDbContext(options); var service = new MovieService(dbContext); var movie = new Movie { Id = 1, Title = "Speed", Genre = "Action", ImageUrl = "aaa", Year = 1998, Description = "some description", UserId = "aaa" }; dbContext.Movies.Add(movie); dbContext.SaveChanges(); var result = service.Delete(1); Assert.AreEqual(result, true); Assert.AreEqual(service.MovieExist(1), false); Assert.AreNotEqual(result, false); Assert.That(movie.Id, Is.Not.Null); }
public void TestBookNotExit() { var options = new DbContextOptionsBuilder <MusicSpotDbContext>().UseInMemoryDatabase("bookNotExist").Options; var dbContext = new MusicSpotDbContext(options); var service = new BookService(dbContext); var book = new Book { Id = 1, Title = "It", Genre = "Horror", ImageUrl = "aaa", Description = "some description", UserId = "aaa" }; dbContext.Books.Add(book); dbContext.SaveChanges(); var result = service.BooksDetails(book.Id); Assert.That(book.Id, Is.Not.Null); Assert.That(result, Is.Not.Null); Assert.AreEqual(result.Result.Genre, book.Genre); Assert.AreEqual(result.Result.Title, book.Title); Assert.AreEqual(result.Result.Id, book.Id); Assert.AreEqual(result.Result.ImageUrl, book.ImageUrl); Assert.AreNotEqual(result.Result.Description, 2000); }
public void TestCreateBooksCount() { var options = new DbContextOptionsBuilder <MusicSpotDbContext>().UseInMemoryDatabase("createBooksReturnCount").Options; var dbContext = new MusicSpotDbContext(options); var service = new BookService(dbContext); var book = new Book { Title = "It", Genre = "Horror", ImageUrl = "aaa", Description = "some description", UserId = "aaa" }; for (int i = 1; i < 5; i++) { service.Create(book.Title, book.Genre, book.ImageUrl, book.Description, book.UserId); dbContext.SaveChanges(); } dbContext.SaveChanges(); int result = dbContext.Books.CountAsync().Result; Assert.AreEqual(4, result); Assert.That(result, Is.Not.Null); Assert.That(book.Id, Is.Not.Null); dbContext.Remove(book); }
public void TestAlbums() { var options = new DbContextOptionsBuilder <MusicSpotDbContext>().UseInMemoryDatabase("albumIndex").Options; var dbContext = new MusicSpotDbContext(options); var service = new AlbumService(dbContext); var album = new Album { Name = "Joni", ImageUrl = "aaaa", Year = 2000, Format = "LP", MediaCondition = "G+", SleeveCondition = "NM", Notes = "some notes", ArtistId = 7 }; dbContext.Albums.Add(album); dbContext.SaveChanges(); var result = service.Index("aaa", album.ArtistId, "Joni", 5, 5); Assert.That(result, Is.Not.Null); Assert.That(album.Id, Is.Not.Null); Assert.AreEqual("aaa", result.Result.UserId); Assert.AreNotEqual("bbbaaa", result.Result.UserId); Assert.AreEqual(7, result.Result.ArtistId); Assert.AreNotEqual("aaaa", result.Result.ArtistId); Assert.AreNotEqual("aaa", result.Result.SearchTerm); Assert.AreEqual("Joni", result.Result.SearchTerm); Assert.AreEqual(5, result.Result.PageNum); Assert.AreEqual(5, result.Result.PageSize); Assert.AreNotEqual("aaa", result.Result.PageNum); }
public void TestGameDelete() { var options = new DbContextOptionsBuilder <MusicSpotDbContext>().UseInMemoryDatabase("gameDelete").Options; var dbContext = new MusicSpotDbContext(options); var service = new GameService(dbContext); var game = new Game { Id = 1, Title = "FIFA", Genre = "Sport", ImageUrl = "aaa", Description = "some description", UserId = "aaa" }; dbContext.Games.Add(game); dbContext.SaveChanges(); var result = service.Delete(1); Assert.AreEqual(result, true); Assert.AreEqual(service.GameExist(1), false); Assert.AreNotEqual(result, false); Assert.That(game.Id, Is.Not.Null); }
public void TestTrackEdit() { var options = new DbContextOptionsBuilder <MusicSpotDbContext>().UseInMemoryDatabase("trackEditCorrect").Options; var dbContext = new MusicSpotDbContext(options); var service = new TrackService(dbContext); var track = new Track { Id = 1, Name = "Joni", Duration = "4:44", AlbumId = 4 }; dbContext.Tracks.Add(track); dbContext.SaveChanges(); var result = service.Edit(track.Id, track.Name, track.Duration, track.AlbumId); Assert.AreNotEqual(track, result); Assert.AreEqual("Joni", track.Name); Assert.AreNotEqual("Joki", track.Name); Assert.That(result, Is.Not.Null); Assert.That(track.Id, Is.Not.Null); Assert.AreEqual(result, true); }
public void TestTracksDetails() { var options = new DbContextOptionsBuilder <MusicSpotDbContext>().UseInMemoryDatabase("trackDetails").Options; var dbContext = new MusicSpotDbContext(options); var service = new TrackService(dbContext); var track = new Track { Id = 1, Name = "Joni", Duration = "4:44", AlbumId = 4 }; dbContext.Tracks.Add(track); dbContext.SaveChanges(); var result = service.TrackDetails(track.Id); Assert.That(result.Result.Id, Is.Not.Null); Assert.That(result, Is.Not.Null); Assert.AreEqual("Joni", result.Result.Name); Assert.AreNotEqual(2000, result.Result.Name); Assert.AreEqual("4:44", result.Result.Duration); Assert.AreNotEqual(8, result.Result.AlbumId); Assert.AreEqual(track.AlbumId, result.Result.AlbumId); }
public void TestTrackCount() { var options = new DbContextOptionsBuilder <MusicSpotDbContext>().UseInMemoryDatabase("trackCount").Options; var dbContext = new MusicSpotDbContext(options); var service = new TrackService(dbContext); var track = new Track { Id = 1, Name = "Joni", Duration = "4:44", AlbumId = 4 }; for (int i = 0; i < 3; i++) { dbContext.Tracks.Add(track); } dbContext.SaveChanges(); var result = dbContext.Tracks.CountAsync().Result; Assert.AreNotEqual(result, true); Assert.AreEqual(result, 1); Assert.That(result, Is.Not.Null); }
public void TestTrackDelete() { var options = new DbContextOptionsBuilder <MusicSpotDbContext>().UseInMemoryDatabase("trackDelete").Options; var dbContext = new MusicSpotDbContext(options); var service = new TrackService(dbContext); var track = new Track { Id = 1, Name = "Joni", Duration = "4:44", AlbumId = 4 }; dbContext.Tracks.Add(track); dbContext.SaveChanges(); var result = service.Delete(track.Id); Assert.AreNotEqual(result, true); Assert.AreEqual(service.TrackExist(track.Id), false); Assert.AreEqual(result, false); Assert.That(track.Id, Is.Not.Null); }
public void TestAllMovies() { var options = new DbContextOptionsBuilder <MusicSpotDbContext>().UseInMemoryDatabase("returnMoviesNotNull").Options; var dbContext = new MusicSpotDbContext(options); var service = new MovieService(dbContext); var movie = new Movie { Title = "Speed", Genre = "Action", ImageUrl = "aaa", Year = 1998, Description = "some description", UserId = "aaa" }; var result = service.AllMovies(movie.UserId, "action", 5, 5); Assert.That(result, Is.Not.Null); Assert.AreEqual("aaa", result.Result.UserId); Assert.AreNotEqual(14, result.Result.UserId); Assert.AreEqual("action", result.Result.SearchTerm); Assert.AreNotEqual("actionssss", result.Result.SearchTerm); Assert.AreEqual(5, result.Result.PageSize); Assert.AreEqual(5, result.Result.PageNum); Assert.AreNotEqual("ccc", result.Result.PageNum); }
public void TestCreateGamesCount() { var options = new DbContextOptionsBuilder <MusicSpotDbContext>().UseInMemoryDatabase("createGamesReturnCount").Options; var dbContext = new MusicSpotDbContext(options); var service = new GameService(dbContext); var game = new Game { Title = "FIFA", Genre = "Sport", ImageUrl = "aaa", Description = "some description", UserId = "aaa" }; for (int i = 1; i < 5; i++) { service.Create(game.Title, game.Genre, game.ImageUrl, game.Description, game.UserId); dbContext.SaveChanges(); } dbContext.SaveChanges(); int result = dbContext.Games.CountAsync().Result; Assert.AreEqual(4, result); Assert.That(result, Is.Not.Null); Assert.That(game.Id, Is.Not.Null); dbContext.Remove(game); }
public void TestGameNotExit() { var options = new DbContextOptionsBuilder <MusicSpotDbContext>().UseInMemoryDatabase("gameNotExist").Options; var dbContext = new MusicSpotDbContext(options); var service = new GameService(dbContext); var game = new Game { Id = 1, Title = "FIFA", Genre = "Action", ImageUrl = "aaa", Description = "some description", UserId = "aaa" }; dbContext.Games.Add(game); dbContext.SaveChanges(); var result = service.GameDetails(game.Id); Assert.That(game.Id, Is.Not.Null); Assert.That(result, Is.Not.Null); Assert.AreEqual(result.Result.Genre, game.Genre); Assert.AreEqual(result.Result.Title, game.Title); Assert.AreEqual(result.Result.Id, game.Id); Assert.AreEqual(result.Result.ImageUrl, game.ImageUrl); Assert.AreNotEqual(result.Result.Description, 2000); }
public void TestAlbumsList() { var options = new DbContextOptionsBuilder <MusicSpotDbContext>().UseInMemoryDatabase("albumsListCount").Options; var dbContext = new MusicSpotDbContext(options); var service = new AlbumService(dbContext); var album = new Album { Name = "Joni", ImageUrl = "aaaa", Year = 2000, Format = "LP", MediaCondition = "G+", SleeveCondition = "NM", Notes = "some notes", ArtistId = 7 }; dbContext.Albums.Add(album); dbContext.SaveChanges(); var result = service.AlbumsList("aaa", album.ArtistId); Assert.That(result, Is.Not.Null); Assert.AreEqual(dbContext.Albums.CountAsync().Result, 1); Assert.That(album.Id, Is.Not.Null); }
public void TestCreateAlbumsCount() { var options = new DbContextOptionsBuilder <MusicSpotDbContext>().UseInMemoryDatabase("createAlbumsReturnCount").Options; var dbContext = new MusicSpotDbContext(options); var service = new AlbumService(dbContext); var album = new Album { Name = "Joni", ImageUrl = "aaaa", Year = 2000, Format = "LP", MediaCondition = "G+", SleeveCondition = "NM", Notes = "some notes", ArtistId = 7 }; for (int i = 1; i < 5; i++) { service.Create(album.Name, album.ImageUrl, album.Year, album.Format, album.MediaCondition, album.SleeveCondition, album.Notes, album.ArtistId); dbContext.SaveChanges(); } dbContext.SaveChanges(); int result = dbContext.Albums.CountAsync().Result; Assert.AreEqual(4, result); Assert.That(result, Is.Not.Null); Assert.That(album.Id, Is.Not.Null); dbContext.Remove(album); }
public void TestAlbumEdit() { var options = new DbContextOptionsBuilder <MusicSpotDbContext>().UseInMemoryDatabase("albumEditCorrect").Options; var dbContext = new MusicSpotDbContext(options); var service = new AlbumService(dbContext); var album = new Album { Name = "Joni", ImageUrl = "aaaa", Year = 2000, Format = "LP", MediaCondition = "G+", SleeveCondition = "NM", Notes = "some notes", ArtistId = 7 }; dbContext.Albums.Add(album); dbContext.SaveChanges(); var result = service.Edit(album.Id, album.Name = "Joki", album.ImageUrl, album.Year, album.Format, album.MediaCondition, album.SleeveCondition, album.Name, album.ArtistId); Assert.AreNotEqual(album, result); Assert.AreEqual("Joki", album.Name); Assert.That(result, Is.Not.Null); Assert.That(album.Id, Is.Not.Null); Assert.AreEqual(result, true); }
public void TestMovieNotExit() { var options = new DbContextOptionsBuilder <MusicSpotDbContext>().UseInMemoryDatabase("movieNotExist").Options; var dbContext = new MusicSpotDbContext(options); var service = new MovieService(dbContext); var movie = new Movie { Id = 1, Title = "Speed", Genre = "Action", ImageUrl = "aaa", Year = 1998, Description = "some description", UserId = "aaa" }; dbContext.Movies.Add(movie); dbContext.SaveChanges(); var result = service.MovieDetails(1); Assert.That(movie.Id, Is.Not.Null); Assert.That(result, Is.Not.Null); Assert.AreEqual(result.Result.Genre, movie.Genre); Assert.AreEqual(result.Result.Title, movie.Title); Assert.AreEqual(result.Result.Id, movie.Id); Assert.AreEqual(result.Result.ImageUrl, movie.ImageUrl); Assert.AreNotEqual(result.Result.Year, 2000); }
public InMemoryDbContext() { connection = new SqliteConnection("Filename=:memory:"); connection.Open(); dbContextOptions = new DbContextOptionsBuilder <MusicSpotDbContext>() .UseSqlite(connection) .Options; using var context = new MusicSpotDbContext(dbContextOptions); context.Database.EnsureCreated(); }
public void TestAllAlbums() { var options = new DbContextOptionsBuilder <MusicSpotDbContext>().UseInMemoryDatabase("returnAlbumNotNull").Options; var dbContext = new MusicSpotDbContext(options); var service = new AlbumService(dbContext); var result = service.AllAlbums("aaa", 14, "music", 5, 5); Assert.That(result, Is.Not.Null); Assert.AreNotEqual("aaaaaa", result.Result.UserId); Assert.AreEqual(14, result.Result.ArtistId); Assert.AreEqual(5, result.Result.PageSize); Assert.AreEqual(5, result.Result.PageNum); Assert.AreEqual("music", result.Result.SearchTerm); }
public void TestAllArtist() { var options = new DbContextOptionsBuilder <MusicSpotDbContext>().UseInMemoryDatabase("returnArtistNotNull").Options; var dbContext = new MusicSpotDbContext(options); var service = new ArtistService(dbContext); var result = service.AllArtists("aaa", "metal", 1, 1); Assert.That(result, Is.Not.Null); Assert.AreEqual("aaa", result.Result.UserId); Assert.AreEqual("metal", result.Result.SearchTerm); Assert.AreNotEqual("rock", result.Result.SearchTerm); Assert.AreEqual(1, result.Result.PageNum); Assert.AreEqual(1, result.Result.PageSize); }
public void TestAllBooks() { var options = new DbContextOptionsBuilder <MusicSpotDbContext>().UseInMemoryDatabase("returnBooksNotNull").Options; var dbContext = new MusicSpotDbContext(options); var service = new BookService(dbContext); var result = service.AllBooks("aaa", "horror", 5, 5); Assert.That(result, Is.Not.Null); Assert.AreEqual("aaa", result.Result.UserId); Assert.AreEqual("horror", result.Result.SearchTerm); Assert.AreNotEqual("sport", result.Result.SearchTerm); Assert.AreNotEqual(6, result.Result.PageNum); Assert.AreNotEqual(7, result.Result.PageSize); }
public void TestCreateArtist() { var options = new DbContextOptionsBuilder <MusicSpotDbContext>().UseInMemoryDatabase("createArtistsReturnCount").Options; var dbContext = new MusicSpotDbContext(options); var service = new ArtistService(dbContext); var artist = new Artist { Name = "joni", Genre = "metal", UserId = "jshsdjhdajdh" }; var result = service.Create(artist.Name, artist.Genre, artist.UserId); Assert.That(result, Is.Not.Null); }
public void TrackCreateTest() { var options = new DbContextOptionsBuilder <MusicSpotDbContext>().UseInMemoryDatabase("TrackCreateCorrect").Options; var dbContext = new MusicSpotDbContext(options); var service = new TrackService(dbContext); var track = new Track { Name = "Joni", Duration = "4:44", AlbumId = 4 }; var result = service.Create(track.Name, track.Duration, track.AlbumId); Assert.That(result, Is.Not.Null); Assert.AreEqual("Joni", track.Name); Assert.That(track.Id, Is.Not.Null); Assert.AreEqual(1, result); }
public void TestArtistList() { var options = new DbContextOptionsBuilder <MusicSpotDbContext>().UseInMemoryDatabase("artistListCount").Options; var dbContext = new MusicSpotDbContext(options); var service = new ArtistService(dbContext); var artist = new Artist { Name = "joni", Genre = "metal", UserId = "jshsdjhdajdh" }; dbContext.Artists.Add(artist); dbContext.SaveChanges(); var result = service.ArtistsList; Assert.That(result, Is.Not.Null); }
public void TestAllTracks() { var options = new DbContextOptionsBuilder <MusicSpotDbContext>().UseInMemoryDatabase("returnTrackNotNull").Options; var dbContext = new MusicSpotDbContext(options); var service = new TrackService(dbContext); var track = new Track { Name = "Joni", Duration = "4:44", AlbumId = 4 }; dbContext.Tracks.Add(track); dbContext.SaveChanges(); var result = service.AllTracks(4); Assert.That(result, Is.Not.Null); Assert.AreNotEqual("aaaaaa", result.Result.UserId); }