[bde] interactions.sh : transactions entre 2 idbde

diff --git a/bde/interactions.sh b/bde/interactions.sh
new file mode 100755 (executable)
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;"