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 Get_userExists_shouldReturnUser()
{
// Arrange
var repository = new DapperUserRepository(Connection, UsersTableName);
var userId = Guid.NewGuid();
var appId = Guid.NewGuid();
var serviceId = Guid.NewGuid();
var createdAt = DateTime.UtcNow;
QueryFromFile(InsertUserScriptFilename, new Dictionary<string, string>
{
{"UserId", userId.ToString()},
{"AppId", appId.ToString()},
{"ServiceId", serviceId.ToString()},
{"Enabled", "1"},
{"CreatedAt", createdAt.ToString("yyyy-MM-dd HH:mm:ss", CultureInfo.InvariantCulture)},
});
// Act
var actual = repository.Get(userId, serviceId);
// 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 Get_byIdUserDoesNotExist_shouldReturnNull()
{
// Arrange
var repository = new DapperUserRepository(Connection, UsersTableName);
// Act
var actual = repository.Get(23);
// Assert
Assert.AreEqual(null, actual);
}
public void Get_userDoesNotExist_shouldReturnNull()
{
// Arrange
var repository = new DapperUserRepository(Connection, UsersTableName);
var userId = Guid.NewGuid();
var serviceId = Guid.NewGuid();
// Act
var actual = repository.Get(userId, serviceId);
// Assert
Assert.AreEqual(null, actual);
}
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 Delete_userDoesNotExist_shouldHaveNoImpact()
{
// Arrange
var repository = new DapperUserRepository(Connection, UsersTableName);
var userId = Guid.NewGuid();
var appId = Guid.NewGuid();
var serviceId = Guid.NewGuid();
var createdAt = DateTime.Now;
QueryFromFile(InsertUserScriptFilename, new Dictionary<string, string>
{
{"UserId", userId.ToString()},
{"AppId", appId.ToString()},
{"ServiceId", serviceId.ToString()},
{"Enabled", "1"},
{"CreatedAt", createdAt.ToString("yyyy-MM-dd HH:mm:ss", CultureInfo.InvariantCulture)},
});
var added = repository.Get(userId, serviceId);
var expected = repository.GetAll().Count();
Assert.AreNotEqual(null, added);
// Act
repository.Delete(added.Id.Value + 1);
// Assert
var actual = repository.GetAll().Count();
Assert.AreEqual(expected, actual);
}
public void Get_userExistsOnlyForDifferentService_shouldReturnNull()
{
// Arrange
var repository = new DapperUserRepository(Connection, UsersTableName);
var userId = Guid.NewGuid();
var appId = Guid.NewGuid();
var serviceId = Guid.NewGuid();
var createdAt = DateTime.UtcNow;
QueryFromFile(InsertUserScriptFilename, new Dictionary<string, string>
{
{"UserId", userId.ToString()},
{"AppId", appId.ToString()},
{"ServiceId", Guid.NewGuid().ToString()},
{"Enabled", "1"},
{"CreatedAt", createdAt.ToString("yyyy-MM-dd HH:mm:ss", CultureInfo.InvariantCulture)},
});
// Act
var actual = repository.Get(userId, serviceId);
// Assert
Assert.AreEqual(null, actual);
}
