public void CallingAllRowsSetsAllRowsToTrue()
{
var expressionMock = new Mock <DeleteDataExpression>();
expressionMock.VerifySet(x => x.IsAllRows = true, Times.AtMostOnce(), "IsAllRows property not set");
var builder = new DeleteDataExpressionBuilder(expressionMock.Object);
builder.AllRows();
expressionMock.VerifyAll();
}
public void CallingInSchemaSetSchemaName()
{
var expressionMock = new Mock <DeleteDataExpression>();
expressionMock.VerifySet(x => x.SchemaName = "TestSchema", Times.AtMostOnce(), "SchemaName property not set");
var builder = new DeleteDataExpressionBuilder(expressionMock.Object);
builder.InSchema("TestSchema");
expressionMock.VerifyAll();
}
public void CallingRowTwiceAddTwoColumns()
{
var expressionMock = new Mock <DeleteDataExpression>();
var builder = new DeleteDataExpressionBuilder(expressionMock.Object);
builder.Row(new { TestColumn = "TestValue" });
builder.Row(new { TestColumn2 = "TestValue2" });
var result = expressionMock.Object;
Assert.AreEqual(2, result.Rows.Count);
}
public void CallingRowAddAColumn()
{
var expressionMock = new Mock <DeleteDataExpression>();
var builder = new DeleteDataExpressionBuilder(expressionMock.Object);
builder.Row(new { TestColumn = "TestValue" });
var result = expressionMock.Object;
var rowobject = result.Rows.First().First();
rowobject.Key.ShouldBe("TestColumn");
rowobject.Value.ShouldBe("TestValue");
}
public void CallingIsNullAddsANullColumn()
{
var expressionMock = new Mock <DeleteDataExpression>();
var builder = new DeleteDataExpressionBuilder(expressionMock.Object);
builder.IsNull("TestColumn");
var result = expressionMock.Object;
var rowobject = result.Rows.First().First();
rowobject.Key.ShouldBe("TestColumn");
rowobject.Value.ShouldBeNull();
}
public void CallingRowAddAColumn()
{
var expressionMock = new Mock <DeleteDataExpression>();
var builder = new DeleteDataExpressionBuilder(expressionMock.Object);
var data = new { TestColumn = "TestValue" };
builder.Row(data);
var result = expressionMock.Object;
IDataDefinition rowobject = result.Rows.First();
Assert.IsInstanceOf <ReflectedDataDefinition>(rowobject);
Assert.AreEqual(data, ((ReflectedDataDefinition)rowobject).Data);
}
public void CallingIsNullAddsANullColumn()
{
var expressionMock = new Mock <DeleteDataExpression>();
var builder = new DeleteDataExpressionBuilder(expressionMock.Object);
builder.IsNull("TestColumn");
var result = expressionMock.Object;
IDataDefinition rowobject = result.Rows.First();
Assert.IsInstanceOf <ExplicitDataDefinition>(rowobject);
ExplicitDataDefinition rowDefinition = (ExplicitDataDefinition)rowobject;
rowDefinition.Data.First().ColumnName.ShouldBe("TestColumn");
rowDefinition.Data.First().Value.ShouldBeNull();
}
public void CallingRowTwiceAddTwoColumns()
{
var expressionMock = new Mock <DeleteDataExpression>();
var builder = new DeleteDataExpressionBuilder(expressionMock.Object);
builder.Row(new { TestColumn = "TestValue" });
builder.Row(new { TestColumn2 = "TestValue2" });
var result = expressionMock.Object;
var rowobject = result.Rows[0];
rowobject[0].Key.ShouldBe("TestColumn");
rowobject[0].Value.ShouldBe("TestValue");
rowobject = result.Rows[1];
rowobject[0].Key.ShouldBe("TestColumn2");
rowobject[0].Value.ShouldBe("TestValue2");
}
