summaryrefslogtreecommitdiff
path: root/src/index.sh
diff options
context:
space:
mode:
authorLouie S <louie@example.com>2023-05-05 19:25:50 -0700
committerLouie S <louie@example.com>2023-05-05 19:31:44 -0700
commit3c6bd67b02dfb5dd7ac11455741530c3ebd034fa (patch)
tree7e59eff4d8832369c179aa85985a2c49f40e8c1a /src/index.sh
parenta26adab1566f7ad0574c93b841f640363a799092 (diff)
Create lib subdirectory for common functions
Diffstat (limited to 'src/index.sh')
-rwxr-xr-xsrc/index.sh23
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 "$@"