public void LoadSp_Northwind()
{
var spa = new SPLoader(Settings.Default.Northwind);
var procs = spa.GetProcedures();
Assert.IsTrue(procs.Any());
}
public void LoadSp_Adventure()
{
var spa = new SPLoader(Settings.Default.AdventureWorks);
var procs = spa.GetProcedures();
Assert.IsTrue(procs.Any());
}
public void LoadParams_individual_Adventure()
{
var spa = new SPLoader(Settings.Default.AdventureWorks);
var procs = spa.GetProcedures().ToList();
foreach (var p in procs)
{
var result = spa.GetParameters(p);
Assert.IsTrue(result != null);
};
}
public void GetParams_individual_Northwind()
{
var spa = new SPLoader(Settings.Default.Northwind);
var procs = spa.GetProcedures().ToList();
foreach(var p in procs)
{
var result = spa.GetParameters(p);
Assert.IsTrue(result != null);
};
}
public void LoadOutputStructure_Adventure()
{
var spa = new SPLoader(Settings.Default.AdventureWorks);
var proc = spa.GetProcedures().Where(λ => λ.Name == "uspGetBillOfMaterials").Single();
//spa.LoadParameters(proc);
//var cmd = new SqlCommand("uspGetBillOfMaterials");
//cmd.CommandType = System.Data.CommandType.StoredProcedure;
var paramList = new Dictionary<string, string>();
paramList.Add("@StartProductID", "893");
paramList.Add("@CheckDate", "4/18/2004");
//cmd.Parameters.Add(new SqlParameter("@StartProductID", 893));
//cmd.Parameters.Add(new SqlParameter("@CheckDate", new DateTime(2004, 4, 18)));
//spa.LoadOutputSchema(proc, paramDefs , paramValues);
//TODO: MOCK OBJECT
//Assert.IsTrue(proc.OutputData != null);
//Assert.IsTrue(proc.OutputData.FirstOrDefault() != null);
//Assert.IsTrue(proc.OutputData.First().Columns.Count() == 8);
}