C# (CSharp) GeneratorTestHelper.GetAlterColumnAddAutoIncrementExpression Exemples

Exemple #1

Fichier : PostgresColumnTests.cs Projet : workgroupengineering/fluentmigrator

        public override void CanCreateAutoIncrementColumnWithDefaultSchema()
        {
            var expression = GeneratorTestHelper.GetAlterColumnAddAutoIncrementExpression();

            var result = Generator.Generate(expression);

            result.ShouldBe("ALTER TABLE \"public\".\"TestTable1\" ALTER \"TestColumn1\" TYPE serial;");
        }

Exemple #2

        public override void CanCreateAutoIncrementColumnWithDefaultSchema()
        {
            var expression = GeneratorTestHelper.GetAlterColumnAddAutoIncrementExpression();

            var result = Generator.Generate(expression);

            result.ShouldBe(string.Empty);
        }

Exemple #3

        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");
        }

Exemple #4

        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)");
        }

Exemple #5

        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);");
        }

Exemple #6

        public override void CanCreateAutoIncrementColumn()
        {
            var expression = GeneratorTestHelper.GetAlterColumnAddAutoIncrementExpression();

            var sql = _generator.Generate(expression);

            sql.ShouldBe("ALTER TABLE [TestTable1] ALTER COLUMN [TestColumn1] COUNTER NOT NULL");
        }

Exemple #7

Fichier : SqlAnywhere16ColumnTests.cs Projet : jzabroski/fluentmigrator

        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");
        }

Exemple #8

Fichier : OracleColumnTests.cs Projet : MihailsKuzmins/fluentmigrator

        public override void CanCreateAutoIncrementColumnWithCustomSchema()
        {
            var expression = GeneratorTestHelper.GetAlterColumnAddAutoIncrementExpression();

            expression.SchemaName = "TestSchema";

            Assert.Throws <DatabaseOperationNotSupportedException>(() => Generator.Generate(expression));
        }

Exemple #9

Fichier : MySqlAlterTableTestscs.cs Projet : ibebbs/fluentmigrator

        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;");
        }

Exemple #10

Fichier : Oracle12CColumnTests.cs Projet : yelps/fluentmigrator

        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 ");
        }

Exemple #11

        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)");
        }

Exemple #12

        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 ");
        }

Exemple #13

        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;");
        }

Exemple #14

Fichier : JetColumnTests.cs Projet : zhuthree/fluentmigrator

        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");
        }

Exemple #15

Fichier : HanaColumnTests.cs Projet : yuripallada/fluentmigrator

        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)");
        }

Exemple #16

        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)");
        }