Create lib subdirectory for common functions

1 files changed, 7 insertions, 16 deletions

diff --git a/src/index.sh b/src/index.sh
index 35ed08c..0b6e693 100755
--- a/src/index.sh
+++ b/src/index.sh
@@ -1,14 +1,13 @@
 #!/usr/bin/env sh
 
+# shellcheck source=./lib/create_table
+. "$(dirname "$0")"/lib/create_table
+# shellcheck source=./lib/insert
+. "$(dirname "$0")"/lib/insert
+
 DB_PATH="$1"
 shift
 
-create_table() {
-	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);"
-}
-
-
 get_title() {
 	FILE="$1"
 
@@ -17,14 +16,6 @@ get_title() {
 		sed 's/\"/\"\"/g'
 }
 
-insert() {
-	NAME="$1"
-	TYPE="$2"
-	PAGE_PATH="$3"
-
-	sqlite3 "$DB_PATH" "INSERT INTO searchIndex(name, type, path) VALUES (\"$NAME\",\"$TYPE\",\"$PAGE_PATH\");"
-}
-
 insert_pages() {
 	# Get title and insert into table for each html file
 	while [ -n "$1" ]; do
@@ -33,11 +24,11 @@ insert_pages() {
 		PAGE_NAME="$(get_title "$1")"
 		PAGE_TYPE="Guide"
 		if [ -n "$PAGE_NAME" ]; then
-			insert "$PAGE_NAME" "$PAGE_TYPE" "$(basename "$1")"
+			insert "$DB_PATH" "$PAGE_NAME" "$PAGE_TYPE" "$(basename "$1")"
 		fi
 		shift
 	done
 }
 
-create_table
+create_table "$DB_PATH"
 insert_pages "$@"