j dZddlZddlZddlZddlZdZgZeedd5ZeD]#Z ejeje % ddde de edd Zejj!ese d eej"d ej$eZej)Zej+d e d eD]`Zej/ddZej2ej/dgdZej+dedededeeededfbej7e de edej+dej7e dej+dej7e dej+dej9dZe d eej=e d!y#1swYxYw)"z"Import harvin data into the gov DBNz%/root/gov_crawler/output/harvin.jsonlrzutf-8)encodingzLoaded z recordsz/root/gov_crawler/search.dbzDB not found at zBDELETE FROM gov_raw WHERE link LIKE 'https://www.harvin.cn/news/%'zDeleted existing recordscontent attachmentsF) ensure_asciiznINSERT INTO gov_raw (title, link, date, content, attachments, site_name, "group") VALUES (?, ?, ?, ?, ?, ?, ?)titlelinkdate site_namegroupz Inserted z records into gov_rawa# INSERT OR IGNORE INTO gov_search (rowid_col, title, site_name, summary, link, date, content, attachments, "group") SELECT rowid, title, site_name, substr(content, 1, 200), link, date, content, attachments, "group" FROM gov_raw WHERE link LIKE 'https://www.harvin.cn/news/%' zSynced to gov_searcha& INSERT OR IGNORE INTO gov_search_v3 (rowid_col, title, site_name, summary, link, date, content, attachments, "group") SELECT rowid, title, site_name, substr(content, 1, 200), link, date, content, attachments, "group" FROM gov_raw WHERE link LIKE 'https://www.harvin.cn/news/%' zSynced to gov_search_v3uJSELECT COUNT(*) FROM gov_raw WHERE site_name = '祥云股份-招标公告'zTotal in gov_raw: zImport complete!)__doc__jsonsqlite3ossys jsonl_pathresultsopenflineappendloadsprintlendb_pathpathexistsexitconnectconncursorexecutergetrdumpsrcommitfetchonecountcloseimport_harvin.pyr.s(  5  *cG,))ztzz$'())G ~X&' ( ww~~g WI &' CHHQKww ST " AeeIr"G$**QUU="5EJK NNz 7QvY& 7K;QRSZQ[\   #g,456    ![\!5'"# u))s )G<<H