From 603d3105cb16470e502f0e3d20f95d2243771e33 Mon Sep 17 00:00:00 2001
From: Louie S <louie@example.com>
Date: Fri, 7 Jun 2024 15:10:52 -0400
Subject: Replace placeholders with wildcard rules

---
 Makefile                    | 10 ++++------
 README.md                   | 10 ++++++++++
 src/scripts/create_table.sh |  7 +++++++
 src/scripts/insert.sh       |  8 ++++++++
 4 files changed, 29 insertions(+), 6 deletions(-)
 create mode 100644 src/scripts/create_table.sh
 create mode 100644 src/scripts/insert.sh

diff --git a/Makefile b/Makefile
index dc6ed0c..ca465f0 100644
--- a/Makefile
+++ b/Makefile
@@ -20,10 +20,8 @@ clean:
 .phony: GNU_Make
 GNU_Make: $(BUILD_DIR)/GNU_Make.docset
 
-# All docset files should be listed here
-$(BUILD_DIR)/GNU_Make.docset: 
-	$(SRC_MAKE_CALL) DOCSET_NAME=GNU_Make
+$(BUILD_DIR)/%.docset: 
+	$(SRC_MAKE_CALL) DOCSET_NAME=$(basename $(@F))
 
-# All archive files should be listed here
-$(BUILD_DIR)/GNU_Make.tgz: GNU_Make
-	tar --exclude='.DS_Store' -czf $@ $(BUILD_DIR)/GNU_Make.docset
+$(BUILD_DIR)/%.tgz: $(BUILD_DIR)/%.docset
+	tar --exclude='.DS_Store' -czf $@ $(basename $@).docset
diff --git a/README.md b/README.md
index ed9bd59..366b689 100644
--- a/README.md
+++ b/README.md
@@ -16,3 +16,13 @@ Other possible targets:
   $(BUILD_DIR)/$(DOCSET_NAME).docset - equivalent to DOCSET_NAME
   $(BUILD_DIR)/$(DOCSET_NAME).tgz    - create a .tgz archive of DOCSET_NAME
 ```
+
+### Project Structure
+
+```
+.
+├── src
+│   ├── configs    - supported docsets, including metadata and build scripts
+│   └── scripts    - general purpose scripts
+└── tmp            - intermediate sources (e.g., upstream sources are downloaded to here)
+```
diff --git a/src/scripts/create_table.sh b/src/scripts/create_table.sh
new file mode 100644
index 0000000..a783c50
--- /dev/null
+++ b/src/scripts/create_table.sh
@@ -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/scripts/insert.sh b/src/scripts/insert.sh
new file mode 100644
index 0000000..31c1b4c
--- /dev/null
+++ b/src/scripts/insert.sh
@@ -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\",\"$PAGE_PATH\");"
+}
-- 
cgit