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"); }