public override void CanAddColumn() { var expression = GeneratorTestHelper.GetCreateColumnExpression(); string sql = _generator.Generate(expression); sql.ShouldBe("ALTER TABLE 'TestTable1' ADD COLUMN 'TestColumn1' TEXT NOT NULL"); }
public void CanAddColumnWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateColumnExpression(); var sql = generator.Generate(expression); sql.ShouldBe("ALTER TABLE [dbo].[TestTable1] ADD [TestColumn1] NVARCHAR(5) NOT NULL"); }
public override void CanAddColumn() { var expression = GeneratorTestHelper.GetCreateColumnExpression(); string sql = generator.Generate(expression); sql.ShouldBe("ALTER TABLE \"TestTable1\" ADD \"TestColumn1\" NVARCHAR2(5) NOT NULL"); }
public override void CanAddColumn() { var expression = GeneratorTestHelper.GetCreateColumnExpression(); var sql = _generator.Generate(expression); sql.ShouldBe("ALTER TABLE [TestTable1] ADD [TestColumn1] NVARCHAR(5) NOT NULL"); }
public override void CanCreateColumnWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateColumnExpression(); var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE \"TestTable1\" ADD \"TestColumn1\" VARCHAR(5) NOT NULL"); }
public override void CanAddColumn() { var expression = GeneratorTestHelper.GetCreateColumnExpression(); var result = generator.Generate(expression); result.ShouldBe("ALTER TABLE [TestTable1] ADD COLUMN [TestColumn1] VARCHAR(5) NOT NULL"); }
public override void CanCreateColumnWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateColumnExpression(); var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE TestTable1 ADD COLUMN TestColumn1 VARGRAPHIC(5) CCSID 1200 NOT NULL DEFAULT"); }
public void CanCreateColumnWithoutDescription() { var expression = GeneratorTestHelper.GetCreateColumnExpression(); var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE TestTable1 ADD TestColumn1 NVARCHAR2(5) NOT NULL"); }
public void CanCreateColumnWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateColumnExpression(); var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE `TestTable1` ADD COLUMN `TestColumn1` NVARCHAR(5) NOT NULL"); }
public void CanAddColumnWithCustomSchema() { var expression = GeneratorTestHelper.GetCreateColumnExpression(); expression.SchemaName = "TestSchema"; var sql = generator.Generate(expression); sql.ShouldBe("ALTER TABLE [TestSchema].[TestTable1] ADD [TestColumn1] NVARCHAR(5) NOT NULL"); }
public virtual void CanCreateText() { var expression = GeneratorTestHelper.GetCreateColumnExpression(); expression.Column.Size = 1048576; var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE TestTable1 ADD TestColumn1 BLOB SUB_TYPE TEXT NOT NULL"); }
public virtual void CanCreateSizedString() { var expression = GeneratorTestHelper.GetCreateColumnExpression(); expression.Column.Size = 10; var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE TestTable1 ADD TestColumn1 VARCHAR(10) NOT NULL"); }
public override void CanCreateColumnWithCustomSchema() { var expression = GeneratorTestHelper.GetCreateColumnExpression(); expression.SchemaName = "TestSchema"; var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE TestTable1 ADD TestColumn1 VARCHAR(5) NOT NULL"); }
public void CanCreateColumnWithDefaultSystemMethodNewGuid() { var expression = GeneratorTestHelper.GetCreateColumnExpression(); expression.Column.DefaultValue = SystemMethods.NewGuid; var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE TestTable1 ADD TestColumn1 NVARCHAR2(5) DEFAULT sys_guid() NOT NULL"); }
public override void CanCreateColumnWithCustomSchema() { var expression = GeneratorTestHelper.GetCreateColumnExpression(); expression.SchemaName = "TestSchema"; var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE \"TestSchema\".\"TestTable1\" ADD \"TestColumn1\" varchar(5) NOT NULL;"); }
public void CanCreateColumnWithDefaultSystemMethodCurrentDateTime() { var expression = GeneratorTestHelper.GetCreateColumnExpression(); expression.Column.DefaultValue = SystemMethods.CurrentDateTime; var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE TestTable1 ADD TestColumn1 NVARCHAR2(5) DEFAULT LOCALTIMESTAMP NOT NULL"); }
public void CanCreateColumnWithDefaultValue() { var expression = GeneratorTestHelper.GetCreateColumnExpression(); expression.Column.DefaultValue = 1; var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE TestTable1 ADD TestColumn1 NVARCHAR2(5) DEFAULT 1 NOT NULL"); }
public virtual void CanCreateDefaultString() { var expression = GeneratorTestHelper.GetCreateColumnExpression(); expression.Column.Size = 0; var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE \"TestTable1\" ADD \"TestColumn1\" VARCHAR(255) NOT NULL"); }
public virtual void CanCreateUniqueColumnWithDefaultSchema() { var expression = GeneratorTestHelper.GetCreateColumnExpression(); expression.Column.IsUnique = true; var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE \"TestTable1\" ADD COLUMN \"TestColumn1\" TEXT NOT NULL UNIQUE"); }
public void CanCreateColumnWithDefaultStringValue() { var expression = GeneratorTestHelper.GetCreateColumnExpression(); expression.Column.DefaultValue = "1"; var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE \"TestTable1\" ADD \"TestColumn1\" NVARCHAR2(5) DEFAULT '1' NOT NULL"); }
public void CanCreateColumnWithDefaultSystemMethodCurrentUser() { var expression = GeneratorTestHelper.GetCreateColumnExpression(); expression.Column.DefaultValue = SystemMethods.CurrentUser; var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE \"TestTable1\" ADD \"TestColumn1\" NVARCHAR2(5) DEFAULT USER NOT NULL"); }
public override void CanCreateColumnWithCustomSchema() { Assert.Ignore("Hana support change default value with type like bellow"); var expression = GeneratorTestHelper.GetCreateColumnExpression(); expression.SchemaName = "TestSchema"; var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE \"TestTable1\" ADD (\"TestColumn1\" NVARCHAR(5))"); }