dimagi / sql-agg / 239

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

137 of 156 branches covered (87.82%)

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

567 of 613 relevant lines covered (92.5%)

3.7 hits per line