#!/bin/bash
#
# Paso 4 del cutover: importar el dump saneado en MySQL 8.4.
#
# --default-character-set=utf8mb4 EN EL CLIENTE es obligatorio: omitirlo es lo que
# produjo el mojibake de summaraise. El dump trae DROP TABLE IF EXISTS en las 29
# tablas, asi que no hace falta vaciar la BD antes.
#
set -euo pipefail
ssh -o BatchMode=yes root@188.40.120.157 'bash -s' <<'EOF'
set -euo pipefail
U=r2ssjifwj0r0ghyoqd528uaa
cd /data/feadulta-migracion
RP=$(docker inspect mysql-$U --format '{{range .Config.Env}}{{println .}}{{end}}' | sed -n 's/^MYSQL_ROOT_PASSWORD=//p')
# OJO: sin -i y con </dev/null. Este script llega por el stdin del ssh, y un
# "docker exec -i" sin redirigir se come el resto del script.
m() { docker exec mysql-$U mysql --default-character-set=utf8mb4 -uroot -p"$RP" -N -B -e "$1" wordpress 2>/dev/null </dev/null; }

echo "== antes del import:"
m "SELECT CONCAT('   tablas: ', COUNT(*)) FROM information_schema.tables WHERE table_schema='wordpress';"

echo "== importando..."
T0=$(date +%s)
docker exec -i mysql-$U mysql --default-character-set=utf8mb4 -uroot -p"$RP" wordpress < feadulta-saneado.sql
T1=$(date +%s)
echo "   import: $((T1-T0))s"

echo ""
echo "== recuentos en destino (comparar con produccion):"
m "SELECT 'tablas', COUNT(*) FROM information_schema.tables WHERE table_schema='wordpress'
   UNION ALL SELECT 'posts', COUNT(*) FROM wp_posts
   UNION ALL SELECT 'users', COUNT(*) FROM wp_users
   UNION ALL SELECT 'options', COUNT(*) FROM wp_options
   UNION ALL SELECT 'terms', COUNT(*) FROM wp_terms
   UNION ALL SELECT 'postmeta', COUNT(*) FROM wp_postmeta;" | sed 's/^/   /'

echo ""
echo "== charset/collation de las tablas (no debe quedar nada raro):"
m "SELECT table_collation, COUNT(*) FROM information_schema.tables WHERE table_schema='wordpress' GROUP BY table_collation;" | sed 's/^/   /'

echo ""
echo "== indice FULLTEXT del buscador:"
m "SELECT index_name, COUNT(*) FROM information_schema.statistics WHERE table_schema='wordpress' AND index_type='FULLTEXT' GROUP BY index_name;" | sed 's/^/   /'

echo ""
echo "== acentos y tipografia (mojibake = 0):"
m "SELECT 'con  raro', COUNT(*) FROM wp_posts WHERE post_title COLLATE utf8mb4_bin LIKE '%Ã%' AND post_title COLLATE utf8mb4_bin NOT LIKE '%ÃÂ%'
   UNION ALL SELECT '’ (mojibake real)', COUNT(*) FROM wp_posts WHERE post_content COLLATE utf8mb4_bin LIKE '%’%'
   UNION ALL SELECT '© mojibake', COUNT(*) FROM wp_posts WHERE post_content COLLATE utf8mb4_bin LIKE '%Â%';" | sed 's/^/   /'

echo ""
echo "== siteurl / home que trae el dump:"
m "SELECT option_name, option_value FROM wp_options WHERE option_name IN ('siteurl','home');" | sed 's/^/   /'
EOF