public void VerifyGenericUpdate()
{
// Arrange
var statement = new UpdateSqlStatement("People");
statement.SetValues.Add(new KeyValuePair <string, object>("IsBurried", true));
statement.SetValues.Add(new KeyValuePair <string, object>("Location", "Some cemetary adress"));
statement.Where = new WhereCondition()
.AddSegment(new WhereCondition.Condition("Age", WhereCondition.ComparisonType.EqualToOrGreaterThan, 100))
.AddSegment(WhereCondition.Operator.And)
.AddSegment(new WhereCondition.Condition("IsDead", WhereCondition.ComparisonType.Equal, true));
// Act
var query = statement.GenerateQuery();
// Assert
var expected = $@"
UPDATE People
SET IsBurried=1, Location='Some cemetary adress'
WHERE (Age >= 100) AND (IsDead = 1);
";
foreach (var c in Environment.NewLine)
{
expected = expected.Trim(c);
}
foreach (var c in Environment.NewLine)
{
expected = expected.Trim(c);
}
query.ShouldBe(expected);
}
public void VerifyCantGenerateWithoutWhere()
{
// Arrange
var statement = new UpdateSqlStatement("People");
statement.SetValues.Add(new KeyValuePair <string, object>("IsDead", true));
// Act & Assert
var ex = Should.Throw <InvalidSqlStatementException>(() => statement.GenerateQuery());
ex.Message.ShouldBe("Missing WHERE statement");
}
public void VerifyCanGenerateWithoutWhere()
{
// Arrange
var statement = new UpdateSqlStatement("People");
statement.SetValues.Add(new KeyValuePair <string, object>("IsDead", true));
statement.Options.AllowMissingWhere = true;
// Act
var query = statement.GenerateQuery();
// Assert
query.ShouldNotBeNullOrEmpty();
}
public void VerifyCantGenerateWithEmptySetValueKeys()
{
// Arrange
var statement = new UpdateSqlStatement("People")
{
Where = new WhereCondition()
.AddSegment(new WhereCondition.Condition("Username", WhereCondition.ComparisonType.Equal, "AdminBoy"))
};
statement.SetValues.Add(new KeyValuePair <string, object>());
// Act & Assert
var ex = Should.Throw <InvalidSqlStatementException>(() => statement.GenerateQuery());
ex.Message.ShouldBe("Empty SET key");
}
