public SQLBoardRepository(AppDbContext context, IUsersBoardsRepository usersBoardsRepo,
IUserRepository userRepo)
: base(context)
{
_UsersBoardsRepo = usersBoardsRepo;
_UserRepo = userRepo;
}
protected override void TearDown()
{
base.Database.ExecuteSqlRaw("DELETE FROM Users_Boards WHERE user_id == 'TestUser'");
base.Database.ExecuteSqlRaw("DELETE FROM Boards WHERE board_id == 'TestBoard'");
base.Database.ExecuteSqlRaw("DELETE FROM Users WHERE user_id == 'TestUser'");
_uBRepo = null;
}
public BoardController(IBoardRepository boardRepo,
IUserRepository userRepo,
IUsersBoardsRepository userBoardsRepo,
IColumnRepository columnRepo)
{
_boardRepo = boardRepo;
_userRepo = userRepo;
_usersBoardsRepo = userBoardsRepo;
_columnRepo = columnRepo;
}
public SQLUsersBoardsRepositoryTests()
{
base.AdditionalSetupOperations = () =>
{
base.Database.ExecuteSqlRaw("INSERT INTO Boards VALUES('TestBoard', 'First Board')");
base.Database.ExecuteSqlRaw("INSERT INTO users (user_id, username, password, email) VALUES('TestUser', 'Dummy User', 'test', '[email protected]')");
base.Database.ExecuteSqlRaw("INSERT INTO Users_Boards VALUES('UBTest', 'TestBoard', 'TestUser')");
};
_uBRepo = new SQLUsersBoardsRepository(this);
}
public BoardControllerTests()
{
base.AdditionalSetupOperations = () =>
{
base.Database.ExecuteSqlRaw("INSERT INTO Boards VALUES('TestBoard', 'First Board')");
base.Database.ExecuteSqlRaw("INSERT INTO users (user_id, username, password, email) VALUES('TestUser', 'Dummy User', 'test', '[email protected]')");
base.Database.ExecuteSqlRaw("INSERT INTO Users_Boards VALUES('UBTest', 'TestBoard', 'TestUser')");
};
_boardRepo = base._repo;
_columnRepo = new SQLColumnRepository(this, new SQLBoardRepository(this, new SQLUsersBoardsRepository(this), new SQLUserRepository(this)));
_dummyUserRepo = Substitute.For <IUserRepository>();
_dummyUsersBoardsRepo = Substitute.For <IUsersBoardsRepository>();
base._controller = new BoardController(_boardRepo, _dummyUserRepo, _dummyUsersBoardsRepo, _columnRepo);
}
public UserController(IUserRepository repo, IUsersBoardsRepository connectionRepo)
{
_UserRepo = repo;
_ConnectionRepo = connectionRepo;
}
