+ tot = cur.fetchall()[0]
+ return (all, tot)
+
+def display_depenses(idbde, all, tot, bymonth=False):
+ """Pretty-printing des résultats."""
+ month = "\tmois" if bymonth else ""
+ print "Compte %s:\nannee%s\tgains\t\tdépenses" % (idbde, month)
+ for li in all:
+ if bymonth:
+ li = [int(li[0]), int(li[1]), li[2], li[3]]
+ print "%s\t%s\t%s\t\t%s" % tuple(li)
+ else:
+ li = [int(li[0]), li[1], li[2]]
+ print "%s\t%s\t\t%s" % tuple(li)
+ print "\nTotal :\n\tgains\t\tdépenses"
+ print "\t%s\t\t%s\n" % tuple(tot)