• 设为首页
  • 点击收藏
  • 手机版
    手机扫一扫访问
    迪恩网络手机版
  • 关注官方公众号
    微信扫一扫关注
    迪恩网络公众号

C# Helpers.FirebirdTestTable类代码示例

原作者: [db:作者] 来自: [db:来源] 收藏 邀请

本文整理汇总了C#中FluentMigrator.Tests.Helpers.FirebirdTestTable的典型用法代码示例。如果您正苦于以下问题:C# FirebirdTestTable类的具体用法?C# FirebirdTestTable怎么用?C# FirebirdTestTable使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。



FirebirdTestTable类属于FluentMigrator.Tests.Helpers命名空间,在下文中一共展示了FirebirdTestTable类的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的C#代码示例。

示例1: AddTestData

        private void AddTestData(FirebirdTestTable table)
        {
            for (int i = 0; i < 3; i++)
            {
                using (var cmd = table.Connection.CreateCommand())
                {
                    cmd.Transaction = table.Transaction;
                    cmd.CommandText = string.Format("INSERT INTO {0} (id) VALUES ({1})", Quoter.QuoteTableName(table.Name), i);
                    cmd.ExecuteNonQuery();
                }
            }

            Processor.AutoCommit();
        }
开发者ID:BarsBarsovich,项目名称:fluentmigrator,代码行数:14,代码来源:FirebirdProcessorTests.cs


示例2: CanReadTableData

        public void CanReadTableData()
        {
            using (var table = new FirebirdTestTable(Processor, null, "id int"))
            {
                Processor.CheckTable(table.Name);
                AddTestData(table);

                using (DataSet ds = Processor.ReadTableData(null, table.Name))
                {
                    ds.ShouldNotBeNull();
                    ds.Tables.Count.ShouldBe(1);
                    ds.Tables[0].Rows.Count.ShouldBe(3);
                    ds.Tables[0].Rows[2][0].ShouldBe(2);
                }
            }
        }
开发者ID:BarsBarsovich,项目名称:fluentmigrator,代码行数:16,代码来源:FirebirdProcessorTests.cs


示例3: CallingIndexExistsCanAcceptTableNameWithSingleQuote

        public override void CallingIndexExistsCanAcceptTableNameWithSingleQuote()
        {
            using (var table = new FirebirdTestTable("\"Test'Table\"", Processor, null, "id int"))
            {
                Processor.CheckTable(table.Name);
                Processor.LockTable(table.Name);
                var idxName = "\"idx_Test'Table\"";

                using (var cmd = table.Connection.CreateCommand())
                {
                    cmd.Transaction = table.Transaction;
                    cmd.CommandText = string.Format("CREATE INDEX {0} ON {1} (id)", idxName, table.Name);
                    cmd.ExecuteNonQuery();
                }

                Processor.AutoCommit();

                Processor.IndexExists(null, table.Name, idxName).ShouldBeTrue();
            }
        }
开发者ID:SaltyDH,项目名称:fluentmigrator,代码行数:20,代码来源:FirebirdIndexTests.cs


示例4: CallingTableExistsReturnsTrueIfTableExists

 public override void CallingTableExistsReturnsTrueIfTableExists()
 {
     using (var table = new FirebirdTestTable(Processor, null, "id int"))
         Processor.TableExists(null, table.Name).ShouldBeTrue();
 }
开发者ID:SaltyDH,项目名称:fluentmigrator,代码行数:5,代码来源:FirebirdTableTests.cs


示例5: CanCreateTrigger

 public void CanCreateTrigger()
 {
     using (var table = new FirebirdTestTable(Processor, null, "id int"))
     {
         Processor.Process(Processor.CreateTriggerExpression(table.Name, "TestTrigger", true, TriggerEvent.Insert, "as begin end"));
         Processor.TriggerExists(String.Empty, table.Name, "TestTrigger").ShouldBeTrue();
     }
 }
开发者ID:dmirmilshteyn,项目名称:fluentmigrator,代码行数:8,代码来源:FirebirdProcessorTests.cs


示例6: IdentityCanDropIdentityColumn

        public void IdentityCanDropIdentityColumn()
        {
            using (var table = new FirebirdTestTable(Processor, null, "bogus int"))
            {
                Processor.Process(new CreateColumnExpression
                {
                    TableName = table.Name,
                    Column = { Name = "id", IsIdentity = true, Type = DbType.Int64 }
                });
                Processor.ColumnExists(String.Empty, table.Name, "id").ShouldBeTrue();
                Processor.SequenceExists(String.Empty, String.Format("gen_{0}_id", table.Name)).ShouldBeTrue();
                Processor.TriggerExists(String.Empty, table.Name, String.Format("gen_id_{0}_id", table.Name)).ShouldBeTrue();

                Processor.Process(new DeleteColumnExpression
                {
                    TableName = table.Name,
                    ColumnNames = { "id" }
                });
                Processor.ColumnExists(String.Empty, table.Name, "id").ShouldBeFalse();
                Processor.SequenceExists(String.Empty, String.Format("gen_{0}_id", table.Name)).ShouldBeFalse();
                Processor.TriggerExists(String.Empty, table.Name, String.Format("gen_id_{0}_id", table.Name)).ShouldBeFalse();
            }
        }
开发者ID:dmirmilshteyn,项目名称:fluentmigrator,代码行数:23,代码来源:FirebirdProcessorTests.cs


示例7: CanReadData

        public void CanReadData()
        {
            using (var table = new FirebirdTestTable(Processor, null, "id int"))
            {
                Processor.CheckTable(table.Name);
                AddTestData(table);

                using (DataSet ds = ((DataSetContainer)Processor.Read("SELECT * FROM {0}", Quoter.QuoteTableName(table.Name))).DataSet)
                {
                    ds.ShouldNotBeNull();
                    ds.Tables.Count.ShouldBe(1);
                    ds.Tables[0].Rows.Count.ShouldBe(3);
                    ds.Tables[0].Rows[2][0].ShouldBe(2);
                }
            }
        }
开发者ID:dmirmilshteyn,项目名称:fluentmigrator,代码行数:16,代码来源:FirebirdProcessorTests.cs


示例8: CallingConstraintExistsReturnsFalseIfConstraintDoesNotExistWithSchema

 public override void CallingConstraintExistsReturnsFalseIfConstraintDoesNotExistWithSchema()
 {
     using (var table = new FirebirdTestTable(Processor, "TestSchema", "id int"))
         Processor.ConstraintExists("TestSchema", table.Name, "DoesNotExist").ShouldBeFalse();
 }
开发者ID:eloekset,项目名称:fluentmigrator,代码行数:5,代码来源:FirebirdConstraintTests.cs


示例9: CallingConstraintExistsCanAcceptConstraintNameWithSingleQuote

 public override void CallingConstraintExistsCanAcceptConstraintNameWithSingleQuote()
 {
     using (var table = new FirebirdTestTable(Processor, null, "id int", string.Format("wibble int CONSTRAINT {0} CHECK(wibble > 0)", "\"c'1\"")))
         Processor.ConstraintExists(null, table.Name, "\"c'1\"").ShouldBeTrue();
 }
开发者ID:eloekset,项目名称:fluentmigrator,代码行数:5,代码来源:FirebirdConstraintTests.cs


示例10: CallingIndexExistsReturnsTrueIfIndexExistsWithSchema

        public void CallingIndexExistsReturnsTrueIfIndexExistsWithSchema()
        {
            using (var table = new FirebirdTestTable(Processor, "TestSchema", "id int"))
            {
                Processor.CheckTable(table.Name);
                Processor.LockTable(table.Name);
                var idxName = string.Format("idx_{0}", table.Name);

                using (var cmd = table.Connection.CreateCommand())
                {
                    cmd.Transaction = table.Transaction;
                    cmd.CommandText = string.Format("CREATE INDEX {0} ON {1} (id)", quoter.QuoteIndexName(idxName), quoter.QuoteTableName(table.Name));
                    cmd.ExecuteNonQuery();
                }

                Processor.AutoCommit();

                Processor.IndexExists("TestSchema", table.Name, idxName).ShouldBeTrue();
            }
        }
开发者ID:ibebbs,项目名称:fluentmigrator,代码行数:20,代码来源:FirebirdProcessorTests.cs


示例11: CallingIndexExistsReturnsFalseIfIndexDoesNotExistWithSchema

 public void CallingIndexExistsReturnsFalseIfIndexDoesNotExistWithSchema()
 {
     using (var table = new FirebirdTestTable(Processor, "TestSchema", "id int"))
         Processor.IndexExists("TestSchema", table.Name, "DoesNotExist").ShouldBeFalse();
 }
开发者ID:ibebbs,项目名称:fluentmigrator,代码行数:5,代码来源:FirebirdProcessorTests.cs


示例12: CallingContraintExistsReturnsTrueIfConstraintExists

 public void CallingContraintExistsReturnsTrueIfConstraintExists()
 {
     using (var table = new FirebirdTestTable(Processor, null, "id int", "wibble int CONSTRAINT c1 CHECK(wibble > 0)"))
         Processor.ConstraintExists(null, table.Name, "C1").ShouldBeTrue();
 }
开发者ID:ibebbs,项目名称:fluentmigrator,代码行数:5,代码来源:FirebirdProcessorTests.cs


示例13: CallingConstraintExistsCanAcceptTableNameWithSingleQuote

 public void CallingConstraintExistsCanAcceptTableNameWithSingleQuote()
 {
     using (var table = new FirebirdTestTable("TestSchema", "TestSingle'Quote", Processor, "id int", "wibble int CONSTRAINT c1 CHECK(wibble > 0)"))
         Processor.ConstraintExists("TestSchema", table.Name, "C1").ShouldBeTrue();
 }
开发者ID:ibebbs,项目名称:fluentmigrator,代码行数:5,代码来源:FirebirdProcessorTests.cs


示例14: CallingColumnExistsReturnsTrueIfColumnExistsWithSchema

 public void CallingColumnExistsReturnsTrueIfColumnExistsWithSchema()
 {
     using (var table = new FirebirdTestTable(Processor, "TestSchema", "id int"))
         Processor.ColumnExists("TestSchema", table.Name, "ID").ShouldBeTrue();
 }
开发者ID:ibebbs,项目名称:fluentmigrator,代码行数:5,代码来源:FirebirdProcessorTests.cs


示例15: CallingIndexExistsReturnsFalseIfIndexDoesNotExist

 public override void CallingIndexExistsReturnsFalseIfIndexDoesNotExist()
 {
     using (var table = new FirebirdTestTable(Processor, null, "id int"))
         Processor.IndexExists(null, table.Name, "DoesNotExist").ShouldBeFalse();
 }
开发者ID:SaltyDH,项目名称:fluentmigrator,代码行数:5,代码来源:FirebirdIndexTests.cs


示例16: CallingColumnExistsReturnsFalseIfColumnDoesNotExist

 public void CallingColumnExistsReturnsFalseIfColumnDoesNotExist()
 {
     using (var table = new FirebirdTestTable(Processor, null, "id int"))
         Processor.ColumnExists(null, table.Name, "DoesNotExist").ShouldBeFalse();
 }
开发者ID:ibebbs,项目名称:fluentmigrator,代码行数:5,代码来源:FirebirdProcessorTests.cs


示例17: CallingColumnExistsReturnsTrueIfColumnExists

 public void CallingColumnExistsReturnsTrueIfColumnExists()
 {
     using (var table = new FirebirdTestTable(Processor, null, "id int"))
         Processor.ColumnExists(null, table.Name, "ID").ShouldBeTrue();
 }
开发者ID:ibebbs,项目名称:fluentmigrator,代码行数:5,代码来源:FirebirdProcessorTests.cs


示例18: CallingTableExistsCanAcceptSchemaNameWithSingleQuote

 public void CallingTableExistsCanAcceptSchemaNameWithSingleQuote()
 {
     using (var table = new FirebirdTestTable(Processor, "Test'Schema", "id int"))
         Processor.TableExists("Test'Schema", table.Name).ShouldBeTrue();
 }
开发者ID:ibebbs,项目名称:fluentmigrator,代码行数:5,代码来源:FirebirdProcessorTests.cs


示例19: CallingConstraintExistsCanAcceptTableNameWithSingleQuote

 public override void CallingConstraintExistsCanAcceptTableNameWithSingleQuote()
 {
     using (var table = new FirebirdTestTable("\"Test'Table\"", Processor, null, "id int", "wibble int CONSTRAINT c1 CHECK(wibble > 0)"))
         Processor.ConstraintExists(null, table.Name, "C1").ShouldBeTrue();
 }
开发者ID:eloekset,项目名称:fluentmigrator,代码行数:5,代码来源:FirebirdConstraintTests.cs


示例20: CallingTableExistsCanAcceptTableNameWithSingleQuote

 public void CallingTableExistsCanAcceptTableNameWithSingleQuote()
 {
     using (var table = new FirebirdTestTable(null, "TestSingle'Quote", Processor, "id int"))
         Processor.TableExists(null, table.Name).ShouldBeTrue();
 }
开发者ID:ibebbs,项目名称:fluentmigrator,代码行数:5,代码来源:FirebirdProcessorTests.cs



注:本文中的FluentMigrator.Tests.Helpers.FirebirdTestTable类示例由纯净天空整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。


鲜花

握手

雷人

路过

鸡蛋
该文章已有0人参与评论

请发表评论

全部评论

专题导读
上一篇:
C# Helpers.PostgresTestTable类代码示例发布时间:2022-05-26
下一篇:
C# SqlServer.SqlServerProcessor类代码示例发布时间:2022-05-26
热门推荐
阅读排行榜

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服(服务时间 9:00~18:00)

在线QQ客服
地址:深圳市南山区西丽大学城创智工业园
电邮:jeky_zhao#qq.com
移动电话:139-2527-9053

Powered by 互联科技 X3.4© 2001-2213 极客世界.|Sitemap