From 8fc5b5f373ef7c602d3abcfb2c1bf75c7a2300b8 Mon Sep 17 00:00:00 2001
From: Teddy Wing
Date: Sat, 12 Mar 2022 00:09:23 +0100
Subject: yaml_extract: Trying to build up a SQL insert statement

Doesn't work yet as I need a way to convert `Yaml` values to Rusqlite
SQL params.
---
 src/main.rs | 20 ++++++++++++++++++++
 1 file changed, 20 insertions(+)

(limited to 'src')

diff --git a/src/main.rs b/src/main.rs
index e064baa..0c445fe 100644
--- a/src/main.rs
+++ b/src/main.rs
@@ -52,6 +52,26 @@ fn yaml_extract(
                 }
             }
 
+            let mut stmt = tx.prepare(
+                &format!(
+                    r#"
+                        INSERT INTO "people"
+                            ({})
+                        VALUES
+                            ({});
+                    "#,
+                    // Wrap column names in quotes.
+                    hash.keys()
+                        .map(|k| format!(r#""{}""#, k.as_str().unwrap()))
+                        .collect::<Vec<String>>()
+                        .join(", "),
+                    // TODO: get len "?"s
+                    format!("{}?", "?, ".repeat(hash.len() - 1)),
+                )
+            ).unwrap();
+
+            // stmt.insert(rusqlite::params_from_iter(hash.values())).unwrap();
+
             // tx.execute(
             //     r#"
             //         INSERT INTO "people"
-- 
cgit v1.2.3