diff options
author | Louie S <louie@example.com> | 2023-05-05 19:16:11 -0700 |
---|---|---|
committer | Louie S <louie@example.com> | 2023-05-05 19:18:23 -0700 |
commit | d7ce7c21ad5fe18b7d0a4e6a496cce2783a50d1e (patch) | |
tree | 68a182570c4dd7bf1edb5ed6f4c438900326038f /src/lib | |
parent | a26adab1566f7ad0574c93b841f640363a799092 (diff) |
First commit for glibc docset
Diffstat (limited to 'src/lib')
-rw-r--r-- | src/lib/create_table | 7 | ||||
-rw-r--r-- | src/lib/insert | 8 |
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\");" +} |