json-light-query
v2.0.0
Published
query to jsonobject/array and return summary of data such as total value of specified attributes.
Downloads
9
Maintainers
Readme
json-light-query
Get the total/average value from json array(object/string).
Usage
1 - How to get total by id
const { VernQueryFactory } = require("json-light-query");
const reqAttrId = "nameOfUniqueId";
const reqAttrVal = "nameOfAttributeToGetTotal";
const reqAttrIdVal = "111111113";
const jsonArraySample = [{
"nameOfUniqueId": "111111113",
"anyAdditonalAttributeIsFine": "1001",
"nameOfAttributeToGetTotal": 10.98
},
{
"nameOfUniqueId": "111111113",
"anyAdditonalAttributeIsFine": "1002",
"nameOfAttributeToGetTotal": 7.21
}];
const resp = VernQueryFactory.getTotalById({jsonObjArray:jsonArraySample, idAttrNm: reqAttrId, numericAttrNm: reqAttrVal}, reqAttrIdVal);
The above resp will be:
{
id: '111111113',
total: 18.19
}
2 - How to get total by group
const { VernQueryFactory } = require("json-light-query");
const reqAttrId = "uniqueId";
const reqAttrVal = "price";
const reqAttrGrpNm = "attrSeq";
const jsonArraySample ='[{"uniqueId":"111111113","attrSeq":"1001","price":10},{"uniqueId":"111111114","attrSeq":"1001","price":10},{"uniqueId":"111111113","attrSeq":"1002","price":10}]';
const resp = VernQueryFactory.getTotalByGroup({jsonObjArray:jsonArraySample, idAttrNm: reqAttrId, numericAttrNm: reqAttrVal}, reqAttrGrpNm);
The above resp will be:
[{
uniqueId: '111111113',
attrSeq: '1001'
price: 20
},
{
uniqueId: '111111113',
attrSeq: '1002'
price: 10
}]
3 - How to get total for all
const { VernQueryFactory } = require("json-light-query");
const reqAttrId = "uniqueId";
const reqAttrVal = "price";
const reqAttrGrpNm = "attrSeq";
const jsonArraySample ='[{"uniqueId":"111111113","attrSeq":"1001","price":10},{"uniqueId":"111111114","attrSeq":"1001","price":10},{"uniqueId":"111111113","attrSeq":"1002","price":10}]';
const resp = VernQueryFactory.getTotal({jsonObjArray:jsonArraySample, idAttrNm: reqAttrId, numericAttrNm: reqAttrVal});
The above resp will be:
{
id: 'all',
total: 30
}
Installation
$ npm i json-light-query