#!/bin/bash
cd /root/gov_crawler
: > /tmp/misjudge.log
COUNT='import sqlite3,sys
c=sqlite3.connect("file:/root/search.db?mode=ro",uri=True)
print("    ", sys.argv[1], "=", c.execute("SELECT COUNT(*) FROM gov_raw WHERE site_name=?",(sys.argv[2],)).fetchone()[0], "行")'
declare -A S=( [crawl_longtan_zcfg.py]="龙潭区人民政府-政策法规" [crawl_nc_hjbha.py]="南昌市生态环境-政府信息公开" [crawl_yjgx.py]="阳江滨海新区（阳江高新区）-环境保护信息公开" [crawl_hbqj_eia.py]="潜江市人民政府-建设项目环境影响评价公示" )
echo "==== 跑前 ====" >> /tmp/misjudge.log
for f in "${!S[@]}"; do python3 -c "$COUNT" "$f" "${S[$f]}" >> /tmp/misjudge.log 2>&1; done
for f in crawl_longtan_zcfg.py crawl_nc_hjbha.py crawl_yjgx.py crawl_hbqj_eia.py; do
  echo "=== $f" >> /tmp/misjudge.log
  timeout 220 python3 "$f" > /tmp/m_$f.log 2>&1
  echo "EXIT=$? | locked=$(grep -c 'database is locked' /tmp/m_$f.log)" >> /tmp/misjudge.log
  tail -3 /tmp/m_$f.log | sed 's/^/    /' >> /tmp/misjudge.log
  python3 -c "$COUNT" "$f" "${S[$f]}" >> /tmp/misjudge.log 2>&1
done
echo ALLDONE >> /tmp/misjudge.log