Added script to scan and load instructions. Instructions now displayed on a page.

1 files changed, 19 insertions, 0 deletions

diff --git a/captain/sql/scan_instructions.sh b/captain/sql/scan_instructions.sh
new file mode 100755
index 0000000..dab98b3
--- /dev/null
+++ b/captain/sql/scan_instructions.sh
@@ -0,0 +1,19 @@
+#!/usr/bin/env bash
+
+cmds=`tempfile`
+echo $cmds
+
+for filename in $2/*.json; do
+    # In case it doesn't exist
+    [ -e "$filename" ] || continue
+    name=${filename##*/}
+    echo $name
+    base=${name%.json}
+    echo $base
+    
+    echo "INSERT OR IGNORE INTO instructions(name) VALUES('$base');" | cat >> $cmds
+done
+
+sqlite3 $1 < $cmds
+
+rm $cmds