public override void CanDeleteDataForMultipleRowsWithDefaultSchema() { var expression = GeneratorTestHelper.GetDeleteDataMultipleRowsExpression(); var result = Generator.Generate(expression); result.ShouldBe("DELETE FROM \"public\".\"TestTable1\" WHERE \"Name\" = 'Just''in' AND \"Website\" IS NULL;DELETE FROM \"public\".\"TestTable1\" WHERE \"Website\" = 'github.com';"); }
public override void CanDeleteDataMultipleRows() { var expression = GeneratorTestHelper.GetDeleteDataMultipleRowsExpression(); var sql = generator.Generate(expression); sql.ShouldBe("DELETE FROM 'TestTable1' WHERE 'Name' = 'Just''in' AND 'Website' IS NULL; DELETE FROM 'TestTable1' WHERE 'Website' = 'github.com'"); }
public override void CanDeleteDataForMultipleRowsWithDefaultSchema() { var expression = GeneratorTestHelper.GetDeleteDataMultipleRowsExpression(); var result = Generator.Generate(expression); result.ShouldBe("DELETE FROM TestTable1 WHERE Name = 'Just''in' AND Website IS NULL; DELETE FROM TestTable1 WHERE Website = 'github.com'"); }
public void CanDeleteDataMulitpleRowsWithDefaultSchema() { var expression = GeneratorTestHelper.GetDeleteDataMultipleRowsExpression(); var sql = generator.Generate(expression); sql.ShouldBe("DELETE FROM [dbo].[TestTable1] WHERE [Name] = 'Just''in' AND [Website] IS NULL; DELETE FROM [dbo].[TestTable1] WHERE [Website] = 'github.com'"); }
public override void CanDeleteDataForMultipleRowsWithDefaultSchema() { var expression = GeneratorTestHelper.GetDeleteDataMultipleRowsExpression(); var result = CreateFixture().Generate(expression); result.ShouldBe("DELETE FROM [dbo].[TestTable1] WHERE [Name] = N'Just''in' AND [Website] IS NULL; DELETE FROM [dbo].[TestTable1] WHERE [Website] = N'github.com'"); }
public override void CanDeleteDataMultipleRows() { var expression = GeneratorTestHelper.GetDeleteDataMultipleRowsExpression(); var sql = generator.Generate(expression); sql.ShouldBe("DELETE FROM `TestTable1` WHERE `Name` = 'Just''in' AND `Website` IS NULL;\r\nDELETE FROM `TestTable1` WHERE `Website` = 'github.com';"); }
public override void CanDeleteDataForMultipleRowsWithCustomSchema() { var expression = GeneratorTestHelper.GetDeleteDataMultipleRowsExpression(); expression.SchemaName = "TestSchema"; var result = Generator.Generate(expression); result.ShouldBe("DELETE FROM [TestTable1] WHERE [Name] = N'Just''in' AND [Website] IS NULL; DELETE FROM [TestTable1] WHERE [Website] = N'github.com'"); }
public override void CanDeleteDataForMultipleRowsWithCustomSchema() { var expression = GeneratorTestHelper.GetDeleteDataMultipleRowsExpression(); expression.SchemaName = "TestSchema"; var result = CreateFixture().Generate(expression); result.ShouldBe("DELETE FROM TestSchema.TestTable1 WHERE Name = 'Just''in' AND Website IS NULL DELETE FROM TestSchema.TestTable1 WHERE Website = 'github.com'"); }
public override void CanDeleteDataMultipleRows() { var expression = GeneratorTestHelper.GetDeleteDataMultipleRowsExpression(); var sql = generator.Generate(expression); sql.ShouldBe("DELETE FROM TestTable1 WHERE Name = 'Just''in' AND Website IS NULL; DELETE FROM TestTable1 WHERE Website = 'github.com'"); sql = quotedIdentiferGenerator.Generate(expression); sql.ShouldBe("DELETE FROM \"TestTable1\" WHERE \"Name\" = 'Just''in' AND \"Website\" IS NULL; DELETE FROM \"TestTable1\" WHERE \"Website\" = 'github.com'"); }
public override void CanDeleteDataForMultipleRowsWithCustomSchema() { var expression = GeneratorTestHelper.GetDeleteDataMultipleRowsExpression(); expression.SchemaName = "TestSchema"; var result = CreateFixture().Generate(expression); result.ShouldBe("DELETE FROM \"TestTable1\" WHERE \"Name\" = N'Just''in' AND \"Website\" IS NULL; " + "DELETE FROM \"TestTable1\" WHERE \"Website\" = N'github.com';"); }
public override void CanDeleteDataForMultipleRowsWithDefaultSchema() { var expression = GeneratorTestHelper.GetDeleteDataMultipleRowsExpression(); var result = CreateFixture().Generate(expression); result.ShouldBe( "DELETE FROM \"TestTable1\" WHERE \"Name\" = 'Just''in' AND \"Website\" IS NULL" + Environment.NewLine + ";" + Environment.NewLine + "DELETE FROM \"TestTable1\" WHERE \"Website\" = 'github.com'"); }
public override void CanDeleteDataForMultipleRowsWithCustomSchema() { Assert.Ignore("HANA does not support schema like us know schema in hana is a database name"); var expression = GeneratorTestHelper.GetDeleteDataMultipleRowsExpression(); expression.SchemaName = "TestSchema"; var result = Generator.Generate(expression); result.ShouldBe("DELETE FROM \"TestSchema\".\"TestTable1\" WHERE \"Name\" = 'Just''in' AND \"Website\" IS NULL;DELETE FROM \"TestSchema\".\"TestTable1\" WHERE \"Website\" = 'github.com';"); }