From b21d0424ad6bf3cec141abe7e1bb624744c12fc6 Mon Sep 17 00:00:00 2001
From: Louie S <louie@example.com>
Date: Wed, 18 Oct 2023 18:08:59 -0400
Subject: Rewrite to base off template; index more terms

---
 src/lib/create_table |  7 +++++++
 src/lib/get_type     | 13 +++++++++++++
 src/lib/insert       |  8 ++++++++
 3 files changed, 28 insertions(+)
 create mode 100644 src/lib/create_table
 create mode 100644 src/lib/get_type
 create mode 100644 src/lib/insert

(limited to 'src/lib')

diff --git a/src/lib/create_table b/src/lib/create_table
new file mode 100644
index 0000000..a783c50
--- /dev/null
+++ b/src/lib/create_table
@@ -0,0 +1,7 @@
+create_table() {
+	DB_PATH="$1"
+
+	sqlite3 "$DB_PATH" "CREATE TABLE IF NOT EXISTS searchIndex(id INTEGER PRIMARY KEY, name TEXT, type TEXT, path TEXT);"
+	sqlite3 "$DB_PATH" "CREATE UNIQUE INDEX IF NOT EXISTS anchor ON searchIndex (name, type, path);"
+}
+
diff --git a/src/lib/get_type b/src/lib/get_type
new file mode 100644
index 0000000..9f04b53
--- /dev/null
+++ b/src/lib/get_type
@@ -0,0 +1,13 @@
+get_type() {
+	FILE="$1"
+	CATEGORY="$(echo "$FILE" | grep -Eo "\.[0-9].?\.html$")"
+
+	if [ -n "$CATEGORY" ]; then
+		case "$CATEGORY" in
+			.1*) echo "Command"  ;;
+			.2*) echo "Service"  ;;
+			.3*) echo "Function" ;;
+			*)  echo "Object"   ;;
+		esac
+	fi
+}
diff --git a/src/lib/insert b/src/lib/insert
new file mode 100644
index 0000000..31c1b4c
--- /dev/null
+++ b/src/lib/insert
@@ -0,0 +1,8 @@
+insert() {
+	DB_PATH="$1"
+	NAME="$2"
+	TYPE="$3"
+	PAGE_PATH="$4"
+
+	sqlite3 "$DB_PATH" "INSERT INTO searchIndex(name, type, path) VALUES (\"$NAME\",\"$TYPE\",\"$PAGE_PATH\");"
+}
-- 
cgit