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 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';");
}
static void WriteJson()
{
var w = new Window
{
StartPosition = new Point(200, 200),
Width = 640,
Height = 480,
Title = "尝试",
RootContainer = new Canvas()
};
Label l = new Label
{
Position = new Vector2(100, 100),
Width = 200,
Height = 50,
Text = "这是测试的文本"
};
w.RootContainer.Add(l);
w.RootContainer.Relayout();
DescriptionGenerator dg = new DescriptionGenerator(w);
dg.Generate();
var d = dg.GetDescription();
string json = JsonConvert.SerializeObject(d);
//string json = EditorJsonUtility.ToJson(d);
var sw = File.CreateText(Application.dataPath + "/Editor/data/test.json");
sw.WriteLine(json);
sw.Flush();
sw.Close();
Debug.Log(json);
}
public override string Generate(CreateTableExpression expression)
{
foreach (var expressionColumn in expression.Columns)
{
expressionColumn.Name = expressionColumn.Name.ToLower();
expressionColumn.TableName = expressionColumn.TableName.ToLower();
}
var createStatement = new StringBuilder();
createStatement.AppendFormat(
"CREATE TABLE {0} ({1})",
Quoter.QuoteTableName(expression.TableName, expression.SchemaName),
Column.Generate(expression.Columns, Quoter.QuoteTableName(expression.TableName)));
var descriptionStatement = DescriptionGenerator.GenerateDescriptionStatements(expression)
?.ToList();
createStatement.Append(";");
if (descriptionStatement != null && descriptionStatement.Count != 0)
{
createStatement.Append(string.Join(";", descriptionStatement.ToArray()));
createStatement.Append(";");
}
return(createStatement.ToString());
}
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'");
}
private static void WriteLogMessage()
{
AnsiConsole.MarkupLine(
"[grey]LOG:[/] " +
DescriptionGenerator.Generate() +
"[grey]...[/]");
}
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 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 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 void GenerateDescriptionStatementsForCreateTableReturnTableDescriptionStatement()
{
var createTableExpression = GeneratorTestHelper.GetCreateTableWithTableDescription();
var statements = DescriptionGenerator.GenerateDescriptionStatements(createTableExpression);
var result = statements.First();
result.ShouldBe("EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'TestDescription', @level0type=N'SCHEMA', @level0name='dbo', @level1type=N'TABLE', @level1name='TestTable1'");
}
public override void GenerateDescriptionStatementsForCreateTableReturnTableDescriptionAndColumnDescriptionsStatements()
{
var createTableExpression = GeneratorTestHelper.GetCreateTableWithTableDescriptionAndColumnDescriptions();
var statements = DescriptionGenerator.GenerateDescriptionStatements(createTableExpression).ToArray();
var result = string.Join(";", statements);
result.ShouldBe("EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'TestDescription', @level0type=N'SCHEMA', @level0name='dbo', @level1type=N'TABLE', @level1name='TestTable1';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';EXEC sys.sp_addextendedproperty @name = N'MS_Description', @value = N'Description:TestColumn2Description', @level0type = N'SCHEMA', @level0name = 'dbo', @level1type = N'Table', @level1name = 'TestTable1', @level2type = N'Column', @level2name = 'TestColumn2'");
}
public override void GenerateDescriptionStatementsForCreateTableReturnTableDescriptionAndColumnDescriptionsStatements()
{
var createTableExpression = GeneratorTestHelper.GetCreateTableWithTableDescriptionAndColumnDescriptions();
var statements = DescriptionGenerator.GenerateDescriptionStatements(createTableExpression).ToArray();
var result = string.Join("", statements);
result.ShouldBe("COMMENT ON TABLE \"public\".\"TestTable1\" IS 'TestDescription';COMMENT ON COLUMN \"public\".\"TestTable1\".\"TestColumn1\" IS 'Description:TestColumn1Description';COMMENT ON COLUMN \"public\".\"TestTable1\".\"TestColumn2\" IS 'Description:TestColumn2Description';");
}
public override void GenerateDescriptionStatementsForCreateTableReturnTableDescriptionStatement()
{
var createTableExpression = GeneratorTestHelper.GetCreateTableWithTableDescription();
var statements = DescriptionGenerator.GenerateDescriptionStatements(createTableExpression);
var result = statements.First();
result.ShouldBe("COMMENT ON TABLE \"public\".\"TestTable1\" IS 'TestDescription';");
}
public override void GenerateDescriptionStatementsForCreateTableReturnTableDescriptionAndColumnDescriptionsWithAdditionalDescriptionsStatements()
{
var createTableExpression = GeneratorTestHelper.GetCreateTableWithTableDescriptionAndColumnDescriptionsAndAdditionalDescriptions();
var statements = DescriptionGenerator.GenerateDescriptionStatements(createTableExpression).ToArray();
var result = string.Join(";", statements);
result.ShouldBe(
"COMMENT ON TABLE TestTable1 IS 'TestDescription';COMMENT ON COLUMN TestTable1.TestColumn1 IS 'TestColumn1Description';COMMENT ON COLUMN TestTable1.TestColumn2 IS 'TestColumn2Description'");
}
public override string Generate(AlterTableExpression expression)
{
var descriptionStatement = DescriptionGenerator.GenerateDescriptionStatement(expression);
if (string.IsNullOrEmpty(descriptionStatement))
{
return(base.Generate(expression));
}
return(descriptionStatement);
}
public void GenerateDescriptionStatementsWithSingleQuoteForCreateTableReturnTableDescriptionStatement()
{
var createTableExpression = GeneratorTestHelper.GetCreateTableWithTableDescription();
createTableExpression.TableDescription = "Test Description with single quote (') character here >> '";
var statements = DescriptionGenerator.GenerateDescriptionStatements(createTableExpression);
var result = statements.First();
result.ShouldBe("COMMENT ON TABLE TestTable1 IS 'Test Description with single quote ('') character here >> '''");
}
public override string Generate(CreateTableExpression expression)
{
var descriptionStatements = DescriptionGenerator.GenerateDescriptionStatements(expression);
var createTableStatement = base.Generate(expression);
var descriptionStatementsArray = descriptionStatements as string[] ?? descriptionStatements.ToArray();
if (!descriptionStatementsArray.Any())
{
return(createTableStatement);
}
return(ComposeStatements(createTableStatement, descriptionStatementsArray));
}
GenerateDescriptionStatementsForCreateTableReturnTableDescriptionAndColumnDescriptionsWithAdditionalDescriptionsStatements()
{
var createTableExpression = GeneratorTestHelper.GetCreateTableWithTableDescriptionAndColumnDescriptionsAndAdditionalDescriptions();
var statements = DescriptionGenerator.GenerateDescriptionStatements(createTableExpression).ToArray();
var result = string.Join(string.Empty, statements);
result.ShouldBe(
"COMMENT ON TABLE \"public\".\"TestTable1\" IS 'TestDescription';COMMENT ON COLUMN \"public\".\"TestTable1\".\"TestColumn1\" IS 'Description:TestColumn1Description" + Environment.NewLine +
"AdditionalColumnDescriptionKey1:AdditionalColumnDescriptionValue1';COMMENT ON COLUMN \"public\".\"TestTable1\".\"TestColumn2\" IS 'Description:TestColumn2Description" + Environment.NewLine +
"AdditionalColumnDescriptionKey2:AdditionalColumnDescriptionValue2';");
}
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(CreateTableExpression expression)
{
var descriptionStatements = DescriptionGenerator.GenerateDescriptionStatements(expression);
var createTableStatement = string.Format("CREATE TABLE {0}.{1}", Quoter.QuoteSchemaName(expression.SchemaName), base.Generate(expression));
var descriptionStatementsArray = descriptionStatements as string[] ?? descriptionStatements.ToArray();
if (!descriptionStatementsArray.Any())
{
return(createTableStatement);
}
return(ComposeStatements(createTableStatement, descriptionStatementsArray));
}
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(CreateTableExpression expression)
{
var createStatement = new StringBuilder();
var tableName = Quoter.QuoteTableName(expression.TableName);
createStatement.Append(string.Format("CREATE TABLE {0}.{1} ({2})", Quoter.QuoteSchemaName(expression.SchemaName), tableName, Column.Generate(expression.Columns, tableName)));
var descriptionStatement = DescriptionGenerator.GenerateDescriptionStatements(expression);
if (descriptionStatement != null && descriptionStatement.Any())
{
createStatement.Append(";");
createStatement.Append(string.Join(";", descriptionStatement.ToArray()));
}
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()));
}
