summaryrefslogtreecommitdiff
path: root/rust/core/src/queries/budget_updates/insert.rs
diff options
context:
space:
mode:
authorJoe Carstairs <me@joeac.net>2024-11-17 09:23:28 +0000
committerJoe Carstairs <me@joeac.net>2024-11-17 09:23:28 +0000
commit1ae19eb3315c40e3f9062592c27fa76c11cf626c (patch)
tree09d9ce380795971f4b50e1d4b0ca3c57c9e1db1a /rust/core/src/queries/budget_updates/insert.rs
parent1a494937021561595d0fb29e26fb707aef9e55de (diff)
Renames workspace folder
Diffstat (limited to 'rust/core/src/queries/budget_updates/insert.rs')
-rw-r--r--rust/core/src/queries/budget_updates/insert.rs28
1 files changed, 28 insertions, 0 deletions
diff --git a/rust/core/src/queries/budget_updates/insert.rs b/rust/core/src/queries/budget_updates/insert.rs
new file mode 100644
index 0000000..e8ae271
--- /dev/null
+++ b/rust/core/src/queries/budget_updates/insert.rs
@@ -0,0 +1,28 @@
+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(", ")
+ )
+}