1 files changed, 16 insertions, 0 deletions
diff --git a/schist_queries/src/clear.rs b/schist_queries/src/clear.rs
new file mode 100644
index 0000000..7cee699
--- /dev/null
+++ b/schist_queries/src/clear.rs
@@ -0,0 +1,16 @@
+use anyhow::Result;
+use diesel::SqliteConnection;
+
+use crate::{
+    accounts::delete_all_accounts, budget_drips::delete_all_budget_drips, categories::delete_all_categories, category_transfers::delete_all_category_transfers, transaction_categorisations::delete_all_transaction_categorisations, transactions::delete_all_transactions
+};
+
+pub fn clear(connection: &mut SqliteConnection) -> Result<()> {
+    delete_all_accounts(connection)?;
+    delete_all_budget_drips(connection)?;
+    delete_all_categories(connection)?;
+    delete_all_category_transfers(connection)?;
+    delete_all_transactions(connection)?;
+    delete_all_transaction_categorisations(connection)?;
+    Ok(())
+}