X-Git-Url: http://gitweb.pimeys.fr/?a=blobdiff_plain;f=bde%2Fstats%2Fall_past.py;h=40f3bea7ec0216b402485cd9c8c1b6290e7db559;hb=cd9ab0f15bff8227fa560169028792f73c31c3f4;hp=75f1b1dc8c30c03105d3c172d41b37fc789067b8;hpb=209b9bae939c744017dfa0192daf855d16db3902;p=scripts-20-100.git

diff --git a/bde/stats/all_past.py b/bde/stats/all_past.py
index 75f1b1d..40f3bea 100755
--- a/bde/stats/all_past.py
+++ b/bde/stats/all_past.py
@@ -3,11 +3,14 @@
 
 """Pour récupérer les soldes des comptes à plusieurs moments du passé."""
 
+import time
+
+import base
 import depenses
 
 def get_idbdes():
     """Récupère les idbdes de tous les comptes."""
-    con, cur = depenses.get_cursor()
+    con, cur = base.getcursor()
     cur.execute("SELECT idbde FROM comptes WHERE idbde >= 0;")
     l = cur.fetchall()
     l = [i[0] for i in l]
@@ -34,14 +37,15 @@ def get_all(idbdes, verbose=False):
     data = {}
     if verbose:
         print "Dernier idbde : %s" % (max(idbdes),)
+        tic = time.time()
     for i in idbdes:
         data[i] = depenses.get_depenses(i, bymonth=True)[0]
-        if i % 100 == 0:
-            if verbose:
-                print i
+        if verbose and i % 100 == 0:
+            print i, time.time() - tic
     return data
 
 if __name__ == "__main__":
     idbdes = get_idbdes()
+    idbdes.sort()
     data = get_all(idbdes, verbose=True)
     to_csv(data, "all_past.csv")