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 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 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 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; var rowobject = result.Rows.First().First(); rowobject.Key.ShouldBe("TestColumn"); rowobject.Value.ShouldBeNull(); }
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"); }