From ce4573c5eea904c77773f2c2b8a7b6cd74977f15 Mon Sep 17 00:00:00 2001 From: Ellie Huxtable Date: Wed, 25 Oct 2023 20:54:20 +0100 Subject: Fix deleted history count (#1328) --- atuin-client/src/database.rs | 13 +++++++------ 1 file changed, 7 insertions(+), 6 deletions(-) (limited to 'atuin-client/src/database.rs') diff --git a/atuin-client/src/database.rs b/atuin-client/src/database.rs index a7be9436..2e4211aa 100644 --- a/atuin-client/src/database.rs +++ b/atuin-client/src/database.rs @@ -346,12 +346,13 @@ impl Database for Sqlite { } async fn history_count(&self, include_deleted: bool) -> Result { - let exclude_deleted: &str = if include_deleted { "" } else { "not" }; - let query = format!( - "select count(1) from history where deleted_at is {} null", - exclude_deleted - ); - let res: (i64,) = sqlx::query_as(&query).fetch_one(&self.pool).await?; + let query = if include_deleted { + "select count(1) from history" + } else { + "select count(1) from history where deleted_at is null" + }; + + let res: (i64,) = sqlx::query_as(query).fetch_one(&self.pool).await?; Ok(res.0) } -- cgit v1.3.1