C# (CSharp) GeneratorTestHelper.GetCreateColumnExpression Examples

Example #1

File: SQLiteAlterTableTests.cs Project: yanpearson/fluentmigrator

        public override void CanAddColumn()
        {
            var    expression = GeneratorTestHelper.GetCreateColumnExpression();
            string sql        = _generator.Generate(expression);

            sql.ShouldBe("ALTER TABLE 'TestTable1' ADD COLUMN 'TestColumn1' TEXT NOT NULL");
        }

Example #2

        public void CanAddColumnWithDefaultSchema()
        {
            var expression = GeneratorTestHelper.GetCreateColumnExpression();
            var sql        = generator.Generate(expression);

            sql.ShouldBe("ALTER TABLE [dbo].[TestTable1] ADD [TestColumn1] NVARCHAR(5) NOT NULL");
        }

Example #3

File: OracleAlterTableTests.cs Project: PrinceLunga/FluentMigrator

        public override void CanAddColumn()
        {
            var    expression = GeneratorTestHelper.GetCreateColumnExpression();
            string sql        = generator.Generate(expression);

            sql.ShouldBe("ALTER TABLE \"TestTable1\" ADD \"TestColumn1\" NVARCHAR2(5) NOT NULL");
        }

Example #4

        public override void CanAddColumn()
        {
            var expression = GeneratorTestHelper.GetCreateColumnExpression();
            var sql        = _generator.Generate(expression);

            sql.ShouldBe("ALTER TABLE [TestTable1] ADD [TestColumn1] NVARCHAR(5) NOT NULL");
        }

Example #5

        public override void CanCreateColumnWithDefaultSchema()
        {
            var expression = GeneratorTestHelper.GetCreateColumnExpression();

            var result = Generator.Generate(expression);

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

Example #6

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

Example #7

File: Db2ColumnTests.cs Project: whilelie/fluentmigrator

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

Example #8

        public void CanCreateColumnWithoutDescription()
        {
            var expression = GeneratorTestHelper.GetCreateColumnExpression();

            var result = Generator.Generate(expression);

            result.ShouldBe("ALTER TABLE TestTable1 ADD TestColumn1 NVARCHAR2(5) NOT NULL");
        }

Example #9

        public void CanCreateColumnWithDefaultSchema()
        {
            var expression = GeneratorTestHelper.GetCreateColumnExpression();

            var result = Generator.Generate(expression);

            result.ShouldBe("ALTER TABLE `TestTable1` ADD COLUMN `TestColumn1` NVARCHAR(5) NOT NULL");
        }

Example #10

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

Example #11

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

Example #12

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

Example #13

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

Example #14

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

Example #15

File: PostgresColumnTests.cs Project: yuripallada/fluentmigrator

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

Example #16

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

Example #17

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

Example #18

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

Example #19

File: SQLiteColumnTests.cs Project: RobertWilliams2000/fluentmigrator

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

Example #20

File: OracleColumnTests.cs Project: MihailsKuzmins/fluentmigrator

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

Example #21

File: OracleColumnTests.cs Project: MihailsKuzmins/fluentmigrator

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

Example #22

File: HanaColumnTests.cs Project: yuripallada/fluentmigrator

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