public async void AddTaskInMemoryTestAsync()
{
IUnitOfWork unitOfWork;
// Creates an InMemory database to be used for testing
var options = new DbContextOptionsBuilder <SynchroLeanDbContext>()
.UseInMemoryDatabase(databaseName: "Add_task_to_database")
.Options;
// Create a userTaskOrigina to send to HTTPPost method
var newUserTask = new UserTask {
Name = "Unit test add",
Description = "Add a task using InMemory database",
Weekdays = 40,
//IsCompleted = false,
Deleted = null
};
// Creates the TaskController with DbContext and adds newUserTask to InMemory database
using (var context = new SynchroLeanDbContext(options))
{
// Bind the context to the UnitOfWork object
unitOfWork = new UnitOfWork(context);
// Add the task to the Db asynchronously
await unitOfWork.UserTaskRepository.AddAsync(newUserTask);
await unitOfWork.CompleteAsync();
}
// Used same context to verify changes are persistent
using (var context = new SynchroLeanDbContext(options))
{
// Assert that UserTasks table contains one entry
Assert.Equal(1, context.UserTasks.Count());
//output.WriteLine("context.UserTasks.Count() = " + context.UserTasks.Count().ToString());
// Bind the context to the UnitOfWork object
unitOfWork = new UnitOfWork(context);
// Retrieve the task from the Db asynchronously
var userTask = await unitOfWork.UserTaskRepository.GetTaskAsync(newUserTask.Id);
await unitOfWork.CompleteAsync();
Assert.NotNull(userTask);
// Validate data equals UserTask passed in
// Not sure why userTask.Name needs to be trimmed but userTask.Description doesn't
Assert.True(newUserTask.Name == userTask.Name.Trim());
Assert.True(newUserTask.Description == userTask.Description);
Assert.True(newUserTask.IsRecurring.Equals(userTask.IsRecurring));
Assert.True(newUserTask.Weekdays.Equals(userTask.Weekdays));
//Assert.True(newUserTask.IsCompleted.Equals(userTask.IsCompleted));
Assert.True(newUserTask.Deleted.Equals(userTask.Deleted));
}
}
public void TaskControllerAddTaskTest()
{
// In-memory database only exists while the connection is open
var connection = new SqliteConnection("DataSource=:memory:");
connection.Open();
try
{
IUnitOfWork unitOfWork;
TasksController controller;
var options = new DbContextOptionsBuilder <SynchroLeanDbContext>()
.UseSqlite(connection)
.Options;
// Create database schema
var context = new SynchroLeanDbContext(options);
context.Database.EnsureCreated();
// Bind the context to the UnitOfWork object
unitOfWork = new UnitOfWork(context);
// Create an instance of TasksController
controller = new TasksController(unitOfWork, mapper);
/// Create a newUserTask to send to HTTPPost method (without dates)
var newUserTask = new UserTaskResource {
Name = "SQLite unit test add",
Description = "Add a task using SQLite database",
Weekdays = 40,
IsCompleted = false,
IsDeleted = false
};
// Add newUserTask to UserTasks table in Db asynchronously
var taskResult = controller.AddUserTaskAsync(newUserTask);
var actionResult = taskResult.Result;
var okObjectResult = actionResult as OkObjectResult;
var userTask = okObjectResult.Value as UserTaskResource;
// Validate data equals UserTaskResource passed in
// Not sure why userTask.Name needs to be trimmed but userTask.Description doesn't
Assert.True(newUserTask.Name == userTask.Name.Trim());
Assert.True(newUserTask.Description == userTask.Description);
Assert.True(newUserTask.Weekdays.Equals(userTask.Weekdays));
Assert.True(newUserTask.IsCompleted.Equals(userTask.IsCompleted));
Assert.True(newUserTask.IsDeleted.Equals(userTask.IsDeleted));
}
finally
{
connection.Close();
}
}
public async void GetUserMetricsTestAsync()
{
// In-memory database only exists while the connection is open
var connection = new SqliteConnection("DataSource=:memory:");
connection.Open();
try
{
IUnitOfWork unitOfWork;
TasksController taskController;
AccountsController accountController;
DateTime startDate;
var options = new DbContextOptionsBuilder <SynchroLeanDbContext>()
.UseSqlite(connection)
.Options;
// Create the schema in the database
using (var context = new SynchroLeanDbContext(options))
{
context.Database.EnsureCreated();
}
// Create a newUserTask to send to HTTPPost method (without dates)
var newUserTask1 = new UserTaskResource {
Name = "User metrics",
Description = "Modify metrics endpoints to accept DateTimes",
Weekdays = 40,
CreationDate = DateTime.Now,
IsCompleted = false,
IsDeleted = false,
OwnerEmail = "*****@*****.**"
};
// Create a newUserTask to send to HTTPPost method (without dates)
var newUserTask2 = new UserTaskResource {
Name = "User metrics",
Description = "complete this to have 50% completion rate",
Weekdays = 0,
CreationDate = DateTime.Now,
IsCompleted = false,
IsDeleted = false,
OwnerEmail = "*****@*****.**"
};
var account = new UserAccountResource {
FirstName = "Cole",
LastName = "Phares",
Email = "*****@*****.**",
IsDeleted = false
};
// Run the test against one instance of the context
using (var context = new SynchroLeanDbContext(options))
{
// Bind the context to the UnitOfWork object
unitOfWork = new UnitOfWork(context);
// Create an instance of TasksController
taskController = new TasksController(unitOfWork, mapper);
// Create an instance of AccountsController
accountController = new AccountsController(unitOfWork, mapper);
var newAccount = new CreateUserAccountResource
{
Email = account.Email,
FirstName = account.FirstName,
LastName = account.LastName,
Password = "******",
IsDeleted = false
};
await accountController.AddUserAccountAsync(newAccount);
// Add newUserTask to UserTasks table in Db asynchronously
await taskController.AddUserTaskAsync(newUserTask1);
await taskController.AddUserTaskAsync(newUserTask2);
startDate = DateTime.Now;
await taskController.EditUserTaskAsync(2,
new UserTaskResource {
Name = "User metrics",
Description = "complete this to have 50% completion rate",
Weekdays = 0,
IsCompleted = true,
IsDeleted = false,
}
);
}
// Use a separate instance of the context to verify correct data was saved to database
using (var context = new SynchroLeanDbContext(options))
{
// Bind the Db context to the UnitOfWork object
unitOfWork = new UnitOfWork(context);
// Create new instance of task controller
taskController = new TasksController(unitOfWork, mapper);
DateTime endDate = DateTime.Now;
// Retrieve the task from the Db asynchronously
var completionRateResult = taskController.GetUserCompletionRate("*****@*****.**", startDate, endDate);
var actionResult = completionRateResult.Result;
var okObjectResult = actionResult as OkObjectResult;
var completionRate = okObjectResult.Value as double?;
Assert.True(completionRate.Equals(.5));
}
}
finally
{
connection.Close();
}
}
public async void TaskControllerGetTaskTestAsync()
{
// In-memory database only exists while the connection is open
var connection = new SqliteConnection("DataSource=:memory:");
connection.Open();
try
{
IUnitOfWork unitOfWork;
TasksController controller;
var options = new DbContextOptionsBuilder <SynchroLeanDbContext>()
.UseSqlite(connection)
.Options;
// Create the schema in the database
using (var context = new SynchroLeanDbContext(options))
{
context.Database.EnsureCreated();
}
/// Create a newUserTask to send to HTTPPost method (without dates)
var newUserTask = new UserTaskResource {
Name = "SQLite unit test add",
Description = "Add a task using SQLite database",
Weekdays = 40,
IsCompleted = false,
IsDeleted = false
};
// Run the test against one instance of the context
using (var context = new SynchroLeanDbContext(options))
{
// Bind the context to the UnitOfWork object
unitOfWork = new UnitOfWork(context);
// Create an instance of TasksController
controller = new TasksController(unitOfWork, mapper);
// Add newUserTask to UserTasks table in Db asynchronously
await controller.AddUserTaskAsync(newUserTask);
}
// Use a separate instance of the context to verify correct data was saved to database
using (var context = new SynchroLeanDbContext(options))
{
// Bind the Db context to the UnitOfWork object
unitOfWork = new UnitOfWork(context);
// Create new instance of task controller
controller = new TasksController(unitOfWork, mapper);
// Retrieve the task from the Db asynchronously
var taskResult = controller.GetTaskAsync("*****@*****.**", newUserTask.Id);
var actionResult = taskResult.Result;
var okObjectResult = actionResult as OkObjectResult;
var userTaskList = okObjectResult.Value as List <UserTaskResource>;
// Assert that UserTasks table in Db contains 1 entry
Assert.True(userTaskList.Count().Equals(1));
// Retreive the first element from the list
UserTaskResource userTask = userTaskList[0];
// Validate data equals UserTaskResource passed in
// Not sure why userTask.Name needs to be trimmed but userTask.Description doesn't
Assert.True(newUserTask.Name == userTask.Name.Trim());
Assert.True(newUserTask.Description == userTask.Description);
Assert.True(newUserTask.Weekdays.Equals(userTask.Weekdays));
Assert.True(newUserTask.IsCompleted.Equals(userTask.IsCompleted));
Assert.True(newUserTask.IsDeleted.Equals(userTask.IsDeleted));
}
}
finally
{
connection.Close();
}
}
public async void AddTaskSQLiteTest()
{
// In-memory database only exists while the connection is open
var connection = new SqliteConnection("DataSource=:memory:");
connection.Open();
try
{
IUnitOfWork unitOfWork;
var options = new DbContextOptionsBuilder <SynchroLeanDbContext>()
.UseSqlite(connection)
.Options;
/// Create a newUserTask to send to HTTPPost method (without dates)
var newUserTask = new UserTask {
Name = "SQLite unit test add",
Description = "Add a task using SQLite database",
Weekdays = 40,
//IsCompleted = false,
Deleted = null
};
// Create the schema in the database
using (var context = new SynchroLeanDbContext(options))
{
context.Database.EnsureCreated();
}
// Run the test against one instance of the context
using (var context = new SynchroLeanDbContext(options))
{
// Bind the context to the UnitOfWork object
unitOfWork = new UnitOfWork(context);
// Add newUserTask to UserTasks table in Db asynchronously
await unitOfWork.UserTaskRepository.AddAsync(newUserTask);
await unitOfWork.CompleteAsync();
}
// Use a separate instance of the context to verify correct data was saved to database
using (var context = new SynchroLeanDbContext(options))
{
// Bind the Db context to the UnitOfWork object
unitOfWork = new UnitOfWork(context);
// Assert that UserTasks table in Db contains 1 entry
Assert.Equal(1, context.UserTasks.Count());
// Retrieve the task from the Db asynchronously
var userTask = await unitOfWork.UserTaskRepository.GetTaskAsync(newUserTask.Id);
await unitOfWork.CompleteAsync();
Assert.NotNull(userTask);
// Validate data equals UserTask passed in
// Not sure why userTask.Name needs to be trimmed but userTask.Description doesn't
Assert.True(newUserTask.Name == userTask.Name.Trim());
Assert.True(newUserTask.Description == userTask.Description);
Assert.True(newUserTask.IsRecurring.Equals(userTask.IsRecurring));
Assert.True(newUserTask.Weekdays.Equals(userTask.Weekdays));
//Assert.True(newUserTask.IsCompleted.Equals(userTask.IsCompleted));
Assert.True(newUserTask.Deleted.Equals(userTask.Deleted));
}
}
finally
{
connection.Close();
}
}