1 files changed, 19 insertions, 0 deletions
diff --git a/backend/core/src/queries/clear.rs b/backend/core/src/queries/clear.rs
new file mode 100644
index 0000000..dbe0f84
--- /dev/null
+++ b/backend/core/src/queries/clear.rs
@@ -0,0 +1,19 @@
+use crate::queries::{
+    accounts::delete_all_accounts,
+    budget_updates::delete_all_budget_updates,
+    categories::delete_all_categories,
+    category_transfers::delete_all_category_transfers,
+    transactions::delete_all_transactions,
+    transaction_categorisations::delete_all_transaction_categorisations,
+};
+use diesel::{result::Error, SqliteConnection};
+
+pub fn clear(connection: &mut SqliteConnection) -> Result<(), Error> {
+    delete_all_accounts(connection)?;
+    delete_all_budget_updates(connection)?;
+    delete_all_categories(connection)?;
+    delete_all_category_transfers(connection)?;
+    delete_all_transactions(connection)?;
+    delete_all_transaction_categorisations(connection)?;
+    Ok(())
+}