"""
cur.execute(req_create_credits)
+ cur.execute("CREATE INDEX credits_index_id ON credits (id);")
+
req = u"""
SELECT
t1.id AS id1,
l.sort()
result = [", ".join([str(i) for i in l]) for l in result]
result = list(set(result))
+ result.sort(key=lambda x : int(x.split(",")[0]))
return result
def get_transactions(cur, ids):
ou d'afficher une liste de toutes celles à dévalider.
"""
ids_to_devalidate = []
+ total = 0
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"))
elif ans.lower() in ["s"]:
lb.remove(idkeep)
ids_to_devalidate.extend(lb)
+ total += l[0]["montant"] * (len(l) - 1)
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])
+ print "Montant total : %s" % (total,)
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.")