From: Vincent Le Gallic <legallic@crans.org>
Date: Tue, 11 Apr 2017 07:30:11 +0000 (+0200)
Subject: [bde] interactions.sh : transactions entre 2 idbde
X-Git-Url: http://gitweb.pimeys.fr/?p=scripts-20-100.git;a=commitdiff_plain;h=8fb71fea0a4037479157053530727f26559ef556

[bde] interactions.sh : transactions entre 2 idbde
---

diff --git a/bde/interactions.sh b/bde/interactions.sh
new file mode 100755
index 0000000..920279e
--- /dev/null
+++ b/bde/interactions.sh
@@ -0,0 +1,18 @@
+#!/bin/bash
+
+# Pour trouver les transactions qui ont eu lieu entre 2 comptes
+
+export LESS='-S'
+
+psql note -c "
+   SELECT t.id, t.date, t.type,
+          t.quantite, t.montant, t.description, t.valide, t.emetteur, t.destinataire,
+          adhe.pseudo AS emetteur, adhd.pseudo AS destinataire
+   FROM transactions AS t, comptes AS adhe, comptes AS adhd
+   WHERE
+       valide AND
+       $1 in (emetteur, destinataire) AND
+       $2 in (emetteur, destinataire) AND
+       t.emetteur = adhe.idbde AND
+       t.destinataire = adhd.idbde
+   ORDER BY date DESC;"