summaryrefslogtreecommitdiff
path: root/rust/schist_core/src/queries/accounts/insert.rs
diff options
context:
space:
mode:
authorJoe Carstairs <me@joeac.net>2024-11-17 09:29:32 +0000
committerJoe Carstairs <me@joeac.net>2024-11-17 09:30:04 +0000
commit10f071447594f2bdcec84a461df9ad648f71f44b (patch)
tree645924a4948f39a4d9e2ec270d79fc6c2a3a937a /rust/schist_core/src/queries/accounts/insert.rs
parent1ae19eb3315c40e3f9062592c27fa76c11cf626c (diff)
Renames app to 'schist'
Diffstat (limited to 'rust/schist_core/src/queries/accounts/insert.rs')
-rw-r--r--rust/schist_core/src/queries/accounts/insert.rs28
1 files changed, 28 insertions, 0 deletions
diff --git a/rust/schist_core/src/queries/accounts/insert.rs b/rust/schist_core/src/queries/accounts/insert.rs
new file mode 100644
index 0000000..7020b68
--- /dev/null
+++ b/rust/schist_core/src/queries/accounts/insert.rs
@@ -0,0 +1,28 @@
+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(", ")
+ )
+}