summaryrefslogtreecommitdiff
path: root/src/lib
diff options
context:
space:
mode:
authorLouie S <louie@example.com>2023-05-05 19:16:11 -0700
committerLouie S <louie@example.com>2023-05-05 19:18:23 -0700
commitd7ce7c21ad5fe18b7d0a4e6a496cce2783a50d1e (patch)
tree68a182570c4dd7bf1edb5ed6f4c438900326038f /src/lib
parenta26adab1566f7ad0574c93b841f640363a799092 (diff)
First commit for glibc docset
Diffstat (limited to 'src/lib')
-rw-r--r--src/lib/create_table7
-rw-r--r--src/lib/insert8
2 files changed, 15 insertions, 0 deletions
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\");"
+}