#!/bin/bash
DB_PATH="/Users/gaotu/WebstormProjects/dysync.net/db/dy.sqlite"

echo "=== 数据库检查 ==="
echo ""

echo "1. 视频记录总数:"
sqlite3 "$DB_PATH" "SELECT COUNT(*) FROM dy_collect_video;"

echo ""
echo "2. 有保存路径的视频数量:"
sqlite3 "$DB_PATH" "SELECT COUNT(*) FROM dy_collect_video WHERE videoSavePath IS NOT NULL AND videoSavePath != '';"

echo ""
echo "3. Cookie配置数量:"
sqlite3 "$DB_PATH" "SELECT COUNT(*) FROM dy_user_cookies;"

echo ""
echo "4. Cookie配置详情:"
sqlite3 -header -column "$DB_PATH" "SELECT id, userName, savePath, favSavePath, uperSavePath, collHasSyncd FROM dy_user_cookies LIMIT 5;"

echo ""
echo "5. 视频记录示例（前3条）:"
sqlite3 -header -column "$DB_PATH" "SELECT id, videoTitle, author, videoSavePath, fileSize FROM dy_collect_video LIMIT 3;"

echo ""
echo "6. 检查视频文件是否存在:"
sqlite3 "$DB_PATH" "SELECT videoSavePath FROM dy_collect_video WHERE videoSavePath IS NOT NULL AND videoSavePath != '' LIMIT 1;" | while read path; do
  if [ -n "$path" ]; then
    echo "检查: $path"
    if [ -f "$path" ]; then
      echo "✅ 文件存在"
      ls -lh "$path" | awk '{print "   大小: " $5}'
    else
      echo "❌ 文件不存在"
    fi
  fi
done