public void SetUp()
 {
     _mssql    = new DbProtocol(DatabaseType.MicrosoftSQL, @".\koske14", "sa", "maun", "IQTools_KeHMIS");
     _extractA = new DbExtract {
         ExtractSql = @"select [Id],[shr],[date_created],[status],[status_date],[uuid] FROM psmart_store", Emr = "IQCare"
     };
     _mysql    = new DbProtocol(DatabaseType.MySQL, @"localhost", "root", "test", "openmrs");
     _extractB = new DbExtract {
         ExtractSql = @"select id,shr,date_created,status,status_date,uuid FROM psmart_store", Emr = "KenyaEMR"
     };
     _psmartSourceReader = new PsmartSourceReader();
 }
        public PsmartExtractService(IPsmartSourceReader psmartSourceReader, IPsmartStageRepository psmartStageRepository, IExtractHistoryRepository extractHistoryRepository)
        {
            _psmartSourceReader       = psmartSourceReader;
            _psmartStageRepository    = psmartStageRepository;
            _extractHistoryRepository = extractHistoryRepository;

            var config = new MapperConfiguration(cfg => {
                cfg.CreateMissingTypeMaps = false;
                cfg.AllowNullCollections  = true;
                cfg.CreateMap <PsmartSource, PsmartStage>();
            });

            _mapper = new Mapper(config);
        }