summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorDan McGee <dan@archlinux.org>2014-10-18 17:25:34 -0500
committerDan McGee <dan@archlinux.org>2014-10-18 17:25:34 -0500
commita07740f230f733f98200fcb4e4528cc01a3bf2d1 (patch)
tree712171ada9a05df57e996fc2259812b297025a96
parentd088579eba892abd990e47dadf9a64a6d1771b42 (diff)
Change case of SUM() SQL function
-rw-r--r--todolists/utils.py2
1 files changed, 1 insertions, 1 deletions
diff --git a/todolists/utils.py b/todolists/utils.py
index 7b98c887..e04c2e5e 100644
--- a/todolists/utils.py
+++ b/todolists/utils.py
@@ -6,7 +6,7 @@ from packages.models import Package
def todo_counts():
sql = """
-SELECT todolist_id, count(*), sum(CASE WHEN status = %s THEN 1 ELSE 0 END)
+SELECT todolist_id, count(*), SUM(CASE WHEN status = %s THEN 1 ELSE 0 END)
FROM todolists_todolistpackage
WHERE removed IS NULL
GROUP BY todolist_id