src/ande_ban/events.py:40:        conn.execute(
src/ande_ban/events.py:83:            conn.execute(
src/ande_ban/campaigns.py:156:    rows = conn.execute(
src/ande_ban/campaigns.py:196:    columns = [description[0] for description in conn.execute(
src/ande_ban/metrics.py:41:        'events': conn.execute('SELECT COUNT(*) FROM events').fetchone()[0],
src/ande_ban/metrics.py:42:        'active_bans': conn.execute('SELECT COUNT(*) FROM active_bans').fetchone()[0],
src/ande_ban/metrics.py:43:        'countries': conn.execute(
src/ande_ban/metrics.py:46:        'asns': conn.execute(
src/ande_ban/metrics.py:49:        'jails': conn.execute('SELECT COUNT(*) FROM jail_status').fetchone()[0],
src/ande_ban/metrics.py:50:        'sync_runs': conn.execute('SELECT COUNT(*) FROM sync_runs').fetchone()[0],
src/ande_ban/metrics.py:52:    latest = conn.execute(
src/ande_ban/diagnostics.py:89:            row = conn.execute(
src/ande_ban/diagnostics.py:137:                integrity = conn.execute("PRAGMA quick_check").fetchone()[0]
src/ande_ban/diagnostics.py:138:                event_count = conn.execute("SELECT COUNT(*) FROM events").fetchone()[0]
src/ande_ban/cli.py:169:                "events": conn.execute("SELECT COUNT(*) FROM events").fetchone()[0],
src/ande_ban/cli.py:170:                "bans": conn.execute("SELECT COUNT(*) FROM events WHERE event_type='ban'").fetchone()[0],
src/ande_ban/cli.py:171:                "permanent": conn.execute("SELECT COUNT(*) FROM permanent_blacklist").fetchone()[0],
src/ande_ban/cli.py:177:                rows = conn.execute("SELECT * FROM events WHERE ip=? ORDER BY id DESC LIMIT ?", (args.ip, args.limit))
src/ande_ban/cli.py:179:                rows = conn.execute("SELECT * FROM events ORDER BY id DESC LIMIT ?", (args.limit,))
src/ande_ban/database.py:90:    return {row[1] for row in conn.execute(f"PRAGMA table_info({table})")}
src/ande_ban/database.py:102:            conn.execute(
src/ande_ban/database.py:129:    conn.execute(
src/ande_ban/database.py:133:    conn.execute(
src/ande_ban/database.py:137:    conn.execute(
src/ande_ban/database.py:162:    conn.executescript(SCHEMA)
src/ande_ban/database.py:168:    row = conn.execute(
src/ande_ban/webapp.py:140:                        last = health_conn.execute(
src/ande_ban/webapp.py:193:                    event = conn.execute(
src/ande_ban/webapp.py:199:                        "active_bans": conn.execute("SELECT COUNT(*) FROM active_bans").fetchone()[0],
src/ande_ban/webapp.py:202:                        "countries": conn.execute("SELECT COUNT(DISTINCT country) FROM active_bans WHERE country IS NOT NULL").fetchone()[0],
src/ande_ban/webapp.py:203:                        "permanent": conn.execute("SELECT COUNT(*) FROM permanent_blacklist").fetchone()[0],
src/ande_ban/webapp.py:204:                        "jails": conn.execute("SELECT COUNT(*) FROM jail_status").fetchone()[0],
src/ande_ban/webapp.py:221:                        for row in conn.execute(
src/ande_ban/webapp.py:226:                    aggregate = conn.execute(
src/ande_ban/webapp.py:255:                    (self.send_api if use_envelope else self.send_json)([dict(row) for row in conn.execute(query)])
src/ande_ban/enrich_history.py:53:            rows = conn.execute(
src/ande_ban/enrich_history.py:126:                conn.execute(
src/ande_ban/administration.py:33:        page_count = int(conn.execute("PRAGMA page_count").fetchone()[0])
src/ande_ban/administration.py:34:        page_size = int(conn.execute("PRAGMA page_size").fetchone()[0])
src/ande_ban/administration.py:35:        freelist = int(conn.execute("PRAGMA freelist_count").fetchone()[0])
src/ande_ban/administration.py:36:        quick_check = str(conn.execute("PRAGMA quick_check").fetchone()[0])
src/ande_ban/administration.py:39:            counts[table] = int(conn.execute(f"SELECT COUNT(*) FROM {table}").fetchone()[0])
src/ande_ban/administration.py:40:        indexes = int(conn.execute("SELECT COUNT(*) FROM sqlite_master WHERE type='index'").fetchone()[0])
src/ande_ban/administration.py:60:            conn.execute("ANALYZE")
src/ande_ban/administration.py:62:            conn.execute("VACUUM")
src/ande_ban/sync.py:64:        conn.execute(
src/ande_ban/sync.py:80:        conn.execute(
src/ande_ban/sync.py:103:            event_count_before = conn.execute(
src/ande_ban/sync.py:115:                conn.execute(
src/ande_ban/sync.py:155:                    conn.execute(
src/ande_ban/sync.py:178:            rows = conn.execute(
src/ande_ban/sync.py:183:                    conn.execute(
src/ande_ban/sync.py:190:                conn.execute(
src/ande_ban/sync.py:195:                conn.execute("DELETE FROM jail_status")
src/ande_ban/sync.py:197:            conn.execute(
src/ande_ban/sync.py:202:            event_count_after = conn.execute(
src/ande_ban/maintenance.py:103:            integrity = conn.execute("PRAGMA quick_check").fetchone()[0]
src/ande_ban/maintenance.py:106:            events = conn.execute("SELECT COUNT(*) FROM events").fetchone()[0]
src/ande_ban/maintenance.py:136:            integrity = conn.execute("PRAGMA quick_check").fetchone()[0]
src/ande_ban/maintenance.py:137:            sync_runs = conn.execute("SELECT COUNT(*) FROM sync_runs").fetchone()[0]
src/ande_ban/events.py.before-storage:39:        conn.execute(
src/ande_ban/events.py.before-storage:82:            conn.execute(
src/ande_ban/analytics.py:36:        conn.execute(statement)
src/ande_ban/analytics.py:46:        for row in conn.execute(query, parameters).fetchall()
src/ande_ban/analytics.py:88:        for row in conn.execute(
src/ande_ban/analytics.py:133:    historical_summary_row = conn.execute(
src/ande_ban/analytics.py:154:        "repeat_offenders": conn.execute(
src/ande_ban/analytics.py:166:        "permanent_candidates": conn.execute(
src/ande_ban/analytics.py:323:    repeat_count = conn.execute(
src/ande_ban/analytics.py:336:    active_asns = conn.execute(
src/ande_ban/analytics.py:389:    summary_row = conn.execute(
src/ande_ban/analytics.py:443:        for row in conn.execute(
src/ande_ban/analytics.py:473:    sync_row = conn.execute(
