From a21ba9243cdf8ff4daa6192ee7bb31d9d3dc8d01 Mon Sep 17 00:00:00 2001 From: Vincent Le Gallic Date: Thu, 18 Feb 2016 11:13:51 +0100 Subject: [PATCH] Seulement les transactions de montant non nul --- sum_transacs_by_categorie.py | 1 + 1 file changed, 1 insertion(+) diff --git a/sum_transacs_by_categorie.py b/sum_transacs_by_categorie.py index 3e26574..900ed80 100755 --- a/sum_transacs_by_categorie.py +++ b/sum_transacs_by_categorie.py @@ -29,6 +29,7 @@ def get_sum(descriptions, debut, fin): AND date >= %(debut)s AND date < %(fin)s AND destinataire = 0 + AND montant != 0 AND description = ANY (%(descriptions)s); """ con, cur = getcursor() -- 2.39.2