[bde/credits_duplicates] Affichage du nombre de transactions à dévalider

[scripts-20-100.git] / bde / credits_duplicates.py

diff --git a/bde/credits_duplicates.py b/bde/credits_duplicates.py
index dc98725954ae128f452873ad2c1b6027686f307b..18b177fbc4910fd7af055a8cea7981c83f228aaa 100755 (executable)
--- a/bde/credits_duplicates.py
+++ b/bde/credits_duplicates.py
@@ -48,6 +48,8 @@ def get_data(cur, delai='1 minute', date='1970-01-01'):
     """
     cur.execute(req_create_credits)
 
+    cur.execute("CREATE INDEX credits_index_id ON credits (id);")
+
     req = u"""
         SELECT
             t1.id AS id1,
@@ -125,7 +127,7 @@ def interactive(blocks, cur, args):
     for b in blocks:
         lb = [int(i) for i in b.split(",")]
         l = get_transactions(cur, b)
-        formatted = pretty_print.sql_pretty_print(l, keys=["id", "date", "type", "emetteur", "destinataire", "quantite", "montant", "description", "valide", "cantinvalidate"])
+        formatted = pretty_print.sql_pretty_print(l, keys=["id", "date", "type", "emetteur", "destinataire", "quantite", "montant", "description", "valide", "cantinvalidate", "prenom", "nom"])
         if not args.noless:
             p = subprocess.Popen(["less"], stdin=subprocess.PIPE)
             p.communicate(formatted.encode("utf-8"))
@@ -144,7 +146,8 @@ def interactive(blocks, cur, args):
             lb.remove(idkeep)
             ids_to_devalidate.extend(lb)
     if ids_to_devalidate:
-        print "\nIDs de transactions à dévalider :\n" + ",".join([str(i) for i in ids_to_devalidate])
+        print "\nIDs de transactions à dévalider (%s) :" % len(ids_to_devalidate)
+        print ",".join([str(i) for i in ids_to_devalidate])
 
 if __name__ == "__main__":
     parser = argparse.ArgumentParser(description="Liste les crédits semblables trop proches dans le temps et propose de les dévalider tous sauf 1.")