public void ProcessRequestForEquityIndexWeights()
{
//retrieve bdis
var sql = @"select top 1 * from BloombergDatarequestitem where bbfieldlist like '%mwei%' and bbticker = 'ibex index' and insertedwhen > getdate() - 5";
var requestItems = new Database().GetTickerItemsToProcess(sql);
var controller = new BergController();
//split into separate lists - one for datawarehouse, one for legacy api, one for bloomberg ad hoc
var requestItemsForBloombergApi = requestItems.FindAll(x => controller.IsForLegacyBloombergApi(x));
var requestItemsForBloombergAdHoc = requestItems.FindAll(x => controller.IsForBloombergAdHoc(x));
var requestItemsForDatawarehouse = requestItems.FindAll(x => !controller.IsForLegacyBloombergApi(x) && !controller.IsForBloombergAdHoc(x));
Assert.AreEqual(requestItems.Count, requestItemsForDatawarehouse.Count + requestItemsForBloombergApi.Count + requestItemsForBloombergAdHoc.Count);
Assert.AreEqual(1, requestItemsForDatawarehouse.Count);
//get errors
new TestBloombergDatawarehouse().ProcessDataRequests(requestItemsForDatawarehouse);
}
public void GetDataWarehouseRequestItemsFromLiveAndProcessThemInDev()
{
//retrieve bdis
var sqlFile = @"sqls\GetBloombergDataRequestItems.sql";
var controller = new BergController();
var sql = File.ReadAllText(sqlFile);
var requestItems = new Database().GetTickerItemsToProcess(sql);
//split into separate lists - one for datawarehouse, one for legacy api, one for bloomberg ad hoc
var requestItemsForBloombergApi = requestItems.FindAll(x => controller.IsForLegacyBloombergApi(x));
var requestItemsForBloombergAdHoc = requestItems.FindAll(x => controller.IsForBloombergAdHoc(x));
var requestItemsForDatawarehouse = requestItems.FindAll(x => !controller.IsForLegacyBloombergApi(x) && !controller.IsForBloombergAdHoc(x));
Assert.AreEqual(requestItems.Count, requestItemsForDatawarehouse.Count + requestItemsForBloombergApi.Count + requestItemsForBloombergAdHoc.Count);
//get errors
new TestBloombergDatawarehouse().ProcessDataRequests(requestItemsForDatawarehouse);
}
public void RequestItemRoutingTests()
{
var controller = new BergController();
var requestItem = new RequestItem
{
BBFieldList = "PX_LAST",
RequestType = BloombergDataInstrument.eRequestType.IntraDayBar,
UserId = "IntradayPrices"
};
Assert.IsTrue(controller.IsForLegacyBloombergApi(requestItem));
requestItem = new RequestItem
{
BBFieldList = "PX_LAST",
RequestType = BloombergDataInstrument.eRequestType.IntraDayTick,
UserId = "IntradayFx"
};
Assert.IsTrue(controller.IsForLegacyBloombergApi(requestItem));
requestItem = new RequestItem
{
BBFieldList = "PX_LAST",
RequestType = BloombergDataInstrument.eRequestType.Reference,
UserId = ""
};
Assert.IsFalse(controller.IsForLegacyBloombergApi(requestItem));
requestItem = new RequestItem
{
BBFieldList = "PX_LAST,OPT_DELTA_SOMETHING",
RequestType = BloombergDataInstrument.eRequestType.Reference,
UserId = ""
};
Assert.IsFalse(controller.IsForLegacyBloombergApi(requestItem));
requestItem = new RequestItem
{
BBFieldList = "SW_VAL_PREMIUM....",
RequestType = BloombergDataInstrument.eRequestType.Reference,
UserId = ""
};
Assert.IsFalse(controller.IsForLegacyBloombergApi(requestItem));
requestItem = new RequestItem
{
BBFieldList = "nSW_VAL_PREMIUM....",
RequestType = BloombergDataInstrument.eRequestType.Reference,
UserId = ""
};
Assert.IsFalse(controller.IsForLegacyBloombergApi(requestItem));
requestItem = new RequestItem
{
BBFieldList = "RTG_....",
RequestType = BloombergDataInstrument.eRequestType.Reference,
UserId = ""
};
Assert.IsFalse(controller.IsForLegacyBloombergApi(requestItem));
requestItem = new RequestItem
{
BBFieldList = "RTG....",
RequestType = BloombergDataInstrument.eRequestType.Reference,
UserId = ""
};
Assert.IsFalse(controller.IsForLegacyBloombergApi(requestItem));
requestItem = new RequestItem
{
BBFieldList = "kjhjkh jkhCALENDAR_NON_SETTLEMENT_DATEskjhjkh",
RequestType = BloombergDataInstrument.eRequestType.Reference,
UserId = ""
};
Assert.IsFalse(controller.IsForLegacyBloombergApi(requestItem));
requestItem = new RequestItem
{
BBFieldList = "kjhjkh jkhCALENDAR_NON_SETTLEMENT_DATESkjhjkh",
RequestType = BloombergDataInstrument.eRequestType.Reference,
UserId = ""
};
Assert.IsFalse(controller.IsForLegacyBloombergApi(requestItem));
//adhoc test
requestItem = new RequestItem
{
BBFieldList = "kjhjkh jkhCALENDAR_NON_SETTLEMENT_DATESkjhjkh",
RequestType = BloombergDataInstrument.eRequestType.Reference,
UserId = "StaticDataImport"
};
Assert.IsTrue(controller.IsForBloombergAdHoc(requestItem));
}