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 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 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 void CantCreateTableWithDescription() { var expression = GeneratorTestHelper.GetCreateTableWithTableDescription(); Assert.Throws <ArgumentException>(() => Generator.Generate(expression)); }
public void CantCreateTableWithDescription() { var expression = GeneratorTestHelper.GetCreateTableWithTableDescription(); Generator.Generate(expression); }