iankelling.org
/
git
/
iankelling.org
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
minor content update
[iankelling.org]
/
get-comments
diff --git
a/get-comments
b/get-comments
index 36bbe0dfca800540ea439a254da9a0ca044544ca..541ce3cf9771dd717d514f1fe205175f501e6e94 100755
(executable)
--- a/
get-comments
+++ b/
get-comments
@@
-20,11
+20,11
@@
trap 'echo "$0:$LINENO:error: \"$BASH_COMMAND\" returned $?" >&2' ERR
cd "${BASH_SOURCE%/*}/proposed-comments"
all=false
cd "${BASH_SOURCE%/*}/proposed-comments"
all=false
-shell="ssh
iankelling.org
"
+shell="ssh
$(chost iankelling.org)
"
while [[ $1 ]]; do
case $1 in
-a) all=true; shift ;;
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
esac
done
@@
-41,9
+41,9
@@
EOF
fi
# we may want to avoid rate limited posts here too.
fi
# we may want to avoid rate limited posts here too.
-sql="select * from c"
+sql="select * from c
;
"
if [[ $date ]]; then
if [[ $date ]]; then
-
date_clause
=" where date > cast('$date' as real)"
+
sql+
=" where date > cast('$date' as real)"
fi
fi
-echo "$sql"
-$s
"$sql" > /tmp/hcomments
+echo "
executing:
$sql"
+$s
> /tmp/hcomments <<<"$sql"