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