private void ThenColumnShouldBe(string name, DataType dataType, bool isDocument, string xmlSchemaCollection, Nullable nullable, string defaultExpression, string defaultConstraintName, string description)
{
ThenColumnShouldBe(name, dataType, defaultExpression, defaultConstraintName, description);
Assert.That(_column.Nullable, Is.EqualTo(nullable));
var notNullClause = ConvertToNotNullClause(nullable);
var sparseClause = ConvertToSparseClause(nullable);
var defaultClause = ConvertToDefaultClause(defaultExpression, defaultConstraintName, true);
var size = new XmlPrecisionScale(isDocument, xmlSchemaCollection);
Assert.That(_column.Size.ToString(), Is.EqualTo(size.ToString()));
var columnDefinition = $"[{name}] xml{size}{notNullClause}{defaultClause}{sparseClause}";
Assert.That(_column.GetColumnDefinition(true), Is.EqualTo(columnDefinition));
}
public void ShouldCreateSizeWhenNoSchema()
{
var size = new XmlPrecisionScale();
Assert.That(size.ToString(), Is.Empty);
}
public void ShouldCreateDocumentExpression()
{
var size = new XmlPrecisionScale(true, "some doc");
Assert.That(size.ToString(), Is.EqualTo("(document some doc)"));
}
public void ShouldCreateContentExpressionWhenIsDocumentIsFalse()
{
var size = new XmlPrecisionScale(false, "some other content");
Assert.That(size.ToString(), Is.EqualTo("(content some other content)"));
}
public void ShouldCreateContentExpression()
{
var size = new XmlPrecisionScale("some schema");
Assert.That(size.ToString(), Is.EqualTo("(content some schema)"));
}
