X-Git-Url: http://gitweb.pimeys.fr/?a=blobdiff_plain;f=bde%2Finteractions.sh;fp=bde%2Finteractions.sh;h=920279e2b4a51b7b2b2e602656ab260f50568d0d;hb=8fb71fea0a4037479157053530727f26559ef556;hp=0000000000000000000000000000000000000000;hpb=70ce3a89449d57833aebad7a45536f78352f6e42;p=scripts-20-100.git

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;"