C# (CSharp) GeneratorTestHelper.GetCreateMultiColumnCreateIndexExpression示例

示例#1

        public void CanCreateMultiColumnIndexWithDefaultSchema()
        {
            var expression = GeneratorTestHelper.GetCreateMultiColumnCreateIndexExpression();
            var sql        = generator.Generate(expression);

            sql.ShouldBe("CREATE INDEX [TestIndex] ON [dbo].[TestTable1] ([TestColumn1] ASC, [TestColumn2] DESC)");
        }

示例#2

文件： SQLiteCreateTableTests.cs 项目： timscott/fluentmigrator

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

            sql.ShouldBe("CREATE INDEX 'TestIndex' ON 'TestTable1' ('TestColumn1' ASC, 'TestColumn2' DESC)");
        }

示例#3

文件： SqlServer2000CreateTableTests.cs 项目： cdownie/fluentmigrator

        public override void CanCreateMultiColumnIndex()
        {
            var expression = GeneratorTestHelper.GetCreateMultiColumnCreateIndexExpression();
            var sql        = generator.Generate(expression);

            sql.ShouldBe("CREATE INDEX [TestIndex] ON [TestTable1] ([TestColumn1] ASC, [TestColumn2] DESC)");
        }

示例#4

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

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

            sql.ShouldBe("CREATE INDEX TestIndex ON TestTable1 (TestColumn1 ASC, TestColumn2 DESC)");
        }

示例#5

        public override void CanCreateMultiColumnIndexWithDefaultSchema()
        {
            var expression = GeneratorTestHelper.GetCreateMultiColumnCreateIndexExpression();

            var result = Generator.Generate(expression);
            result.ShouldBe("CREATE INDEX \"TestIndex\" ON \"public\".\"TestTable1\" (\"TestColumn1\" ASC,\"TestColumn2\" DESC);");
        }

示例#6

文件： RedshiftIndexTests.cs 项目： zhuthree/fluentmigrator

        public override void CanCreateMultiColumnIndexWithDefaultSchema()
        {
            var expression = GeneratorTestHelper.GetCreateMultiColumnCreateIndexExpression();

            var result = _generator.Generate(expression);

            result.ShouldBe(string.Empty);
        }

示例#7

文件： MySqlIndexTests.cs 项目： AeonLucid/RadarrCore.FluentMigrator

        public override void CanCreateMultiColumnIndexWithDefaultSchema()
        {
            var expression = GeneratorTestHelper.GetCreateMultiColumnCreateIndexExpression();

            var result = Generator.Generate(expression);

            result.ShouldBe("CREATE INDEX `TestIndex` ON `TestTable1` (`TestColumn1` ASC, `TestColumn2` DESC)");
        }

示例#8

文件： MySqlCreateTableTests.cs 项目： timscott/fluentmigrator

        public override void CanCreateMultiColumnIndex()
        {
            var expression = GeneratorTestHelper.GetCreateMultiColumnCreateIndexExpression();

            var sql = generator.Generate(expression);

            sql.ShouldBe("CREATE INDEX `TestIndex` ON `TestTable1` (`TestColumn1` ASC, `TestColumn2` DESC)");
        }

示例#9

文件： FirebirdIndexTests.cs 项目： yuripallada/fluentmigrator

        public override void CanCreateMultiColumnIndexWithDefaultSchema()
        {
            var expression = GeneratorTestHelper.GetCreateMultiColumnCreateIndexExpression();

            var result = Generator.Generate(expression);

            result.ShouldBe("CREATE ASC INDEX TestIndex ON TestTable1 (TestColumn1, TestColumn2)");
        }

示例#10

文件： SqlServer2000CreateTableTests.cs 项目： cdownie/fluentmigrator

        public void CanCreateClusteredMultiColumnIndex()
        {
            var expression = GeneratorTestHelper.GetCreateMultiColumnCreateIndexExpression();

            expression.Index.IsClustered = true;
            var sql = generator.Generate(expression);

            sql.ShouldBe("CREATE CLUSTERED INDEX [TestIndex] ON [TestTable1] ([TestColumn1] ASC, [TestColumn2] DESC)");
        }

示例#11

        public void CanCreateMultiColumnIndexWithCustomSchema()
        {
            var expression = GeneratorTestHelper.GetCreateMultiColumnCreateIndexExpression();

            expression.Index.SchemaName = "TestSchema";
            var sql = generator.Generate(expression);

            sql.ShouldBe("CREATE INDEX [TestIndex] ON [TestSchema].[TestTable1] ([TestColumn1] ASC, [TestColumn2] DESC)");
        }

示例#12

        public void CanCreateMultiColumnClusteredIndexTreatedAsNonClustered()
        {
            var expression = GeneratorTestHelper.GetCreateMultiColumnCreateIndexExpression();

            expression.Index.IsClustered = true;

            var result = Generator.Generate(expression);

            result.ShouldBe("CREATE INDEX [TestIndex] ON [TestTable1] ([TestColumn1] ASC, [TestColumn2] DESC)");
        }

示例#13

文件： SQLiteIndexTests.cs 项目： yuripallada/fluentmigrator

        public override void CanCreateMultiColumnIndexWithCustomSchema()
        {
            var expression = GeneratorTestHelper.GetCreateMultiColumnCreateIndexExpression();

            expression.Index.SchemaName = "TestSchema";

            var result = Generator.Generate(expression);

            result.ShouldBe("CREATE INDEX \"TestIndex\" ON \"TestTable1\" (\"TestColumn1\" ASC, \"TestColumn2\" DESC)");
        }

示例#14

文件： SqlServer2005ClusteredTests.cs 项目： AeonLucid/RadarrCore.FluentMigrator

        public override void CanCreateMultiColumnClusteredIndexWithDefaultSchema()
        {
            var expression = GeneratorTestHelper.GetCreateMultiColumnCreateIndexExpression();

            expression.Index.IsClustered = true;

            var result = Generator.Generate(expression);

            result.ShouldBe("CREATE CLUSTERED INDEX [TestIndex] ON [dbo].[TestTable1] ([TestColumn1] ASC, [TestColumn2] DESC)");
        }

示例#15

        public override void CanCreateMultiColumnIndexWithCustomSchema()
        {
            Assert.Ignore("HANA does not support schema like us know schema in hana is a database name");

            var expression = GeneratorTestHelper.GetCreateMultiColumnCreateIndexExpression();

            expression.Index.SchemaName = "TestSchema";

            var result = Generator.Generate(expression);

            result.ShouldBe("CREATE INDEX \"TestIndex\" ON \"TestSchema\".\"TestTable1\" (\"TestColumn1\" ASC,\"TestColumn2\" DESC)");
        }