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