r78727 MediaWiki - Code Review archive

Repository:MediaWiki
Revision:r78726‎ | r78727 | r78728 >
Date:19:50, 21 December 2010
Author:rfaulk
Status:deferred
Tags:
Comment:
Modified SQL to filter banner updates. Fixed image link in reporting html.
Modified paths:
  • /trunk/fundraiser-statistics/bash/log_copy.sh (modified) (history)
  • /trunk/fundraiser-statistics/fundraiser-scripts/fundraiser_reporting.py (modified) (history)
  • /trunk/fundraiser-statistics/mine-log (deleted) (history)
  • /trunk/fundraiser-statistics/reporting/reporting_all.html (modified) (history)

Diff [purge]

Index: trunk/fundraiser-statistics/fundraiser-scripts/fundraiser_reporting.py
@@ -48,8 +48,8 @@
4949 def init_db(self):
5050 """ Establish connection """
5151 #db = MySQLdb.connect(host='db10.pmtpa.wmnet', user='rfaulk', db='faulkner')
52 - self.db = MySQLdb.connect(host='127.0.0.1', user='rfaulk', db='faulkner', port=3307)
53 - #self.db = MySQLdb.connect(host='storage3.pmtpa.wmnet', user='rfaulk', db='faulkner')
 52+ #self.db = MySQLdb.connect(host='127.0.0.1', user='rfaulk', db='faulkner', port=3307)
 53+ self.db = MySQLdb.connect(host='storage3.pmtpa.wmnet', user='rfaulk', db='faulkner')
5454
5555 """ Create cursor """
5656 self.cur = self.db.cursor()
Index: trunk/fundraiser-statistics/reporting/reporting_all.html
@@ -51,7 +51,7 @@
5252 <br>
5353
5454 <h3><u>Landing Pages Donations Per Donation Click (Completion Rate)</u></h3>
55 -<OBJECT WIDTH="1600" HEIGHT="800" data="report_LP_metrics_conversion_rate.png" type="image/png">
 55+<OBJECT WIDTH="1600" HEIGHT="800" data="report_LP_metrics_completion_rate.png" type="image/png">
5656 </OBJECT>
5757
5858 </body>
Index: trunk/fundraiser-statistics/bash/log_copy.sh
@@ -56,16 +56,5 @@
5757
5858 cd ..
5959
60 -python squid_miner_script.py l ./logs/landingpages-$T* 1>./mine_log/log-$T.txt 2>./mine_log/log-$T.txt
61 -python squid_miner_script.py i ./logs/bannerImpressions-$T* 1>./mine_log/log-$T.txt 2>./mine_log/log-$T.txt
62 -
63 -cd /home/rfaulk/bash-scripts
64 -
65 -# Run the hourly test
66 -#./run_test.sh
67 -
68 -# start_time="20101110000000"
69 -# end_time="20101110010000"
70 -# banner="testing50_2010"
71 -#
72 -# python data_aggregation_script.py start_time end_time banner
 60+python squid_miner_script.py l ./logs/landingpages-$T* 1>./mine-log/log-banimp-$T.txt 2>./mine-log/log-banimp-$T.txt
 61+python squid_miner_script.py i ./logs/bannerImpressions-$T* 1>./mine-log/log-lp-$T.txt 2>./mine-log/log-lp-$T.txt

Status & tagging log