public override void CanCreateIndex() { var expression = GeneratorTestHelper.GetCreateIndexExpression(); var sql = _generator.Generate(expression); sql.ShouldBe("CREATE INDEX `TestIndex` ON `TestTable1` (`TestColumn1` ASC);"); }
public override void CanCreateIndex() { var expression = GeneratorTestHelper.GetCreateIndexExpression(); string sql = _generator.Generate(expression); sql.ShouldBe("CREATE INDEX \"TestIndex\" ON \"TestTable1\" (\"TestColumn1\" ASC)"); }
public override void CanCreateIndex() { var expression = GeneratorTestHelper.GetCreateIndexExpression(); string sql = generator.Generate(expression); sql.ShouldBe("CREATE INDEX 'TestIndex' ON 'TestTable1' ('TestColumn1' ASC)"); }
public void CanCreateIndexWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateIndexExpression(); var sql = generator.Generate(expression); sql.ShouldBe("CREATE INDEX [TestIndex] ON [dbo].[TestTable1] ([TestColumn1] ASC)"); }
public override void CanCreateIndex() { var expression = GeneratorTestHelper.GetCreateIndexExpression(); var sql = generator.Generate(expression); sql.ShouldBe("CREATE INDEX [TestIndex] ON [TestTable1] ([TestColumn1] ASC)"); }
public override void CanCreateIndexWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateIndexExpression(); var result = Generator.Generate(expression); result.ShouldBe("CREATE INDEX \"TestIndex\" ON \"public\".\"TestTable1\" (\"TestColumn1\" ASC);"); }
public override void CanCreateIndexWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateIndexExpression(); var result = Generator.Generate(expression); result.ShouldBe("CREATE INDEX [TestIndex] ON [TestTable1] ([TestColumn1] ASC)"); }
public override void CanCreateIndexWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateIndexExpression(); var result = _generator.Generate(expression); result.ShouldBe(string.Empty); }
public void CanCreateIndexWithIncludedColumnAndFilter() { var expression = GeneratorTestHelper.GetCreateIndexExpression(); var x = new CreateIndexExpressionBuilder(expression).Filter("TestColumn2 IS NULL").Include("TestColumn3"); var result = _generator.Generate(expression); result.ShouldBe("CREATE INDEX [TestIndex] ON [dbo].[TestTable1] ([TestColumn1] ASC) INCLUDE ([TestColumn3]) WHERE TestColumn2 IS NULL"); }
public void CanCreateIndexWithOnlineOffOption() { var expression = GeneratorTestHelper.GetCreateIndexExpression(); new CreateIndexExpressionBuilder(expression).Online(false); var result = Generator.Generate(expression); result.ShouldBe("CREATE INDEX [TestIndex] ON [dbo].[TestTable1] ([TestColumn1] ASC) WITH (ONLINE=OFF)"); }
public void CanCreateClusteredIndex() { var expression = GeneratorTestHelper.GetCreateIndexExpression(); expression.Index.IsClustered = true; var sql = generator.Generate(expression); sql.ShouldBe("CREATE CLUSTERED INDEX [TestIndex] ON [TestTable1] ([TestColumn1] ASC)"); }
public void CanCreateIndexWithCustomSchema() { var expression = GeneratorTestHelper.GetCreateIndexExpression(); expression.Index.SchemaName = "TestSchema"; var sql = generator.Generate(expression); sql.ShouldBe("CREATE INDEX [TestIndex] ON [TestSchema].[TestTable1] ([TestColumn1] ASC)"); }
public void CanCreateIndexWithCompression() { var expression = GeneratorTestHelper.GetCreateIndexExpression(); new CreateIndexExpressionBuilder(expression).WithDataCompression(DataCompressionType.Page); var result = _generator.Generate(expression); result.ShouldBe("CREATE INDEX [TestIndex] ON [dbo].[TestTable1] ([TestColumn1] ASC) WITH (DATA_COMPRESSION = PAGE)"); }
public void CanCreateClusteredIndexTreatedAsNonClustered() { var expression = GeneratorTestHelper.GetCreateIndexExpression(); expression.Index.IsClustered = true; var result = Generator.Generate(expression); result.ShouldBe("CREATE INDEX [TestIndex] ON [TestTable1] ([TestColumn1] ASC)"); }
public override void CanCreateIndexWithCustomSchema() { var expression = GeneratorTestHelper.GetCreateIndexExpression(); expression.Index.SchemaName = "TestSchema"; var result = Generator.Generate(expression); result.ShouldBe("CREATE INDEX \"TestIndex\" ON \"TestTable1\" (\"TestColumn1\" ASC)"); }
public override void CanCreateIndexWithCustomSchema() { var expression = GeneratorTestHelper.GetCreateIndexExpression(); expression.Index.SchemaName = "TestSchema"; var result = _generator.Generate(expression); result.ShouldBe(string.Empty); }
public override void CanCreateClusteredIndexWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateIndexExpression(); expression.Index.IsClustered = true; var result = Generator.Generate(expression); result.ShouldBe("CREATE CLUSTERED INDEX [TestIndex] ON [dbo].[TestTable1] ([TestColumn1] ASC)"); }
public override void CanCreateIndexWithCustomSchema() { Assert.Ignore("HANA does not support schema like us know schema in hana is a database name"); var expression = GeneratorTestHelper.GetCreateIndexExpression(); expression.Index.SchemaName = "TestSchema"; var result = Generator.Generate(expression); result.ShouldBe("CREATE INDEX \"TestIndex\" ON \"TestSchema\".\"TestTable1\" (\"TestColumn1\" ASC)"); }