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 GetAll_userExist_shouldReturnUser()
{
// 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 userId2 = Guid.NewGuid();
var appId2 = Guid.NewGuid();
var serviceId2 = Guid.NewGuid();
var createdAt2 = DateTime.Now;
QueryFromFile(InsertUserScriptFilename, new Dictionary<string, string>
{
{"UserId", userId2.ToString()},
{"AppId", appId2.ToString()},
{"ServiceId", serviceId2.ToString()},
{"Enabled", "1"},
{"CreatedAt", createdAt2.ToString("yyyy-MM-dd HH:mm:ss", CultureInfo.InvariantCulture)},
});
// Act
var actual = repository.GetAll().ToList();
// Assert
Assert.AreEqual(2, actual.Count());
var actualApp1 = actual.First(x => x.AppId == appId);
Assert.AreEqual(userId, actualApp1.UserId);
Assert.AreEqual(appId, actualApp1.AppId);
Assert.AreEqual(serviceId, actualApp1.ServiceId);
Assert.AreEqual(createdAt.Date, actualApp1.CreatedAt.Date);
Assert.IsTrue(actualApp1.Enabled);
Assert.IsTrue(actualApp1.Id > 0);
var actualApp2 = actual.First(x => x.AppId == appId2);
Assert.AreEqual(userId2, actualApp2.UserId);
Assert.AreEqual(appId2, actualApp2.AppId);
Assert.AreEqual(serviceId2, actualApp2.ServiceId);
Assert.AreEqual(createdAt2.Date, actualApp2.CreatedAt.Date);
Assert.IsTrue(actualApp2.Enabled);
Assert.IsTrue(actualApp2.Id > 0);
}
