Add support to aggregate multiple queries into a single response #17

Activity

1. php-coder

   added

   enhancementNew feature or requestNew feature or request

   on Sep 11, 2022
2. php-coder commented on Sep 11, 2022

   

   php-coder

   on Sep 11, 2022

   Last edited by php-coder

   OwnerAuthor

   More actions

   Example of a response:

   {
     "num_of_categories": 5,
     "num_of_countries": 10
     "num_of_series": 100
   }

   And possible syntax:

   - path: /v1/stat
     get:
       queries:
         num_of_categories: SELECT COUNT(*) FROM categories
         num_of_countries:  SELECT COUNT(*) FROM countries
         num_of_series:     SELECT COUNT(*) FROM series

   OR

   - path: /v1/stat
     get:
       aggregated_query:
         num_of_categories: SELECT COUNT(*) FROM categories
         num_of_countries:  SELECT COUNT(*) FROM countries
         num_of_series:     SELECT COUNT(*) FROM series

   OR

   - path: /v1/stat
     get:
       query:
         aggregate:
           num_of_categories: SELECT COUNT(*) FROM categories
           num_of_countries:  SELECT COUNT(*) FROM countries
           num_of_series:     SELECT COUNT(*) FROM series
3. php-coder

   self-assigned this

   on Sep 29, 2022
4. php-coder

   added this to the 0.0.3 milestone on Sep 29, 2022
5. php-coder

   added 5 commits that reference this issue on Sep 29, 2022

   chore: modify an output to show SQL query on a new line

   ...

   beb9e8b

   refactor: treat a sinqle query as a list with one element

   ...

   159663a

   refactor: treat a sinqle query as a list with one element

   ...

   10a4915

   feat(python): add support to aggregate multiple queries within a sing…

   ...

   75e2091

   chore(golang,js): don't fail on not yet supported aggregated_queries

   ...

   574fe28
6. php-coder

   modified the milestones: 0.0.3, 0.0.4 on Apr 9, 2024