#!/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