first pass at an implementation

1 files changed, 80 insertions, 1 deletions

diff --git a/src/main.rs b/src/main.rs
index e7a11a9..d594413 100644
--- a/src/main.rs
+++ b/src/main.rs
@@ -1,3 +1,82 @@
+use std::io::Write;
+
+struct Sheet(Vec<Vec<String>>);
+
+impl Sheet {
+    fn new(contents: &str) -> Self {
+        let mut rdr = csv::ReaderBuilder::new()
+            .has_headers(false)
+            .from_reader(contents.as_bytes());
+        let sheet = rdr
+            .records()
+            .map(|record| {
+                record.unwrap().iter().map(|s| s.to_string()).collect()
+            })
+            .collect();
+        Self(sheet)
+    }
+
+    #[allow(dead_code)]
+    fn value_at(&self, coord: &str) -> String {
+        let letter = coord.chars().next().unwrap();
+        let num: usize = coord[1..].parse().unwrap();
+        let row = num - 1;
+        let col = ((letter as u32) - ('A' as u32)) as usize;
+        let Self(sheet) = self;
+        sheet[row][col].clone()
+    }
+
+    fn rows(&self) -> impl Iterator<Item = &Vec<String>> + '_ {
+        let Self(sheet) = self;
+        sheet.iter()
+    }
+}
+
 fn main() {
-    println!("Hello, world!");
+    let sheets: Vec<_> = std::env::args()
+        .skip(1)
+        .map(|u| Sheet::new(&reqwest::get(&u).unwrap().text().unwrap()))
+        .collect();
+
+    let mut file = std::fs::File::create("categories.tsv").unwrap();
+    for row in sheets[0].rows().skip(1) {
+        if row[0] == "" {
+            break;
+        }
+        let percentage: f64 = row[1].trim_end_matches('%').parse().unwrap();
+        file.write_all(
+            [
+                row[0].as_ref(),
+                format!("{}", (percentage * 100.0) as u32).as_ref(),
+            ]
+            .join("\t")
+            .as_bytes(),
+        )
+        .unwrap();
+        file.write_all(b"\n").unwrap();
+    }
+    file.sync_all().unwrap();
+
+    let mut file = std::fs::File::create("holdings.tsv").unwrap();
+    for row in sheets[1].rows().skip(2) {
+        if row[0] == "" {
+            break;
+        }
+        file.write_all(
+            [
+                row[0].as_ref(),
+                if row[1] == "" { "\\N" } else { row[1].as_ref() },
+                if row[2] == "" { "\\N" } else { row[2].as_ref() },
+                row[3].as_ref(),
+                row[7].replace(['$', ','].as_ref(), "").as_ref(),
+                row[8].replace(['$', ','].as_ref(), "").as_ref(),
+                row[11].as_ref(),
+            ]
+            .join("\t")
+            .as_bytes(),
+        )
+        .unwrap();
+        file.write_all(b"\n").unwrap();
+    }
+    file.sync_all().unwrap();
 }