public void UpdateDatabaseWithCompanyDetailsTest() { ClearTable(); string[] columnNames = { "NASDAQ Symbol", "Security Name" }; var fileName = @"symboldirectory/otherlisted.txt"; LoadFileToDb lftdb = PrepareCompanyDetailsList(columnNames, ref fileName); columnNames = new string[] { "Symbol", "Sector", "industry", "IPOyear" }; var temppath = Path.GetTempPath(); fileName = @"symboldirectory/NYSECompanyList.csv"; var delimiter = ","; fileName = temppath + fileName; lftdb.FileName = fileName; lftdb.Columns = columnNames; lftdb.Delimiter = delimiter; var loadResult = lftdb.ParseCompanyDetailsFile(); var resultCount = lftdb.SaveRecordsToDb(_repository); Assert.IsTrue(loadResult); var testRcd = _context.CompanyDetails.FirstOrDefault(s => s.Symbol.Equals("ICE")); Assert.AreEqual(2005, testRcd.IPOyear); Assert.AreEqual("Finance", testRcd.Sector); }
public void ParseFileTest() { var fileName = @"symboldirectory/nasdaqlisted.txt"; var temppath = Path.GetTempPath(); fileName = temppath + fileName; string[] columnNames = { "Symbol", "Security Name" }; var lftdb = new LoadFileToDb(fileName, columnNames); var loadResult = lftdb.ParseSecurityListingFile(); Assert.IsTrue(loadResult); }
public void SaveRecordsToDbEmptyTableTest() { ClearTable(); string[] columnNames = { "Symbol", "Security Name" }; var fileName = @"symboldirectory/nasdaqlisted.txt"; LoadFileToDb lftdb = PrepareCompanyDetailsList(columnNames, ref fileName); var resultCount = lftdb.SaveRecordsToDb(_repository); Assert.AreEqual(resultCount, lftdb.CompanyDetails.Count); Console.WriteLine(_context.CompanyDetails.Count(r => r.IsExTrdFund == true)); }
public LoadExternalFilesToDb(StockReporterContext context, IGenericRepository <CompanyDetail, string> repository) { _context = context; _repository = repository; delimiter = "|"; isETF = false; isMutualFund = false; string[] columnNames = { }; var fileName = ""; loadFileToDb = new LoadFileToDb(fileName, columnNames); }
public void SaveOtherListedToDbEmptyTableTest() { ClearTable(); string[] columnNames = { "NASDAQ Symbol", "Security Name" }; var fileName = @"symboldirectory/otherlisted.txt"; LoadFileToDb lftdb = PrepareCompanyDetailsList(columnNames, ref fileName); var resultCount = lftdb.SaveRecordsToDb(_repository); Assert.AreEqual(resultCount, lftdb.CompanyDetails.Count); var ibmRecord = _repository.Get("IBM"); Assert.AreEqual("International Business Machines Corporation Common Stock", ibmRecord.SecurityName); }
public void SaveETFRecordsToDbEmptyTableTest() { isETF = true; ClearTable(); string[] columnNames = { "Symbol", "Name" }; var fileName = @"symboldirectory/ETFList.csv"; LoadFileToDb lftdb = PrepareCompanyDetailsList(columnNames, ref fileName, ","); var resultCount = lftdb.SaveRecordsToDb(_repository); Assert.AreEqual(resultCount, lftdb.CompanyDetails.Count); var iwoRecord = _context.CompanyDetails.FirstOrDefault(r => r.Symbol.Equals("IWO")); Assert.IsTrue(iwoRecord.IsExTrdFund); }
private LoadFileToDb PrepareCompanyDetailsList(string[] columnNames, ref string fileName, string delimiter = "|") { var temppath = Path.GetTempPath(); fileName = temppath + fileName; var lftdb = new LoadFileToDb(fileName, columnNames) { Delimiter = delimiter, IsETF = isETF, IsMutaulFund = isMutalFund }; var loadResult = lftdb.ParseSecurityListingFile(); return(lftdb); }
public void SaveMutualFundsToDbEmptyTableTest() { ClearTable(); isMutalFund = true; string[] columnNames = { "Fund Symbol", "Fund Name" }; var fileName = @"symboldirectory/mfundslist.txt"; LoadFileToDb lftdb = PrepareCompanyDetailsList(columnNames, ref fileName); lftdb.IsMutaulFund = true; var resultCount = lftdb.SaveRecordsToDb(_repository); Assert.AreEqual(resultCount, lftdb.CompanyDetails.Count); var fairxRecord = _repository.Get("FAIRX"); Assert.AreEqual("Fairholme Fd", fairxRecord.SecurityName); }