/// <summary>
/// Execute
/// </summary>
/// <returns></returns>
protected override bool Execute()
{
//See if this request has cached data
MemCachedD_Value cache = MemCacheD.Get_BSO <dynamic>("PxStat.Data", "Cube_API", "ReadCollection", DTO);
Navigation_ADO adoNav = new Navigation_ADO(Ado);
//If we're cacheing, we only want the cache to live until the next scheduled release goes live
//Also, if there is a next release before the scheduled cache expiry time, then we won't trust the cache
var nextRelease = adoNav.ReadNextLiveDate(DateTime.Now);
DateTime nextReleaseDate = default;
if (nextRelease.hasData)
{
if (!nextRelease.data[0].NextRelease.Equals(DBNull.Value))
{
nextReleaseDate = Convert.ToDateTime(nextRelease.data[0].NextRelease);
}
}
if (cache.hasData && nextReleaseDate >= cache.expiresAt)
{
Response.data = cache.data;
return(true);
}
Cube_BSO cBso = new Cube_BSO();
// cache store is done in the following function
Response.data = cBso.ExecuteReadCollection(Ado, DTO);
return(true);
}
/// <summary>
/// Execute
/// </summary>
/// <returns></returns>
protected override bool Execute()
{
//so that caches don't get mixed up..
DTO.meta = _meta;
//See if this request has cached data
MemCachedD_Value cache = MemCacheD.Get_BSO <dynamic>("PxStat.Data", "Cube_API", "ReadCollection", DTO);
if (cache.hasData)
{
Response.data = cache.data;
return(true);
}
if (Throttle_BSO.IsThrottled(Ado, HttpContext.Current.Request, Request, SamAccountName))
{
Log.Instance.Debug("Request throttled");
Response.error = Label.Get("error.throttled");
}
Cube_BSO cBso = new Cube_BSO();
// cache store is done in the following function
Response.data = cBso.ExecuteReadCollection(Ado, DTO, _meta);
return(true);
}
public static dynamic PxAPIv1(RESTful_API restfulRequest)
{
try
{
var parameters = ((List <string>)restfulRequest.parameters).Where(x => !string.IsNullOrWhiteSpace(x));
int pcount = parameters.Count() - 1;
JSONRPC_API rpc = Map.RESTful2JSONRPC_API(restfulRequest);
Cube_MAP map = new Cube_MAP();
JObject rpcParams = new JObject();
PxApiMetadata meta = new PxApiMetadata();
var context = HttpContext.Current.Request;
switch (pcount)
{
case Constants.C_DATA_PXAPIV1_SUBJECT_QUERY:
//Get a list of all subjects
rpcParams.Add("LngIsoCode", parameters.ElementAt(Constants.C_DATA_PXAPIV1_SUBJECT_QUERY));
rpc.parameters = rpcParams;
var rspSbj = new Subject_BSO_Read(rpc).Read().Response;
if (rspSbj.data == null)
{
return new RESTful_Output()
{
statusCode = HttpStatusCode.NotFound
}
}
;
rspSbj.data = Utility.JsonSerialize_IgnoreLoopingReference(meta.ReadSubjectsAsObjectList(rspSbj));
var responseSbj = Map.JSONRPC2RESTful_Output(rspSbj, null, HttpStatusCode.NotFound, HttpStatusCode.InternalServerError);
return(responseSbj);
case Constants.C_DATA_PXAPIV1_PRODUCT_QUERY:
//Get a list of products for a subject
rpcParams.Add("LngIsoCode", parameters.ElementAt(Constants.C_DATA_PXAPIV1_SUBJECT_QUERY));
rpcParams.Add("SbjCode", parameters.ElementAt(Constants.C_DATA_PXAPIV1_PRODUCT_QUERY));
rpc.parameters = rpcParams;
var rspPrd = new Product_BSO_Read(rpc).Read().Response;
if (rspPrd.data == null)
{
return new RESTful_Output()
{
statusCode = HttpStatusCode.NotFound
}
}
;
meta = new PxApiMetadata();
if (rspPrd.data.Count == 0)
{
rspPrd = new JSONRPC_Output();
rspPrd.data = null;
}
else
{
rspPrd.data = Utility.JsonSerialize_IgnoreLoopingReference(meta.ReadProductsAsObjectList(rspPrd));
}
var responsePrd = Map.JSONRPC2RESTful_Output(rspPrd, null, HttpStatusCode.NotFound, HttpStatusCode.InternalServerError);
return(responsePrd);
case Constants.C_DATA_PXAPIV1_COLLECTION_QUERY:
//Get a list of live tables for a product
rpcParams.Add("LngIsoCode", parameters.ElementAt(Constants.C_DATA_PXAPIV1_SUBJECT_QUERY));
rpcParams.Add("product", parameters.ElementAt(Constants.C_DATA_PXAPIV1_COLLECTION_QUERY));
if (!Int32.TryParse(parameters.ElementAt(Constants.C_DATA_PXAPIV1_PRODUCT_QUERY), out int sbjInt))
{
rpcParams.Add("SbjCode", "0");
}
else
{
rpcParams.Add("SbjCode", sbjInt.ToString());
}
rpc.parameters = rpcParams;
List <dynamic> collection = new List <dynamic>();
RESTful_Output output = new RESTful_Output();
DateTime nextReleaseDateForProduct = default;
using (Cube_BSO cBso = new Cube_BSO(new ADO("defaultConnection")))
{
nextReleaseDateForProduct = cBso.GetNextReleaseDate(parameters.ElementAt(Constants.C_DATA_PXAPIV1_COLLECTION_QUERY));
}
//See if this request has cached data
MemCachedD_Value cache = MemCacheD.Get_BSO <dynamic>("PxStat.Data", "Cube_API", "ReadCollectionPxApi", rpcParams);
if (cache.hasData && (nextReleaseDateForProduct == default || nextReleaseDateForProduct > DateTime.Now))
{
output.response = cache.data;
output.statusCode = HttpStatusCode.OK;
}
else
{
using (Cube_BSO cBso = new Cube_BSO(new ADO("defaultConnection")))
{
collection = cBso.ReadCollection(parameters.ElementAt(Constants.C_DATA_PXAPIV1_SUBJECT_QUERY), parameters.ElementAt(Constants.C_DATA_PXAPIV1_PRODUCT_QUERY), parameters.ElementAt(Constants.C_DATA_PXAPIV1_COLLECTION_QUERY));
}
meta = new PxApiMetadata();
if (collection != null)
{
if (collection.Count > 0)
{
output.response = Utility.JsonSerialize_IgnoreLoopingReference(meta.ReadCollectionAsObjectList(new JSONRPC_Output()
{
data = collection
}));
output.statusCode = HttpStatusCode.OK;
}
else
{
output.statusCode = HttpStatusCode.NotFound;
}
}
else
{
output.statusCode = HttpStatusCode.NotFound;
}
}
MemCacheD.Store_BSO <dynamic>("PxStat.Data", "Cube_API", "ReadCollectionPxApi", rpcParams, output.response, nextReleaseDateForProduct, Constants.C_CAS_DATA_CUBE_READ_COLLECTION_PXAPI);
return(output);
default:
if (pcount < Constants.C_DATA_PXAPIV1_METADATA_QUERY)
{
throw new Exception(Label.Get("error.validation"));
}
//Either get the metadata for the table or, if a query has been supplied, get the table data based on the query
string request = string.IsNullOrWhiteSpace(restfulRequest.httpPOST) ? restfulRequest.httpGET[Constants.C_JSON_STAT_QUERY_CLASS] : restfulRequest.httpPOST;
//For conventional RESTful patterns, don't return metadata unless the requested MtrCode is contained in the collection
//for the subject and product parameters
List <dynamic> collectionPrdSbjmeta = new List <dynamic>();
using (Cube_BSO cBso = new Cube_BSO(new ADO("defaultConnection")))
{
collectionPrdSbjmeta = cBso.ReadCollection(parameters.ElementAt(Constants.C_DATA_PXAPIV1_SUBJECT_QUERY), parameters.ElementAt(Constants.C_DATA_PXAPIV1_PRODUCT_QUERY), parameters.ElementAt(Constants.C_DATA_PXAPIV1_COLLECTION_QUERY));
}
if (collectionPrdSbjmeta == null)
{
var empty = new RESTful_Output();
empty.statusCode = HttpStatusCode.NotFound;
return(empty);
}
if (collectionPrdSbjmeta.Where(x => x.MtrCode == parameters.ElementAt(Constants.C_DATA_PXAPIV1_METADATA_QUERY)).ToList().Count == 0)
{
var empty = new RESTful_Output();
empty.statusCode = HttpStatusCode.NotFound;
return(empty);
}
if (request == null)
{
rpcParams.Add("LngIsoCode", parameters.ElementAt(Constants.C_DATA_PXAPIV1_SUBJECT_QUERY));
rpcParams.Add("matrix", parameters.ElementAt(Constants.C_DATA_PXAPIV1_METADATA_QUERY));
rpcParams.Add("format", JToken.FromObject(new { type = Constants.C_SYSTEM_JSON_STAT_NAME, version = Constants.C_SYSTEM_JSON_STAT_2X_VERSION }));
Matrix theMatrix;
using (Cube_BSO cBso = new Cube_BSO(new ADO("defaultConnection")))
{
theMatrix = cBso.GetMetadataMatrix(parameters.ElementAt(Constants.C_DATA_PXAPIV1_SUBJECT_QUERY), parameters.ElementAt(Constants.C_DATA_PXAPIV1_METADATA_QUERY));
}
var rspMeta = new RESTful_Output(); // JSONRPC_Output();
if (theMatrix != null)
{
var json = theMatrix.GetApiMetadata(parameters.ElementAt(Constants.C_DATA_PXAPIV1_SUBJECT_QUERY));
rpc.parameters = rpcParams;
rspMeta.response = Utility.JsonSerialize_IgnoreLoopingReference(json);
rspMeta.statusCode = HttpStatusCode.OK;
}
else
{
rspMeta.statusCode = HttpStatusCode.NotFound;
}
return(rspMeta);
}
else
{
//This is a request for data - we need to use the query
//For conventional RESTful patterns, don't return metadata unless the requested MtrCode is contained in the collection
//for the subject and product parameters
List <dynamic> collectionPrdSbjdata = new List <dynamic>();
using (Cube_BSO cBso = new Cube_BSO(new ADO("defaultConnection")))
{
collectionPrdSbjdata = cBso.ReadCollection(parameters.ElementAt(Constants.C_DATA_PXAPIV1_SUBJECT_QUERY), parameters.ElementAt(Constants.C_DATA_PXAPIV1_PRODUCT_QUERY), parameters.ElementAt(Constants.C_DATA_PXAPIV1_COLLECTION_QUERY));
}
if (collectionPrdSbjmeta == null)
{
var empty = new RESTful_Output();
empty.statusCode = HttpStatusCode.NotFound;
return(empty);
}
if (collectionPrdSbjdata.Where(x => x.MtrCode == parameters.ElementAt(Constants.C_DATA_PXAPIV1_METADATA_QUERY)).ToList().Count == 0)
{
var empty = new RESTful_Output();
empty.statusCode = HttpStatusCode.NotFound;
return(empty);
}
string queryString = string.IsNullOrWhiteSpace(restfulRequest.httpPOST) ? restfulRequest.httpGET[Constants.C_JSON_STAT_QUERY_CLASS] : restfulRequest.httpPOST;
PxApiV1Query pxapiQuery = Utility.JsonDeserialize_IgnoreLoopingReference <PxApiV1Query>(queryString);
Format_DTO_Read format = new Format_DTO_Read(pxapiQuery.Response.Format);
string pivot = pxapiQuery.Response.Pivot;
JsonStatQuery jsQuery = new JsonStatQuery();
jsQuery.Class = Constants.C_JSON_STAT_QUERY_CLASS;
jsQuery.Id = new List <string>();
jsQuery.Dimensions = new Dictionary <string, JsonQuery.Dimension>();
foreach (var q in pxapiQuery.Query)
{
jsQuery.Id.Add(q.Code);
jsQuery.Dimensions.Add(q.Code, new JsonQuery.Dimension()
{
Category = new JsonQuery.Category()
{
Index = q.Selection.Values.ToList <string>()
}
});
}
jsQuery.Extension = new Dictionary <string, object>();
jsQuery.Extension.Add("matrix", parameters.ElementAt(Constants.C_DATA_PXAPIV1_METADATA_QUERY));
jsQuery.Extension.Add("language", new Language()
{
Code = parameters.ElementAt(Constants.C_DATA_PXAPIV1_SUBJECT_QUERY), Culture = null
});
jsQuery.Extension.Add("codes", false);
jsQuery.Extension.Add("format", new JsonQuery.Format()
{
Type = format.FrmType, Version = format.FrmVersion
});
if (pivot != null)
{
jsQuery.Extension.Add("pivot", pivot);
}
jsQuery.Version = Constants.C_JSON_STAT_QUERY_VERSION;
JSONRPC_API jsonRpcRequest = Map.RESTful2JSONRPC_API(restfulRequest);
jsonRpcRequest.parameters = Utility.JsonSerialize_IgnoreLoopingReference(jsQuery);
//Run the request as a Json Rpc call
JSONRPC_Output rsp = new Cube_BSO_ReadDataset(jsonRpcRequest, true).Read().Response;
if (rsp.error != null)
{
return(Map.JSONRPC2RESTful_Output(rsp, null, HttpStatusCode.Forbidden));
}
// Convert the JsonRpc output to RESTful output
var response = Map.JSONRPC2RESTful_Output(rsp, format.FrmMimetype, HttpStatusCode.NotFound, HttpStatusCode.InternalServerError);
string suffix;
using (Format_BSO bso = new Format_BSO(new ADO("defaultConnection")))
{
suffix = bso.GetFileSuffixForFormat(format);
};
response.fileName = parameters.ElementAt(Constants.C_DATA_PXAPIV1_METADATA_QUERY) + "." + DateTime.Now.ToString("yyyyMMddHHmmss") + suffix;
return(response);
}
}
}
catch (Exception ex)
{
RESTful_Output error = new RESTful_Output
{
statusCode = HttpStatusCode.InternalServerError
};
Log.Instance.Debug(ex.Message);
return(error);
}
}
public static dynamic PxAPIv1(RESTful_API restfulRequest)
{
try
{
var parameters = ((List <string>)restfulRequest.parameters).Where(x => !string.IsNullOrWhiteSpace(x));
int pcount = parameters.Count() - 1;
JSONRPC_API rpc = Map.RESTful2JSONRPC_API(restfulRequest);
Cube_MAP map = new Cube_MAP();
JObject rpcParams = new JObject();
PxApiMetadata meta = new PxApiMetadata();
var context = HttpContext.Current.Request;
switch (pcount)
{
case Constants.C_DATA_PXAPIV1_SUBJECT_QUERY:
//Get a list of all subjects
rpcParams.Add("LngIsoCode", parameters.ElementAt(Constants.C_DATA_PXAPIV1_SUBJECT_QUERY));
rpc.parameters = rpcParams;
var rspSbj = new Subject_BSO_Read(rpc).Read().Response;
if (rspSbj.data == null)
{
return new RESTful_Output()
{
statusCode = HttpStatusCode.NotFound
}
}
;
rspSbj.data = Utility.JsonSerialize_IgnoreLoopingReference(meta.ReadSubjectsAsObjectList(rspSbj));
var responseSbj = Map.JSONRPC2RESTful_Output(rspSbj, null, rspSbj.data == null ? HttpStatusCode.NotFound : HttpStatusCode.OK);
return(responseSbj);
case Constants.C_DATA_PXAPIV1_PRODUCT_QUERY:
//Get a list of products for a subject
rpcParams.Add("LngIsoCode", parameters.ElementAt(Constants.C_DATA_PXAPIV1_SUBJECT_QUERY));
rpcParams.Add("SbjCode", parameters.ElementAt(Constants.C_DATA_PXAPIV1_PRODUCT_QUERY));
rpc.parameters = rpcParams;
var rspPrd = new Product_BSO_Read(rpc).Read().Response;
if (rspPrd.data == null)
{
return new RESTful_Output()
{
statusCode = HttpStatusCode.NotFound
}
}
;
meta = new PxApiMetadata();
if (rspPrd.data.Count == 0)
{
rspPrd = new JSONRPC_Output();
rspPrd.data = null;
}
else
{
rspPrd.data = Utility.JsonSerialize_IgnoreLoopingReference(meta.ReadProductsAsObjectList(rspPrd));
}
var responsePrd = Map.JSONRPC2RESTful_Output(rspPrd, null, rspPrd.data == null ? HttpStatusCode.NotFound : HttpStatusCode.OK);
return(responsePrd);
case Constants.C_DATA_PXAPIV1_COLLECTION_QUERY:
//Get a list of live tables for a product
rpcParams.Add("LngIsoCode", parameters.ElementAt(Constants.C_DATA_PXAPIV1_SUBJECT_QUERY));
rpcParams.Add("product", parameters.ElementAt(Constants.C_DATA_PXAPIV1_COLLECTION_QUERY));
rpc.parameters = rpcParams;
List <dynamic> collection = new List <dynamic>();
RESTful_Output output = new RESTful_Output();
DateTime nextReleaseDateForProduct = default;
using (Cube_BSO cBso = new Cube_BSO(new ADO("defaultConnection")))
{
nextReleaseDateForProduct = cBso.GetNextReleaseDate(parameters.ElementAt(Constants.C_DATA_PXAPIV1_COLLECTION_QUERY));
}
//See if this request has cached data
MemCachedD_Value cache = MemCacheD.Get_BSO <dynamic>("PxStat.Data", "Cube_API", "ReadCollectionPxApi", rpcParams);
if (cache.hasData && (nextReleaseDateForProduct == default || nextReleaseDateForProduct > DateTime.Now))
{
output.response = cache.data;
output.statusCode = HttpStatusCode.OK;
}
else
{
using (Cube_BSO cBso = new Cube_BSO(new ADO("defaultConnection")))
{
collection = cBso.ReadCollection(parameters.ElementAt(Constants.C_DATA_PXAPIV1_SUBJECT_QUERY), parameters.ElementAt(Constants.C_DATA_PXAPIV1_COLLECTION_QUERY));
}
meta = new PxApiMetadata();
if (collection.Count > 0)
{
output.response = Utility.JsonSerialize_IgnoreLoopingReference(meta.ReadCollectionAsObjectList(new JSONRPC_Output()
{
data = collection
}));
output.statusCode = HttpStatusCode.OK;
}
else
{
output.statusCode = HttpStatusCode.NotFound;
}
}
MemCacheD.Store_BSO <dynamic>("PxStat.Data", "Cube_API", "ReadCollectionPxApi", rpcParams, output.response, nextReleaseDateForProduct, Constants.C_CAS_DATA_CUBE_READ_COLLECTION_PXAPI + parameters.ElementAt(Constants.C_DATA_PXAPIV1_COLLECTION_QUERY));
//MemCacheD.CasRepositoryFlush(Constants.C_CAS_DATA_CUBE_READ_COLLECTION_PXAPI + parameters.ElementAt(Constants.C_DATA_PXAPIV1_COLLECTION_QUERY));
return(output);
case Constants.C_DATA_PXAPIV1_METADATA_QUERY:
//Either get the metadata for the table or, if a query has been supplied, get the table data based on the query
string request = string.IsNullOrWhiteSpace(Utility.HttpPOST()) ? Utility.HttpGET()["query"] : Utility.HttpPOST();
if (request == null)
{
rpcParams.Add("LngIsoCode", parameters.ElementAt(Constants.C_DATA_PXAPIV1_SUBJECT_QUERY));
rpcParams.Add("matrix", parameters.ElementAt(Constants.C_DATA_PXAPIV1_METADATA_QUERY));
rpcParams.Add("format", JToken.FromObject(new { type = "JSON-stat", version = "2.0" }));
Matrix theMatrix;
using (Cube_BSO cBso = new Cube_BSO(new ADO("defaultConnection")))
{
theMatrix = cBso.GetMetadataMatrix(parameters.ElementAt(Constants.C_DATA_PXAPIV1_SUBJECT_QUERY), parameters.ElementAt(Constants.C_DATA_PXAPIV1_METADATA_QUERY));
}
var rspMeta = new RESTful_Output(); // JSONRPC_Output();
if (theMatrix != null)
{
var json = theMatrix.GetApiMetadata(parameters.ElementAt(Constants.C_DATA_PXAPIV1_SUBJECT_QUERY));
rpc.parameters = rpcParams;
rspMeta.response = Utility.JsonSerialize_IgnoreLoopingReference(json);
rspMeta.statusCode = HttpStatusCode.OK;
}
else
{
rspMeta.statusCode = HttpStatusCode.NotFound;
}
return(rspMeta);
}
else
{
//This is a request for data - we need to use the query
string queryString = string.IsNullOrWhiteSpace(Utility.HttpPOST()) ? Utility.HttpGET()["query"] : Utility.HttpPOST();
PxApiV1Query pxapiQuery = Utility.JsonDeserialize_IgnoreLoopingReference <PxApiV1Query>(queryString);
Format_DTO_Read format = new Format_DTO_Read(pxapiQuery.Response.Format);
Analytic_BSO_Create.Create(HttpContext.Current.Request, "PxStat.Data.PxAPIv1", HttpContext.Current.Request.UserAgent,
restfulRequest.ipAddress, parameters.ElementAt(Constants.C_DATA_PXAPIV1_METADATA_QUERY), false, format);
JsonStatQuery jsQuery = new JsonStatQuery();
jsQuery.Class = "query";
jsQuery.Id = new List <string>();
jsQuery.Dimensions = new Dictionary <string, JsonQuery.Dimension>();
foreach (var q in pxapiQuery.Query)
{
jsQuery.Id.Add(q.Code);
jsQuery.Dimensions.Add(q.Code, new JsonQuery.Dimension()
{
Category = new JsonQuery.Category()
{
Index = q.Selection.Values.ToList <string>()
}
});
}
jsQuery.Extension = new Dictionary <string, object>();
jsQuery.Extension.Add("matrix", parameters.ElementAt(Constants.C_DATA_PXAPIV1_METADATA_QUERY));
jsQuery.Extension.Add("language", new Language()
{
Code = parameters.ElementAt(Constants.C_DATA_PXAPIV1_SUBJECT_QUERY)
});
jsQuery.Extension.Add("format", new JsonQuery.Format()
{
Type = format.FrmType, Version = format.FrmVersion
});
jsQuery.Version = Utility.GetCustomConfig("APP_JSON_STAT_QUERY_VERSION");
JSONRPC_API jsonRpcRequest = Map.RESTful2JSONRPC_API(restfulRequest);
jsonRpcRequest.parameters = Utility.JsonSerialize_IgnoreLoopingReference(jsQuery);
//Run the request as a Json Rpc call
JSONRPC_Output rsp = new Cube_BSO_ReadDataset(jsonRpcRequest).Read().Response;
// Convert the JsonRpc output to RESTful output
var response = Map.JSONRPC2RESTful_Output(rsp, format.FrmMimetype, rsp.data == null ? HttpStatusCode.NotFound : HttpStatusCode.OK);
string suffix;
using (Format_BSO bso = new Format_BSO(new ADO("defaultConnection")))
{
suffix = bso.GetFileSuffixForFormat(format);
};
response.fileName = parameters.ElementAt(Constants.C_DATA_PXAPIV1_METADATA_QUERY) + suffix;
return(response);
}
default:
throw new Exception(Label.Get("error.validation"));
}
}
catch (Exception ex)
{
RESTful_Output error = new RESTful_Output
{
statusCode = HttpStatusCode.InternalServerError
};
Log.Instance.Error(ex.Message);
return(error);
}
}