+
+def get_cursor():
+ """Ouvre une connexion à la bdd."""
+ con = psycopg2.connect(database="note")
+ con.set_client_encoding("utf-8")
+ cur = con.cursor(cursor_factory = psycopg2.extras.DictCursor)
+ return (con, cur)
+
+def get_depenses(idbde):
+ """Récupère toutes les dépenses/gains du compte ``idbde``"""
+ con, cur = get_cursor()
+ cur.execute(create_temp_table, {"idbde" : idbde})
+ cur.execute(display_all)
+ l = cur.fetchall()
+ print "annee\tdepenses\tgains"
+ for li in l:
+ li = [int(li[0]), li[1], li[2]]
+ print "%s\t%s\t\t%s" % tuple(li)
+ cur.execute(display_sum)
+ l = cur.fetchall()
+ print "\nTotal :\n\tdepenses\tgains"
+ print "\t%s\t\t%s" % tuple(l[0])
+
+if __name__ == "__main__":
+ idbde = int(sys.argv[1])
+ get_depenses(idbde)