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.

1 files changed, 20 insertions, 0 deletions

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"