public override void CanCreateAutoIncrementColumnWithDefaultSchema() { var expression = GeneratorTestHelper.GetAlterColumnAddAutoIncrementExpression(); var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE \"public\".\"TestTable1\" ALTER \"TestColumn1\" TYPE serial;"); }
public override void CanCreateAutoIncrementColumnWithDefaultSchema() { var expression = GeneratorTestHelper.GetAlterColumnAddAutoIncrementExpression(); var result = Generator.Generate(expression); result.ShouldBe(string.Empty); }
public override void CanCreateAutoIncrementColumnWithDefaultSchema() { var expression = GeneratorTestHelper.GetAlterColumnAddAutoIncrementExpression(); var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE `TestTable1` MODIFY COLUMN `TestColumn1` INTEGER NOT NULL AUTO_INCREMENT"); }
public override void CanCreateAutoIncrementColumnWithDefaultSchema() { var expression = GeneratorTestHelper.GetAlterColumnAddAutoIncrementExpression(); var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE [TestTable1] ALTER COLUMN [TestColumn1] INT NOT NULL IDENTITY(1,1)"); }
public override void CanCreateAutoIncrementColumnWithDefaultSchema() { var expression = GeneratorTestHelper.GetAlterColumnAddAutoIncrementExpression(); var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE \"TestTable1\" ALTER (\"TestColumn1\" INTEGER GENERATED ALWAYS AS IDENTITY);"); }
public override void CanCreateAutoIncrementColumn() { var expression = GeneratorTestHelper.GetAlterColumnAddAutoIncrementExpression(); var sql = _generator.Generate(expression); sql.ShouldBe("ALTER TABLE [TestTable1] ALTER COLUMN [TestColumn1] COUNTER NOT NULL"); }
public override void CanCreateAutoIncrementColumnWithDefaultSchema() { var expression = GeneratorTestHelper.GetAlterColumnAddAutoIncrementExpression(); var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE [dbo].[TestTable1] ALTER [TestColumn1] INTEGER NOT NULL DEFAULT AUTOINCREMENT"); }
public override void CanCreateAutoIncrementColumnWithCustomSchema() { var expression = GeneratorTestHelper.GetAlterColumnAddAutoIncrementExpression(); expression.SchemaName = "TestSchema"; Assert.Throws <DatabaseOperationNotSupportedException>(() => Generator.Generate(expression)); }
public override void CanCreateAutoIncrementColumn() { var expression = GeneratorTestHelper.GetAlterColumnAddAutoIncrementExpression(); var sql = _generator.Generate(expression); sql.ShouldBe("ALTER TABLE `TestTable1` MODIFY COLUMN `TestColumn1` INTEGER NOT NULL AUTO_INCREMENT;"); }
public override void CanCreateAutoIncrementColumnWithDefaultSchema() { var expression = GeneratorTestHelper.GetAlterColumnAddAutoIncrementExpression(); var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE TestTable1 MODIFY TestColumn1 NUMBER(10,0) GENERATED ALWAYS AS IDENTITY "); }
public void CanCreateAutoIncrementColumnWithDefaultSchemaAndMinValue() { var expression = GeneratorTestHelper.GetAlterColumnAddAutoIncrementExpression(); expression.Column.AdditionalFeatures.Add("OracleIdentityMinValue", 5L); var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE TestTable1 MODIFY TestColumn1 NUMBER(10,0) GENERATED ALWAYS AS IDENTITY (MINVALUE 5)"); }
public void CanCreateAutoIncrementColumnWithDefaultSchemaAndDefaultOnNullIdentity() { var expression = GeneratorTestHelper.GetAlterColumnAddAutoIncrementExpression(); expression.Column.AdditionalFeatures.Add("OracleIdentityGeneration", OracleGenerationType.ByDefaultOnNull); var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE TestTable1 MODIFY TestColumn1 NUMBER(10,0) GENERATED BY DEFAULT ON NULL AS IDENTITY "); }
public override void CanCreateAutoIncrementColumnWithCustomSchema() { var expression = GeneratorTestHelper.GetAlterColumnAddAutoIncrementExpression(); expression.SchemaName = "TestSchema"; var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE \"TestSchema\".\"TestTable1\" ALTER \"TestColumn1\" TYPE integer, ALTER \"TestColumn1\" ADD GENERATED ALWAYS AS IDENTITY;"); }
public override void CanCreateAutoIncrementColumnWithCustomSchema() { var expression = GeneratorTestHelper.GetAlterColumnAddAutoIncrementExpression(); expression.SchemaName = "TestSchema"; var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE [TestTable1] ALTER COLUMN [TestColumn1] COUNTER NOT NULL"); }
public override void CanCreateAutoIncrementColumnWithCustomSchema() { Assert.Ignore("Hana support change default value with type like bellow"); var expression = GeneratorTestHelper.GetAlterColumnAddAutoIncrementExpression(); expression.SchemaName = "TestSchema"; var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE \"TestTable1\" ALTER (\"TestColumn1\" INTEGER GENERATED BY DEFAULT AS IDENTITY)"); }
public void CanCreateAutoIncrementColumnWithDefaultSchemaAndAllIdentityOptions() { var expression = GeneratorTestHelper.GetAlterColumnAddAutoIncrementExpression(); expression.Column.AdditionalFeatures.Add("OracleIdentityStartWith", 1L); expression.Column.AdditionalFeatures.Add("OracleIdentityIncrementBy", 2); expression.Column.AdditionalFeatures.Add("OracleIdentityMinValue", 3L); expression.Column.AdditionalFeatures.Add("OracleIdentityMaxValue", 4L); var result = Generator.Generate(expression); result.ShouldBe("ALTER TABLE TestTable1 MODIFY TestColumn1 NUMBER(10,0) GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 2 MINVALUE 3 MAXVALUE 4)"); }