Adding numbers that are not in array format? Or how to filter to array so I can sum up











up vote
1
down vote

favorite












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.










share|improve this question
























  • 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 at 15:36















up vote
1
down vote

favorite












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.










share|improve this question
























  • 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 at 15:36













up vote
1
down vote

favorite









up vote
1
down vote

favorite











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.










share|improve this question















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






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 22 at 15:49









peak

29.6k83955




29.6k83955










asked Nov 22 at 15:35









Danilo Cabello

1,102815




1,102815












  • 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 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 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 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 at 15:36












1 Answer
1






active

oldest

votes

















up vote
2
down vote













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)





share|improve this answer





















    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',
    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
    });


    }
    });














    draft saved

    draft discarded


















    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








    up vote
    2
    down vote













    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)





    share|improve this answer

























      up vote
      2
      down vote













      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)





      share|improve this answer























        up vote
        2
        down vote










        up vote
        2
        down vote









        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)





        share|improve this answer












        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)






        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Nov 22 at 15:46









        peak

        29.6k83955




        29.6k83955






























            draft saved

            draft discarded




















































            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.





            Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


            Please pay close attention to the following guidance:


            • 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.




            draft saved


            draft discarded














            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





















































            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







            Popular posts from this blog

            What visual should I use to simply compare current year value vs last year in Power BI desktop

            Alexandru Averescu

            Trompette piccolo