bde/trouver.sh

   1 #!/bin/bash
   2
   3 # Pour trouver quelqu'un dans la base de données
   4
   5 for i in $@
   6 do
   7   if [ $i = "--no-mail" ]
   8     then nomail=1;
   9     shift;
  10   fi;
  11   if [ $i = "--idbde" ]
  12     then searchidcbde=1;
  13     shift;
  14   fi
  15   if [ $i = "--all" ] || [ $i = "-a" ]
  16     then searchall=1;
  17     shift;
  18   fi
  19 done
  20
  21 # Si on n'a *pas* mis --no-mail (too many negations, I know)
  22 if [ -z "${nomail}" ]
  23 then
  24   adding=" OR mail ILIKE '%$1%'"
  25 fi
  26 # Si on a mis --idbde, il faut matcher l'idbde de manière plus lâche
  27 if [ "${searchidcbde}" = "1" ]
  28 then
  29   wild="%"
  30 fi
  31
  32     psql note -c "SELECT * FROM comptes WHERE pseudo ILIKE '%$1%' OR nom ILIKE '%$1%'
  33      OR prenom ILIKE '%$1%'${adding} OR CAST(idbde AS varchar) LIKE '${wild}$1${wild}' ORDER BY nom;"
  34 if [ -n "${searchall}" ]
  35 then
  36     psql note -c "SELECT a.*, c.* FROM aliases AS a, comptes AS c WHERE a.idbde = c.idbde AND a.alias ILIKE '%$1%' ORDER BY a.alias;"
  37     psql note -c "SELECT h.*, c.* FROM historique AS h, comptes AS c WHERE h.idbde = c.idbde AND h.avant ILIKE '%$1%' ORDER BY h.avant;"
  38 fi