public override void CanCreateNamedMultiColumnPrimaryKeyConstraintWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateNamedMultiColumnPrimaryKeyExpression(); var result = Generator.Generate(expression); result.ShouldBe(string.Empty); }
public override void CanCreateNamedMultiColumnPrimaryKeyConstraintWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateNamedMultiColumnPrimaryKeyExpression(); var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE TestTable1 ADD CONSTRAINT TESTPRIMARYKEY PRIMARY KEY (TestColumn1, TestColumn2)"); }
public override void CanCreateNamedMultiColumnPrimaryKeyConstraintWithCustomSchema() { var expression = GeneratorTestHelper.GetCreateNamedMultiColumnPrimaryKeyExpression(); expression.Constraint.SchemaName = "TestSchema"; Assert.Throws <DatabaseOperationNotSupportedException>(() => Generator.Generate(expression)); }
public override void CanCreateNamedMultiColumnPrimaryKeyConstraintWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateNamedMultiColumnPrimaryKeyExpression(); var result = _generator.Generate(expression); result.ShouldBe( "ALTER TABLE \"public\".\"TestTable1\" ADD CONSTRAINT \"TESTPRIMARYKEY\" PRIMARY KEY (\"TestColumn1\", \"TestColumn2\");"); }
public override void CanCreateNamedMultiColumnPrimaryKeyConstraintWithCustomSchema() { var expression = GeneratorTestHelper.GetCreateNamedMultiColumnPrimaryKeyExpression(); expression.Constraint.SchemaName = "TestSchema"; var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE [TestSchema].[TestTable1] ADD CONSTRAINT [TESTPRIMARYKEY] PRIMARY KEY ([TestColumn1], [TestColumn2])"); }
public override void CanCreateNamedMultiColumnNonClusteredPrimaryKeyConstraintWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateNamedMultiColumnPrimaryKeyExpression(); expression.Constraint.AdditionalFeatures.Add(SqlServerExtensions.ConstraintType, SqlServerConstraintType.NonClustered); var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE [dbo].[TestTable1] ADD CONSTRAINT [TESTPRIMARYKEY] PRIMARY KEY NONCLUSTERED ([TestColumn1], [TestColumn2])"); }
public override void CanCreateNamedMultiColumnPrimaryKeyConstraintWithCustomSchema() { Assert.Ignore("HANA does not support schema like us know schema in hana is a database name"); var expression = GeneratorTestHelper.GetCreateNamedMultiColumnPrimaryKeyExpression(); expression.Constraint.SchemaName = "TestSchema"; var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE \"TestTable1\" " + "ADD CONSTRAINT \"TESTPRIMARYKEY\" " + "PRIMARY KEY (\"TestColumn1\", \"TestColumn2\")"); }