diff options
author | Louie S <louie@example.com> | 2023-03-22 18:16:52 -0700 |
---|---|---|
committer | Louie S <louie@example.com> | 2023-03-22 18:16:52 -0700 |
commit | 8ee6bf8240947294b994ff0f883ec481ea86e602 (patch) | |
tree | 4d2052cc5da42687c25df2d2aed1f9ad3c3a8b88 /src/index.sh |
First commit
Diffstat (limited to 'src/index.sh')
-rwxr-xr-x | src/index.sh | 43 |
1 files changed, 43 insertions, 0 deletions
diff --git a/src/index.sh b/src/index.sh new file mode 100755 index 0000000..35ed08c --- /dev/null +++ b/src/index.sh @@ -0,0 +1,43 @@ +#!/usr/bin/env sh + +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" + + pup -p -f "$FILE" 'title text{}' | \ + tr -d \\n | \ + 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 + unset PAGE_NAME + unset PAGE_TYPE + PAGE_NAME="$(get_title "$1")" + PAGE_TYPE="Guide" + if [ -n "$PAGE_NAME" ]; then + insert "$PAGE_NAME" "$PAGE_TYPE" "$(basename "$1")" + fi + shift + done +} + +create_table +insert_pages "$@" |