X-Git-Url: http://gitweb.pimeys.fr/?a=blobdiff_plain;f=bde%2Fthis_is_dirty.sh;h=cb72f589364fb014bac5e913ac7ce52e0b4e327d;hb=50a8fbb4944e1afe65482102ac33c88c7d072fc7;hp=cec4131f851657119bb0893e0d5a84c1c4974fae;hpb=249c4ceb0ec65b63ae0e7292066e2d88517d9e62;p=scripts-20-100.git

diff --git a/bde/this_is_dirty.sh b/bde/this_is_dirty.sh
index cec4131..cb72f58 100755
--- a/bde/this_is_dirty.sh
+++ b/bde/this_is_dirty.sh
@@ -1,12 +1,20 @@
 #!/bin/bash
 
 
-#psql bde -c "ALTER TABLE transactions DISABLE TRIGGER ALL;"
 #psql bde -c "INSERT INTO transactions (conso, emetteur, destinataire, montant, quantite, valide, remarque) VALUES (1, 2850, 0, 35, 1, true, 'sweat ENS Z');"
 #psql bde -c "INSERT INTO transactions (conso, emetteur, destinataire, montant, quantite, valide, remarque) VALUES (1, 3246, 3539, 94.72, 1, true, 'Pot A♡');"
 #psql bde -c "INSERT INTO transactions (date, conso, emetteur, destinataire, montant, quantite, valide, remarque) VALUES ('2013-01-17 00:14:56', 44, 2822, 0, 2.00, 6, true, 'Pinte');"
+
+#psql bde -c "ALTER TABLE transactions DISABLE TRIGGER ALL;"
 #psql bde -c "ALTER TABLE transactions ENABLE TRIGGER ALL;"
+connard=2187
+recepteur=2798
+quantite=1
+taxe=3.00
+randomreason='Sauce - Menu'
 
-psql bde -c "INSERT INTO transactions (conso, emetteur, destinataire, montant, quantite, valide, remarque) VALUES (1, 1814, 0, 39.85, 1, true, 'Vidage de note');"
+psql bde -c "UPDATE adherents SET solde=solde + 500 WHERE numcbde = ${connard};"
+psql bde -c "INSERT INTO transactions (conso, emetteur, destinataire, montant, quantite, valide, remarque) VALUES (1, ${connard}, ${recepteur}, ${taxe}, ${quantite}, true, '${randomreason}');"
+psql bde -c "UPDATE adherents SET solde=solde - 500 WHERE numcbde = ${connard};"