public void CanCreateMultiColumnUniqueConstraint() { var expression = GeneratorTestHelper.GetCreateMultiColumnUniqueConstraintExpression(); var result = _generator.Generate(expression); result.ShouldBe("ALTER TABLE [TestTable1] ADD CONSTRAINT [UC_TestTable1_TestColumn1_TestColumn2] UNIQUE ([TestColumn1], [TestColumn2])"); }
public void CanCreateMultiColumnUniqueConstraint() { var expression = GeneratorTestHelper.GetCreateMultiColumnUniqueConstraintExpression(); var result = generator.Generate(expression); result.ShouldBe("ALTER TABLE \"TestTable1\" ADD CONSTRAINT \"UC_TestTable1_TestColumn1_TestColumn2\" UNIQUE (\"TestColumn1\", \"TestColumn2\")"); }
public void CanCreateMultiColmnUniqueConstraint() { var expression = GeneratorTestHelper.GetCreateMultiColumnUniqueConstraintExpression(); var result = _generator.Generate(expression); result.ShouldBe("ALTER TABLE `TestTable1` ADD CONSTRAINT `UC_TestTable1_TestColumn1_TestColumn2` UNIQUE (`TestColumn1`, `TestColumn2`)"); }
public override void CanCreateMultiColumnUniqueConstraintWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateMultiColumnUniqueConstraintExpression(); var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE TestTable1 ADD CONSTRAINT UC_TestTable1_TestColumn1_TestColumn2 UNIQUE (TestColumn1, TestColumn2)"); }
public override void CanCreateMultiColumnUniqueConstraintWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateMultiColumnUniqueConstraintExpression(); var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE \"public\".\"TestTable1\" ADD CONSTRAINT \"UC_TestTable1_TestColumn1_TestColumn2\" UNIQUE (\"TestColumn1\", \"TestColumn2\");"); }
public override void CanCreateMultiColumnUniqueConstraintWithCustomSchema() { var expression = GeneratorTestHelper.GetCreateMultiColumnUniqueConstraintExpression(); expression.Constraint.SchemaName = "TestSchema"; Assert.Throws <System.ArgumentException>(() => Generator.Generate(expression)); }
public override void CanCreateMultiColumnUniqueConstraintWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateMultiColumnUniqueConstraintExpression(); var result = Generator.Generate(expression); result.ShouldBe(string.Empty); }
public override void CanCreateMultiColumnUniqueConstraintWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateMultiColumnUniqueConstraintExpression(); var result = Generator.Generate(expression); result.ShouldBe("CREATE UNIQUE INDEX \"UC_TestTable1_TestColumn1_TestColumn2\" ON \"TestTable1\" (\"TestColumn1\" ASC, \"TestColumn2\" ASC)"); }
public void CanCreateMultiColumnUniqueConstraintWithCustomSchema() { var expression = GeneratorTestHelper.GetCreateMultiColumnUniqueConstraintExpression(); expression.Constraint.SchemaName = "TestSchema"; var result = generator.Generate(expression); result.ShouldBe("ALTER TABLE [TestSchema].[TestTable1] ADD CONSTRAINT [UC_TestTable1_TestColumn1_TestColumn2] UNIQUE ([TestColumn1], [TestColumn2])"); }
public override void CanCreateMultiColumnUniqueConstraintWithCustomSchema() { var expression = GeneratorTestHelper.GetCreateMultiColumnUniqueConstraintExpression(); expression.Constraint.SchemaName = "TestSchema"; var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE `TestTable1` ADD CONSTRAINT `UC_TestTable1_TestColumn1_TestColumn2` UNIQUE (`TestColumn1`, `TestColumn2`)"); }
public override void CanCreateMultiColumnUniqueConstraintWithCustomSchema() { Assert.Ignore("HANA does not support schema like us know schema in hana is a database name"); var expression = GeneratorTestHelper.GetCreateMultiColumnUniqueConstraintExpression(); expression.Constraint.SchemaName = "TestSchema"; var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE \"TestTable1\" ADD CONSTRAINT \"UC_TestTable1_TestColumn1_TestColumn2\" " + "UNIQUE (\"TestColumn1\", \"TestColumn2\")"); }