X-Git-Url: http://gitweb.pimeys.fr/?a=blobdiff_plain;f=bde%2Factivites.sh;fp=bde%2Factivites.sh;h=2d3efd09e56467356690c0a43acb39db10c3e0e4;hb=8e6221db8bf74c533d0d7ef61828400de740c703;hp=0000000000000000000000000000000000000000;hpb=66722ac5b0bc032dbbaef64d58920d3af64b5603;p=scripts-20-100.git

diff --git a/bde/activites.sh b/bde/activites.sh
new file mode 100755
index 0000000..2d3efd0
--- /dev/null
+++ b/bde/activites.sh
@@ -0,0 +1,19 @@
+#!/bin/bash
+
+# Pour avoir rapidement la liste des activités
+
+export LESS="-S"
+
+for i in $@
+do
+  if [ $i = "--pot" ]
+    then pot=1;
+  fi;
+done
+
+if [ "${pot}" = "1" ]
+then
+    WHERE="WHERE titre ILIKE '%pot%' "
+fi
+
+psql bde -c "SELECT * FROM activites ${WHERE}ORDER BY debut DESC;"