#!/usr/bin/env python3
"""Debug why 0/15 inserted"""
import sqlite3

DB_PATH = "/root/search.db"
conn = sqlite3.connect(DB_PATH)
c = conn.cursor()

# Check if any records remain
c.execute("SELECT COUNT(*) FROM gov_raw WHERE script_name='crawl_ningguo_qtxx.py'")
cnt = c.fetchone()[0]
print(f"crawl_ningguo_qtxx.py records: {cnt}")

# Check if OpennessContent URLs exist from any script
c.execute("SELECT COUNT(*) FROM gov_raw WHERE page_url LIKE '%OpennessContent%'")
oc_cnt = c.fetchone()[0]
print(f"OpennessContent URLs in DB: {oc_cnt}")

# Check if these specific URLs exist
url = "https://www.ningguo.gov.cn/OpennessContent/show/3784926.html"
c.execute("SELECT id, script_name FROM gov_raw WHERE page_url=?", (url,))
row = c.fetchone()
if row:
    print(f"URL exists: id={row[0]}, script={row[1]}")
else:
    print(f"URL does NOT exist (correct)")

# Show last 10 records by id
c.execute("SELECT id, page_url, script_name FROM gov_raw ORDER BY id DESC LIMIT 10")
print("\nLast 10 records:")
for row in c.fetchall():
    print(f"  #{row[0]} {row[1][:60]} script={row[2]}")
conn.close()