#!/bin/bash
# =====================================================================
#  Serverda yangilanishdan keyin BIR MARTA ishga tushiriladi (cPanel > Terminal):
#     bash /home/mylogo/came.mylogo.uz/server_update.sh
#
#  Bazadagi ma'lumotlar o'chmaydi: skript avval bazaning to'liq nusxasini oladi,
#  migratsiyadan oldin va keyin yozuvlar sonini solishtiradi. Eski fayllar
#  o'chirilmaydi - backups/ papkasiga ko'chiriladi.
# =====================================================================
set -u
APP_DIR="/home/mylogo/came.mylogo.uz"
VENV_ACTIVATE="/home/mylogo/virtualenv/came.mylogo.uz/3.11/bin/activate"
STAMP="$(date +%Y%m%d_%H%M%S)"

cd "$APP_DIR" || { echo "[XATO] $APP_DIR topilmadi"; exit 1; }
# shellcheck disable=SC1090
source "$VENV_ACTIVATE" || { echo "[XATO] virtualenv topilmadi: $VENV_ACTIVATE"; exit 1; }
mkdir -p backups

echo "== 1/6 Bazaning zaxira nusxasi"
DB_FILE="$(python -c 'import config; print(config.DB_PATH)' 2>/dev/null || echo "$APP_DIR/attendance.db")"
if [ ! -f "$DB_FILE" ]; then
    echo "[XATO] Baza topilmadi: $DB_FILE  (.env dagi DB_PATH ni tekshiring). To'xtatildi."; exit 1
fi
python - "$DB_FILE" "backups/before_update_$STAMP.db" <<'PY' || { echo "[XATO] Zaxira olinmadi. To'xtatildi."; exit 1; }
import sqlite3, sys
src = sqlite3.connect(sys.argv[1]); dst = sqlite3.connect(sys.argv[2])
src.backup(dst); dst.close(); src.close()
print("   saqlandi:", sys.argv[2])
PY

count_rows() {
python - "$1" <<'PY'
import sqlite3, sys
c = sqlite3.connect(sys.argv[1])
out = []
for t in ("users", "attendance", "advances", "work_schedule"):
    try:
        out.append(f"{t}={c.execute(f'SELECT COUNT(*) FROM {t}').fetchone()[0]}")
    except sqlite3.OperationalError:
        out.append(f"{t}=-")
print(" ".join(out))
PY
}
BEFORE="$(count_rows "$DB_FILE")"
echo "   yozuvlar: $BEFORE"

echo "== 2/6 Kutubxonalar (yangi: fpdf2)"
pip install -q -r requirements.txt || { echo "[XATO] pip install muvaffaqiyatsiz. To'xtatildi."; exit 1; }

echo "== 3/6 Kod va baza migratsiyasini tekshirish"
python - <<'PY' || { echo "[XATO] Kod yoki migratsiya xatosi. Zaxira: backups/before_update_*.db. To'xtatildi."; exit 1; }
import config, database
database.init_db()
import repo, webapp, main  # noqa: F401 - import xatosi bo'lmasligi
print("   migratsiya OK, foydalanuvchilar:", len(repo.list_users(include_archived=True, include_admins=True)))
PY
AFTER="$(count_rows "$DB_FILE")"
echo "   yozuvlar: $AFTER"
if [ "$BEFORE" != "$AFTER" ]; then
    echo "[DIQQAT] Yozuvlar soni o'zgardi! Oldin: $BEFORE | Keyin: $AFTER"
    echo "         Zaxira: backups/before_update_$STAMP.db - botni qayta ishga tushirmayman."; exit 1
fi

echo "== 4/6 Eskirgan fayllarni chetga olish (o'chirilmaydi)"
OLD="backups/old_code_$STAMP"
for f in app.py db.py debug_env.py cron webapp test_logic.py test_checkout.py test_webapp.py; do
    if [ -e "$f" ]; then mkdir -p "$OLD"; mv "$f" "$OLD/" && echo "   $f -> $OLD/"; fi
done
CRON_NOW="$(crontab -l 2>/dev/null || true)"
if echo "$CRON_NOW" | grep -q "came.mylogo.uz/cron/"; then
    echo "$CRON_NOW" > "backups/crontab_$STAMP.txt"
    echo "$CRON_NOW" | grep -v "came.mylogo.uz/cron/" | crontab -
    echo "   eski cron/*.py vazifalari o'chirildi (nusxa: backups/crontab_$STAMP.txt)"
fi

echo "== 5/6 Telegram token tekshiruvi"
python - <<'PY'
import json, urllib.request, config
try:
    r = json.load(urllib.request.urlopen(f"https://api.telegram.org/bot{config.BOT_TOKEN}/getMe", timeout=15))
    print("   bot:", "@" + r["result"]["username"])
except Exception as e:
    print("   [DIQQAT] Token ishlamayapti:", e, "- .env dagi BOT_TOKEN ni yangilang")
PY

echo "== 6/6 Qayta ishga tushirish"
mkdir -p tmp && touch tmp/restart.txt && echo "   Web Panel (Passenger) qayta ishga tushadi"
if [ -f bot.pid ] && kill -0 "$(cat bot.pid)" 2>/dev/null; then
    kill "$(cat bot.pid)" && echo "   eski bot to'xtatildi - watchdog 1 daqiqa ichida yangisini ishga tushiradi"
else
    echo "   bot ishlamayotgan edi - watchdog ishga tushiradi (cron: bot_watchdog.sh)"
fi
echo
echo "[OK] Yangilanish tugadi. Zaxira: backups/before_update_$STAMP.db"
