public override void CanCreateMulitColumnForeignKey() { var expression = GeneratorTestHelper.GetCreateMultiColumnForeignKeyExpression(); var result = _generator.Generate(expression); result.ShouldBe(string.Empty); }
public override void CanCreateMulitColumnForeignKey() { var expression = GeneratorTestHelper.GetCreateMultiColumnForeignKeyExpression(); string sql = generator.Generate(expression); sql.ShouldBe("ALTER TABLE \"TestTable1\" ADD CONSTRAINT \"FK_Test\" FOREIGN KEY (\"TestColumn1\", \"TestColumn3\") REFERENCES \"TestTable2\" (\"TestColumn2\", \"TestColumn4\")"); }
public override void CanCreateMulitColumnForeignKey() { var expression = GeneratorTestHelper.GetCreateMultiColumnForeignKeyExpression(); string sql = generator.Generate(expression); sql.ShouldBe("ALTER TABLE TestTable1 ADD CONSTRAINT FK_Test FOREIGN KEY (TestColumn1, TestColumn3) REFERENCES TestTable2 (TestColumn2, TestColumn4)"); }
public override void CanCreateMultiColumnForeignKeyWithDifferentSchemas() { var expression = GeneratorTestHelper.GetCreateMultiColumnForeignKeyExpression(); expression.ForeignKey.ForeignTableSchema = "TestSchema"; Assert.Throws <System.ArgumentException>(() => Generator.Generate(expression)); }
public override void CanCreateMultiColumnForeignKeyWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateMultiColumnForeignKeyExpression(); var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE `TestTable1` ADD CONSTRAINT `FK_TestTable1_TestColumn1_TestColumn3_TestTable2_TestColumn2_TestColumn4` FOREIGN KEY (`TestColumn1`, `TestColumn3`) REFERENCES `TestTable2` (`TestColumn2`, `TestColumn4`)"); }
public override void CanCreateMulitColumnForeignKey() { var expression = GeneratorTestHelper.GetCreateMultiColumnForeignKeyExpression(); var sql = _generator.Generate(expression); sql.ShouldBe( "ALTER TABLE `TestTable1` ADD CONSTRAINT `FK_Test` FOREIGN KEY (`TestColumn1`, `TestColumn3`) REFERENCES `TestTable2` (`TestColumn2`, `TestColumn4`)"); }
public override void CanCreateMultiColumnForeignKeyWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateMultiColumnForeignKeyExpression(); var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE [dbo].[TestTable1] ADD CONSTRAINT [FK_TestTable1_TestColumn1_TestColumn3_TestTable2_TestColumn2_TestColumn4] FOREIGN KEY ([TestColumn1], [TestColumn3]) REFERENCES [dbo].[TestTable2] ([TestColumn2], [TestColumn4])"); }
public override void CanCreateMulitColumnForeignKey() { var expression = GeneratorTestHelper.GetCreateMultiColumnForeignKeyExpression(); var sql = _generator.Generate(expression); sql.ShouldBe( "ALTER TABLE [TestTable1] ADD CONSTRAINT [FK_Test] FOREIGN KEY ([TestColumn1], [TestColumn3]) REFERENCES [TestTable2] ([TestColumn2], [TestColumn4])"); }
public override void CanCreateMultiColumnForeignKeyWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateMultiColumnForeignKeyExpression(); var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE \"public\".\"TestTable1\" ADD CONSTRAINT \"FK_TestTable1_TestColumn1_TestColumn3_TestTable2_TestColumn2_TestColumn4\" FOREIGN KEY (\"TestColumn1\",\"TestColumn3\") REFERENCES \"public\".\"TestTable2\" (\"TestColumn2\",\"TestColumn4\");"); }
public override void CanCreateMultiColumnForeignKeyWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateMultiColumnForeignKeyExpression(); var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE TestTable1 ADD CONSTRAINT FK_TestTable1_TestColumn1_TestColumn3_TestTable2_TestColumn2_TestColumn4 FOREIGN KEY (TestColumn1, TestColumn3) REFERENCES TestTable2 (TestColumn2, TestColumn4)"); }
public override void CanCreateMultiColumnForeignKeyWithCustomSchema() { var expression = GeneratorTestHelper.GetCreateMultiColumnForeignKeyExpression(); expression.ForeignKey.ForeignTableSchema = "TestSchema"; expression.ForeignKey.PrimaryTableSchema = "TestSchema"; Assert.Throws <DatabaseOperationNotSupportedException>(() => Generator.Generate(expression)); }
public override void CanCreateMultiColumnForeignKeyWithDifferentSchemas() { var expression = GeneratorTestHelper.GetCreateMultiColumnForeignKeyExpression(); expression.ForeignKey.ForeignTableSchema = "TestSchema"; var result = Generator.Generate(expression); result.ShouldBe(string.Empty); }
public override void CanCreateMultiColumnForeignKeyWithDifferentSchemas() { var expression = GeneratorTestHelper.GetCreateMultiColumnForeignKeyExpression(); expression.ForeignKey.ForeignTableSchema = "TestSchema"; var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE \"TestTable1\" ADD CONSTRAINT " + "\"FK_TestTable1_TestColumn1_TestColumn3_TestTable2_TestColumn2_TestColumn4\" " + "FOREIGN KEY (\"TestColumn1\", \"TestColumn3\") " + "REFERENCES \"TestTable2\" (\"TestColumn2\", \"TestColumn4\");"); }
public void CanCreateMulitColumnForeignKeyWithCustomSchema() { var expression = GeneratorTestHelper.GetCreateMultiColumnForeignKeyExpression(); expression.ForeignKey.ForeignTableSchema = "TestSchema"; expression.ForeignKey.PrimaryTableSchema = "TestSchema"; var sql = generator.Generate(expression); sql.ShouldBe( "ALTER TABLE [TestSchema].[TestTable1] ADD CONSTRAINT [FK_Test] FOREIGN KEY ([TestColumn1], [TestColumn3]) REFERENCES [TestSchema].[TestTable2] ([TestColumn2], [TestColumn4])"); }
public override void CanCreateMultiColumnForeignKeyWithDifferentSchemas() { Assert.Ignore("HANA does not support schema like us know schema in hana is a database name"); var expression = GeneratorTestHelper.GetCreateMultiColumnForeignKeyExpression(); expression.ForeignKey.ForeignTableSchema = "TestSchema"; var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE \"TestTable1\" ADD CONSTRAINT " + "\"FK_TestTable1_TestColumn1_TestColumn3_TestTable2_TestColumn2_TestColumn4\" " + "FOREIGN KEY (\"TestColumn1\", \"TestColumn3\") " + "REFERENCES \"TestTable2\" (\"TestColumn2\", \"TestColumn4\")"); }
public override void CanCreateMultiColumnForeignKeyWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateMultiColumnForeignKeyExpression(); Assert.Throws <DatabaseOperationNotSupportedException>(() => Generator.Generate(expression)); }
public void CanCreateMulitColumnForeignKeyInStrictMode() { _generator.compatabilityMode = Runner.CompatabilityMode.STRICT; Assert.Throws <DatabaseOperationNotSupportedException>(() => _generator.Generate(GeneratorTestHelper.GetCreateMultiColumnForeignKeyExpression())); }
public override void CanCreateMultiColumnForeignKeyWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateMultiColumnForeignKeyExpression(); Assert.Throws <System.ArgumentException>(() => Generator.Generate(expression)); }