Adding numbers that are not in array format? Or how to filter to array so I can sum up
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
In previous versions of jq I was able to run the following:
cat pull_requests.json | jq '.data.organization.repositories.nodes | .pullRequests.totalCount | add'
On this sample data:
{
"data": {
"organization": {
"repositories": {
"nodes": [{
"pullRequests": {
"totalCount": 2
}
},
{
"pullRequests": {
"totalCount": 8
}
},
{
"pullRequests": {
"totalCount": 23
}
}
]
}
}
}
}
And I would get the correct result.
But currently on jq-1.6 I am getting the following error:
jq: error (at <stdin>:24): Cannot iterate over number (2)
What I noticed from the output without the add filter is that is not an array:
➤ cat pull_requests.json | jq '.data.organization.repositories.nodes | .pullRequests.totalCount'
2
8
23
So my question is how to add these numbers up?
I also tried casting it to array by using [.pullRequests.totalCount] but I was unable to merge, meld, join the arrays to get the final count.
stream add jq
edited Nov 22 '18 at 15:49
peak
34.6k94461
asked Nov 22 '18 at 15:35
Danilo CabelloDanilo Cabello
1,5451321
add a comment |
In previous versions of jq I was able to run the following:
cat pull_requests.json | jq '.data.organization.repositories.nodes | .pullRequests.totalCount | add'
On this sample data:
{
"data": {
"organization": {
"repositories": {
"nodes": [{
"pullRequests": {
"totalCount": 2
}
},
{
"pullRequests": {
"totalCount": 8
}
},
{
"pullRequests": {
"totalCount": 23
}
}
]
}
}
}
}
And I would get the correct result.
But currently on jq-1.6 I am getting the following error:
jq: error (at <stdin>:24): Cannot iterate over number (2)
What I noticed from the output without the add filter is that is not an array:
➤ cat pull_requests.json | jq '.data.organization.repositories.nodes | .pullRequests.totalCount'
2
8
23
So my question is how to add these numbers up?
I also tried casting it to array by using [.pullRequests.totalCount] but I was unable to merge, meld, join the arrays to get the final count.
stream add jq
edited Nov 22 '18 at 15:49
peak
34.6k94461
asked Nov 22 '18 at 15:35
Danilo CabelloDanilo Cabello
1,5451321
For now I am doingcat pull_requests.json | jq '.data.organization.repositories.nodes | .pullRequests.totalCount' | awk '{s+=$1}END{print s}'but I would like to use only jq in this case because it used to work.
– Danilo Cabello
Nov 22 '18 at 15:36
add a comment |
In previous versions of jq I was able to run the following:
cat pull_requests.json | jq '.data.organization.repositories.nodes | .pullRequests.totalCount | add'
On this sample data:
{
"data": {
"organization": {
"repositories": {
"nodes": [{
"pullRequests": {
"totalCount": 2
}
},
{
"pullRequests": {
"totalCount": 8
}
},
{
"pullRequests": {
"totalCount": 23
}
}
]
}
}
}
}
And I would get the correct result.
But currently on jq-1.6 I am getting the following error:
jq: error (at <stdin>:24): Cannot iterate over number (2)
What I noticed from the output without the add filter is that is not an array:
➤ cat pull_requests.json | jq '.data.organization.repositories.nodes | .pullRequests.totalCount'
2
8
23
So my question is how to add these numbers up?
I also tried casting it to array by using [.pullRequests.totalCount] but I was unable to merge, meld, join the arrays to get the final count.
stream add jq
edited Nov 22 '18 at 15:49
peak
34.6k94461
asked Nov 22 '18 at 15:35
Danilo CabelloDanilo Cabello
1,5451321
In previous versions of jq I was able to run the following:
cat pull_requests.json | jq '.data.organization.repositories.nodes | .pullRequests.totalCount | add'
On this sample data:
{
"data": {
"organization": {
"repositories": {
"nodes": [{
"pullRequests": {
"totalCount": 2
}
},
{
"pullRequests": {
"totalCount": 8
}
},
{
"pullRequests": {
"totalCount": 23
}
}
]
}
}
}
}
And I would get the correct result.
But currently on jq-1.6 I am getting the following error:
jq: error (at <stdin>:24): Cannot iterate over number (2)
What I noticed from the output without the add filter is that is not an array:
➤ cat pull_requests.json | jq '.data.organization.repositories.nodes | .pullRequests.totalCount'
2
8
23
So my question is how to add these numbers up?
I also tried casting it to array by using [.pullRequests.totalCount] but I was unable to merge, meld, join the arrays to get the final count.
stream add jq
stream add jq
edited Nov 22 '18 at 15:49
peak
34.6k94461
asked Nov 22 '18 at 15:35
Danilo CabelloDanilo Cabello
1,5451321
edited Nov 22 '18 at 15:49
peak
34.6k94461
asked Nov 22 '18 at 15:35
Danilo CabelloDanilo Cabello
1,5451321
edited Nov 22 '18 at 15:49
peak
34.6k94461
edited Nov 22 '18 at 15:49
peak
34.6k94461
edited Nov 22 '18 at 15:49
peak
34.6k94461
34.6k94461
asked Nov 22 '18 at 15:35
Danilo CabelloDanilo Cabello
1,5451321
asked Nov 22 '18 at 15:35
Danilo CabelloDanilo Cabello
1,5451321
asked Nov 22 '18 at 15:35
Danilo CabelloDanilo Cabello
1,5451321
1,5451321
For now I am doingcat pull_requests.json | jq '.data.organization.repositories.nodes | .pullRequests.totalCount' | awk '{s+=$1}END{print s}'but I would like to use only jq in this case because it used to work.
– Danilo Cabello
Nov 22 '18 at 15:36
add a comment |
For now I am doingcat pull_requests.json | jq '.data.organization.repositories.nodes | .pullRequests.totalCount' | awk '{s+=$1}END{print s}'but I would like to use only jq in this case because it used to work.
– Danilo Cabello
Nov 22 '18 at 15:36
For now I am doing
cat pull_requests.json | jq '.data.organization.repositories.nodes | .pullRequests.totalCount' | awk '{s+=$1}END{print s}' but I would like to use only jq in this case because it used to work.– Danilo Cabello
Nov 22 '18 at 15:36
For now I am doing
cat pull_requests.json | jq '.data.organization.repositories.nodes | .pullRequests.totalCount' | awk '{s+=$1}END{print s}' but I would like to use only jq in this case because it used to work.– Danilo Cabello
Nov 22 '18 at 15:36
add a comment |
1 Answer
1
active
oldest
votes
You are mistaken in thinking that the jq filter as shown used to work on the JSON as shown.
There are fortunately two simple fixes:
[ .data.organization.repositories.nodes
| .pullRequests.totalCount ]
| add
or:
.data.organization.repositories.nodes
| map(.pullRequests.totalCount)
| add
Using sigma/1
Another option is to use a stream-oriented summation function:
def sigma(s): reduce s as $s (null; .+$s);
.data.organization.repositories.nodes
| sigma(..pullRequests.totalCount)
answered Nov 22 '18 at 15:46
peakpeak
34.6k94461
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53434228%2fadding-numbers-that-are-not-in-array-format-or-how-to-filter-to-array-so-i-can%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
You are mistaken in thinking that the jq filter as shown used to work on the JSON as shown.
There are fortunately two simple fixes:
[ .data.organization.repositories.nodes
| .pullRequests.totalCount ]
| add
or:
.data.organization.repositories.nodes
| map(.pullRequests.totalCount)
| add
Using sigma/1
Another option is to use a stream-oriented summation function:
def sigma(s): reduce s as $s (null; .+$s);
.data.organization.repositories.nodes
| sigma(..pullRequests.totalCount)
answered Nov 22 '18 at 15:46
peakpeak
34.6k94461
add a comment |
You are mistaken in thinking that the jq filter as shown used to work on the JSON as shown.
There are fortunately two simple fixes:
[ .data.organization.repositories.nodes
| .pullRequests.totalCount ]
| add
or:
.data.organization.repositories.nodes
| map(.pullRequests.totalCount)
| add
Using sigma/1
Another option is to use a stream-oriented summation function:
def sigma(s): reduce s as $s (null; .+$s);
.data.organization.repositories.nodes
| sigma(..pullRequests.totalCount)
answered Nov 22 '18 at 15:46
peakpeak
34.6k94461
add a comment |
You are mistaken in thinking that the jq filter as shown used to work on the JSON as shown.
There are fortunately two simple fixes:
[ .data.organization.repositories.nodes
| .pullRequests.totalCount ]
| add
or:
.data.organization.repositories.nodes
| map(.pullRequests.totalCount)
| add
Using sigma/1
Another option is to use a stream-oriented summation function:
def sigma(s): reduce s as $s (null; .+$s);
.data.organization.repositories.nodes
| sigma(..pullRequests.totalCount)
answered Nov 22 '18 at 15:46
peakpeak
34.6k94461
You are mistaken in thinking that the jq filter as shown used to work on the JSON as shown.
There are fortunately two simple fixes:
[ .data.organization.repositories.nodes
| .pullRequests.totalCount ]
| add
or:
.data.organization.repositories.nodes
| map(.pullRequests.totalCount)
| add
Using sigma/1
Another option is to use a stream-oriented summation function:
def sigma(s): reduce s as $s (null; .+$s);
.data.organization.repositories.nodes
| sigma(..pullRequests.totalCount)
answered Nov 22 '18 at 15:46
peakpeak
34.6k94461
answered Nov 22 '18 at 15:46
peakpeak
34.6k94461
answered Nov 22 '18 at 15:46
peakpeak
34.6k94461
answered Nov 22 '18 at 15:46
peakpeak
34.6k94461
34.6k94461
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53434228%2fadding-numbers-that-are-not-in-array-format-or-how-to-filter-to-array-so-i-can%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
For now I am doing
cat pull_requests.json | jq '.data.organization.repositories.nodes | .pullRequests.totalCount' | awk '{s+=$1}END{print s}'but I would like to use only jq in this case because it used to work.– Danilo Cabello
Nov 22 '18 at 15:36