public async void Should_Get_GameRoot_By_Id()
{
var game_root = new GameRoot {
Id = 3, Name = "Sudoku"
};
var options = new DbContextOptionsBuilder <GServerDbContext>()
.UseInMemoryDatabase(databaseName: "test2root")
.Options;
using (var context = new GServerDbContext(options))
{
var repository = new GameRootRepository(context);
await repository.AddAsync(game_root);
}
using (var context = new GServerDbContext(options))
{
var repository = new GameRootRepository(context);
var _game_root = await repository.GetByIdAsync(game_root.Id);
var _game_root_null = await repository.GetByIdAsync(5);
Assert.IsType <GameRoot>(_game_root);
Assert.Equal("Sudoku", _game_root.Name);
Assert.Null(_game_root_null);
Assert.Equal(3, _game_root.Id);
}
}
public async void Should_Save_GameRoot_To_Db()
{
var game_root = new GameRoot {
Id = 1,
Name = "Tavla"
};
var options = new DbContextOptionsBuilder <GServerDbContext>()
.UseInMemoryDatabase("test1root")
.Options;
using (var context = new GServerDbContext(options)) {
var repository = new GameRootRepository(context);
await repository.AddAsync(game_root);
}
using (var context = new GServerDbContext(options))
{
var repository = new GameRootRepository(context);
var all_game_roots = await repository.ListAllAsync();
Assert.NotNull(all_game_roots);
Assert.Equal(1, all_game_roots.Count);
}
}
public async void Should_Update_GameRoot_Data()
{
var game_root = new GameRoot {
Id = 1, Name = "Sudoku"
};
var options = new DbContextOptionsBuilder <GServerDbContext>()
.UseInMemoryDatabase(databaseName: "test4root")
.Options;
using (var context = new GServerDbContext(options))
{
var repository = new GameRootRepository(context);
await repository.AddAsync(game_root);
}
using (var context = new GServerDbContext(options))
{
var repository = new GameRootRepository(context);
var _game_root = await repository.GetByIdAsync(game_root.Id);
_game_root.Name = "Tavla";
await repository.UpdateAsync(_game_root);
_game_root = await repository.GetByIdAsync(game_root.Id);
Assert.Equal("Tavla", _game_root.Name);
}
}
public async void Should_Get_Category_By_Id()
{
var category = new Category {
Id = 3, Title = "MMORPG"
};
var category_2 = new Category {
Id = 4, Title = "FPS"
};
var options = new DbContextOptionsBuilder <GServerDbContext>()
.UseInMemoryDatabase(databaseName: "test2")
.Options;
using (var context = new GServerDbContext(options))
{
var repository = new CategoryRepository(context);
await repository.AddAsync(category);
await repository.AddAsync(category_2);
}
using (var context = new GServerDbContext(options))
{
var repository = new CategoryRepository(context);
var _category = await repository.GetByIdAsync(category.Id);
var _category_null = await repository.GetByIdAsync(5);
Assert.IsType <Category>(_category);
Assert.Equal("MMORPG", _category.Title);
Assert.Null(_category_null);
Assert.Equal(3, _category.Id);
}
}
public GameRepository(
GServerDbContext gServerDbContext,
UserManager <User> userManager)
: base(gServerDbContext)
{
this.userManager = userManager;
}
public async void Should_Update_Category_Data()
{
var category = new Category {
Id = 1, Title = "FPS"
};
var options = new DbContextOptionsBuilder <GServerDbContext>()
.UseInMemoryDatabase(databaseName: "test4")
.Options;
using (var context = new GServerDbContext(options))
{
var repository = new CategoryRepository(context);
await repository.AddAsync(category);
}
using (var context = new GServerDbContext(options))
{
var repository = new CategoryRepository(context);
var _category = await repository.GetByIdAsync(category.Id);
_category.Title = "MMORPG";
await repository.UpdateAsync(_category);
_category = await repository.GetByIdAsync(category.Id);
Assert.Equal("MMORPG", _category.Title);
}
}
public async void Should_Save_Category_To_Db()
{
var category = new Category {
Id = 1, Title = "MMORPG"
};
var category_2 = new Category {
Id = 2, Title = "FPS"
};
var options = new DbContextOptionsBuilder <GServerDbContext>()
.UseInMemoryDatabase(databaseName: "test1")
.Options;
using (var context = new GServerDbContext(options)) {
var repository = new CategoryRepository(context);
await repository.AddAsync(category);
await repository.AddAsync(category_2);
}
using (var context = new GServerDbContext(options))
{
var repository = new CategoryRepository(context);
var all_categories = await repository.ListAllAsync();
Assert.NotNull(all_categories);
}
}
public async void Should_Remove_GameRoot_By_Id()
{
var game_root = new GameRoot {
Id = 3, Name = "Sudoku"
};
var game_root_2 = new GameRoot {
Id = 4, Name = "Chess"
};
var game_root_3 = new GameRoot {
Id = 5, Name = "Go"
};
var options = new DbContextOptionsBuilder <GServerDbContext>()
.UseInMemoryDatabase(databaseName: "test3root")
.Options;
using (var context = new GServerDbContext(options))
{
var repository = new GameRootRepository(context);
await repository.AddAsync(game_root);
await repository.AddAsync(game_root_2);
await repository.AddAsync(game_root_3);
}
using (var context = new GServerDbContext(options))
{
var repository = new GameRootRepository(context);
await repository.DeleteAsync(game_root);
}
using (var context = new GServerDbContext(options))
{
var repository = new GameRootRepository(context);
var all_game_roots = await repository.ListAllAsync();
Assert.Equal(2, all_game_roots.Count);
}
}
public async void Should_Remove_Category_Data_By_Id()
{
var category = new Category {
Id = 3, Title = "MMORPG"
};
var category_2 = new Category {
Id = 4, Title = "FPS"
};
var category_3 = new Category {
Id = 5, Title = "FPS"
};
var options = new DbContextOptionsBuilder <GServerDbContext>()
.UseInMemoryDatabase(databaseName: "test3")
.Options;
using (var context = new GServerDbContext(options))
{
var repository = new CategoryRepository(context);
await repository.AddAsync(category);
await repository.AddAsync(category_2);
await repository.AddAsync(category_3);
}
using (var context = new GServerDbContext(options))
{
var repository = new CategoryRepository(context);
await repository.DeleteAsync(category);
}
using (var context = new GServerDbContext(options))
{
var repository = new CategoryRepository(context);
var all_categories = await repository.ListAllAsync();
Assert.Equal(2, all_categories.Count);
}
}
public CategoryRepository(GServerDbContext gServerDbContext) : base(gServerDbContext)
{
}
public GameRootRepository(GServerDbContext gServerDbContext) : base(gServerDbContext)
{
}
