bde/this_is_dirty.sh

   1 #!/bin/bash
   2
   3
   4 #psql bde -c "INSERT INTO transactions (conso, emetteur, destinataire, montant, quantite, valide, remarque) VALUES (1, 2850, 0, 35, 1, true, 'sweat ENS Z');"
   5 #psql bde -c "INSERT INTO transactions (conso, emetteur, destinataire, montant, quantite, valide, remarque) VALUES (1, 3246, 3539, 94.72, 1, true, 'Pot A♡');"
   6 #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');"
   7
   8 #psql bde -c "ALTER TABLE transactions DISABLE TRIGGER ALL;"
   9 #psql bde -c "ALTER TABLE transactions ENABLE TRIGGER ALL;"
  10 connard=2187
  11 recepteur=2798
  12 quantite=1
  13 taxe=3.00
  14 randomreason='Sauce - Menu'
  15
  16 psql bde -c "UPDATE adherents SET solde=solde + 500 WHERE numcbde = ${connard};"
  17 psql bde -c "INSERT INTO transactions (conso, emetteur, destinataire, montant, quantite, valide, remarque) VALUES (1, ${connard}, ${recepteur}, ${taxe}, ${quantite}, true, '${randomreason}');"
  18 psql bde -c "UPDATE adherents SET solde=solde - 500 WHERE numcbde = ${connard};"
  19
  20