openoffice-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From msei...@apache.org
Subject svn commit: r1798550 - /openoffice/devtools/aoo-stats/downloads-by-country-test.py
Date Mon, 12 Jun 2017 22:02:35 GMT
Author: mseidel
Date: Mon Jun 12 22:02:35 2017
New Revision: 1798550

URL: http://svn.apache.org/viewvc?rev=1798550&view=rev
Log:
Updated version of "downloads-by-country.py" with fixes/additions.

Added:
    openoffice/devtools/aoo-stats/downloads-by-country-test.py   (with props)

Added: openoffice/devtools/aoo-stats/downloads-by-country-test.py
URL: http://svn.apache.org/viewvc/openoffice/devtools/aoo-stats/downloads-by-country-test.py?rev=1798550&view=auto
==============================================================================
--- openoffice/devtools/aoo-stats/downloads-by-country-test.py (added)
+++ openoffice/devtools/aoo-stats/downloads-by-country-test.py Mon Jun 12 22:02:35 2017
@@ -0,0 +1,122 @@
+################################################################
+# 
+#  Licensed to the Apache Software Foundation (ASF) under one
+#  or more contributor license agreements.  See the NOTICE file
+#  distributed with this work for additional information
+#  regarding copyright ownership.  The ASF licenses this file
+#  to you under the Apache License, Version 2.0 (the
+#  "License"); you may not use this file except in compliance
+#  with the License.  You may obtain a copy of the License at
+#  
+#    http://www.apache.org/licenses/LICENSE-2.0
+#  
+#  Unless required by applicable law or agreed to in writing,
+#  software distributed under the License is distributed on an
+#  "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+#  KIND, either express or implied.  See the License for the
+#  specific language governing permissions and limitations
+#  under the License.
+#  
+################################################################
+
+
+import urllib
+import json
+import os
+import hashlib
+import datetime
+import time
+import sys
+
+from urllib import urlencode
+
+def getSourceForgeStats(download, start_date, end_date):
+
+    #print download
+
+    url = download + "/stats/json?start_date=" + start_date + "&" "end_date=" + end_date
+    
+    attempts = 0
+
+    while attempts < 3:
+        try:    
+            conn = urllib.urlopen(url)
+            data = conn.read()
+            
+            return data
+
+        except:
+            attempts += 1
+            print "error " + str(attempts)
+
+    return ""
+
+# dictionary of language code to country_dict (dictionary of country name to count)
+country_dict = {}
+
+def mergeCountries(countries):
+
+    for country_tuple in countries:
+
+        country_name = country_tuple[0]
+        country_count = country_tuple[1]
+
+        if country_name in country_dict:
+            country_dict[country_name] = country_dict[country_name] + country_count
+        else:
+            country_dict[country_name] = country_count
+
+
+if len(sys.argv) == 0:
+    print "syntax:  python downloads-by-country.py <urls.lst> <start-date> <end-date>"
+    print "where <file.list> is a list of files URL's to gather stats on, and <start-date>
and <end-date> are in YYYY-MM-DD format."
+
+downloads = [line.strip() for line in open(sys.argv[1])]
+
+for download in downloads :
+
+    data = getSourceForgeStats(download, sys.argv[2], sys.argv[3])
+
+    #print data
+
+    obj = json.loads(data)
+
+    countries = obj["countries"]
+
+    mergeCountries(countries)
+
+
+print "<html>"
+print "<head>"
+print "<title>OpenOffice Downloads by Country</title>"
+print "</head>"
+print "<body>"
+print "<h2>Downloads by Country</h2>"
+print "<p>The data in this table is based on download statistics gathered by SourceForge
(the host of our downloads) and exposed by them through their "
+print "<a href='https://sourceforge.net/p/forge/documentation/Download%20Stats%20API/'>Download
Stats API</a>. "
+print "The data is collected and aggregated by a <a href='https://svn.apache.org/repos/asf/openoffice/devtools/aoo-stats/downloads-by-country.py'>Python
script</a>.</p>"
+print "<p>The download figures are for full-install downloads of Apache OpenOffice
downloaded via SourceForge. This does not include downloads of language packs, SDKs or source
tarballs. "
+print "It does not include downloads of earlier versions of OpenOffice.org or downloads made
from copies of OpenOffice hosted on other repositories.</p>"
+print "<p>This table is <b>not</b> live. The data is manually updated.</p>"
+print "<p>This table shows downloads per <a href='https://en.wikipedia.org/wiki/Country_code_top-level_domain'>country</a>
for the period from " + sys.argv[2] + " to " + sys.argv[3] + ".</p>"
+print "<table border='1' cellpadding='20'>"
+
+print "<tr>"
+print "<th>Rank</th>"
+print "<th>Country</th>"
+print "<th>Downloads</th>"
+print "</tr>"
+
+rank = 1
+
+for country in sorted(country_dict,key=lambda x: country_dict[x], reverse=True):
+    print "<tr>"
+    print "<td align='right'>" + "#" + str(rank) + "</td>"
+    print "<td>" + country.encode("utf-8") + "</td>"
+    print "<td align='right'>" + str(country_dict[country]) + "</td>"
+    print "</tr>"
+    rank +=1
+
+print"</table>"
+print "</body>"
+

Propchange: openoffice/devtools/aoo-stats/downloads-by-country-test.py
------------------------------------------------------------------------------
    svn:executable = *



Mime
View raw message