import sqlite3, re
conn = sqlite3.connect('/root/search.db')
cur = conn.cursor()
cur.execute("SELECT id, title, length(content), content FROM gov_raw WHERE site_name='汇能控股集团有限公司-公示公告' LIMIT 3")
for row in cur.fetchall():
    paras = [p.strip() for p in re.split(r'\n\n+', row[3]) if p.strip()]
    text_paras = [p for p in paras if not p.startswith('**附件') and not p.startswith('- [')]
    print(f'  {row[1][:40]} | {row[2]}字 | {len(text_paras)}段')
    for p in text_paras[:3]:
        print(f'    ¶ {p[:60]}')
cur.execute("SELECT COUNT(*) FROM gov_raw WHERE site_name='汇能控股集团有限公司-公示公告'")
print(f'\n总计: {cur.fetchone()[0]}条')
cur.execute("SELECT COUNT(*) FROM gov_search WHERE site_name='汇能控股集团有限公司-公示公告'")
print(f'FTS: {cur.fetchone()[0]}条')
conn.close()