public void Get_byIdUserExists_shouldReturnUser()
{
// Arrange
var repository = new DapperUserRepository(Connection, UsersTableName);
var userId = Guid.NewGuid();
var appId = Guid.NewGuid();
var serviceId = Guid.NewGuid();
var createdAt = DateTime.Now;
var userModel = new UserModel
{
UserId = userId,
AppId = appId,
ServiceId = serviceId,
CreatedAt = createdAt,
Enabled = true
};
// Act
var id = repository.Insert(userModel);
// Act
var actual = repository.Get(id);
// Assert
Assert.AreEqual(userId, actual.UserId);
Assert.AreEqual(appId, actual.AppId);
Assert.AreEqual(serviceId, actual.ServiceId);
Assert.AreEqual(createdAt.Date, actual.CreatedAt.Date);
Assert.IsTrue(actual.Enabled);
Assert.IsTrue(actual.Id > 0);
}
public void Update_userDoesNotExist_shouldThrowException()
{
var repository = new DapperUserRepository(Connection, UsersTableName);
var user = CreateUser();
var id = repository.Insert(user);
repository.Update(id + 1, user);
}
public void Update_invalidData_shouldThrowException()
{
var repository = new DapperUserRepository(Connection, UsersTableName);
var user = CreateUser();
var id = repository.Insert(user);
repository.Update(id, null);
}
public void Update_userExistsValidData_shouldUpdateUser()
{
var repository = new DapperUserRepository(Connection, UsersTableName);
var user = CreateUser();
user.Enabled = true;
var id = repository.Insert(user);
user = CreateUser();
user.Enabled = false;
repository.Update(id, user);
var actual = repository.Get(id);
user.Id = id;
Assert.AreEqual(user, actual);
}
public void Insert_invalidUser_shouldThrowException()
{
// Arrange
var repository = new DapperUserRepository(Connection, UsersTableName);
// Act
repository.Insert(null);
// Assert
// see expected exception
}
public void Insert_validUser_shouldInsertUser()
{
// Arrange
var repository = new DapperUserRepository(Connection, UsersTableName);
var userModel = CreateUser();
// Act
var id = repository.Insert(userModel);
// Assert
Assert.IsTrue(id > 0);
var users = QueryFromFile<UserModel>(SelectUserScriptFilename, new Dictionary<string, string>
{
{"UserId", userModel.UserId.ToString()}
}).ToList();
Assert.AreNotEqual(0, users.Count());
var actual = users.First();
Assert.AreEqual(userModel.UserId, actual.UserId);
Assert.AreEqual(userModel.AppId, actual.AppId);
Assert.AreEqual(userModel.ServiceId, actual.ServiceId);
Assert.AreEqual(userModel.CreatedAt.Date, actual.CreatedAt.Date);
Assert.IsTrue(actual.Enabled);
Assert.IsTrue(actual.Id > 0);
}
