public void Test_QryAccount_POCO_Context_and_Reader() // assumes that 10 records exist with extra info data
{
QryAccountContext context = new QryAccountContext();
Options opt = OdbcOptions.GetOptions("DSN=LOCALDELTATEST");
context.init(opt);
for (int i = 0; i < 10; i++)
{
QryAccount tmp = context._Records.Skip(i).FirstOrDefault();
Assert.IsFalse(0 == tmp.AUnique);
Assert.AreNotEqual(string.Empty, tmp.BankInfo.Trim());
}
}
private static IEnumerable <QryAccount> GetXRefFromSupplierRecords(IConfiguration config)
{
// A: Get XRef from Account for AUnique,BankInfo pairs
QryAccountContext context = new QryAccountContext();
Options opt = OdbcOptions.GetOptions(config["System5DSN"]);
context.init(opt);
Func <QryAccount, QryAccount> clean = (acct) =>
{
acct.AName = acct.AName.TrimEnd();
acct.BankInfo = acct.BankInfo.TrimEnd();
return(acct);
};
IEnumerable <QryAccount> records = context._Records.Select(r => clean(r));
return(records);
}
public void IntegrationTest_Get_XRef_from_Supplier_Account_For_Aunique_BankInfo_Pairs() // convert to unit test
{
// A: Get XRef from Account for AUnique,BankInfo pairs
QryAccountContext context = new QryAccountContext();
Options opt = OdbcOptions.GetOptions("DSN=LOCALDELTATEST");
context.init(opt);
Func <QryAccount, QryAccount> clean = (acct) =>
{
acct.AName = acct.AName.TrimEnd();
acct.BankInfo = acct.BankInfo.TrimEnd();
return(acct);
};
IEnumerable <QryAccount> records = context._Records.Select(r => clean(r));
for (int i = 0; i < 10; i++)
{
QryAccount tmp = context._Records.Skip(i).FirstOrDefault();
Assert.IsFalse(0 == tmp.AUnique);
Assert.AreNotEqual(string.Empty, tmp.BankInfo.TrimEnd());
}
}
