clear.sh

# Terminalで一気に
echo "update ThreadInfo set threadStatus=2 where threadStatus=6 and isDatOchi=1;" | sqlite3 "$HOME/Library/Application Support/BathyScaphe/BathyScaphe.db"

# Automator 前スクリプト
echo "select threadName, threadID, boardID  from ThreadInfo where threadStatus=6 and isDatOchi=1;" | sqlite3 "$HOME/Library/Application Support/BathyScaphe/BathyScaphe.db" | sed -e 's/\|/    /g'

# Automator 後スクリプト
ps xaw | grep 'BathyScaphe.app' | grep -v grep > /dev/null && exit 1
awk '{ if( NF > 2 ) printf "update ThreadInfo set threadStatus=2 where boardID=%d and threadID=%d;\n", $NF, $(NF-1) }' | sqlite3 "$HOME/Library/Application Support/BathyScaphe/BathyScaphe.db"