diff options
Diffstat (limited to 'src/index.sh')
| -rwxr-xr-x | src/index.sh | 23 |
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 "$@" |