public override void CanAlterColumn()
{
var expression = GeneratorTestHelper.GetAlterColumnExpression();
string sql = generator.Generate(expression);
sql.ShouldBe("ALTER TABLE \"TestTable1\" MODIFY \"TestColumn1\" NVARCHAR2(20) NOT NULL");
}
public void CanAlterColumn()
{
//TODO: This will fail if there are any keys attached
var expression = GeneratorTestHelper.GetAlterColumnExpression();
var sql = generator.Generate(expression);
sql.ShouldBe("ALTER TABLE [TestTable1] ALTER COLUMN [TestColumn1] NVARCHAR(20) NOT NULL");
}
public override void CanAlterColumnWithDefaultSchema()
{
var expression = GeneratorTestHelper.GetAlterColumnExpression();
var result = Generator.Generate(expression);
result.ShouldBe(string.Empty);
}
public void CanAlterColumnWithoutDescription()
{
var expression = GeneratorTestHelper.GetAlterColumnExpression();
var result = Generator.Generate(expression);
result.ShouldBe("ALTER TABLE TestTable1 MODIFY TestColumn1 NVARCHAR2(20) NOT NULL");
}
public void CanAlterColumnWithDefaultSchema()
{
var expression = GeneratorTestHelper.GetAlterColumnExpression();
var result = Generator.Generate(expression);
result.ShouldBe("ALTER TABLE `TestTable1` MODIFY COLUMN `TestColumn1` NVARCHAR(20) NOT NULL");
}
public void CanNotAlterColumnInStrictMode()
{
var expression = GeneratorTestHelper.GetAlterColumnExpression();
Generator.CompatibilityMode = CompatibilityMode.STRICT;
Assert.Throws <DatabaseOperationNotSupportedException>(() => Generator.Generate(expression));
}
public override void CanAlterColumnWithCustomSchema()
{
var expression = GeneratorTestHelper.GetAlterColumnExpression();
expression.SchemaName = "TestSchema";
Assert.Throws <DatabaseOperationNotSupportedException>(() => Generator.Generate(expression));
}
public override void CanAlterColumnWithDefaultSchema()
{
var expression = GeneratorTestHelper.GetAlterColumnExpression();
var result = Generator.Generate(expression);
result.ShouldBe("ALTER TABLE \"TestTable1\" MODIFY \"TestColumn1\" NVARCHAR2(20) NOT NULL");
}
public override void CanAlterColumn()
{
var expression = GeneratorTestHelper.GetAlterColumnExpression();
var sql = _generator.Generate(expression);
sql.ShouldBe("ALTER TABLE `TestTable1` MODIFY COLUMN `TestColumn1` VARCHAR(20) NOT NULL");
}
public override void CanAlterColumnWithDefaultSchema()
{
//TODO: This will fail if there are any keys attached
var expression = GeneratorTestHelper.GetAlterColumnExpression();
var result = Generator.Generate(expression);
result.ShouldBe("ALTER TABLE [TestTable1] ALTER COLUMN [TestColumn1] NVARCHAR(20) NOT NULL");
}
public void CanAlterColumnToSetNullableFalse()
{
var expression = GeneratorTestHelper.GetAlterColumnExpression();
expression.Column.IsNullable = false;
var result = Generator.Generate(expression);
result.ShouldBe("ALTER TABLE [dbo].[TestTable1] ALTER [TestColumn1] NVARCHAR(20) NOT NULL");
}
public override void CanAlterColumnWithCustomSchema()
{
var expression = GeneratorTestHelper.GetAlterColumnExpression();
expression.SchemaName = "TestSchema";
var result = Generator.Generate(expression);
result.ShouldBe(string.Empty);
}
public override void CanAlterColumnWithCustomSchema()
{
var expression = GeneratorTestHelper.GetAlterColumnExpression();
expression.SchemaName = "TestSchema";
var result = Generator.Generate(expression);
result.ShouldBe("ALTER TABLE `TestTable1` MODIFY COLUMN `TestColumn1` VARCHAR(20) NOT NULL");
}
public override void CanAlterColumnWithDefaultSchema()
{
var expression = GeneratorTestHelper.GetAlterColumnExpression();
expression.Column.IsNullable = null;
var result = Generator.Generate(expression);
result.ShouldBe("ALTER TABLE \"TestTable1\" ALTER (\"TestColumn1\" NVARCHAR(20));");
}
public override void CanAlterColumnWithDefaultSchema()
{
var expression = GeneratorTestHelper.GetAlterColumnExpression();
expression.Column.IsNullable = null;
var result = Generator.Generate(expression);
result.ShouldBe("ALTER TABLE TestTable1 ALTER COLUMN TestColumn1 SET DATA TYPE VARGRAPHIC(20) CCSID 1200 NOT NULL");
}
public void CanAlterColumnNotNull()
{
var expression = GeneratorTestHelper.GetAlterColumnExpression();
expression.Column.IsNullable = false;
var result = Generator.Generate(expression);
result.ShouldBe("ALTER TABLE TestTable1 MODIFY TestColumn1 NVARCHAR2(20) NOT NULL");
}
public void CanAlterColumnNoNullSettings()
{
var expression = GeneratorTestHelper.GetAlterColumnExpression();
expression.Column.IsNullable = null;
var result = Generator.Generate(expression);
result.ShouldBe("ALTER TABLE TestTable1 MODIFY TestColumn1 NVARCHAR2(20)");
}
public override void CanAlterColumnWithCustomSchema()
{
var expression = GeneratorTestHelper.GetAlterColumnExpression();
expression.Column.IsNullable = null;
expression.SchemaName = "TestSchema";
var result = Generator.Generate(expression);
result.ShouldBe("ALTER TABLE \"TestSchema\".\"TestTable1\" ALTER \"TestColumn1\" TYPE varchar(20);");
}
public void CanAlterColumnToNullableWithCustomSchema()
{
var expression = GeneratorTestHelper.GetAlterColumnExpression();
expression.SchemaName = "TestSchema";
expression.Column.IsNullable = true;
var result = Generator.Generate(expression);
result.ShouldBe("ALTER TABLE [TestTable1] ALTER COLUMN [TestColumn1] NVARCHAR(20) NULL");
}
public void CanAlterColumnNoNullSettings()
{
var expression = GeneratorTestHelper.GetAlterColumnExpression();
expression.Column.IsNullable = null;
string sql = generator.Generate(expression);
sql.ShouldBe("ALTER TABLE TestTable1 MODIFY TestColumn1 NVARCHAR2(20)");
sql = quotedIdentiferGenerator.Generate(expression);
sql.ShouldBe("ALTER TABLE \"TestTable1\" MODIFY \"TestColumn1\" NVARCHAR2(20)");
}
public override void CanAlterColumnWithCustomSchema()
{
Assert.Ignore("Hana support change default value with type like bellow");
var expression = GeneratorTestHelper.GetAlterColumnExpression();
expression.Column.IsNullable = null;
expression.SchemaName = "TestSchema";
var result = Generator.Generate(expression);
result.ShouldBe("ALTER TABLE \"TestTable1\" ALTER (\"TestColumn1\" NVARCHAR(20))");
//HANA Dosent suport SCHEMA YEAT
}
