public async Task LoadAsx300Async()
{
// Load asx list.
LambdaLogger.Log($"In Load Asx300Async...\n");
var stockList = await dal.GetAll();
LambdaLogger.Log($"Found existing items {stockList.Count}, abou to remove them all.\n");
foreach (StockEntity stock in stockList)
{
await dal.Delete(stock.Code);
}
LambdaLogger.Log($"Remove all items done.\n");
LambdaLogger.Log($"About populate all stocks.\n");
string resultPath = await this.s3service.DownloadFileFromS3Async(this.S3_Bucket_Name, "asx300.csv", this.Temp_Folder + "asx300/");
var newStockList = this.LoadStockFromCSV(resultPath);
foreach (var s in newStockList)
{
await this.dal.InsertNewStock(s);
}
LambdaLogger.Log($"{newStockList.Count} new items been populated into the db.\n");
}
public async void TestDelete()
{
StockServiceDAL service = new StockServiceDAL(this.tableName);
await service.Delete("SUN");
}