Milimetric has uploaded a new change for review. https://gerrit.wikimedia.org/r/54878
Change subject: better synchronize running of cron job with sql ...................................................................... better synchronize running of cron job with sql Change-Id: Ia24e66b3f47e133c72cea07d0b63ceb83b813809 --- M templates/misc/email-blog-pageviews.erb 1 file changed, 5 insertions(+), 2 deletions(-) git pull ssh://gerrit.wikimedia.org:29418/operations/puppet refs/changes/78/54878/1 diff --git a/templates/misc/email-blog-pageviews.erb b/templates/misc/email-blog-pageviews.erb index 181049a..dfda018 100644 --- a/templates/misc/email-blog-pageviews.erb +++ b/templates/misc/email-blog-pageviews.erb @@ -1,7 +1,10 @@ -DATE=`date '+%Y-%m-%d'`; +DATE=`date --date=yesterday +%Y-%m-%d`; OUTPUT=/tmp/blog_$DATE.tsv -mysql log -h <%= db_host %> -p<%= db_pass %> -u<%= db_user %> -e "select count(event_requestUrl) as count, date(timestamp), event_requestUrl from WikimediaBlogVisit_5308166 where date(timestamp)=date('$DATE') group by event_requestUrl order by date(timestamp) desc, count desc;" > $OUTPUT +echo "Page view count for the 24 hour period starting at midnight, $DATE UTC" > $OUTPUT +echo "" >> $OUTPUT + +mysql log -h <%= db_host %> -p<%= db_pass %> -u<%= db_user %> -e "select count(event_requestUrl) as count, date(timestamp), event_requestUrl from WikimediaBlogVisit_5308166 where date(timestamp)=date('$DATE') group by event_requestUrl order by date(timestamp) desc, count desc;" >> $OUTPUT cat $OUTPUT | mailx -s "Daily Blog Pageviews" <%= recipient_email %> rm $OUTPUT -- To view, visit https://gerrit.wikimedia.org/r/54878 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: newchange Gerrit-Change-Id: Ia24e66b3f47e133c72cea07d0b63ceb83b813809 Gerrit-PatchSet: 1 Gerrit-Project: operations/puppet Gerrit-Branch: production Gerrit-Owner: Milimetric <dandree...@wikimedia.org> _______________________________________________ MediaWiki-commits mailing list MediaWiki-commits@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits