From 825355068ba919c9f58593293f917328e7833c20 Mon Sep 17 00:00:00 2001 From: Teddy Wing Date: Fri, 18 Mar 2022 00:49:56 +0100 Subject: select(): Trying to inspect data queried from database Can't get the info from inside the closure it seems. The row iterator doesn't seem to be looping. Not sure what the story is yet. Maybe I'm not converting the data types correctly. --- src/select.rs | 20 ++++++++++++++++++-- src/yaml/sql.rs | 1 + 2 files changed, 19 insertions(+), 2 deletions(-) (limited to 'src') diff --git a/src/select.rs b/src/select.rs index a270ed6..603be1e 100644 --- a/src/select.rs +++ b/src/select.rs @@ -18,6 +18,7 @@ pub fn select( ).unwrap(); let column_count = stmt.column_count(); + dbg!(column_count); let rows = stmt.query_map( rusqlite::named_params! { @@ -39,19 +40,34 @@ pub fn select( // closure. for i in 0..=column_count { - data.push(row.get(i)?); + // data.push(row.get(i)?); + + let value = row.get(i)?; + dbg!(&value); + data.push(value); } + dbg!(&data); Ok(data) }, ).unwrap(); + dbg!("test"); + for row_result in rows { + dbg!("a"); + let row = row_result.unwrap(); + dbg!(&row); + + // return row[0].0.into_owned(); + } + // sqlite3 -header test.db ' // SELECT "name" // FROM pragma_table_info("test") // WHERE "pk" != 0;' - todo!(); + // todo!(); + yaml_rust::Yaml::Null } diff --git a/src/yaml/sql.rs b/src/yaml/sql.rs index 99353c3..49d83f7 100644 --- a/src/yaml/sql.rs +++ b/src/yaml/sql.rs @@ -3,6 +3,7 @@ use yaml_rust::yaml; use std::borrow::Cow; +#[derive(Debug)] pub(crate) struct Yaml<'a>(pub Cow<'a, yaml::Yaml>); // impl<'a, Y> From for Yaml<'a> -- cgit v1.2.3