import sqlite3

c = sqlite3.connect('/opt/docket/data/docket.db')

c.execute('PRAGMA busy_timeout=30000')

c.row_factory = sqlite3.Row

total = c.execute("SELECT COUNT(*) FROM bills WHERE source='legiscan'").fetchone()[0]

withs = c.execute("SELECT COUNT(*) FROM bills WHERE source='legiscan' AND summary IS NOT NULL AND summary<>''").fetchone()[0]

print("legiscan total:", total, "with_summary:", withs)

rows = c.execute("""SELECT jurisdiction, COUNT(*) n FROM bills

    WHERE source='legiscan' AND summary IS NOT NULL AND summary<>''

    GROUP BY jurisdiction ORDER BY n DESC LIMIT 20""").fetchall()

print("by state:", [(r['jurisdiction'], r['n']) for r in rows])

samp = c.execute("""SELECT jurisdiction, number, substr(summary,1,120) s, summary_source

    FROM bills WHERE source='legiscan' AND summary IS NOT NULL AND summary<>'' LIMIT 5""").fetchall()

for r in samp:

    print("SAMPLE", r['jurisdiction'], r['number'], '|', r['summary_source'], '|', r['s'])