]>
gitweb.pimeys.fr Git - scripts-20-100.git/blob - bde/stats/depenses.py
2 # -*- coding: utf-8 -*-
4 """Affiche les dépenses totales d'un compte par année + total"""
11 create_temp_table
= """
12 SELECT extract(year FROM date) AS annee,
14 CASE WHEN emetteur = %(idbde)s THEN montant * quantite
17 )/100.0 AS numeric(10,2)) AS depenses,
19 CASE WHEN destinataire = %(idbde)s THEN montant*quantite
22 )/100.0 AS numeric(10,2)) AS gains
25 WHERE valide AND %(idbde)s in (emetteur, destinataire)
30 display_all
= """ SELECT * FROM past
35 display_sum
= """ SELECT sum(gains) AS gains, sum(depenses) AS depenses
41 """Ouvre une connexion à la bdd."""
42 con
= psycopg2
.connect(database
="note")
43 con
.set_client_encoding("utf-8")
44 cur
= con
.cursor(cursor_factory
= psycopg2
.extras
.DictCursor
)
47 def get_depenses(idbde
):
48 """Récupère toutes les dépenses/gains du compte ``idbde``"""
49 con
, cur
= get_cursor()
50 cur
.execute(create_temp_table
, {"idbde" : idbde
})
51 cur
.execute(display_all
)
53 print "annee\tdepenses\tgains"
55 li
= [int(li
[0]), li
[1], li
[2]]
56 print "%s\t%s\t\t%s" % tuple(li
)
57 cur
.execute(display_sum
)
59 print "\nTotal :\n\tdepenses\tgains"
60 print "\t%s\t\t%s" % tuple(l
[0])
62 if __name__
== "__main__":
63 idbde
= int(sys
.argv
[1])