diff options
Diffstat (limited to 'captain/sql/scan_instructions.sh')
-rwxr-xr-x | captain/sql/scan_instructions.sh | 19 |
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 |