From f75546ed680c80b300dcf4112f03bc3517c84a15 Mon Sep 17 00:00:00 2001
From: Joe Carstairs <me@joeac.net>
Date: Sat, 30 Nov 2024 19:27:46 +0000
Subject: AB queries for payees

---
 rust/actualbudget_queries/src/actualbudget_payees.rs | 13 +++++++++++++
 rust/actualbudget_queries/src/lib.rs                 |  1 +
 2 files changed, 14 insertions(+)
 create mode 100644 rust/actualbudget_queries/src/actualbudget_payees.rs

(limited to 'rust/actualbudget_queries/src')

diff --git a/rust/actualbudget_queries/src/actualbudget_payees.rs b/rust/actualbudget_queries/src/actualbudget_payees.rs
new file mode 100644
index 0000000..d5b0c5f
--- /dev/null
+++ b/rust/actualbudget_queries/src/actualbudget_payees.rs
@@ -0,0 +1,13 @@
+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/rust/actualbudget_queries/src/lib.rs b/rust/actualbudget_queries/src/lib.rs
index e16dafc..ca3f6ea 100644
--- a/rust/actualbudget_queries/src/lib.rs
+++ b/rust/actualbudget_queries/src/lib.rs
@@ -1,4 +1,5 @@
 pub mod actualbudget_accounts;
 pub mod actualbudget_categories;
+pub mod actualbudget_payees;
 pub mod actualbudget_transactions;
 pub mod actualbudget_zero_budgets;
-- 
cgit v1.2.3