Renames app to 'schist'

34 files changed, 0 insertions, 548 deletions

diff --git a/rust/core/src/queries/accounts/delete_all.rs b/rust/core/src/queries/accounts/delete_all.rs
deleted file mode 100644
index 84d7bf6..0000000
--- a/rust/core/src/queries/accounts/delete_all.rs
+++ /dev/null
@@ -1,11 +0,0 @@
-use anyhow::{Context, Result};
-use diesel::{RunQueryDsl, SqliteConnection};
-
-use crate::schema::accounts::dsl::accounts;
-
-pub fn delete_all_accounts(connection: &mut SqliteConnection) -> Result<usize> {
-    let num_rows_deleted = diesel::delete(accounts)
-        .execute(connection)
-        .with_context(|| "failed to delete all accounts")?;
-    Ok(num_rows_deleted)
-}
diff --git a/rust/core/src/queries/accounts/get_all.rs b/rust/core/src/queries/accounts/get_all.rs
deleted file mode 100644
index ab53729..0000000
--- a/rust/core/src/queries/accounts/get_all.rs
+++ /dev/null
@@ -1,10 +0,0 @@
-use anyhow::{Context, Result};
-use crate::{models::account::Account, schema::accounts::dsl::accounts};
-use diesel::{QueryDsl, RunQueryDsl, SelectableHelper, SqliteConnection};
-
-pub fn get_all_accounts(connection: &mut SqliteConnection) -> Result<Vec<Account>> {
-    let all_accounts = accounts.select(Account::as_select())
-        .load(connection)
-        .with_context(|| "failed to get all accounts")?;
-    Ok(all_accounts)
-}
diff --git a/rust/core/src/queries/accounts/insert.rs b/rust/core/src/queries/accounts/insert.rs
deleted file mode 100644
index 7020b68..0000000
--- a/rust/core/src/queries/accounts/insert.rs
+++ /dev/null
@@ -1,28 +0,0 @@
-use anyhow::{Context, Result};
-use crate::{
-    models::account::Account,
-    schema::accounts::dsl::accounts as accounts_table,
-};
-use diesel::prelude::*;
-
-pub fn insert_accounts(
-    accounts: &[Account],
-    connection: &mut SqliteConnection,
-) -> Result<usize> {
-    let num_accounts_inserted = diesel::insert_into(accounts_table)
-        .values(accounts)
-        .execute(connection)
-        .with_context(|| err_msg(accounts))?;
-    Ok(num_accounts_inserted)
-}
-
-fn err_msg(accounts: &[Account]) -> String {
-    format!(
-        "failed to insert accounts: [{}]",
-        accounts
-            .iter()
-            .map(|a| format!("\"{}\": \"{}\"", a.id, a.name))
-            .collect::<Vec<String>>()
-            .join(", ")
-    )
-}
diff --git a/rust/core/src/queries/accounts/mod.rs b/rust/core/src/queries/accounts/mod.rs
deleted file mode 100644
index 222b180..0000000
--- a/rust/core/src/queries/accounts/mod.rs
+++ /dev/null
@@ -1,7 +0,0 @@
-mod delete_all;
-mod get_all;
-mod insert;
-
-pub use delete_all::delete_all_accounts;
-pub use get_all::get_all_accounts;
-pub use insert::insert_accounts;
diff --git a/rust/core/src/queries/budget_updates/delete_all.rs b/rust/core/src/queries/budget_updates/delete_all.rs
deleted file mode 100644
index b7ad082..0000000
--- a/rust/core/src/queries/budget_updates/delete_all.rs
+++ /dev/null
@@ -1,11 +0,0 @@
-use anyhow::{Context, Result};
-use diesel::{RunQueryDsl, SqliteConnection};
-
-use crate::schema::budget_updates::dsl::budget_updates;
-
-pub fn delete_all_budget_updates(connection: &mut SqliteConnection) -> Result<usize> {
-    let num_rows_deleted = diesel::delete(budget_updates)
-        .execute(connection)
-        .with_context(|| "failed to delete all budget updates")?;
-    Ok(num_rows_deleted)
-}
diff --git a/rust/core/src/queries/budget_updates/get_all.rs b/rust/core/src/queries/budget_updates/get_all.rs
deleted file mode 100644
index 9c9310b..0000000
--- a/rust/core/src/queries/budget_updates/get_all.rs
+++ /dev/null
@@ -1,16 +0,0 @@
-use anyhow::{Context, Result};
-use crate::{
-    models::budget_update::BudgetUpdate,
-    schema::budget_updates::dsl::budget_updates as budget_updates_table,
-};
-use diesel::{QueryDsl, RunQueryDsl, SelectableHelper, SqliteConnection};
-
-pub fn get_all_budget_updates(
-    connection: &mut SqliteConnection,
-) -> Result<Vec<BudgetUpdate>> {
-    let all_budget_updates = budget_updates_table
-        .select(BudgetUpdate::as_select())
-        .load::<BudgetUpdate>(connection)
-        .with_context(|| "failed to get all budget updates")?;
-    Ok(all_budget_updates)
-}
diff --git a/rust/core/src/queries/budget_updates/get_first_with_date_and_category_id.rs b/rust/core/src/queries/budget_updates/get_first_with_date_and_category_id.rs
deleted file mode 100644
index 2d8f97c..0000000
--- a/rust/core/src/queries/budget_updates/get_first_with_date_and_category_id.rs
+++ /dev/null
@@ -1,25 +0,0 @@
-use anyhow::{Context, Result};
-use crate::{
-    models::{budget_update::BudgetUpdate, date_utc::DateUtc},
-    schema::budget_updates::{
-        self as budget_updates_schema, dsl::budget_updates as budget_updates_table,
-    },
-};
-use diesel::{
-    ExpressionMethods, OptionalExtension, QueryDsl, RunQueryDsl, SelectableHelper, SqliteConnection
-};
-
-pub fn get_first_budget_update_with_date_and_category_id(
-    date: &DateUtc,
-    category_id: i32,
-    connection: &mut SqliteConnection,
-) -> Result<Option<BudgetUpdate>> {
-    let first_budget_update = budget_updates_table
-        .select(BudgetUpdate::as_select())
-        .filter(budget_updates_schema::date.eq(date.to_string()))
-        .filter(budget_updates_schema::category_id.eq(category_id))
-        .first(connection)
-        .optional()
-        .with_context(|| format!("failed to get first budget update with date {}", date.to_string()))?;
-    Ok(first_budget_update)
-}
diff --git a/rust/core/src/queries/budget_updates/get_most_recent_with_category_id.rs b/rust/core/src/queries/budget_updates/get_most_recent_with_category_id.rs
deleted file mode 100644
index 41ef5ec..0000000
--- a/rust/core/src/queries/budget_updates/get_most_recent_with_category_id.rs
+++ /dev/null
@@ -1,21 +0,0 @@
-use anyhow::{Context, Result};
-use crate::{
-    models::date_utc::DateUtc,
-    schema::budget_updates::{
-        self as budget_updates_schema, dsl::budget_updates as budget_updates_table,
-    }, traits::nowlike::Nowlike,
-};
-use diesel::{dsl::max, ExpressionMethods, QueryDsl, RunQueryDsl, SqliteConnection};
-
-pub fn get_most_recent_budget_update_date_with_category_id(
-    category_id: i32,
-    connection: &mut SqliteConnection,
-) -> Result<Option<DateUtc>> {
-    let most_recent_date = budget_updates_table
-        .select(max(budget_updates_schema::date))
-        .filter(budget_updates_schema::category_id.eq(category_id))
-        .filter(budget_updates_schema::date.le(DateUtc::now()))
-        .first(connection)
-        .with_context(|| format!("failed to get most recent budget update date with category ID {}", category_id))?;
-    Ok(most_recent_date)
-}
diff --git a/rust/core/src/queries/budget_updates/insert.rs b/rust/core/src/queries/budget_updates/insert.rs
deleted file mode 100644
index e8ae271..0000000
--- a/rust/core/src/queries/budget_updates/insert.rs
+++ /dev/null
@@ -1,28 +0,0 @@
-use anyhow::{Context, Result};
-use crate::{
-    models::budget_update::BudgetUpdate,
-    schema::budget_updates::dsl::budget_updates as budget_updates_table,
-};
-use diesel::prelude::*;
-
-pub fn insert_budget_updates(
-    budget_updates: &[BudgetUpdate],
-    connection: &mut SqliteConnection,
-) -> Result<usize> {
-    let num_rows_inserted = diesel::insert_into(budget_updates_table)
-        .values(budget_updates)
-        .execute(connection)
-        .with_context(|| err_msg(budget_updates))?;
-    Ok(num_rows_inserted)
-}
-
-fn err_msg(budget_updates: &[BudgetUpdate]) -> String {
-    format!(
-        "failed to insert budget updates: [{}]",
-        budget_updates
-            .iter()
-            .map(|a| a.id.to_string())
-            .collect::<Vec<String>>()
-            .join(", ")
-    )
-}
diff --git a/rust/core/src/queries/budget_updates/mod.rs b/rust/core/src/queries/budget_updates/mod.rs
deleted file mode 100644
index 6fc7de0..0000000
--- a/rust/core/src/queries/budget_updates/mod.rs
+++ /dev/null
@@ -1,11 +0,0 @@
-mod delete_all;
-mod get_all;
-mod get_first_with_date_and_category_id;
-mod get_most_recent_with_category_id;
-mod insert;
-
-pub use delete_all::delete_all_budget_updates;
-pub use get_all::get_all_budget_updates;
-pub use get_first_with_date_and_category_id::get_first_budget_update_with_date_and_category_id;
-pub use get_most_recent_with_category_id::get_most_recent_budget_update_date_with_category_id;
-pub use insert::insert_budget_updates;
diff --git a/rust/core/src/queries/categories/delete_all.rs b/rust/core/src/queries/categories/delete_all.rs
deleted file mode 100644
index 1fd2581..0000000
--- a/rust/core/src/queries/categories/delete_all.rs
+++ /dev/null
@@ -1,11 +0,0 @@
-use anyhow::{Context, Result};
-use diesel::{RunQueryDsl, SqliteConnection};
-
-use crate::schema::categories::dsl::categories;
-
-pub fn delete_all_categories(connection: &mut SqliteConnection) -> Result<usize> {
-    let num_rows_deleted = diesel::delete(categories)
-        .execute(connection)
-        .with_context(|| "failed to delete all categories")?;
-    Ok(num_rows_deleted)
-}
diff --git a/rust/core/src/queries/categories/get_all.rs b/rust/core/src/queries/categories/get_all.rs
deleted file mode 100644
index 431ed9c..0000000
--- a/rust/core/src/queries/categories/get_all.rs
+++ /dev/null
@@ -1,11 +0,0 @@
-use anyhow::{Context, Result};
-use crate::{models::category::Category, schema::categories::dsl::categories as categories_table};
-use diesel::{QueryDsl, RunQueryDsl, SelectableHelper, SqliteConnection};
-
-pub fn get_all_categories(connection: &mut SqliteConnection) -> Result<Vec<Category>> {
-    let all_categories = categories_table
-        .select(Category::as_select())
-        .load(connection)
-        .with_context(|| "failed to get all categories")?;
-    Ok(all_categories)
-}
diff --git a/rust/core/src/queries/categories/get_all_balances.rs b/rust/core/src/queries/categories/get_all_balances.rs
deleted file mode 100644
index c9a0102..0000000
--- a/rust/core/src/queries/categories/get_all_balances.rs
+++ /dev/null
@@ -1,47 +0,0 @@
-use anyhow::{Context, Result};
-use crate::{models::category_balance::CategoryBalance, queries::{
-        budget_updates::get_all_budget_updates,
-        categories::get_all_categories,
-        category_transfers::{
-            sum_category_transfer_quantity_per_from_category_id,
-            sum_category_transfer_quantity_per_to_category_id,
-        },
-        transaction_categorisations::sum_transaction_categorisation_quantity_per_category_id,
-    }, utils::calculate_category_balance};
-use diesel::SqliteConnection;
-
-pub fn get_all_category_balances(
-    connection: &mut SqliteConnection,
-) -> Result<Vec<CategoryBalance>> {
-    get_all_category_balances_without_context(connection)
-        .with_context(|| "failed to get all category balances")
-}
-
-fn get_all_category_balances_without_context(
-    connection: &mut SqliteConnection,
-) -> Result<Vec<CategoryBalance>> {
-    let categories = get_all_categories(connection)?;
-    let transaction_sums = sum_transaction_categorisation_quantity_per_category_id(connection)?;
-    let category_transfer_from_sums =
-        sum_category_transfer_quantity_per_from_category_id(connection)?;
-    let category_transfer_to_sums = sum_category_transfer_quantity_per_to_category_id(connection)?;
-    let budget_updates = get_all_budget_updates(connection)?;
-
-    let mut balances = Vec::<CategoryBalance>::new();
-    for category in categories {
-        let balance = calculate_category_balance(
-            &category,
-            &transaction_sums,
-            &category_transfer_from_sums,
-            &category_transfer_to_sums,
-            &budget_updates,
-        )?;
-
-        balances.push(CategoryBalance {
-            category_id: category.id,
-            balance: balance.try_into().unwrap(),
-        })
-    }
-
-    Ok(balances)
-}
diff --git a/rust/core/src/queries/categories/get_all_ids.rs b/rust/core/src/queries/categories/get_all_ids.rs
deleted file mode 100644
index 8505e71..0000000
--- a/rust/core/src/queries/categories/get_all_ids.rs
+++ /dev/null
@@ -1,11 +0,0 @@
-use anyhow::{Context, Result};
-use crate::schema::categories::{self as categories_schema, dsl::categories as categories_table};
-use diesel::{QueryDsl, RunQueryDsl, SqliteConnection};
-
-pub fn get_all_category_ids(connection: &mut SqliteConnection) -> Result<Vec<i32>> {
-    let all_category_ids = categories_table
-        .select(categories_schema::id)
-        .load(connection)
-        .with_context(|| "failed to get all category IDs")?;
-    Ok(all_category_ids)
-}
diff --git a/rust/core/src/queries/categories/get_most_recent_budget_per_category_id.rs b/rust/core/src/queries/categories/get_most_recent_budget_per_category_id.rs
deleted file mode 100644
index 9f2e4f6..0000000
--- a/rust/core/src/queries/categories/get_most_recent_budget_per_category_id.rs
+++ /dev/null
@@ -1,52 +0,0 @@
-use anyhow::{Context, Result};
-use crate::{models::{budget::Budget, category_budget::CategoryBudget}, queries::{
-    budget_updates::{
-        get_first_budget_update_with_date_and_category_id, get_most_recent_budget_update_date_with_category_id,
-    },
-    categories::get_all_category_ids,
-}};
-use diesel::SqliteConnection;
-
-pub fn get_most_recent_category_budget_per_category_id(
-    connection: &mut SqliteConnection,
-) -> Result<Vec<CategoryBudget>> {
-    get_most_recent_category_budget_per_category_id_without_context(connection)
-        .with_context(|| "failed to get most recent category budget per category ID")
-}
-
-fn get_most_recent_category_budget_per_category_id_without_context(
-    connection: &mut SqliteConnection,
-) -> Result<Vec<CategoryBudget>> {
-    let category_ids: Vec<i32> = get_all_category_ids(connection)?;
-
-    let mut budgets = Vec::<CategoryBudget>::new();
-    for category_id in category_ids {
-        let most_recent_budget_update_date =
-            get_most_recent_budget_update_date_with_category_id(category_id, connection)?;
-
-        if most_recent_budget_update_date.is_none() {
-            budgets.push(CategoryBudget {
-                category_id,
-                budget: Option::None,
-            });
-            continue;
-        }
-        let most_recent_budget_update_date = most_recent_budget_update_date.unwrap();
-
-        let most_recent_budget_update = get_first_budget_update_with_date_and_category_id(
-            &most_recent_budget_update_date,
-            category_id,
-            connection,
-        )?;
-        // The fact we found the date by getting the most recent budget update
-        // date guarantees that the Option is Some
-        let most_recent_budget_update = most_recent_budget_update.unwrap();
-
-        budgets.push(CategoryBudget {
-            category_id,
-            budget: Some(Budget::from(&most_recent_budget_update)),
-        });
-    }
-
-    Ok(budgets)
-}
diff --git a/rust/core/src/queries/categories/insert.rs b/rust/core/src/queries/categories/insert.rs
deleted file mode 100644
index bccba72..0000000
--- a/rust/core/src/queries/categories/insert.rs
+++ /dev/null
@@ -1,28 +0,0 @@
-use anyhow::{Context, Result};
-use crate::{
-    models::category::Category,
-    schema::categories::dsl::categories as categories_table,
-};
-use diesel::prelude::*;
-
-pub fn insert_categories(
-    categories: &[Category],
-    connection: &mut SqliteConnection,
-) -> Result<usize> {
-    let num_categories_inserted = diesel::insert_into(categories_table)
-        .values(categories)
-        .execute(connection)
-        .with_context(|| err_msg(categories))?;
-    Ok(num_categories_inserted)
-}
-
-fn err_msg(categories: &[Category]) -> String {
-    format!(
-        "failed to insert categories: [{}]",
-        categories
-            .iter()
-            .map(|a| format!("\"{}\": \"{}\"", a.id, a.name))
-            .collect::<Vec<String>>()
-            .join(", ")
-    )
-}
diff --git a/rust/core/src/queries/categories/mod.rs b/rust/core/src/queries/categories/mod.rs
deleted file mode 100644
index edeeebf..0000000
--- a/rust/core/src/queries/categories/mod.rs
+++ /dev/null
@@ -1,13 +0,0 @@
-mod delete_all;
-mod get_all;
-mod get_all_balances;
-mod get_all_ids;
-mod get_most_recent_budget_per_category_id;
-mod insert;
-
-pub use delete_all::delete_all_categories;
-pub use get_all::get_all_categories;
-pub use get_all_balances::get_all_category_balances;
-pub use get_all_ids::get_all_category_ids;
-pub use get_most_recent_budget_per_category_id::get_most_recent_category_budget_per_category_id;
-pub use insert::insert_categories;
diff --git a/rust/core/src/queries/category_transfers/delete_all.rs b/rust/core/src/queries/category_transfers/delete_all.rs
deleted file mode 100644
index 406b80b..0000000
--- a/rust/core/src/queries/category_transfers/delete_all.rs
+++ /dev/null
@@ -1,7 +0,0 @@
-use diesel::{result::Error, RunQueryDsl, SqliteConnection};
-
-use crate::schema::category_transfers::dsl::category_transfers;
-
-pub fn delete_all_category_transfers(connection: &mut SqliteConnection) -> Result<usize, Error> {
-    diesel::delete(category_transfers).execute(connection)
-}
diff --git a/rust/core/src/queries/category_transfers/get_all.rs b/rust/core/src/queries/category_transfers/get_all.rs
deleted file mode 100644
index 73d7e10..0000000
--- a/rust/core/src/queries/category_transfers/get_all.rs
+++ /dev/null
@@ -1,11 +0,0 @@
-use anyhow::{Context, Result};
-use crate::{models::category_transfer::CategoryTransfer, schema::category_transfers::dsl::category_transfers as category_transfers_table};
-use diesel::{QueryDsl, RunQueryDsl, SelectableHelper, SqliteConnection};
-
-pub fn get_all_category_transfers(connection: &mut SqliteConnection) -> Result<Vec<CategoryTransfer>> {
-    let all_category_transfers = category_transfers_table
-        .select(CategoryTransfer::as_select())
-        .load(connection)
-        .with_context(|| "failed to get all category transfers")?;
-    Ok(all_category_transfers)
-}
diff --git a/rust/core/src/queries/category_transfers/insert.rs b/rust/core/src/queries/category_transfers/insert.rs
deleted file mode 100644
index e1db167..0000000
--- a/rust/core/src/queries/category_transfers/insert.rs
+++ /dev/null
@@ -1,15 +0,0 @@
-use crate::{
-    models::category_transfer::CategoryTransfer,
-    schema::category_transfers::dsl::category_transfers as category_transfers_table,
-};
-use diesel::prelude::*;
-use diesel::result::Error;
-
-pub fn insert_category_transfers(
-    category_transfers: &[CategoryTransfer],
-    connection: &mut SqliteConnection,
-) -> Result<usize, Error> {
-    diesel::insert_into(category_transfers_table)
-        .values(category_transfers)
-        .execute(connection)
-}
diff --git a/rust/core/src/queries/category_transfers/mod.rs b/rust/core/src/queries/category_transfers/mod.rs
deleted file mode 100644
index eed7946..0000000
--- a/rust/core/src/queries/category_transfers/mod.rs
+++ /dev/null
@@ -1,11 +0,0 @@
-mod delete_all;
-mod get_all;
-mod insert;
-mod sum_quantity_per_from_category_id;
-mod sum_quantity_per_to_category_id;
-
-pub use delete_all::delete_all_category_transfers;
-pub use get_all::get_all_category_transfers;
-pub use insert::insert_category_transfers;
-pub use sum_quantity_per_from_category_id::sum_category_transfer_quantity_per_from_category_id;
-pub use sum_quantity_per_to_category_id::sum_category_transfer_quantity_per_to_category_id;
diff --git a/rust/core/src/queries/category_transfers/sum_quantity_per_from_category_id.rs b/rust/core/src/queries/category_transfers/sum_quantity_per_from_category_id.rs
deleted file mode 100644
index a9c2a8c..0000000
--- a/rust/core/src/queries/category_transfers/sum_quantity_per_from_category_id.rs
+++ /dev/null
@@ -1,18 +0,0 @@
-use crate::schema::category_transfers::{
-    self as category_transfers_schema,
-    dsl::category_transfers as category_transfers_table,
-};
-use diesel::{dsl::sum, result::Error, QueryDsl, RunQueryDsl, SqliteConnection};
-
-pub fn sum_category_transfer_quantity_per_from_category_id(
-    connection: &mut SqliteConnection,
-) -> Result<Vec<(i32, i64)>, Error> {
-    category_transfers_table
-        .group_by(category_transfers_schema::from_category_id)
-        .select((
-            category_transfers_schema::from_category_id,
-            sum(category_transfers_schema::quantity),
-        ))
-        .load::<(i32, Option<i64>)>(connection)
-        .map(|result| result.iter().map(|sum| (sum.0, sum.1.unwrap_or(0))).collect())
-}
diff --git a/rust/core/src/queries/category_transfers/sum_quantity_per_to_category_id.rs b/rust/core/src/queries/category_transfers/sum_quantity_per_to_category_id.rs
deleted file mode 100644
index f041477..0000000
--- a/rust/core/src/queries/category_transfers/sum_quantity_per_to_category_id.rs
+++ /dev/null
@@ -1,18 +0,0 @@
-use crate::schema::category_transfers::{
-    self as category_transfers_schema,
-    dsl::category_transfers as category_transfers_table,
-};
-use diesel::{dsl::sum, result::Error, QueryDsl, RunQueryDsl, SqliteConnection};
-
-pub fn sum_category_transfer_quantity_per_to_category_id(
-    connection: &mut SqliteConnection,
-) -> Result<Vec<(i32, i64)>, Error> {
-    category_transfers_table
-        .group_by(category_transfers_schema::to_category_id)
-        .select((
-            category_transfers_schema::to_category_id,
-            sum(category_transfers_schema::quantity),
-        ))
-        .load::<(i32, Option<i64>)>(connection)
-        .map(|vec| vec.iter().map(|(id, sum)| (*id, sum.unwrap_or(0))).collect())
-}
diff --git a/rust/core/src/queries/clear.rs b/rust/core/src/queries/clear.rs
deleted file mode 100644
index e704634..0000000
--- a/rust/core/src/queries/clear.rs
+++ /dev/null
@@ -1,20 +0,0 @@
-use anyhow::Result;
-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::SqliteConnection;
-
-pub fn clear(connection: &mut SqliteConnection) -> Result<()> {
-    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(())
-}
diff --git a/rust/core/src/queries/mod.rs b/rust/core/src/queries/mod.rs
deleted file mode 100644
index f0852ce..0000000
--- a/rust/core/src/queries/mod.rs
+++ /dev/null
@@ -1,7 +0,0 @@
-pub mod accounts;
-pub mod budget_updates;
-pub mod categories;
-pub mod category_transfers;
-pub mod clear;
-pub mod transactions;
-pub mod transaction_categorisations;
diff --git a/rust/core/src/queries/transaction_categorisations/delete_all.rs b/rust/core/src/queries/transaction_categorisations/delete_all.rs
deleted file mode 100644
index e80a0ca..0000000
--- a/rust/core/src/queries/transaction_categorisations/delete_all.rs
+++ /dev/null
@@ -1,7 +0,0 @@
-use diesel::{result::Error, RunQueryDsl, SqliteConnection};
-
-use crate::schema::transaction_categorisations::dsl::transaction_categorisations;
-
-pub fn delete_all_transaction_categorisations(connection: &mut SqliteConnection) -> Result<usize, Error> {
-    diesel::delete(transaction_categorisations).execute(connection)
-}
diff --git a/rust/core/src/queries/transaction_categorisations/get_all.rs b/rust/core/src/queries/transaction_categorisations/get_all.rs
deleted file mode 100644
index 0cacfe6..0000000
--- a/rust/core/src/queries/transaction_categorisations/get_all.rs
+++ /dev/null
@@ -1,11 +0,0 @@
-use anyhow::{Context, Result};
-use crate::{models::transaction_categorisation::TransactionCategorisation, schema::transaction_categorisations::dsl::transaction_categorisations as transaction_categorisations_table};
-use diesel::{QueryDsl, RunQueryDsl, SelectableHelper, SqliteConnection};
-
-pub fn get_all_transaction_categorisations(connection: &mut SqliteConnection) -> Result<Vec<TransactionCategorisation>> {
-    let all_transaction_categorisations = transaction_categorisations_table
-        .select(TransactionCategorisation::as_select())
-        .load(connection)
-        .with_context(|| "failed to get all transaction categorisations")?;
-    Ok(all_transaction_categorisations)
-}
diff --git a/rust/core/src/queries/transaction_categorisations/insert.rs b/rust/core/src/queries/transaction_categorisations/insert.rs
deleted file mode 100644
index 3da1c33..0000000
--- a/rust/core/src/queries/transaction_categorisations/insert.rs
+++ /dev/null
@@ -1,15 +0,0 @@
-use crate::{
-    models::transaction_categorisation::TransactionCategorisation,
-    schema::transaction_categorisations::dsl::transaction_categorisations as transaction_categorisations_table,
-};
-use diesel::prelude::*;
-use diesel::result::Error;
-
-pub fn insert_transaction_categorisations(
-    transaction_categorisations: &[TransactionCategorisation],
-    connection: &mut SqliteConnection,
-) -> Result<usize, Error> {
-    diesel::insert_into(transaction_categorisations_table)
-        .values(transaction_categorisations)
-        .execute(connection)
-}
diff --git a/rust/core/src/queries/transaction_categorisations/mod.rs b/rust/core/src/queries/transaction_categorisations/mod.rs
deleted file mode 100644
index d383791..0000000
--- a/rust/core/src/queries/transaction_categorisations/mod.rs
+++ /dev/null
@@ -1,9 +0,0 @@
-mod delete_all;
-mod get_all;
-mod insert;
-mod sum_quantity_per_category_id;
-
-pub use delete_all::delete_all_transaction_categorisations;
-pub use get_all::get_all_transaction_categorisations;
-pub use insert::insert_transaction_categorisations;
-pub use sum_quantity_per_category_id::sum_transaction_categorisation_quantity_per_category_id;
diff --git a/rust/core/src/queries/transaction_categorisations/sum_quantity_per_category_id.rs b/rust/core/src/queries/transaction_categorisations/sum_quantity_per_category_id.rs
deleted file mode 100644
index 61f3492..0000000
--- a/rust/core/src/queries/transaction_categorisations/sum_quantity_per_category_id.rs
+++ /dev/null
@@ -1,18 +0,0 @@
-use crate::schema::transaction_categorisations::{
-    self as transaction_categorisations_schema,
-    dsl::transaction_categorisations as transaction_categorisations_table,
-};
-use diesel::{dsl::sum, result::Error, QueryDsl, RunQueryDsl, SqliteConnection};
-
-pub fn sum_transaction_categorisation_quantity_per_category_id(
-    connection: &mut SqliteConnection,
-) -> Result<Vec<(i32, i64)>, Error> {
-    transaction_categorisations_table
-        .group_by(transaction_categorisations_schema::category_id)
-        .select((
-            transaction_categorisations_schema::category_id,
-            sum(transaction_categorisations_schema::quantity),
-        ))
-        .load::<(i32, Option<i64>)>(connection)
-        .map(|vec| vec.iter().map(|(category_id, sum)| (*category_id, sum.unwrap_or(0))).collect())
-}
diff --git a/rust/core/src/queries/transactions/delete_all.rs b/rust/core/src/queries/transactions/delete_all.rs
deleted file mode 100644
index 43b7976..0000000
--- a/rust/core/src/queries/transactions/delete_all.rs
+++ /dev/null
@@ -1,7 +0,0 @@
-use diesel::{result::Error, RunQueryDsl, SqliteConnection};
-
-use crate::schema::transactions::dsl::transactions;
-
-pub fn delete_all_transactions(connection: &mut SqliteConnection) -> Result<usize, Error> {
-    diesel::delete(transactions).execute(connection)
-}
diff --git a/rust/core/src/queries/transactions/get_all.rs b/rust/core/src/queries/transactions/get_all.rs
deleted file mode 100644
index afb87f4..0000000
--- a/rust/core/src/queries/transactions/get_all.rs
+++ /dev/null
@@ -1,11 +0,0 @@
-use anyhow::{Context, Result};
-use crate::{models::transaction::Transaction, schema::transactions::dsl::transactions as transactions_table};
-use diesel::{QueryDsl, RunQueryDsl, SelectableHelper, SqliteConnection};
-
-pub fn get_all_transactions(connection: &mut SqliteConnection) -> Result<Vec<Transaction>> {
-    let all_transactions = transactions_table
-        .select(Transaction::as_select())
-        .load(connection)
-        .with_context(|| "failed to get all category transfers")?;
-    Ok(all_transactions)
-}
diff --git a/rust/core/src/queries/transactions/insert.rs b/rust/core/src/queries/transactions/insert.rs
deleted file mode 100644
index 32f3dc2..0000000
--- a/rust/core/src/queries/transactions/insert.rs
+++ /dev/null
@@ -1,15 +0,0 @@
-use crate::{
-    models::transaction::Transaction,
-    schema::transactions::dsl::transactions as transactions_table,
-};
-use diesel::prelude::*;
-use diesel::result::Error;
-
-pub fn insert_transactions(
-    transactions: &[Transaction],
-    connection: &mut SqliteConnection,
-) -> Result<usize, Error> {
-    diesel::insert_into(transactions_table)
-        .values(transactions)
-        .execute(connection)
-}
diff --git a/rust/core/src/queries/transactions/mod.rs b/rust/core/src/queries/transactions/mod.rs
deleted file mode 100644
index 983e9af..0000000
--- a/rust/core/src/queries/transactions/mod.rs
+++ /dev/null
@@ -1,7 +0,0 @@
-mod delete_all;
-mod get_all;
-mod insert;
-
-pub use delete_all::delete_all_transactions;
-pub use get_all::get_all_transactions;
-pub use insert::insert_transactions;