public void CanCreateNamedUniqueConstraint() { var expression = GeneratorTestHelper.GetCreateNamedUniqueConstraintExpression(); var result = _generator.Generate(expression); result.ShouldBe("ALTER TABLE [TestTable1] ADD CONSTRAINT [TESTUNIQUECONSTRAINT] UNIQUE ([TestColumn1])"); }
public override void CanCreateNamedUniqueConstraintWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateNamedUniqueConstraintExpression(); var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE TestTable1 ADD CONSTRAINT TESTUNIQUECONSTRAINT UNIQUE (TestColumn1)"); }
public override void CanCreateNamedUniqueConstraintWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateNamedUniqueConstraintExpression(); var result = Generator.Generate(expression); result.ShouldBe(string.Empty); }
public override void CanCreateNamedUniqueConstraintWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateNamedUniqueConstraintExpression(); var result = Generator.Generate(expression); result.ShouldBe("CREATE UNIQUE INDEX \"TESTUNIQUECONSTRAINT\" ON \"TestTable1\" (\"TestColumn1\" ASC)"); }
public void CanCreateNamedUniqueConstraintWithCustomSchema() { var expression = GeneratorTestHelper.GetCreateNamedUniqueConstraintExpression(); expression.Constraint.SchemaName = "TestSchema"; var result = generator.Generate(expression); result.ShouldBe("ALTER TABLE [TestSchema].[TestTable1] ADD CONSTRAINT [TESTUNIQUECONSTRAINT] UNIQUE ([TestColumn1])"); }
public override void CanCreateNamedUniqueConstraintWithCustomSchema() { var expression = GeneratorTestHelper.GetCreateNamedUniqueConstraintExpression(); expression.Constraint.SchemaName = "TestSchema"; var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE `TestTable1` ADD CONSTRAINT `TESTUNIQUECONSTRAINT` UNIQUE (`TestColumn1`)"); }
public override void CanCreateNamedNonClusteredUniqueConstraintWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateNamedUniqueConstraintExpression(); expression.Constraint.AdditionalFeatures.Add(SqlServerExtensions.ConstraintType, SqlServerConstraintType.NonClustered); var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE [dbo].[TestTable1] ADD CONSTRAINT [TESTUNIQUECONSTRAINT] UNIQUE NONCLUSTERED ([TestColumn1])"); }
public void CanCreateNamedUniqueConstraint() { var expression = GeneratorTestHelper.GetCreateNamedUniqueConstraintExpression(); var result = generator.Generate(expression); result.ShouldBe("ALTER TABLE TestTable1 ADD CONSTRAINT TESTUNIQUECONSTRAINT UNIQUE (TestColumn1)"); result = quotedIdentiferGenerator.Generate(expression); result.ShouldBe("ALTER TABLE \"TestTable1\" ADD CONSTRAINT \"TESTUNIQUECONSTRAINT\" UNIQUE (\"TestColumn1\")"); }
public void CanCreateClusteredNamedUniqueConstraint() { var expression = GeneratorTestHelper.GetCreateNamedUniqueConstraintExpression(); expression.Constraint.AdditionalFeatures.Add(SqlServerExtensions.ConstraintType, SqlServerConstraintType.Clustered); var result = _generator.Generate(expression); result.ShouldBe("ALTER TABLE [TestTable1] ADD CONSTRAINT [TESTUNIQUECONSTRAINT] UNIQUE CLUSTERED ([TestColumn1])"); }
public override void CanCreateNamedUniqueConstraintWithCustomSchema() { Assert.Ignore("HANA does not support schema like us know schema in hana is a database name"); var expression = GeneratorTestHelper.GetCreateNamedUniqueConstraintExpression(); expression.Constraint.SchemaName = "TestSchema"; var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE \"TestSchema\".\"TestTable1\" " + "ADD CONSTRAINT \"TESTUNIQUECONSTRAINT\" " + "UNIQUE (\"TestColumn1\")"); }