Exemplos de GeneratorTestHelper.GetCreateUniqueMultiColumnIndexExpression em C# (CSharp)

Exemplo n.º 1

        public void CanCreatUniqueMultiColumnIndexWithDefaultSchema()
        {
            var expression = GeneratorTestHelper.GetCreateUniqueMultiColumnIndexExpression();
            var sql        = generator.Generate(expression);

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

Exemplo n.º 2

        public override void CanCreateMultiColumnUniqueIndexWithDefaultSchema()
        {
            var expression = GeneratorTestHelper.GetCreateUniqueMultiColumnIndexExpression();

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

Exemplo n.º 3

Arquivo: OracleCreateTableTests.cs Projeto: yanpearson/fluentmigrator

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

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

Exemplo n.º 4

Arquivo: SqlServer2000CreateTableTests.cs Projeto: cdownie/fluentmigrator

        public override void CanCreateMultiColumnUniqueIndex()
        {
            var expression = GeneratorTestHelper.GetCreateUniqueMultiColumnIndexExpression();
            var sql        = generator.Generate(expression);

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

Exemplo n.º 5

Arquivo: SQLiteCreateTableTests.cs Projeto: robinvarg/fluentmigrator

        public override void CanCreateMultiColumnUniqueIndex()
        {
            var expression = GeneratorTestHelper.GetCreateUniqueMultiColumnIndexExpression();

            var sql = _generator.Generate(expression);

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

Exemplo n.º 6

Arquivo: RedshiftIndexTests.cs Projeto: zhuthree/fluentmigrator

        public override void CanCreateMultiColumnUniqueIndexWithDefaultSchema()
        {
            var expression = GeneratorTestHelper.GetCreateUniqueMultiColumnIndexExpression();

            var result = _generator.Generate(expression);

            result.ShouldBe(string.Empty);
        }

Exemplo n.º 7

Arquivo: MySqlCreateTableTests.cs Projeto: ibebbs/fluentmigrator

        public override void CanCreateMultiColumnUniqueIndex()
        {
            var expression = GeneratorTestHelper.GetCreateUniqueMultiColumnIndexExpression();

            var sql = _generator.Generate(expression);

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

Exemplo n.º 8

Arquivo: Db2IndexTests.cs Projeto: zhuthree/fluentmigrator

        public override void CanCreateMultiColumnUniqueIndexWithDefaultSchema()
        {
            var expression = GeneratorTestHelper.GetCreateUniqueMultiColumnIndexExpression();

            var result = Generator.Generate(expression);

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

Exemplo n.º 9

Arquivo: SQLiteCreateTableTests.cs Projeto: PrinceLunga/FluentMigrator

        public override void CanCreateMultiColumnUniqueIndex()
        {
            var expression = GeneratorTestHelper.GetCreateUniqueMultiColumnIndexExpression();

            var sql = _generator.Generate(expression);

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

Exemplo n.º 10

Arquivo: SqlServer2000CreateTableTests.cs Projeto: cdownie/fluentmigrator

        public void CanCreatClusteredUniqueMultiColumnIndex()
        {
            var expression = GeneratorTestHelper.GetCreateUniqueMultiColumnIndexExpression();

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

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

Exemplo n.º 11

Arquivo: PostgresIndexTests.cs Projeto: RobertWilliams2000/fluentmigrator

        public void CanCreateMultiColumnUniqueIndexWithOneNonDistinctNulls()
        {
            var expression = GeneratorTestHelper.GetCreateUniqueMultiColumnIndexExpression();

            expression.Index.Columns.First().SetAdditionalFeature(PostgresExtensions.IndexColumnNullsDistinct, false);

            var result = Generator.Generate(expression);

            result.ShouldBe("CREATE UNIQUE INDEX \"TestIndex\" ON \"public\".\"TestTable1\" (\"TestColumn1\" ASC,\"TestColumn2\" DESC) WHERE \"TestColumn1\" IS NOT NULL;");
        }

Exemplo n.º 12

Arquivo: SqlServer2005ClusteredTests.cs Projeto: AeonLucid/RadarrCore.FluentMigrator

        public override void CanCreateUniqueClusteredMultiColumnIndexWithDefaultSchema()
        {
            var expression = GeneratorTestHelper.GetCreateUniqueMultiColumnIndexExpression();

            expression.Index.IsClustered = true;

            var result = Generator.Generate(expression);

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

Exemplo n.º 13

        public void CanCreatMultiColumnUniqueClusteredIndexTreatedAsNonClustered()
        {
            var expression = GeneratorTestHelper.GetCreateUniqueMultiColumnIndexExpression();

            expression.Index.IsClustered = true;

            var result = Generator.Generate(expression);

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

Exemplo n.º 14

        public override void CanCreateMultiColumnUniqueIndexWithCustomSchema()
        {
            var expression = GeneratorTestHelper.GetCreateUniqueMultiColumnIndexExpression();

            expression.Index.SchemaName = "TestSchema";

            var result = Generator.Generate(expression);

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

Exemplo n.º 15

Arquivo: SqlServer2008IndexTests.cs Projeto: whilelie/fluentmigrator

        public void CanCreateMultiColumnUniqueIndexWithOneNonDistinctNulls()
        {
            var expression = GeneratorTestHelper.GetCreateUniqueMultiColumnIndexExpression();

            expression.Index.Columns.First().SetAdditionalFeature(SqlServerExtensions.IndexColumnNullsDistinct, false);

            var result = _generator.Generate(expression);

            result.ShouldBe("CREATE UNIQUE INDEX [TestIndex] ON [dbo].[TestTable1] ([TestColumn1] ASC, [TestColumn2] DESC) WHERE [TestColumn1] IS NOT NULL");
        }

Exemplo n.º 16

        public override void CanCreateMultiColumnUniqueIndexWithCustomSchema()
        {
            var expression = GeneratorTestHelper.GetCreateUniqueMultiColumnIndexExpression();

            expression.Index.SchemaName = "TestSchema";

            var result = Generator.Generate(expression);

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

Exemplo n.º 17

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

            var expression = GeneratorTestHelper.GetCreateUniqueMultiColumnIndexExpression();

            expression.Index.SchemaName = "TestSchema";

            var result = Generator.Generate(expression);

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