public void CanCreateMultiColumnPrimaryKeyConstraint() { var expression = GeneratorTestHelper.GetCreateMultiColumnPrimaryKeyExpression(); var result = _generator.Generate(expression); result.ShouldBe("ALTER TABLE [TestTable1] ADD CONSTRAINT [PK_TestTable1_TestColumn1_TestColumn2] PRIMARY KEY ([TestColumn1], [TestColumn2])"); }
public void CanCreateMultiColmnPrimaryKeyConstraint() { var expression = GeneratorTestHelper.GetCreateMultiColumnPrimaryKeyExpression(); var result = generator.Generate(expression); result.ShouldBe("ALTER TABLE \"TestTable1\" ADD CONSTRAINT \"PK_TestTable1_TestColumn1_TestColumn2\" PRIMARY KEY (\"TestColumn1\", \"TestColumn2\")"); }
public void CanCreateMultiColmnPrimaryKeyConstraint() { var expression = GeneratorTestHelper.GetCreateMultiColumnPrimaryKeyExpression(); var result = _generator.Generate(expression); result.ShouldBe("ALTER TABLE `TestTable1` ADD CONSTRAINT `PK_TestTable1_TestColumn1_TestColumn2` PRIMARY KEY (`TestColumn1`, `TestColumn2`);"); }
public override void CanCreateMultiColumnPrimaryKeyConstraintWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateMultiColumnPrimaryKeyExpression(); var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE TestTable1 ADD CONSTRAINT PK_TestTable1_TestColumn1_TestColumn2 PRIMARY KEY (TestColumn1, TestColumn2)"); }
public override void CanCreateMultiColumnPrimaryKeyConstraintWithCustomSchema() { var expression = GeneratorTestHelper.GetCreateMultiColumnPrimaryKeyExpression(); expression.Constraint.SchemaName = "TestSchema"; Assert.Throws <System.ArgumentException>(() => Generator.Generate(expression)); }
public override void CanCreateMultiColumnPrimaryKeyConstraintWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateMultiColumnPrimaryKeyExpression(); var result = Generator.Generate(expression); result.ShouldBe(string.Empty); }
public override void CanCreateMultiColumnPrimaryKeyConstraintWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateMultiColumnPrimaryKeyExpression(); var result = _generator.Generate(expression); result.ShouldBe( "ALTER TABLE \"public\".\"TestTable1\" ADD CONSTRAINT \"PK_TestTable1_TestColumn1_TestColumn2\" PRIMARY KEY (\"TestColumn1\", \"TestColumn2\");"); }
public void CanCreateMultiColumnPrimaryKeyConstraintWithCustomSchema() { var expression = GeneratorTestHelper.GetCreateMultiColumnPrimaryKeyExpression(); expression.Constraint.SchemaName = "TestSchema"; var result = generator.Generate(expression); result.ShouldBe("ALTER TABLE [TestSchema].[TestTable1] ADD CONSTRAINT [PK_TestTable1_TestColumn1_TestColumn2] PRIMARY KEY ([TestColumn1], [TestColumn2])"); }
public override void CanCreateMultiColumnPrimaryKeyConstraintWithCustomSchema() { var expression = GeneratorTestHelper.GetCreateMultiColumnPrimaryKeyExpression(); expression.Constraint.SchemaName = "TestSchema"; var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE `TestTable1` ADD CONSTRAINT `PK_TestTable1_TestColumn1_TestColumn2` PRIMARY KEY (`TestColumn1`, `TestColumn2`)"); }
public override void CanCreateMultiColumnPrimaryKeyConstraintWithCustomSchema() { Assert.Ignore("HANA does not support schema like us know schema in hana is a database name"); var expression = GeneratorTestHelper.GetCreateMultiColumnPrimaryKeyExpression(); expression.Constraint.SchemaName = "TestSchema"; var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE \"TestTable1\" ADD CONSTRAINT \"PK_TestTable1_TestColumn1_TestColumn2\" " + "PRIMARY KEY (\"TestColumn1\", \"TestColumn2\")"); }
public override void CanCreateMultiColumnPrimaryKeyConstraintWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateMultiColumnPrimaryKeyExpression(); Assert.Throws <DatabaseOperationNotSupportedException>(() => Generator.Generate(expression)); }