public void RetrieveFromDatawarehouse()
{
var t = new BloombergDatawarehouseController(new BergController()).GetDataFromDatawarehouse(new RequestItem {
OriginalInputTicker = "0963590 VX SEDOL1"
});
t = new BloombergDatawarehouseController(new BergController()).GetDataFromDatawarehouse(new RequestItem {
OriginalInputTicker = " SZU GR Equity"
});
t = new BloombergDatawarehouseController(new BergController()).GetDataFromDatawarehouse(new RequestItem {
OriginalInputTicker = " ARL GR Equity"
});
Assert.AreEqual(true, Convert.ToBoolean(t.FOUND_CREDITRISK));
Assert.AreEqual(true, Convert.ToBoolean(t.FOUND_DESCRIPTION));
Assert.AreEqual(true, Convert.ToBoolean(t.FOUND_NNAP));
Assert.AreEqual(false, Convert.ToBoolean(t.FOUND_FIXEDINCOME));
Assert.AreEqual(false, Convert.ToBoolean(t.FOUND_NAP));
// Assert.AreEqual(true, t.TickerFoundInPerSecurityPull);
Assert.AreEqual(true, t.TickerFoundInBackOfficeFiles);
t = new BloombergDatawarehouseController(new BergController()).GetDataFromDatawarehouse(new RequestItem {
OriginalInputTicker = "n/a Equity"
});
Assert.AreEqual(false, t.TickerFoundInPerSecurityPull);
Assert.AreEqual(false, t.TickerFoundInBackOfficeFiles);
}
public void ProcessCalendarNonSettlementDateRequest()
{
Utils.DbController.ExecuteNonQuery("delete BloombergDataResult WHERE BloombergDataRequestItemID = 9999999");
var warehouse = new BloombergDatawarehouseController(new BergController());
var request = new RequestItem
{
ID = 9999999,
UserId = "Doesnt matter",
BBTicker = "Not used",
BBFieldList = "CALENDAR_NON_SETTLEMENT_DATES[CALENDAR_START_DATE,20140626,CALENDAR_END_DATE,20180814,SETTLEMENT_CALENDAR_CODE,EN]"
};
//this is the test
warehouse.ProcessDataRequests(new List <RequestItem> {
request
});
//this is retrieving result from the result queue.
var res = Utils.DbController.GetScalar <string>("SELECT c1 FROM BloombergDataResult WHERE BloombergDataRequestItemID = 9999999");
Assert.AreEqual("2014-08-25;2014-12-25;2014-12-26;2015-01-01;2015-04-03;2015-04-06;2015-05-04;2015-05-25;2015-08-31;2015-12-25;2015-12-28;2016-01-01;2016-03-25;2016-03-28;2016-05-02;2016-05-30;2016-08-29;2016-12-26;2016-12-27;2017-01-02;2017-04-14;2017-04-17;2017-05-01;2017-05-29;2017-08-28;2017-12-25;2017-12-26;2018-01-01;2018-03-30;2018-04-02;2018-05-07;2018-05-28;", res);
}
