public void should_Execute_Reader(string name)
{
var extract = _extracts.First(x => x.Name.IsSameAs(name));
var reader = _reader.ExecuteReader(_protocol, extract).Result;
Assert.NotNull(reader);
reader.Read();
Assert.NotNull(reader[0]);
reader.Close();
}
public void should_Execute_Reader_MySql()
{
var extract = TestInitializer.KenyaEmr.Extracts.First(x => x.DocketId.IsSameAs("CBS"));
_reader = TestInitializer.ServiceProviderMysql.GetService <IMasterPatientIndexReader>();
var reader = _reader.ExecuteReader(_kenyaEmrDb, extract).Result as MySqlDataReader;
Assert.NotNull(reader);
Assert.True(reader.HasRows);
reader.Close();
}
public async Task <int> Extract(DbExtract extract, DbProtocol dbProtocol)
{
var mapper = dbProtocol.SupportsDifferential ? ExtractDiffMapper.Instance : ExtractMapper.Instance;
int batch = 500;
DomainEvents.Dispatch(new CbsNotification(new ExtractProgress(nameof(MasterPatientIndex), "extracting...")));
//DomainEvents.Dispatch(new CbsStatusNotification(extract.Id,ExtractStatus.Loading));
var list = new List <TempMasterPatientIndex>();
int count = 0;
int totalCount = 0;
using (var rdr = await _reader.ExecuteReader(dbProtocol, extract))
{
while (rdr.Read())
{
totalCount++;
count++;
// AutoMapper profiles
var extractRecord = mapper.Map <IDataRecord, TempMasterPatientIndex>(rdr);
extractRecord.Id = LiveGuid.NewGuid();
if (!string.IsNullOrWhiteSpace(extractRecord.sxdmPKValueDoB))
{
list.Add(extractRecord);
}
if (count == batch)
{
// TODO: batch and save
_extractRepository.BatchInsert(list);
try
{
DomainEvents.Dispatch(new CbsNotification(new ExtractProgress(nameof(MasterPatientIndex), "extracting...", totalCount, count, 0, 0, 0)));
}
catch (Exception e)
{
Log.Error(e, "Notification error");
}
count = 0;
list = new List <TempMasterPatientIndex>();
}
// TODO: Notify progress...
}
if (count > 0)
{
_extractRepository.BatchInsert(list);
}
_extractRepository.CloseConnection();
}
try
{
DomainEvents.Dispatch(new CbsNotification(new ExtractProgress(nameof(MasterPatientIndex), "extracted", totalCount, 0, 0, 0, 0)));
DomainEvents.Dispatch(new CbsStatusNotification(extract.Id, ExtractStatus.Found, totalCount));
DomainEvents.Dispatch(new CbsStatusNotification(extract.Id, ExtractStatus.Loaded, totalCount));
}
catch (Exception e)
{
Log.Error(e, "Notification error");
}
return(totalCount);
}
