dimagi / sql-agg / 241 / 2

93%

master: 92%

Pull #49

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

156 of 175 branches covered (89.14%)

569 of 615 relevant lines covered (92.52%)

0.93 hits per line