From 3c530aafe415db3515465e8b0662373065afd925 Mon Sep 17 00:00:00 2001
From: Louie Shprung <lshprung@scu.edu>
Date: Sun, 26 Mar 2023 13:58:50 -0700
Subject: Index terms

---
 src/lib/create_table | 6 ++++++
 src/lib/insert       | 9 +++++++++
 2 files changed, 15 insertions(+)
 create mode 100644 src/lib/create_table
 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..cdeb477
--- /dev/null
+++ b/src/lib/create_table
@@ -0,0 +1,6 @@
+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/insert b/src/lib/insert
new file mode 100644
index 0000000..2e4dd8c
--- /dev/null
+++ b/src/lib/insert
@@ -0,0 +1,9 @@
+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