From 9e36f63c6edbd7d675202e873716de9748928b59 Mon Sep 17 00:00:00 2001 From: Ellie Huxtable Date: Mon, 24 Jun 2024 16:46:19 +0100 Subject: fix: ensure we cleanup all tables when deleting (#2191) --- crates/atuin-server-postgres/src/lib.rs | 16 ++++++++++++++-- 1 file changed, 14 insertions(+), 2 deletions(-) (limited to 'crates/atuin-server-postgres/src') diff --git a/crates/atuin-server-postgres/src/lib.rs b/crates/atuin-server-postgres/src/lib.rs index 7aa87424..e28b6e09 100644 --- a/crates/atuin-server-postgres/src/lib.rs +++ b/crates/atuin-server-postgres/src/lib.rs @@ -401,13 +401,19 @@ impl Database for Postgres { .await .map_err(fix_error)?; - sqlx::query("delete from users where id = $1") + sqlx::query("delete from history where user_id = $1") .bind(u.id) .execute(&self.pool) .await .map_err(fix_error)?; - sqlx::query("delete from history where user_id = $1") + sqlx::query("delete from store where user_id = $1") + .bind(u.id) + .execute(&self.pool) + .await + .map_err(fix_error)?; + + sqlx::query("delete from user_verification_token where user_id = $1") .bind(u.id) .execute(&self.pool) .await @@ -419,6 +425,12 @@ impl Database for Postgres { .await .map_err(fix_error)?; + sqlx::query("delete from users where id = $1") + .bind(u.id) + .execute(&self.pool) + .await + .map_err(fix_error)?; + Ok(()) } -- cgit v1.3.1