From 8fb71fea0a4037479157053530727f26559ef556 Mon Sep 17 00:00:00 2001 From: Vincent Le Gallic Date: Tue, 11 Apr 2017 09:30:11 +0200 Subject: [PATCH] [bde] interactions.sh : transactions entre 2 idbde --- bde/interactions.sh | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) create mode 100755 bde/interactions.sh 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;" -- 2.39.2