import sqlite3
import sys, os
sys.path.insert(0, "/root/gov_crawler")
from crawler_lib import push_to_searchdb, push_to_searchdb

test = [{
    "site_name": "TEST-寿光",
    "title": "Test item",
    "url": "https://www.shouguang.gov.cn/news/hpgs/test.html",
    "source_url": "https://www.shouguang.gov.cn/news/hpgs/test.html",
    "pub_date": "2026-07-15",
    "content": "Test content body here.",
    "summary": "Test content",
    "attachments": ""
}]

push_to_searchdb(test, "test")

conn = sqlite3.connect("/mnt/data/search.db")
cur = conn.cursor()
rows = cur.execute("select title, source_url from gov_raw where site_name='TEST-寿光'").fetchall()
print("Result:", rows)