public override void GenerateDescriptionStatementForAlterTableReturnTableDescriptionStatement()
{
var alterTableExpression = GeneratorTestHelper.GetAlterTableWithDescriptionExpression();
var statement = DescriptionGenerator.GenerateDescriptionStatement(alterTableExpression);
statement.ShouldBe("COMMENT ON TABLE \"public\".\"TestTable1\" IS 'TestDescription';");
}
public override void GenerateDescriptionStatementForAlterColumnReturnColumnDescriptionStatement()
{
var alterColumnExpression = GeneratorTestHelper.GetAlterColumnExpressionWithDescription();
var statement = DescriptionGenerator.GenerateDescriptionStatement(alterColumnExpression);
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("COMMENT ON COLUMN TestTable1.TestColumn1 IS 'TestColumn1Description'");
}
public override void GenerateDescriptionStatementForAlterColumnReturnColumnDescriptionStatement()
{
var alterColumnExpression = GeneratorTestHelper.GetAlterColumnExpressionWithDescription();
var statement = DescriptionGenerator.GenerateDescriptionStatement(alterColumnExpression);
statement.ShouldBe("IF EXISTS (SELECT * FROM fn_listextendedproperty(N'MS_Description', N'SCHEMA', N'dbo', N'TABLE', N'TestTable1', N'Column', N'TestColumn1' )) EXEC sys.sp_dropextendedproperty @name=N'MS_Description', @level0type = N'SCHEMA', @level0name = 'dbo', @level1type = N'Table', @level1name = 'TestTable1', @level2type = N'Column', @level2name = 'TestColumn1';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'");
}
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 override void GenerateDescriptionStatementForAlterColumnReturnColumnDescriptionStatementWithAdditionalDescriptions()
{
var alterColumnExpression = GeneratorTestHelper.GetAlterColumnExpressionWithDescriptionWithAdditionalDescriptions();
var statement = DescriptionGenerator.GenerateDescriptionStatement(alterColumnExpression);
statement.ShouldBe("COMMENT ON COLUMN \"public\".\"TestTable1\".\"TestColumn1\" IS 'Description:TestColumn1Description" + Environment.NewLine +
"AdditionalColumnDescriptionKey1:AdditionalColumnDescriptionValue1';");
}
public override string Generate(AlterTableExpression expression)
{
var descriptionStatement = DescriptionGenerator.GenerateDescriptionStatement(expression);
return(string.Format("{0};",
string.IsNullOrEmpty(descriptionStatement)
? base.Generate(expression) : descriptionStatement));
}
public override void GenerateDescriptionStatementForCreateColumnReturnColumnDescriptionStatementWithAdditionalDescriptions()
{
var createColumnExpression = GeneratorTestHelper.GetCreateColumnExpressionWithDescriptionWithAdditionalDescriptions();
var statement = DescriptionGenerator.GenerateDescriptionStatement(createColumnExpression);
statement.ShouldBe("COMMENT ON COLUMN TestTable1.TestColumn1 IS 'Description:TestColumn1Description" + Environment.NewLine +
"AdditionalColumnDescriptionKey1:AdditionalColumnDescriptionValue1'");
}
public override string Generate(AlterTableExpression expression)
{
var descriptionStatement = DescriptionGenerator.GenerateDescriptionStatement(expression);
if (string.IsNullOrEmpty(descriptionStatement))
{
return(base.Generate(expression));
}
return(descriptionStatement);
}
public override string Generate(AlterColumnExpression expression)
{
var alterTableStatement = string.Format("ALTER TABLE {0}.{1}", Quoter.QuoteSchemaName(expression.SchemaName), base.Generate(expression));
var descriptionStatement = DescriptionGenerator.GenerateDescriptionStatement(expression);
if (string.IsNullOrEmpty(descriptionStatement))
{
return(alterTableStatement);
}
return(ComposeStatements(alterTableStatement, new[] { descriptionStatement }));
}
public override string Generate(AlterTableExpression expression)
{
var alterStatement = new StringBuilder();
var descriptionStatement = DescriptionGenerator.GenerateDescriptionStatement(expression);
alterStatement.Append(base.Generate(expression));
if (string.IsNullOrEmpty(descriptionStatement))
{
alterStatement.Append(descriptionStatement);
}
return(alterStatement.ToString());
}
public override string Generate(CreateColumnExpression expression)
{
var alterTableStatement = base.Generate(expression);
var descriptionStatement = DescriptionGenerator.GenerateDescriptionStatement(expression);
if (string.IsNullOrEmpty(descriptionStatement))
{
return(alterTableStatement);
}
return(ComposeStatements(alterTableStatement, new[] { descriptionStatement }));
}
public override string Generate(AlterColumnExpression expression)
{
var alterStatement = new StringBuilder();
alterStatement.AppendFormat("ALTER TABLE {0} {1};", Quoter.QuoteTableName(expression.TableName, expression.SchemaName), ((RedshiftColumn)Column).GenerateAlterClauses(expression.Column));
var descriptionStatement = DescriptionGenerator.GenerateDescriptionStatement(expression);
if (!string.IsNullOrEmpty(descriptionStatement))
{
alterStatement.Append(";");
alterStatement.Append(descriptionStatement);
}
return(alterStatement.ToString());
}
public override string Generate(CreateColumnExpression expression)
{
var createStatement = new StringBuilder();
createStatement.AppendFormat("ALTER TABLE {0} ADD {1};", Quoter.QuoteTableName(expression.TableName, expression.SchemaName), Column.Generate(expression.Column));
var descriptionStatement = DescriptionGenerator.GenerateDescriptionStatement(expression);
if (!string.IsNullOrEmpty(descriptionStatement))
{
createStatement.Append(";");
createStatement.Append(descriptionStatement);
}
return(createStatement.ToString());
}
public override string Generate(CreateColumnExpression expression)
{
var createStatement = new StringBuilder();
createStatement.Append(base.Generate(expression));
var descriptionStatement = DescriptionGenerator.GenerateDescriptionStatement(expression);
if (!string.IsNullOrEmpty(descriptionStatement))
{
createStatement.Append(";");
createStatement.Append(descriptionStatement);
}
return(createStatement.ToString());
}
public override string Generate(AlterColumnExpression expression)
{
var descriptionStatement = DescriptionGenerator.GenerateDescriptionStatement(expression);
if (string.IsNullOrEmpty(descriptionStatement))
{
return(base.Generate(expression));
}
var wrappedAlterColumnStatement = WrapStatementInExecuteImmediateBlock(base.Generate(expression));
var alterColumnWithDescriptionBuilder = new StringBuilder(wrappedAlterColumnStatement);
alterColumnWithDescriptionBuilder.Append(WrapStatementInExecuteImmediateBlock(descriptionStatement));
return(WrapInBlock(alterColumnWithDescriptionBuilder.ToString()));
}
public override string Generate(CreateColumnExpression expression)
{
var descriptionStatement = DescriptionGenerator.GenerateDescriptionStatement(expression);
if (string.IsNullOrEmpty(descriptionStatement))
{
return(string.Format("{0};", base.Generate(expression)));
}
var wrappedCreateColumnStatement = base.Generate(expression);
var createColumnWithDescriptionBuilder = new StringBuilder(wrappedCreateColumnStatement);
createColumnWithDescriptionBuilder.Append(descriptionStatement);
return(WrapInBlock(createColumnWithDescriptionBuilder.ToString()));
}