X-Git-Url: http://gitweb.pimeys.fr/?a=blobdiff_plain;f=bde%2Fthis_is_dirty.sh;fp=bde%2Fthis_is_dirty.sh;h=0000000000000000000000000000000000000000;hb=62bd5a01bbcc7b96c4b1dd098415253d14492517;hp=cb72f589364fb014bac5e913ac7ce52e0b4e327d;hpb=7630720dd491fa53093743e683d4e05f22d03afd;p=scripts-20-100.git diff --git a/bde/this_is_dirty.sh b/bde/this_is_dirty.sh deleted file mode 100755 index cb72f58..0000000 --- a/bde/this_is_dirty.sh +++ /dev/null @@ -1,20 +0,0 @@ -#!/bin/bash - - -#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 "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};" - -