public async Task CheckValidExisitingPlayer()
{
using var contextFactory = new TestTriviaGameContextFactory();
using TriviaRankContext context = contextFactory.CreateContext();
var insertedPlayer = new Player
{
Username = "******",
Password = "******",
Birthday = DateTime.Now,
Points = 100,
FirstName = "Test",
LastName = "Player"
};
await context.Players.AddAsync(insertedPlayer);
context.SaveChanges();
var repo = new PlayerRepository(context);
PlayerModel player = await repo.getPlayerById(insertedPlayer.Id);
Assert.Equal(insertedPlayer.Id, player.Id);
Assert.Equal(insertedPlayer.Username, player.Username);
Assert.Equal(insertedPlayer.Birthday, player.Birthday);
Assert.Equal(insertedPlayer.Points, player.Points);
Assert.Equal(insertedPlayer.FirstName, player.FirstName);
Assert.Equal(insertedPlayer.LastName, player.LastName);
}
public async Task DeleteFriendInvite()
{
using var contextFactory = new TestTriviaGameContextFactory();
using TriviaRankContext context = contextFactory.CreateContext();
var insertedPlayer1 = new Player
{
Username = "******",
Password = "******",
Birthday = DateTime.Now,
Points = 100,
FirstName = "Bart",
LastName = "Simpson"
};
var insertedPlayer2 = new Player
{
Username = "******",
Password = "******",
Birthday = DateTime.Now,
Points = 200,
FirstName = "Milhouse",
LastName = "Vanhouten"
};
await context.Players.AddAsync(insertedPlayer1);
await context.Players.AddAsync(insertedPlayer2);
context.SaveChanges();
var repo = new OutboxRepository(context);
await repo.createFriendInvite(insertedPlayer1.Username, insertedPlayer2.Username);
await repo.deleteFriendInvite(insertedPlayer1.Username, insertedPlayer2.Username);
Assert.Empty((await repo.getFriendInvites(insertedPlayer2.Id)).Where(p => p.Id == insertedPlayer1.Id));
}
public async Task CheckValidFriendsAdded()
{
using var contextFactory = new TestTriviaGameContextFactory();
using TriviaRankContext context = contextFactory.CreateContext();
var insertedPlayer1 = new Player
{
Username = "******",
Password = "******",
Birthday = DateTime.Now,
Points = 100,
FirstName = "Bob",
LastName = "Smith"
};
var insertedFriend2 = new Player
{
Username = "******",
Password = "******",
Birthday = DateTime.Now,
Points = 200,
FirstName = "Jim",
LastName = "Jones"
};
var insertedFriend3 = new Player
{
Username = "******",
Password = "******",
Birthday = DateTime.Now,
Points = 300,
FirstName = "Bill",
LastName = "Johnson"
};
var numPlayersBefore = context.Players.Count();
await context.Players.AddAsync(insertedPlayer1);
await context.Players.AddAsync(insertedFriend2);
await context.Players.AddAsync(insertedFriend3);
context.SaveChanges();
var repo = new PlayerRepository(context);
await repo.createFriend(insertedPlayer1.Id, insertedFriend2.Id);
await repo.createFriend(insertedFriend2.Id, insertedFriend3.Id);
Assert.Equal(2, (await repo.getFriendsOfPlayer(insertedFriend2.Id)).Count());
}
public async Task CheckCreateValidGameInvite()
{
using var contextFactory = new TestTriviaGameContextFactory();
using TriviaRankContext context = contextFactory.CreateContext();
var insertedPlayer1 = new Player
{
Username = "******",
Password = "******",
Birthday = DateTime.Now,
Points = 100,
FirstName = "Bart",
LastName = "Simpson"
};
var insertedPlayer2 = new Player
{
Username = "******",
Password = "******",
Birthday = DateTime.Now,
Points = 200,
FirstName = "Milhouse",
LastName = "Vanhouten"
};
await context.Players.AddAsync(insertedPlayer1);
await context.Players.AddAsync(insertedPlayer2);
context.SaveChanges();
var game1 = new Game
{
GameName = "new game 1",
OwnerId = insertedPlayer1.Id,
StartDate = DateTimeOffset.Now,
EndDate = DateTimeOffset.Now,
GameMode = true,
TotalQuestions = 10,
IsPublic = true
};
await context.Games.AddAsync(game1);
context.SaveChanges();
var repo = new OutboxRepository(context);
await repo.createGameInvite(game1.Id, insertedPlayer2.Id);
var invitedGame = (await repo.getGameInvites(insertedPlayer2.Id)).FirstOrDefault();
Assert.Equal(game1.Id, invitedGame.Id);
}
public async Task CreateGame_Success()
{
//arrange
using var contextfactory = new TestTriviaGameContextFactory();
using TriviaRankContext context = contextfactory.CreateContext();
var insertOwner = new Player
{
Username = "******",
Password = "******",
Birthday = DateTime.Now,
Points = 100,
FirstName = "Test",
LastName = "Player"
};
await context.Players.AddAsync(insertOwner);
context.SaveChanges();
var newGame = new GameModel
{
OwnerId = insertOwner.Id,
GameName = "some game",
TotalQuestions = 10,
IsPublic = true,
StartDate = DateTimeOffset.Now,
EndDate = DateTimeOffset.Now.AddMinutes(10),
GameMode = true
};
//act
var repo = new GameRepository(context);
var insertedGame = await repo.CreateGame(newGame);
//assert
var dbGame = await context.Games.OrderBy(x => x.Id).LastAsync();
Assert.Equal(insertedGame.Id, dbGame.Id);
Assert.Equal(insertedGame.GameName, dbGame.GameName);
Assert.Equal(insertedGame.OwnerId, dbGame.OwnerId);
Assert.Equal(insertedGame.StartDate, dbGame.StartDate);
Assert.Equal(insertedGame.EndDate, dbGame.EndDate);
Assert.Equal(insertedGame.GameMode, dbGame.GameMode);
Assert.Equal(insertedGame.TotalQuestions, dbGame.TotalQuestions);
Assert.Equal(insertedGame.IsPublic, dbGame.IsPublic);
}
public TriviaRankContext CreateContext()
{
if (_connection == null)
{
_connection = new SqliteConnection("DataSource=:memory:");
_connection.Open();
DbContextOptions <TriviaRankContext> options = CreateOptions();
using var context = new TriviaRankContext(options);
context.Database.EnsureCreated();
// add extra test seed data here (or, in each test method)
}
return(new TriviaRankContext(CreateOptions()));
}
public async Task CheckValidLastNMessages()
{
using var contextFactory = new TestTriviaGameContextFactory();
using TriviaRankContext context = contextFactory.CreateContext();
var messages = new String[] { "Hello!", "Hello Again!", "Hello Again2!" };
var insertedPlayer1 = new Player
{
Username = "******",
Password = "******",
Birthday = DateTime.Now,
Points = 100,
FirstName = "Larry",
LastName = "Larman"
};
var insertedPlayer2 = new Player
{
Username = "******",
Password = "******",
Birthday = DateTime.Now,
Points = 100,
FirstName = "Jimbo",
LastName = "Jones"
};
await context.Players.AddAsync(insertedPlayer1);
await context.Players.AddAsync(insertedPlayer2);
context.SaveChanges();
var repo = new MessageRepository(context);
await repo.createMessage(insertedPlayer1.Id, insertedPlayer2.Id, messages[0]);
await repo.createMessage(insertedPlayer1.Id, insertedPlayer2.Id, messages[1]);
await repo.createMessage(insertedPlayer1.Id, insertedPlayer2.Id, messages[2]);
var repoMessages = (await repo.getLastNMessages(insertedPlayer1.Id, insertedPlayer2.Id, 3)).ToArray();
foreach (var index in Enumerable.Range(0, 3))
{
Assert.Equal(messages[index], repoMessages[index].Body);
}
}
public async Task CheckValidAddedMessage()
{
using var contextFactory = new TestTriviaGameContextFactory();
using TriviaRankContext context = contextFactory.CreateContext();
var testBody = "Hello Test2!";
var insertedPlayer1 = new Player
{
Username = "******",
Password = "******",
Birthday = DateTime.Now,
Points = 100,
FirstName = "Larry",
LastName = "Larman"
};
var insertedPlayer2 = new Player
{
Username = "******",
Password = "******",
Birthday = DateTime.Now,
Points = 100,
FirstName = "Jimbo",
LastName = "Jones"
};
await context.Players.AddAsync(insertedPlayer1);
await context.Players.AddAsync(insertedPlayer2);
context.SaveChanges();
var repo = new MessageRepository(context);
await repo.createMessage(insertedPlayer1.Id, insertedPlayer2.Id, testBody);
var body = (await repo.getLastNMessages(insertedPlayer1.Id, insertedPlayer2.Id, 1)).FirstOrDefault().Body;
Assert.Equal(testBody, body);
}
public OutboxRepository(TriviaRankContext context)
{
_context = context;
}
public async Task CheckValidNumIndexedPlayers()
{
using var contextFactory = new TestTriviaGameContextFactory();
using TriviaRankContext context = contextFactory.CreateContext();
var insertedPlayer1 = new Player
{
Username = "******",
Password = "******",
Birthday = DateTime.Now,
Points = 100,
FirstName = "Bob",
LastName = "Smith"
};
var insertedPlayer2 = new Player
{
Username = "******",
Password = "******",
Birthday = DateTime.Now,
Points = 100,
FirstName = "Bob",
LastName = "Smith"
};
var insertedPlayer3 = new Player
{
Username = "******",
Password = "******",
Birthday = DateTime.Now,
Points = 100,
FirstName = "Bob",
LastName = "Smith"
};
var insertedPlayer4 = new Player
{
Username = "******",
Password = "******",
Birthday = DateTime.Now,
Points = 100,
FirstName = "Bob",
LastName = "Smith"
};
var insertedPlayer5 = new Player
{
Username = "******",
Password = "******",
Birthday = DateTime.Now,
Points = 100,
FirstName = "Bob",
LastName = "Smith"
};
await context.Players.AddAsync(insertedPlayer1);
await context.Players.AddAsync(insertedPlayer2);
await context.Players.AddAsync(insertedPlayer3);
await context.Players.AddAsync(insertedPlayer4);
await context.Players.AddAsync(insertedPlayer5);
context.SaveChanges();
var repo = new PlayerRepository(context);
Assert.Equal(2, (await repo.getNPlayers(2, 0)).Count());
Assert.Equal(2, (await repo.getNPlayers(2, 1)).Count());
Assert.Single((await repo.getNPlayers(1, 2)));
Assert.Single((await repo.getNPlayers(2, 2)));
}
public async Task CheckValidPlayerGames()
{
using var contextFactory = new TestTriviaGameContextFactory();
using TriviaRankContext context = contextFactory.CreateContext();
var insertedPlayer1 = new Player
{
Username = "******",
Password = "******",
Birthday = DateTime.Now,
Points = 100,
FirstName = "Bob",
LastName = "Smith"
};
var insertedPlayer2 = new Player
{
Username = "******",
Password = "******",
Birthday = DateTime.Now,
Points = 100,
FirstName = "Bob",
LastName = "Smith"
};
await context.Players.AddAsync(insertedPlayer1);
await context.Players.AddAsync(insertedPlayer2);
context.SaveChanges();
var insertedGame1 = new Game
{
GameName = "randomGame",
OwnerId = insertedPlayer1.Id,
StartDate = DateTimeOffset.Now,
EndDate = DateTimeOffset.Now,
GameMode = true,
TotalQuestions = 10,
IsPublic = true
};
await context.Games.AddAsync(insertedGame1);
context.SaveChanges();
var insertedGamePlayer1 = new GamePlayer
{
GameId = insertedGame1.Id,
PlayerId = insertedPlayer2.Id,
TotalCorrect = 8
};
await context.GamePlayers.AddAsync(insertedGamePlayer1);
context.SaveChanges();
var repo = new PlayerRepository(context);
GameModel createdGame = (await repo.getPlayerGames(insertedPlayer2.Id, null)).FirstOrDefault();
Assert.Equal(insertedGame1.Id, createdGame.Id);
Assert.Equal(insertedGame1.GameName, createdGame.GameName);
Assert.Equal(insertedGame1.OwnerId, createdGame.OwnerId);
Assert.Equal(insertedGame1.StartDate, createdGame.StartDate);
Assert.Equal(insertedGame1.EndDate, createdGame.EndDate);
Assert.Equal(insertedGame1.GameMode, createdGame.GameMode);
Assert.Equal(insertedGame1.TotalQuestions, createdGame.TotalQuestions);
Assert.Equal(insertedGame1.IsPublic, createdGame.IsPublic);
}
public PlayerRepository(TriviaRankContext context)
{
_context = context;
}
public async Task CreatePlayer_PlayerIsValid_Success()
{
//arrange
using var contextfactory = new TestTriviaGameContextFactory();
using TriviaRankContext context = contextfactory.CreateContext();
var insertOwner = new Player
{
Username = "******",
Password = "******",
Birthday = DateTime.Now,
Points = 100,
FirstName = "Test",
LastName = "Player"
};
var insertPlayer = new Player
{
Username = "******",
Password = "******",
Birthday = DateTime.Now,
Points = 100,
FirstName = "TestPlayer",
LastName = "Playerlastname"
};
await context.AddAsync(insertOwner);
await context.AddAsync(insertPlayer);
await context.SaveChangesAsync();
var insertPlayerModel = new PlayerModel
{
Id = insertPlayer.Id,
Username = insertPlayer.Username,
Password = insertPlayer.Password,
Birthday = insertPlayer.Birthday,
Points = insertPlayer.Points,
FirstName = insertPlayer.FirstName,
LastName = insertPlayer.LastName
};
var game = new Game
{
GameName = "testgame1",
GameMode = true,
OwnerId = insertOwner.Id,
StartDate = DateTimeOffset.Now,
EndDate = DateTimeOffset.Now.AddMinutes(20.0),
TotalQuestions = 10,
IsPublic = true
};
await context.AddAsync(game);
await context.SaveChangesAsync();
var repo = new GameRepository(context);
//act
var insertedId = await repo.AddPlayerToGame(game.Id, insertPlayerModel);
var gp = await context.GamePlayers.Where(gp => gp.PlayerId == insertPlayer.Id).FirstOrDefaultAsync();
//assert
Assert.Equal(insertedId, gp.Id);
}
public async Task SearchAllGames_GameIsValid_Success()
{
//arrange
using var contextfactory = new TestTriviaGameContextFactory();
using TriviaRankContext context = contextfactory.CreateContext();
var insertOwner = new Player
{
Username = "******",
Password = "******",
Birthday = DateTime.Now,
Points = 100,
FirstName = "Test",
LastName = "Player"
};
await context.AddAsync(insertOwner);
context.SaveChanges();
var insertedGames = new List <Game>();
for (var i = 1; i < 5; i++)
{
var game = new Game
{
GameName = "CoolGameDude" + i,
GameMode = true,
OwnerId = 1,
StartDate = DateTimeOffset.Now,
EndDate = DateTimeOffset.Now.AddMinutes(20.0),
TotalQuestions = i + 10,
IsPublic = true
};
await context.AddAsync(game);
}
for (var i = 1; i < 5; i++)
{
var game = new Game
{
GameName = "CoolGameDude" + i,
GameMode = true,
OwnerId = 1,
StartDate = DateTimeOffset.Now,
EndDate = DateTimeOffset.Now,
TotalQuestions = i + 10,
IsPublic = true
};
await context.AddAsync(game);
}
context.SaveChanges();
var repo = new GameRepository(context);
var dbGames = new List <GameModel>();
//act
dbGames = await repo.SearchAllGames();
//assert
Assert.NotEmpty(dbGames);
}
public GameRepository(TriviaRankContext context)
{
_context = context;
}
public MessageRepository(TriviaRankContext context)
{
_context = context;
}
