public void EditQueryWithTwoParams_WhenSecondParameterIsNull_ShouldRemoveParams()
{
// Arrange
int queryElementsCountBeforeAct = queriesDbSet.Count();
int parametersElementsCountBeforeAct = parametersDbSet.Count();
int queryParametersElementsCountBeforeAct = queryParametersDbSet.Count();
int queryIdBeforeAct = queriesDbSet.First().SqlQueryId;
string queryNameBeforeAct = queriesDbSet.First().SqlQueryName;
string queryContentBeforeAct = queriesDbSet.First().SqlQueryContent;
DateTime queryCreatedDateBeforeAct = queriesDbSet.First().SqlQueryCreatedDate;
string newQueryName = "new query name";
string newQueryContent = "new query content";
int queryParametersCount = queryParametersDbSet
.Where(p => p.SqlQueryId == queriesDbSet.First().SqlQueryId)
.Count();
SqlQuery queryToUpdate = queriesDbSet.First();
queryToUpdate.SqlQueryName = newQueryName;
queryToUpdate.SqlQueryContent = newQueryContent;
string[] parameterIds = null;
// Act
queryRepo.Edit(queryToUpdate, parameterIds);
SqlQuery updatedQuery = queriesDbSet.ElementAt(queryToUpdate.SqlQueryId);
// Assert
Assert.AreEqual(queryElementsCountBeforeAct, queriesDbSet.Count());
Assert.AreEqual(parametersElementsCountBeforeAct, parametersDbSet.Count());
Assert.IsTrue(queryParametersElementsCountBeforeAct > queryParametersDbSet.Count());
Assert.AreEqual(newQueryName, updatedQuery.SqlQueryName);
Assert.AreEqual(newQueryContent, updatedQuery.SqlQueryContent);
Assert.AreEqual(queryCreatedDateBeforeAct, updatedQuery.SqlQueryCreatedDate);
Assert.AreEqual(
queryParametersElementsCountBeforeAct,
(queryParametersDbSet.Count() + queryParametersCount)
);
Assert.IsTrue(
queryParametersDbSet
.Where(p => p.SqlQueryId == queryToUpdate.SqlQueryId)
.Count() <= 0
);
}
public void MappingTest()
{
//Arrange
var dataStorage = new Mock <IDataStorage>();
var entity = new Query {
Id = 1,
AnswerAuthor = new User {
Id = 11
},
AnswerText = "oldAnswer",
QueryAuthor = new User {
Id = 12
},
QueryText = "oldQuestion"
};
var updatedEntity = new Query {
Id = 1,
AnswerAuthor = new User {
Id = 21
},
AnswerText = "newAnswer",
QueryAuthor = new User {
Id = 22
},
QueryText = "newQuestion"
};
var repository = new QueryRepository(dataStorage.Object);
dataStorage.Setup(ds => ds.GetData <Query>()).Returns(new List <Query> {
entity
});
//Act
repository.Edit(updatedEntity);
//Assert
//Values are equal
Assert.That(entity.AnswerAuthor, Is.EqualTo(updatedEntity.AnswerAuthor));
Assert.That(entity.AnswerText, Is.EqualTo(updatedEntity.AnswerText));
Assert.That(entity.QueryAuthor, Is.EqualTo(updatedEntity.QueryAuthor));
Assert.That(entity.QueryText, Is.EqualTo(updatedEntity.QueryText));
}
public void MappingTest()
{
//Arrange
var dataStorage = new Mock<IDataStorage>();
var entity = new Query {
Id = 1,
AnswerAuthor = new User {Id = 11},
AnswerText = "oldAnswer",
QueryAuthor = new User {Id = 12},
QueryText = "oldQuestion"
};
var updatedEntity = new Query {
Id = 1,
AnswerAuthor = new User {Id = 21},
AnswerText = "newAnswer",
QueryAuthor = new User {Id = 22},
QueryText = "newQuestion"
};
var repository = new QueryRepository(dataStorage.Object);
dataStorage.Setup(ds => ds.GetData<Query>()).Returns(new List<Query> {entity});
//Act
repository.Edit(updatedEntity);
//Assert
//Values are equal
Assert.That(entity.AnswerAuthor, Is.EqualTo(updatedEntity.AnswerAuthor));
Assert.That(entity.AnswerText, Is.EqualTo(updatedEntity.AnswerText));
Assert.That(entity.QueryAuthor, Is.EqualTo(updatedEntity.QueryAuthor));
Assert.That(entity.QueryText, Is.EqualTo(updatedEntity.QueryText));
}
