public void Execute_Schema_ListStructureContainingManyElements()
{
var conn = new SqlConnection(ConnectionStringReader.GetSqlClient());
var factory = new RelationalStructureDiscoveryFactory(conn);
var cmd = factory.Instantiate(Target.Perspectives, TargetType.Object,
new IFilter[] {
});
var structs = cmd.Execute();
Assert.That(structs.Count(), Is.EqualTo(24)); //All available schemas
}
public void Execute_Schema_ListStructureContainingSixElements()
{
var conn = new SqlConnection(ConnectionStringReader.GetSqlClient());
var factory = new RelationalStructureDiscoveryFactory(conn);
var cmd = factory.Instantiate(Target.Perspectives, TargetType.Object,
new CaptionFilter[] {
});
var structs = cmd.Execute();
Assert.That(structs.Count(), Is.EqualTo(6 + 2));//6 standards + Northwind + Olympics
}
public void Execute_Routines_ListStructureContainingThreeElements()
{
var conn = new SqlConnection(ConnectionStringReader.GetSqlClient());
var factory = new RelationalStructureDiscoveryFactory(conn);
var cmd = factory.Instantiate(Target.Routines, TargetType.Object,
new [] {
new CaptionFilter(Target.Perspectives, "HumanResources")
});
var structs = cmd.Execute();
Assert.That(structs.Count(), Is.EqualTo(3));
}
public void Execute_Table_ListStructureContainingFifteenElements()
{
var conn = new SqlConnection(ConnectionStringReader.GetSqlClient());
var factory = new RelationalStructureDiscoveryFactory(conn);
var cmd = factory.Instantiate(Target.Tables, TargetType.Object,
new [] {
new CaptionFilter(Target.Perspectives, "Sales"),
});
var structs = cmd.Execute();
Assert.That(structs.Count(), Is.EqualTo(19 + 7));//Tables + Views
}
public void Execute_SchemaWithDbo_ListStructureContainingManyElements()
{
var conn = new SqlConnection(ConnectionStringReader.GetSqlClient());
var factory = new RelationalStructureDiscoveryFactory(conn);
var cmd = factory.Instantiate(Target.Perspectives, TargetType.Object,
new [] {
new OwnerFilter("dbo")
});
var structs = cmd.Execute();
Assert.That(structs.Count(), Is.EqualTo(6 + 2 + 2)); //Standards + Northwind + Olympics + tSQLt + SQLCop
}
public void Execute_RoutinesWithName_ListStructureContainingThisRoutine()
{
var conn = new SqlConnection(ConnectionStringReader.GetSqlClient());
var factory = new RelationalStructureDiscoveryFactory(conn);
var cmd = factory.Instantiate(Target.Routines, TargetType.Object,
new [] {
new CaptionFilter(Target.Perspectives, "dbo")
, new CaptionFilter(Target.Routines, "ufnGetContactInformation")
});
var structs = cmd.Execute();
Assert.That(structs.Count(), Is.EqualTo(1));
}
public void Execute_ParameterWithNameAndResult_ListStructureContainingThisParameter(bool isResult, int count)
{
var conn = new SqlConnection(ConnectionStringReader.GetSqlClient());
var factory = new RelationalStructureDiscoveryFactory(conn);
var cmd = factory.Instantiate(Target.Parameters, TargetType.Object,
new IFilter [] {
new CaptionFilter(Target.Perspectives, "HumanResources")
, new CaptionFilter(Target.Routines, "uspUpdateEmployeePersonalInfo")
, new CaptionFilter(Target.Parameters, "BirthDate")
, new IsResultFilter(isResult)
});
var structs = cmd.Execute();
Assert.That(structs.Count(), Is.EqualTo(count));
}
