fix: clear voice_activity upon starting

this lets stale records from abrupt stopping be deleted

1 files changed, 4 insertions, 0 deletions

diff --git a/src/database/mod.rs b/src/database/mod.rs
index 0674477..f2185fb 100644
--- a/src/database/mod.rs
+++ b/src/database/mod.rs
@@ -12,6 +12,10 @@ pub async fn init_pool(path: &str) -> Result<DbPool> {
     }
     let pool = SqlitePool::connect(&format!("sqlite:{path}?mode=rwc")).await?;
     run_migrations(&pool).await?;
+    // Clear stale voice activity records from previous run.
+    sqlx::query("DELETE FROM voice_activity")
+        .execute(&pool)
+        .await?;
     Ok(pool)
 }