C# (CSharp) GeneratorTestHelper.GetAlterTableAutoIncrementColumnExpression示例

示例#1

文件： PostgresColumnTests.cs 项目： MihailsKuzmins/fluentmigrator

        public override void CanCreateColumnWithAutoIncrementAndDefaultSchema()
        {
            var expression = GeneratorTestHelper.GetAlterTableAutoIncrementColumnExpression();

            var result = Generator.Generate(expression);

            result.ShouldBe("ALTER TABLE \"public\".\"TestTable1\" ADD \"TestColumn1\" serial NOT NULL;");
        }

示例#2

文件： SQLiteColumnTests.cs 项目： RobertWilliams2000/fluentmigrator

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

            expression.Column.IsPrimaryKey = true;

            var result = Generator.Generate(expression);

            result.ShouldBe("ALTER TABLE \"TestTable1\" ADD COLUMN \"TestColumn1\" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT");
        }

示例#3

        public override void CanCreateColumnWithAutoIncrementAndCustomSchema()
        {
            var expression = GeneratorTestHelper.GetAlterTableAutoIncrementColumnExpression();

            expression.SchemaName = "TestSchema";

            var result = Generator.Generate(expression);

            result.ShouldBe("ALTER TABLE \"TestSchema\".\"TestTable1\" ADD \"TestColumn1\" integer NOT NULL GENERATED ALWAYS AS IDENTITY;");
        }

示例#4

文件： SQLiteAlterTableTests.cs 项目： yanpearson/fluentmigrator

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

            expression.Column.IsPrimaryKey = true;

            string sql = _generator.Generate(expression);

            sql.ShouldBe("ALTER TABLE 'TestTable1' ADD COLUMN 'TestColumn1' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT");
        }