From 249c4ceb0ec65b63ae0e7292066e2d88517d9e62 Mon Sep 17 00:00:00 2001 From: Vincent Le Gallic Date: Mon, 30 Sep 2013 14:40:27 +0200 Subject: [PATCH] =?utf8?q?Quelques=20notes=20pour=20ins=C3=A9rer=20des=20t?= =?utf8?q?ransactions.?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- bde/this_is_dirty.sh | 12 ++++++++++++ 1 file changed, 12 insertions(+) create mode 100755 bde/this_is_dirty.sh diff --git a/bde/this_is_dirty.sh b/bde/this_is_dirty.sh new file mode 100755 index 0000000..cec4131 --- /dev/null +++ b/bde/this_is_dirty.sh @@ -0,0 +1,12 @@ +#!/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 ENABLE TRIGGER ALL;" + +psql bde -c "INSERT INTO transactions (conso, emetteur, destinataire, montant, quantite, valide, remarque) VALUES (1, 1814, 0, 39.85, 1, true, 'Vidage de note');" + + -- 2.39.2