summaryrefslogtreecommitdiff
path: root/src
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
parenta26adab1566f7ad0574c93b841f640363a799092 (diff)
Create lib subdirectory for common functions
Diffstat (limited to 'src')
-rwxr-xr-xsrc/index.sh23
-rw-r--r--src/lib/create_table7
-rw-r--r--src/lib/insert8
3 files changed, 22 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 "$@"
diff --git a/src/lib/create_table b/src/lib/create_table
new file mode 100644
index 0000000..a783c50
--- /dev/null
+++ b/src/lib/create_table
@@ -0,0 +1,7 @@
+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..baa13bd
--- /dev/null
+++ b/src/lib/insert
@@ -0,0 +1,8 @@
+insert() {
+ DB_PATH="$1"
+ NAME="$2"
+ TYPE="$3"
+ PAGE_PATH="$4"
+
+ sqlite3 "$DB_PATH" "INSERT INTO searchIndex(name, type, path) VALUES (\"$NAME\",\"$TYPE\",\"libc/$PAGE_PATH\");"
+}