while [[ $1 ]]; do
case $1 in
-a) all=true; shift ;;
- -l) shell= ; shift ;; # -l for local
+ -l) shell= ; shift ;; # -l for local site instead of iankelling.org
esac
done
fi
# we may want to avoid rate limited posts here too.
-sql="select * from c"
+sql="select * from c;"
if [[ $date ]]; then
- date_clause=" where date > cast('$date' as real)"
+ sql+=" where date > cast('$date' as real)"
fi
-echo "$sql"
-$s "$sql" > /tmp/hcomments
+echo "executing: $sql"
+$s > /tmp/hcomments <<<"$sql"