public void SettingTheTableNameSetsTheTableName()
{
CreateConstraintExpression expression = new CreateConstraintExpression(ConstraintType.Unique);
CreateConstraintExpressionBuilder builder = new CreateConstraintExpressionBuilder(expression);
builder.OnTable("FOO");
expression.Constraint.TableName.ShouldBe("FOO");
}
public void AddingASingleColumnShouldAddItToToColumnList()
{
CreateConstraintExpression expression = new CreateConstraintExpression(ConstraintType.Unique);
CreateConstraintExpressionBuilder builder = new CreateConstraintExpressionBuilder(expression);
builder.OnTable("FOO").Column("BAR");
expression.Constraint.Columns.First().ShouldBe("BAR");
}
public void AddingMultipleColumnShouldAddThenToToColumnList()
{
CreateConstraintExpression expression = new CreateConstraintExpression(ConstraintType.Unique);
CreateConstraintExpressionBuilder builder = new CreateConstraintExpressionBuilder(expression);
builder.OnTable("FOO").Columns(new string[]{"BAR","BAZ" });
expression.Constraint.Columns.First().ShouldBe("BAR");
expression.Constraint.Columns.ElementAt(1).ShouldBe("BAZ");
}
public void ATableShouldBeAllowedToSpecifyASchema()
{
CreateConstraintExpression expression = new CreateConstraintExpression(ConstraintType.PrimaryKey);
CreateConstraintExpressionBuilder builder = new CreateConstraintExpressionBuilder(expression);
builder.OnTable("FOO").WithSchema("BAR").Column("BAZ");
expression.Constraint.SchemaName.ShouldBe("BAR");
expression.Constraint.TableName.ShouldBe("FOO");
expression.Constraint.Columns.First().ShouldBe("BAZ");
}
