#!/bin/bash
cd ~
run() { php bin/console dbal:run-sql "$1" --env=prod 2>&1 | grep -oE '[0-9]+ rows' | grep -oE '[0-9]+'; }
F="pv.is_bot = 0 AND pv.url = '/annuaire' AND pv.duration_seconds IS NULL AND pv.referer IS NULL AND s.source = 'direct' AND s.device_type = 'desktop' AND pv.created_at >= '2026-09-28' AND pv.created_at < '2026-10-21'"
while true; do
  n=$(run "DELETE FROM page_view WHERE id IN (SELECT id FROM (SELECT pv.id FROM page_view pv JOIN stat_session s ON s.id = pv.session_id WHERE $F LIMIT 10000) t)")
  echo "$(date +%T) visites ${n:-?}"; [ "${n:-0}" -eq 0 ] && break; sleep 1
done
while true; do
  n=$(run "DELETE FROM stat_session WHERE id IN (SELECT id FROM (SELECT s.id FROM stat_session s WHERE s.source = 'direct' AND s.device_type = 'desktop' AND s.landing_page = '/annuaire' AND s.started_at >= '2026-09-28' AND s.started_at < '2026-10-21' AND NOT EXISTS (SELECT 1 FROM page_view pv WHERE pv.session_id = s.id) LIMIT 10000) t)")
  echo "$(date +%T) sessions ${n:-?}"; [ "${n:-0}" -eq 0 ] && break; sleep 1
done
echo FIN