public void CanCreateUniqueConstraint() { var expression = GeneratorTestHelper.GetCreateUniqueConstraintExpression(); var result = _generator.Generate(expression); result.ShouldBe("ALTER TABLE [TestTable1] ADD CONSTRAINT [UC_TestTable1_TestColumn1] UNIQUE ([TestColumn1])"); }
public override void CanCreateUniqueConstraintWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateUniqueConstraintExpression(); var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE \"TestTable1\" ADD CONSTRAINT \"UC_TestTable1_TestColumn1\" UNIQUE (\"TestColumn1\");"); }
public override void CanCreateUniqueConstraintWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateUniqueConstraintExpression(); var result = Generator.Generate(expression); result.ShouldBe(string.Empty); }
public override void CanCreateUniqueConstraintWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateUniqueConstraintExpression(); var result = Generator.Generate(expression); result.ShouldBe("CREATE UNIQUE INDEX \"UC_TestTable1_TestColumn1\" ON \"TestTable1\" (\"TestColumn1\" ASC)"); }
public void CanCreateUniqueConstraintWithCustomSchema() { var expression = GeneratorTestHelper.GetCreateUniqueConstraintExpression(); expression.Constraint.SchemaName = "TestSchema"; var result = generator.Generate(expression); result.ShouldBe("ALTER TABLE [TestSchema].[TestTable1] ADD CONSTRAINT [UC_TestTable1_TestColumn1] UNIQUE ([TestColumn1])"); }
public override void CanCreateUniqueConstraintWithCustomSchema() { var expression = GeneratorTestHelper.GetCreateUniqueConstraintExpression(); expression.Constraint.SchemaName = "TestSchema"; var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE TestSchema.TestTable1 ADD CONSTRAINT TestSchema.UC_TestTable1_TestColumn1 UNIQUE (TestColumn1)"); }
public override void CanCreateUniqueConstraintWithCustomSchema() { var expression = GeneratorTestHelper.GetCreateUniqueConstraintExpression(); expression.Constraint.SchemaName = "TestSchema"; var result = Generator.Generate(expression); result.ShouldBe(string.Empty); }
public void CanCreateUniqueConstraint() { var expression = GeneratorTestHelper.GetCreateUniqueConstraintExpression(); var result = generator.Generate(expression); result.ShouldBe("ALTER TABLE TestTable1 ADD CONSTRAINT UC_TestTable1_TestColumn1 UNIQUE (TestColumn1)"); result = quotedIdentiferGenerator.Generate(expression); result.ShouldBe("ALTER TABLE \"TestTable1\" ADD CONSTRAINT \"UC_TestTable1_TestColumn1\" UNIQUE (\"TestColumn1\")"); }
public override void CanCreateUniqueConstraintWithCustomSchema() { Assert.Ignore("HANA does not support schema like us know schema in hana is a database name"); var expression = GeneratorTestHelper.GetCreateUniqueConstraintExpression(); expression.Constraint.SchemaName = "TestSchema"; var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE \"TestSchema\".\"TestTable1\" ADD CONSTRAINT \"UC_TestTable1_TestColumn1\" UNIQUE (\"TestColumn1\")"); }