#!/usr/bin/env python3
import sqlite3, time

conn = sqlite3.connect('/root/search.db')
conn.execute("PRAGMA journal_mode=WAL")
conn.execute("PRAGMA busy_timeout=30000")

print('Starting FTS rebuild...')
t0 = time.time()
conn.execute("INSERT INTO gov_search(gov_search) VALUES('rebuild')")
conn.commit()
elapsed = time.time() - t0
print(f'Rebuild done in {elapsed:.1f}s')

count = conn.execute('SELECT count(*) FROM gov_search').fetchone()[0]
print(f'FTS rows after rebuild: {count}')
conn.close()