public override void GenerateDescriptionStatementForCreateColumnReturnColumnDescriptionStatement()
{
var createColumnExpression = GeneratorTestHelper.GetCreateColumnExpressionWithDescription();
var statement = DescriptionGenerator.GenerateDescriptionStatement(createColumnExpression);
statement.ShouldBe("COMMENT ON COLUMN \"public\".\"TestTable1\".\"TestColumn1\" IS 'Description:TestColumn1Description';");
}
public override void GenerateDescriptionStatementForCreateColumnReturnColumnDescriptionStatement()
{
var createColumnExpression = GeneratorTestHelper.GetCreateColumnExpressionWithDescription();
var statement = DescriptionGenerator.GenerateDescriptionStatement(createColumnExpression);
statement.ShouldBe("EXEC sys.sp_addextendedproperty @name = N'MS_Description', @value = N'Description:TestColumn1Description', @level0type = N'SCHEMA', @level0name = 'dbo', @level1type = N'Table', @level1name = 'TestTable1', @level2type = N'Column', @level2name = 'TestColumn1'");
}
public void CanCreateColumnWithDescription()
{
var expression = GeneratorTestHelper.GetCreateColumnExpressionWithDescription();
var result = Generator.Generate(expression);
result.ShouldBe("ALTER TABLE `TestTable1` ADD COLUMN `TestColumn1` VARCHAR(5) NOT NULL COMMENT 'TestColumn1Description'");
}
public void CanCreateColumnWithDescription()
{
var expression = GeneratorTestHelper.GetCreateColumnExpressionWithDescription();
var result = Generator.Generate(expression);
result.ShouldBe("BEGIN EXECUTE IMMEDIATE 'ALTER TABLE TestTable1 ADD TestColumn1 NVARCHAR2(5) NOT NULL';EXECUTE IMMEDIATE 'COMMENT ON COLUMN TestTable1.TestColumn1 IS ''Description:TestColumn1Description'''; END;");
}
public void CanCreateColumnWithDescription()
{
var expression = GeneratorTestHelper.GetCreateColumnExpressionWithDescription();
var result = Generator.Generate(expression);
result.ShouldBe(@"ALTER TABLE [dbo].[TestTable1] ADD [TestColumn1] NVARCHAR(5) NOT NULL" + Environment.NewLine +
"GO" + Environment.NewLine +
"EXEC sys.sp_addextendedproperty @name = N'MS_Description', @value = N'TestColumn1Description', @level0type = N'SCHEMA', @level0name = 'dbo', @level1type = N'Table', @level1name = 'TestTable1', @level2type = N'Column', @level2name = 'TestColumn1'" + Environment.NewLine);
}
