public void Get_appExists_shouldReturnApp()
{
// Arrange
var repository = new DapperAppRepository(Connection, AppTableName);
var appId = Guid.NewGuid();
var serviceId = Guid.NewGuid();
var createdAt = DateTime.UtcNow;
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 },
});
// Act
var actual = repository.Get(appId, serviceId);
// Assert
Assert.AreEqual(appId, actual.AppId);
Assert.AreEqual(serviceId, actual.ServiceId);
Assert.AreEqual(secret, actual.Secret);
Assert.AreEqual(createdAt.Date, actual.CreatedAt.Date);
Assert.IsTrue(actual.Enabled);
Assert.IsTrue(actual.Id > 0);
Assert.AreEqual(name, actual.Name);
}
public void Get_appDoesNotExist_shouldReturnNull()
{
// Arrange
var repository = new DapperAppRepository(Connection, AppTableName);
var appId = Guid.NewGuid();
var serviceId = Guid.NewGuid();
// Act
var actual = repository.Get(appId, serviceId);
// Assert
Assert.AreEqual(null, actual);
}
public void Get_byIdAppDoesNotExist_shouldReturnNull()
{
// Arrange
var repository = new DapperAppRepository(Connection, AppTableName);
// Act
var actual = repository.Get(23);
// Assert
Assert.AreEqual(null, actual);
}
public void Get_byIdAppExists_shouldReturnApp()
{
// 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";
var app = new AppModel
{
AppId = appId,
ServiceId = serviceId,
Secret = secret,
Enabled = true,
CreatedAt = createdAt,
Name = name,
};
var id = repository.Insert(app);
// Act
var actual = repository.Get(id);
// Assert
Assert.AreEqual(appId, actual.AppId);
Assert.AreEqual(serviceId, actual.ServiceId);
Assert.AreEqual(secret, actual.Secret);
Assert.AreEqual(createdAt.Date, actual.CreatedAt.Date);
Assert.IsTrue(actual.Enabled);
Assert.IsTrue(actual.Id > 0);
Assert.AreEqual(name, actual.Name);
}
public void Update_appExistsValidData_shouldUpdateApp()
{
var repository = new DapperAppRepository(Connection, AppTableName);
var app = CreateApp();
app.Enabled = true;
var id = repository.Insert(app);
app = CreateApp();
app.Enabled = false;
repository.Update(id, app);
var actual = repository.Get(id);
app.Id = id;
Assert.AreEqual(app, actual);
}
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);
}