From d2cd12de233cca31d09b60ce8c9f36838d4e6f71 Mon Sep 17 00:00:00 2001
From: George Abbott <george@gabbott.dev>
Date: Fri, 3 Nov 2023 19:20:06 +0000
Subject: Commit all

---
 main.go | 79 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 79 insertions(+)
 create mode 100644 main.go

(limited to 'main.go')

diff --git a/main.go b/main.go
new file mode 100644
index 0000000..64c2e08
--- /dev/null
+++ b/main.go
@@ -0,0 +1,79 @@
+package main 
+
+import (
+	bt "badtudexo"
+	st "saggytrousers"
+	"fmt"
+	"os"
+	xl "github.com/xuri/excelize/v2"
+)
+
+// This program has the function of finding duplicate values in a column. It
+// will spit them back as output if they exist. Useful, to, e.g. check
+// duplicates in a reference that should be unique.
+
+func usage() {
+	fmt.Println(`bt-duplref: check for duplicates.
+
+This program allows you to check whether there are any duplicates in a given 
+file column. This can be handy as a check for, e.g. transaction references.
+
+Note: Speed
+-----------
+A downside to this program at the moment is the algorithm used is O(N^2), so 
+does not scale well. It should be performant enough for a few thousand rows,
+but beyond that it may become a bit slow.
+
+	`)
+	os.Exit(-1)
+}
+
+func parseArgs(args []string) {
+	for i := 0; i < len(args); i++ {
+		arg := args[i]
+		switch arg {
+		case "-h", "help", "--help":
+			usage()
+		case "-v", "--verbose": 
+			verbose = true
+		case "--no-verbose", "--quiet", "-q":
+			verbose = false
+		default:
+			i++
+			g_file = args[i]
+		}
+	}
+}
+
+var g_file string
+var verbose bool = true
+
+func main() {
+	args := os.Args
+	parseArgs(args)
+
+	file, err := xl.OpenFile(g_file)
+	if err != nil {
+		fmt.Println("Could not open file.")
+	}
+
+	sheet := st.SelectSheet(file, "")
+	columnIdx := st.SelectHeader(file, sheet, "", /* exact: */ false)
+	columns, err := file.GetCols(sheet)
+	if err != nil {
+		fmt.Println("Could not get columns.")
+		return
+	}
+	column := columns[columnIdx]
+
+	// Do the thing. 
+	if verbose { fmt.Println("Loaded file, now checking duplicates...") }
+	dupls := bt.Duplicate(column)
+
+	// Output. 
+	for _, d := range dupls {
+		v := d.Value
+		i := d.Index
+		fmt.Printf("Duplicate at index %d is %v\n", i, v)
+	}
+}
-- 
cgit v1.2.1