AB queries for payees

2 files changed, 14 insertions, 0 deletions

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;