dimagi / sql-agg / 240

93%

master: 92%

push

travis-ci

Add support for grouping by conditional expressions

Produces the following SQL:

  SELECT CASE WHEN indicator_a between 0 and 1 THEN '0-1'
              WHEN indicator_a between 2 and 2 THEN '2' ELSE %(param_1)s
              END AS bucket,
        count(user_table."user") AS "user"
  FROM user_table GROUP BY bucket

139 of 158 branches covered (87.97%)

3 of 3 new or added lines in 1 file covered. (100.0%)

569 of 615 relevant lines covered (92.52%)

3.7 hits per line