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