public void CanCreatUniqueMultiColumnIndexWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateUniqueMultiColumnIndexExpression(); var sql = generator.Generate(expression); sql.ShouldBe("CREATE UNIQUE INDEX [TestIndex] ON [dbo].[TestTable1] ([TestColumn1] ASC, [TestColumn2] DESC)"); }
public override void CanCreateMultiColumnUniqueIndexWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateUniqueMultiColumnIndexExpression(); var result = Generator.Generate(expression); result.ShouldBe("CREATE UNIQUE INDEX \"TestIndex\" ON \"public\".\"TestTable1\" (\"TestColumn1\" ASC,\"TestColumn2\" DESC);"); }
public override void CanCreateMultiColumnUniqueIndex() { var expression = GeneratorTestHelper.GetCreateUniqueMultiColumnIndexExpression(); string sql = _generator.Generate(expression); sql.ShouldBe("CREATE UNIQUE INDEX TestIndex ON TestTable1 (TestColumn1 ASC, TestColumn2 DESC)"); }
public override void CanCreateMultiColumnUniqueIndex() { var expression = GeneratorTestHelper.GetCreateUniqueMultiColumnIndexExpression(); var sql = generator.Generate(expression); sql.ShouldBe("CREATE UNIQUE INDEX [TestIndex] ON [TestTable1] ([TestColumn1] ASC, [TestColumn2] DESC)"); }
public override void CanCreateMultiColumnUniqueIndex() { var expression = GeneratorTestHelper.GetCreateUniqueMultiColumnIndexExpression(); var sql = _generator.Generate(expression); sql.ShouldBe("CREATE UNIQUE INDEX 'TestIndex' ON 'TestTable1' ('TestColumn1' ASC, 'TestColumn2' DESC)"); }
public override void CanCreateMultiColumnUniqueIndexWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateUniqueMultiColumnIndexExpression(); var result = _generator.Generate(expression); result.ShouldBe(string.Empty); }
public override void CanCreateMultiColumnUniqueIndex() { var expression = GeneratorTestHelper.GetCreateUniqueMultiColumnIndexExpression(); var sql = _generator.Generate(expression); sql.ShouldBe("CREATE UNIQUE INDEX `TestIndex` ON `TestTable1` (`TestColumn1` ASC, `TestColumn2` DESC);"); }
public override void CanCreateMultiColumnUniqueIndexWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateUniqueMultiColumnIndexExpression(); var result = Generator.Generate(expression); result.ShouldBe("CREATE UNIQUE INDEX TestIndex ON TestTable1 (TestColumn1, TestColumn2 DESC)"); }
public override void CanCreateMultiColumnUniqueIndex() { var expression = GeneratorTestHelper.GetCreateUniqueMultiColumnIndexExpression(); var sql = _generator.Generate(expression); sql.ShouldBe("CREATE UNIQUE INDEX \"TestIndex\" ON \"TestTable1\" (\"TestColumn1\" ASC, \"TestColumn2\" DESC)"); }
public void CanCreatClusteredUniqueMultiColumnIndex() { var expression = GeneratorTestHelper.GetCreateUniqueMultiColumnIndexExpression(); expression.Index.IsClustered = true; var sql = generator.Generate(expression); sql.ShouldBe("CREATE UNIQUE CLUSTERED INDEX [TestIndex] ON [TestTable1] ([TestColumn1] ASC, [TestColumn2] DESC)"); }
public void CanCreateMultiColumnUniqueIndexWithOneNonDistinctNulls() { var expression = GeneratorTestHelper.GetCreateUniqueMultiColumnIndexExpression(); expression.Index.Columns.First().SetAdditionalFeature(PostgresExtensions.IndexColumnNullsDistinct, false); var result = Generator.Generate(expression); result.ShouldBe("CREATE UNIQUE INDEX \"TestIndex\" ON \"public\".\"TestTable1\" (\"TestColumn1\" ASC,\"TestColumn2\" DESC) WHERE \"TestColumn1\" IS NOT NULL;"); }
public override void CanCreateUniqueClusteredMultiColumnIndexWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateUniqueMultiColumnIndexExpression(); expression.Index.IsClustered = true; var result = Generator.Generate(expression); result.ShouldBe("CREATE UNIQUE CLUSTERED INDEX [TestIndex] ON [dbo].[TestTable1] ([TestColumn1] ASC, [TestColumn2] DESC)"); }
public void CanCreatMultiColumnUniqueClusteredIndexTreatedAsNonClustered() { var expression = GeneratorTestHelper.GetCreateUniqueMultiColumnIndexExpression(); expression.Index.IsClustered = true; var result = Generator.Generate(expression); result.ShouldBe("CREATE UNIQUE INDEX [TestIndex] ON [TestTable1] ([TestColumn1] ASC, [TestColumn2] DESC)"); }
public override void CanCreateMultiColumnUniqueIndexWithCustomSchema() { var expression = GeneratorTestHelper.GetCreateUniqueMultiColumnIndexExpression(); expression.Index.SchemaName = "TestSchema"; var result = Generator.Generate(expression); result.ShouldBe("CREATE UNIQUE INDEX [TestIndex] ON [TestTable1] ([TestColumn1] ASC, [TestColumn2] DESC)"); }
public void CanCreateMultiColumnUniqueIndexWithOneNonDistinctNulls() { var expression = GeneratorTestHelper.GetCreateUniqueMultiColumnIndexExpression(); expression.Index.Columns.First().SetAdditionalFeature(SqlServerExtensions.IndexColumnNullsDistinct, false); var result = _generator.Generate(expression); result.ShouldBe("CREATE UNIQUE INDEX [TestIndex] ON [dbo].[TestTable1] ([TestColumn1] ASC, [TestColumn2] DESC) WHERE [TestColumn1] IS NOT NULL"); }
public override void CanCreateMultiColumnUniqueIndexWithCustomSchema() { var expression = GeneratorTestHelper.GetCreateUniqueMultiColumnIndexExpression(); expression.Index.SchemaName = "TestSchema"; var result = Generator.Generate(expression); result.ShouldBe("CREATE UNIQUE ASC INDEX \"TestIndex\" ON \"TestTable1\" (\"TestColumn1\", \"TestColumn2\")"); }
public override void CanCreateMultiColumnUniqueIndexWithCustomSchema() { Assert.Ignore("HANA does not support schema like us know schema in hana is a database name"); var expression = GeneratorTestHelper.GetCreateUniqueMultiColumnIndexExpression(); expression.Index.SchemaName = "TestSchema"; var result = Generator.Generate(expression); result.ShouldBe("CREATE UNIQUE INDEX \"TestIndex\" ON \"TestSchema\".\"TestTable1\" (\"TestColumn1\" ASC,\"TestColumn2\" DESC)"); }