public void Delete_appDoesNotExists_shouldHaveNoImpact()
{
// Arrange
var repository = new DapperAppRepository(Connection, AppTableName);
var appId = Guid.NewGuid();
var serviceId = Guid.NewGuid();
var createdAt = DateTime.Now;
const string secret = "testsecret";
const string name = "user1";
QueryFromFile(InsertAppScriptFilename, new Dictionary<string, string>
{
{ "AppId", appId.ToString() },
{ "ServiceId", serviceId.ToString() },
{ "Secret", secret },
{ "Enabled", "1"},
{ "CreatedAt", createdAt.ToString("yyyy-MM-dd HH:mm:ss", CultureInfo.InvariantCulture) },
{ "Name", name },
});
var added = repository.Get(appId, serviceId);
Assert.AreNotEqual(null, added);
var expected = repository.GetAll().Count();
// Act
repository.Delete(added.Id.Value + 1);
// Assert
var actual = repository.GetAll().Count();
Assert.AreEqual(expected, actual);
}
public void GetAll_appsExist_shouldReturnApps()
{
// Arrange
var repository = new DapperAppRepository(Connection, AppTableName);
var appId = Guid.NewGuid();
var serviceId = Guid.NewGuid();
var createdAt = DateTime.Now;
const string secret = "testsecret";
const string name = "user1";
QueryFromFile(InsertAppScriptFilename, new Dictionary<string, string>
{
{"AppId", appId.ToString()},
{"ServiceId", serviceId.ToString()},
{"Secret", secret},
{"Enabled", "1"},
{"CreatedAt", createdAt.ToString("yyyy-MM-dd HH:mm:ss", CultureInfo.InvariantCulture)},
{ "Name", name },
});
var appId2 = Guid.NewGuid();
var serviceId2 = Guid.NewGuid();
var createdAt2 = DateTime.Now - TimeSpan.FromSeconds(23);
const string secret2 = "testsecret2";
const string name2 = "user2";
QueryFromFile(InsertAppScriptFilename, new Dictionary<string, string>
{
{"AppId", appId2.ToString()},
{"ServiceId", serviceId2.ToString()},
{"Secret", secret2},
{"Enabled", "1"},
{"CreatedAt", createdAt2.ToString("yyyy-MM-dd HH:mm:ss", CultureInfo.InvariantCulture)},
{ "Name", name2 },
});
// Act
var actual = repository.GetAll().ToList();
// Assert
Assert.AreEqual(2, actual.Count());
var actualApp1 = actual.First(x => x.AppId == appId);
Assert.AreEqual(serviceId, actualApp1.ServiceId);
Assert.AreEqual(secret, actualApp1.Secret);
Assert.AreEqual(createdAt.Date, actualApp1.CreatedAt.Date);
Assert.AreEqual(name, actualApp1.Name);
Assert.IsTrue(actualApp1.Enabled);
var actualApp2 = actual.First(x => x.AppId == appId2);
Assert.AreEqual(serviceId2, actualApp2.ServiceId);
Assert.AreEqual(secret2, actualApp2.Secret);
Assert.AreEqual(createdAt2.Date, actualApp2.CreatedAt.Date);
Assert.AreEqual(name2, actualApp2.Name);
Assert.IsTrue(actualApp2.Enabled);
}
