本文整理汇总了C#中FluentMigrator.Tests.Helpers.FirebirdTestTable类的典型用法代码示例。如果您正苦于以下问题：C# FirebirdTestTable类的具体用法？C# FirebirdTestTable怎么用？C# FirebirdTestTable使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
FirebirdTestTable类属于FluentMigrator.Tests.Helpers命名空间，在下文中一共展示了FirebirdTestTable类的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的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();
}示例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);
}
}
}示例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();
}
}示例4: CallingTableExistsReturnsTrueIfTableExists
public override void CallingTableExistsReturnsTrueIfTableExists()
{
using (var table = new FirebirdTestTable(Processor, null, "id int"))
Processor.TableExists(null, table.Name).ShouldBeTrue();
}示例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();
}
}示例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();
}
}示例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);
}
}
}示例8: CallingConstraintExistsReturnsFalseIfConstraintDoesNotExistWithSchema
public override void CallingConstraintExistsReturnsFalseIfConstraintDoesNotExistWithSchema()
{
using (var table = new FirebirdTestTable(Processor, "TestSchema", "id int"))
Processor.ConstraintExists("TestSchema", table.Name, "DoesNotExist").ShouldBeFalse();
}示例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();
}示例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();
}
}示例11: CallingIndexExistsReturnsFalseIfIndexDoesNotExistWithSchema
public void CallingIndexExistsReturnsFalseIfIndexDoesNotExistWithSchema()
{
using (var table = new FirebirdTestTable(Processor, "TestSchema", "id int"))
Processor.IndexExists("TestSchema", table.Name, "DoesNotExist").ShouldBeFalse();
}示例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();
}示例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();
}示例14: CallingColumnExistsReturnsTrueIfColumnExistsWithSchema
public void CallingColumnExistsReturnsTrueIfColumnExistsWithSchema()
{
using (var table = new FirebirdTestTable(Processor, "TestSchema", "id int"))
Processor.ColumnExists("TestSchema", table.Name, "ID").ShouldBeTrue();
}示例15: CallingIndexExistsReturnsFalseIfIndexDoesNotExist
public override void CallingIndexExistsReturnsFalseIfIndexDoesNotExist()
{
using (var table = new FirebirdTestTable(Processor, null, "id int"))
Processor.IndexExists(null, table.Name, "DoesNotExist").ShouldBeFalse();
}