From 4a107f2bf07833dbfbc14b5f3bbc630572f7ee0e Mon Sep 17 00:00:00 2001
From: Teddy Wing
Date: Tue, 8 Mar 2022 23:49:36 +0100
Subject: get_column_names(): Remove transaction code

We probably don't even need a transaction for a `SELECT`. Get rid of
that code and remove the `mut` on `dbconn` which was only necessary for
the transaction.
---
 src/main.rs | 15 +++------------
 1 file changed, 3 insertions(+), 12 deletions(-)

(limited to 'src')

diff --git a/src/main.rs b/src/main.rs
index ce18f49..2709005 100644
--- a/src/main.rs
+++ b/src/main.rs
@@ -6,9 +6,9 @@ fn main() {
 
     // Get column names from SQLite
 
-    let mut dbconn = rusqlite::Connection::open("./test.db").unwrap();
+    let dbconn = rusqlite::Connection::open("./test.db").unwrap();
 
-    let table_columns = get_column_names(&mut dbconn);
+    let table_columns = get_column_names(&dbconn);
     dbg!(table_columns);
 
     let text_data = std::fs::read_to_string("test.yml").unwrap();
@@ -46,16 +46,9 @@ fn yaml_extract(doc: &yaml::Yaml) {
     }
 }
 
-fn get_column_names(dbconn: &mut rusqlite::Connection) -> Vec<String> {
+fn get_column_names(dbconn: &rusqlite::Connection) -> Vec<String> {
     let mut column_names = Vec::new();
 
-    // let tx = dbconn.transaction().unwrap();
-
-    // let mut stmt = tx.prepare(r#"
-    //     SELECT "name"
-    //     FROM pragma_table_info("test");
-    // "#).unwrap();
-
     let mut stmt = dbconn.prepare(r#"
         SELECT "name"
         FROM pragma_table_info("test");
@@ -70,7 +63,5 @@ fn get_column_names(dbconn: &mut rusqlite::Connection) -> Vec<String> {
         column_names.push(row.unwrap());
     }
 
-    // tx.commit().unwrap();
-
     column_names
 }
-- 
cgit v1.2.3