Ottomata has submitted this change and it was merged.
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(-)
Approvals:
Ottomata: Verified; Looks good to me, approved
jenkins-bot: Verified
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: merged
Gerrit-Change-Id: Ia24e66b3f47e133c72cea07d0b63ceb83b813809
Gerrit-PatchSet: 1
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Milimetric <dandree...@wikimedia.org>
Gerrit-Reviewer: Ottomata <o...@wikimedia.org>
Gerrit-Reviewer: jenkins-bot
_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
