#!/usr/bin/env python3
import sqlite3
conn = sqlite3.connect("/root/search.db")
cur = conn.cursor()

# Check FTS
r = cur.execute("SELECT count(*) FROM gov_search WHERE gov_search MATCH '晋江'").fetchone()
print("FTS hits for 晋江:", r[0])

r2 = cur.execute("SELECT count(*) FROM gov_raw WHERE site_name='jinjiang.gov.cn-绿色转型-生态环境保护'").fetchone()
print("Total records:", r2[0])

# Check a sample with content
r3 = cur.execute("SELECT title, content[:100] FROM gov_raw WHERE site_name='jinjiang.gov.cn-绿色转型-生态环境保护' AND content LIKE '%table%' LIMIT 3").fetchall()
print("Sample with tables:")
for row in r3:
    print("  Title:", row[0][:40], "| Content has table:", 'table' in (row[1] or '').lower())

conn.close()