#!/bin/bash
# 2019-04-24 -- Nathalie

echo "==BEGIN " `date`

cd /var/www/pix/current

echo "--DEBUT requête mise à jour toomany_limit" `date`
mysql -e "update providers as P inner join (select provider_id, round(count(*)-((count(*)/100)*1)) as nb from images group by provider_id having count(*) > 100000) as Q on P.id = Q.provider_id set P.toomany_limit = Q.nb where P.toomany_limit >100000 or P.toomany_limit=0 or P.toomany_limit is null;"
echo "--FIN requête mise à jour toomany_limit" `date`
echo

echo "--DEBUT Provider.delete_toomany_images " `date`
script/rails runner -e production 'Provider.delete_toomany_images'
echo "--FIN Provider.delete_toomany_images " `date`
echo

echo "==DONE " `date`