#!/usr/bin/env python3
"""检查生产DB的触发器"""
import sqlite3
conn = sqlite3.connect("/root/search.db")
cur = conn.cursor()
cur.execute("SELECT name, sql FROM sqlite_master WHERE type='trigger' AND sql LIKE '%gov_raw%'")
rows = cur.fetchall()
for name, sql in rows:
    print(f"触发器: {name}")
    print(f"SQL: {sql[:500]}")
    print("---")
if not rows:
    print("无针对gov_raw的触发器")
conn.close()