summaryrefslogtreecommitdiff
path: root/actualbudget_queries/src
diff options
context:
space:
mode:
authorJoe Carstairs <jcarstairs@scottlogic.com>2025-07-28 13:22:53 +0100
committerJoe Carstairs <jcarstairs@scottlogic.com>2025-07-28 13:30:27 +0100
commit2361adeb0ca77904138e3466d51c2f44cf6df613 (patch)
treef6e7192908f99fab62061913d8a1e9d2b918414b /actualbudget_queries/src
parentc7ed1e61ce2218be0b9e60577454124c4e43a366 (diff)
Tidier folders
Diffstat (limited to 'actualbudget_queries/src')
-rw-r--r--actualbudget_queries/src/actualbudget_accounts.rs25
-rw-r--r--actualbudget_queries/src/actualbudget_categories.rs7
-rw-r--r--actualbudget_queries/src/actualbudget_payees.rs13
-rw-r--r--actualbudget_queries/src/actualbudget_transactions.rs23
-rw-r--r--actualbudget_queries/src/actualbudget_zero_budgets.rs20
-rw-r--r--actualbudget_queries/src/lib.rs5
6 files changed, 0 insertions, 93 deletions
diff --git a/actualbudget_queries/src/actualbudget_accounts.rs b/actualbudget_queries/src/actualbudget_accounts.rs
deleted file mode 100644
index d499208..0000000
--- a/actualbudget_queries/src/actualbudget_accounts.rs
+++ /dev/null
@@ -1,25 +0,0 @@
-use actualbudget_models::ActualbudgetAccount;
-use actualbudget_schema::actualbudget_schema::accounts::{
- self as accounts_schema,
- dsl::accounts as accounts_table,
-};
-use anyhow::{Context, Result};
-use diesel::{ExpressionMethods, OptionalExtension, QueryDsl, RunQueryDsl, SelectableHelper, SqliteConnection};
-
-pub fn get_all_actualbudget_accounts(connection: &mut SqliteConnection) -> Result<Vec<ActualbudgetAccount>> {
- let actualbudget_accounts = accounts_table
- .select(ActualbudgetAccount::as_select())
- .load(connection)
- .with_context(|| "failed to get all Actualbudget accounts")?;
- Ok(actualbudget_accounts)
-}
-
-pub fn get_category_transfers_account(connection: &mut SqliteConnection) -> Result<Option<ActualbudgetAccount>> {
- let category_transfers_account = accounts_table
- .filter(accounts_schema::name.eq("Category transfers"))
- .select(ActualbudgetAccount::as_select())
- .first(connection)
- .optional()
- .with_context(|| "failed to get Category Transfers account")?;
- Ok(category_transfers_account)
-}
diff --git a/actualbudget_queries/src/actualbudget_categories.rs b/actualbudget_queries/src/actualbudget_categories.rs
deleted file mode 100644
index 846faf5..0000000
--- a/actualbudget_queries/src/actualbudget_categories.rs
+++ /dev/null
@@ -1,7 +0,0 @@
-use actualbudget_models::ActualbudgetCategory;
-use actualbudget_schema::actualbudget_schema::categories::dsl::categories;
-use diesel::{result::Error, QueryDsl, RunQueryDsl, SelectableHelper, SqliteConnection};
-
-pub fn get_all_actualbudget_categories(connection: &mut SqliteConnection) -> Result<Vec<ActualbudgetCategory>, Error> {
- categories.select(ActualbudgetCategory::as_select()).load(connection)
-}
diff --git a/actualbudget_queries/src/actualbudget_payees.rs b/actualbudget_queries/src/actualbudget_payees.rs
deleted file mode 100644
index d5b0c5f..0000000
--- a/actualbudget_queries/src/actualbudget_payees.rs
+++ /dev/null
@@ -1,13 +0,0 @@
-use actualbudget_models::ActualbudgetPayee;
-use actualbudget_schema::actualbudget_schema::payees::dsl::payees;
-use anyhow::{Result, Context};
-use diesel::{QueryDsl, RunQueryDsl, SelectableHelper, SqliteConnection};
-
-pub fn get_all_actualbudget_payees(
- connection: &mut SqliteConnection,
-) -> Result<Vec<ActualbudgetPayee>> {
- payees
- .select(ActualbudgetPayee::as_select())
- .load(connection)
- .with_context(|| "failed to get actualbudget payees")
-}
diff --git a/actualbudget_queries/src/actualbudget_transactions.rs b/actualbudget_queries/src/actualbudget_transactions.rs
deleted file mode 100644
index 4dc38e8..0000000
--- a/actualbudget_queries/src/actualbudget_transactions.rs
+++ /dev/null
@@ -1,23 +0,0 @@
-use actualbudget_models::{ActualbudgetDate, ActualbudgetTransaction};
-use actualbudget_schema::actualbudget_schema::v_transactions::{
- self as transactions_schema,
- dsl::v_transactions as transactions_table,
-};
-use anyhow::{Context, Result};
-use diesel::{dsl::min, result::Error, QueryDsl, RunQueryDsl, SelectableHelper, SqliteConnection};
-
-pub fn get_all_actualbudget_transactions(connection: &mut SqliteConnection) -> Result<Vec<ActualbudgetTransaction>> {
- let actualbudget_transactions = transactions_table
- .select(ActualbudgetTransaction::as_select())
- .load(connection)
- .with_context(|| "failed to get all Actualbudget transactions")?;
- Ok(actualbudget_transactions)
-}
-
-pub fn get_first_actualbudget_transaction_date(connection: &mut SqliteConnection) -> Result<ActualbudgetDate> {
- let date_as_int = transactions_table
- .select(min(transactions_schema::date))
- .first::<Option<i32>>(connection)
- .map_or_else(|e| Err(e), |o| o.map_or_else(|| Err(Error::NotFound), |i| Ok(i)))?;
- Ok(ActualbudgetDate::from_i32(date_as_int))
-}
diff --git a/actualbudget_queries/src/actualbudget_zero_budgets.rs b/actualbudget_queries/src/actualbudget_zero_budgets.rs
deleted file mode 100644
index 5ae4055..0000000
--- a/actualbudget_queries/src/actualbudget_zero_budgets.rs
+++ /dev/null
@@ -1,20 +0,0 @@
-use anyhow::{Context, Result};
-use actualbudget_models::{actualbudget_schema::zero_budgets as zero_budgets_schema, ActualbudgetDate, ActualbudgetZeroBudget};
-use actualbudget_schema::actualbudget_schema::zero_budgets::dsl::zero_budgets as zero_budgets_table;
-use diesel::{dsl::min, result::Error, QueryDsl, RunQueryDsl, SelectableHelper, SqliteConnection};
-
-pub fn get_all_actualbudget_zero_budgets(connection: &mut SqliteConnection) -> Result<Vec<ActualbudgetZeroBudget>> {
- let zero_budgets = zero_budgets_table
- .select(ActualbudgetZeroBudget::as_select())
- .load(connection)
- .with_context(|| "failed to get all Actualbudget zero budgets")?;
- Ok(zero_budgets)
-}
-
-pub fn get_first_zero_budget_date(connection: &mut SqliteConnection) -> Result<ActualbudgetDate> {
- let date_as_int = zero_budgets_table
- .select(min(zero_budgets_schema::month))
- .first::<Option<i32>>(connection)
- .map_or_else(|e| Err(e), |o| o.map_or_else(|| Err(Error::NotFound), |i| Ok(i)))?;
- Ok(ActualbudgetDate::from_i32(date_as_int))
-}
diff --git a/actualbudget_queries/src/lib.rs b/actualbudget_queries/src/lib.rs
deleted file mode 100644
index ca3f6ea..0000000
--- a/actualbudget_queries/src/lib.rs
+++ /dev/null
@@ -1,5 +0,0 @@
-pub mod actualbudget_accounts;
-pub mod actualbudget_categories;
-pub mod actualbudget_payees;
-pub mod actualbudget_transactions;
-pub mod actualbudget_zero_budgets;