本文整理汇总了C#中FluentMigrator.Tests.Helpers.PostgresTestTable类的典型用法代码示例。如果您正苦于以下问题:C# PostgresTestTable类的具体用法?C# PostgresTestTable怎么用?C# PostgresTestTable使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
PostgresTestTable类属于FluentMigrator.Tests.Helpers命名空间,在下文中一共展示了PostgresTestTable类的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: CallingDefaultValueExistsCanAcceptSchemaNameWithSingleQuote
public void CallingDefaultValueExistsCanAcceptSchemaNameWithSingleQuote()
{
using (var table = new PostgresTestTable(Processor, "test'schema", "id int"))
{
table.WithDefaultValueOn("id");
Processor.DefaultValueExists("test'schema", table.Name, "id", 1).ShouldBeTrue();
}
}
示例2: CallingIndexExistsCanAcceptTableNameWithSingleQuote
public override void CallingIndexExistsCanAcceptTableNameWithSingleQuote()
{
using (var table = new PostgresTestTable("Test'Table", Processor, null, "id int"))
{
var idxName = string.Format("\"idx_{0}\"", Quoter.UnQuote(table.Name));
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.IndexExists(null, table.Name, idxName).ShouldBeTrue();
}
}
示例3: CanReadData
public void CanReadData()
{
using (var table = new PostgresTestTable(Processor, null, "id int"))
{
AddTestData(table);
DataSet ds = Processor.Read("SELECT * FROM {0}", table.Name);
ds.ShouldNotBeNull();
ds.Tables.Count.ShouldBe(1);
ds.Tables[0].Rows.Count.ShouldBe(3);
ds.Tables[0].Rows[2][0].ShouldBe(2);
}
}
示例4: CallingIndexExistsReturnsTrueIfIndexExistsWithSchema
public void CallingIndexExistsReturnsTrueIfIndexExistsWithSchema()
{
using (var table = new PostgresTestTable(Processor, "TestSchema", "id int"))
{
var idxName = string.Format("\"idx_{0}\"", quoter.UnQuote(table.Name));
var cmd = table.Connection.CreateCommand();
cmd.Transaction = table.Transaction;
cmd.CommandText = string.Format("CREATE INDEX {0} ON {1} (id)", idxName, table.NameWithSchema);
cmd.ExecuteNonQuery();
Processor.IndexExists("TestSchema", table.Name, idxName).ShouldBeTrue();
}
}
示例5: CallingColumnExistsCanAcceptTableNameWithSingleQuote
public override void CallingColumnExistsCanAcceptTableNameWithSingleQuote()
{
using (var table = new PostgresTestTable("Test'Table", Processor, null, "id int"))
Processor.ColumnExists(null, table.Name, "id").ShouldBeTrue();
}
示例6: CallingTableExistsReturnsFalseIfTableExistsInDifferentSchema
public void CallingTableExistsReturnsFalseIfTableExistsInDifferentSchema()
{
using (var table = new PostgresTestTable(Processor, "TestSchema1", "id int"))
Processor.TableExists("TestSchema2", table.Name).ShouldBeFalse();
}
示例7: CanReadTableDataWithSchema
public void CanReadTableDataWithSchema()
{
using (var table = new PostgresTestTable(Processor, "TestSchema", "id int"))
{
AddTestData(table);
DataSet ds = Processor.ReadTableData("TestSchema", table.Name);
ds.ShouldNotBeNull();
ds.Tables.Count.ShouldBe(1);
ds.Tables[0].Rows.Count.ShouldBe(3);
ds.Tables[0].Rows[2][0].ShouldBe(2);
}
}
示例8: CallingColumnExistsReturnsFalseIfColumnDoesNotExistWithSchema
public void CallingColumnExistsReturnsFalseIfColumnDoesNotExistWithSchema()
{
using (var table = new PostgresTestTable(Processor, "TestSchema", "id int"))
Processor.ColumnExists("TestSchema", table.Name, "DoesNotExist").ShouldBeFalse();
}
示例9: CallingColumnExistsCanAcceptColumnNameWithSingleQuote
public void CallingColumnExistsCanAcceptColumnNameWithSingleQuote()
{
var columnNameWithSingleQuote = quoter.Quote("i'd");
using (var table = new PostgresTestTable(Processor, null, string.Format("{0} int", columnNameWithSingleQuote)))
Processor.ColumnExists(null, table.Name, "i'd").ShouldBeTrue();
}
示例10: CallingTableExistsReturnsTrueIfTableExists
public void CallingTableExistsReturnsTrueIfTableExists()
{
using (var table = new PostgresTestTable(Processor, null, "id int"))
Processor.TableExists(null, table.Name).ShouldBeTrue();
}
示例11: CanReadTableData
public void CanReadTableData()
{
using (var table = new PostgresTestTable(Processor, null, "id int"))
{
AddTestData(table);
DataSet ds = ((DataSetContainer)Processor.ReadTableData(null, 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);
}
}
示例12: CanReadDataWithSchema
public void CanReadDataWithSchema()
{
using (var table = new PostgresTestTable(Processor, "TestSchema", "id int"))
{
AddTestData(table);
DataSet ds = ((DataSetContainer)Processor.Read("SELECT * FROM {0}", table.NameWithSchema)).DataSet;
ds.ShouldNotBeNull();
ds.Tables.Count.ShouldBe(1);
ds.Tables[0].Rows.Count.ShouldBe(3);
ds.Tables[0].Rows[2][0].ShouldBe(2);
}
}
示例13: CallingIndexExistsReturnsFalseIfIndexDoesNotExistWithSchema
public override void CallingIndexExistsReturnsFalseIfIndexDoesNotExistWithSchema()
{
using (var table = new PostgresTestTable(Processor, "TestSchema", "id int"))
Processor.IndexExists("TestSchema", table.Name, "DoesNotExist").ShouldBeFalse();
}
示例14: CallingColumnExistsReturnsTrueIfColumnExistsWithSchema
public override void CallingColumnExistsReturnsTrueIfColumnExistsWithSchema()
{
using (var table = new PostgresTestTable(Processor, "TestSchema", "id int"))
Processor.ColumnExists("TestSchema", table.Name, "id").ShouldBeTrue();
}
示例15: CallingTableExistsCanAcceptSchemaNameWithSingleQuote
public void CallingTableExistsCanAcceptSchemaNameWithSingleQuote()
{
using (var table = new PostgresTestTable(Processor, "Test'Schema", "id int"))
Processor.TableExists("Test'Schema", table.Name).ShouldBeTrue();
}